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
| | | ---------------Original Message---------------
From: juiccy_mann
Sent: Thursday, June 09, 2011 8:01 AM
Subject: Complex pricing procedure
Hi Gurus
My client has a requirement whereby they need to bill on materials which have over stayed in their premises in excess of 30 days. The client deals with the business of storage of materials for it customers. They have proposed two levels of tariff 30-60 days 20USD and 61-90 30 USD. the rates are to be prorated i.e per day. Meaning that if a customer has 10 boxes in store which have over stayed by 20 days he will pay ( 20days X 10 boxes X 20/30). how do we go about this? |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Typewriter
SAP Logistics Sales and Distribution Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight Visit IBM's Leveraging IT Services Briefing Center. Register now and learn how to deliver smarter security & resiliency.  _.____.__ |
