Hi, I can understand the Goods Receipt date is the date on which the customer pick the stock. However my doubt is how would system know GR date to calculate the number of days between GR and GI date. Where this GR date will be updated in SAP? Because GI was completed and hardly no chance to enter the details in delivey. PR02 condition type has scale type - Graduated to interval scale. This would solve the issue but my confusion is once the PGI has done delivery number will show in the invoice due list. How long the business to wait creating invoices for the deliveries. Because we are unsure when will customer pick the goods so that to calculate the storage cost? I respect your suggestion but I have not understood the solution you proposed. Can you please brief me more. Thanks, Vamsi
| | | ---------------Original Message--------------- From: Typewriter Sent: Thursday, June 09, 2011 10:12 AM Subject: Complex pricing procedure Hi, Initial idea There are 3 parts to this pricing - Part 1. Storage related price - 1. The number of storage days could be got from calculating the number of days between Goods Receipt & Goods Issue. 2. Do you have product identification (i.e. pallet numbers or batch numbers)? & Do you keep track of date of GR vis-a-vis Material identification number? 3. If 2 is happening / can happen; then in sales order, after putting in the material & batch (pallet # ) of material; the Number of storage days can automatically be calculated (by the system). 4. For pricing of Excess storage days - Use Scale pricing, condition type PR02 is perfect for that. I have tested it, it works OK. To 29 days - (normal price say) 10 Euros per day; To 60 days - 20 Euros per day; To 90 days - 30 Euros per day Thus if Storage days = 35 days, then pricing = 29X10 + 6X20 Euros Part 2. Number of BOXES - 5. Take ZPR0 and have per BOX the rate (say 1Euros per BOX = Number of BOXES, if you do want ONLY number of boxes). 6. In Sales order give number of BOXES, condition type ZPR0 shall give you the total prices (or total number of boxes). Part 3. Multiplying Storage price & Number of Boxes - 7. Now in your pricing procedure you have 2 condition types, one for Storage price & the other for Number of boxes. In procedure, for each of these lines in field "SubTotal" press F4, & use 1Carry over value to KOMP-KZWI1 & 2 respectively. 8. Create a line say description "SubTotal value", in CalType, give Routine to multiply KZWI1*KZWI2. This shall have to be created, please see similar examples, with F4 | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | Popular White Papers In the Spotlight _.____.__ |