Importing Price Lists and Volume Pricing

[bbranco]

Hi,
I am trying to DTW item price lists and volume pricing.

I am getting a message Object reference not set to an object error

I am under Inventory->Price Lists->Special Prices->Special Prices for Business Partners->SpecialPricesQuantityArea

I manually setup the item on the Period and Volume Discounts->Web Price List manually.  I also set it up on the 2nd screen Period Discounts.  I am trying to get the Volumne Discounts for Price List.

Then I will need to update the prior onces, but this is a start.

Can someone give me some guidance?  I did a query on SPP2 for an item I added manually and that had a *7 in the CardCode

This is the layout for SPP2 that I am using

ParentKey	ParentKey2	LineNum	Quantity	SPDARowNumber	SpecialPrice	RowNumber	PriceCurrency	Discountin	UoMEntry
ItemCode	CardCode	LineNum	Amount	SPP1LNum	Price	SPP2LNum	Currency	Discount	UoMEntry
A00002	*7	0	1	0	100	0	$	0	-1
A00002	*7	1	10	1	90	1	$	10	-1

[ANKIT_CHAUHAN]

Hi bbranco ,

Refer to SAP Note 928625 for preparing the data.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[bbranco]

Hi Ankit,
Thank you for the link, it looks very helpful.

If I didn't want to make it customer specific, can I just leave CardCode empty?

My prices are for a specific price list that will primarily be used for pricing on their web site.


Brian 

[ANKIT_CHAUHAN]

Hi bbranco ,

I used it a long time back so do not know the exact details.

The following is mentioned:

• CardCode: BP master code or an asterisk followed by the price list number (e.g. *1) only when importing Period and Volume Discounts in cases in which no business partner is defined.

You can test it by putting no value for BP.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[Vaibhav1212]

Hi Ankit, If possible, can you share me the sap note was trying to take look it is not available as of now.

[raymond_giuseppi]

Do you have an S-Id, the note is currently available.

[Vaibhav1212]

No, I don't sorry is there any other way. Thank you

[raymond_giuseppi]

Check with your administrators, they can either create an S-ID for you or download the note as a pdf. (This is SAP copyright material)