Haven't got too much free time to help. But couldn't you just setup an accrual during the billing. Regards Waza
| | | ---------------Original Message--------------- From: Pavan Kumar Sent: Monday, July 11, 2011 1:09 AM Subject: Elimination of COPA Dummy Customer BACKGROUND Our Company sells goods to its customers( Retail and Vendors) for full price, government pays those customers full price if they sell those items in a "Food Scheme"( Special program by government to help poor people and supported by our company). As the deal is we will be giving 10% discount on those items to government, they will be sending us invoice for all the goods they paid to customers( 10% of what they paid). We need to adjust that 10% amount in our reporting and assign to correct value field(Tender) and get them sorted. OUR PREVIOUS DESIGN Example: Retail Quantity Price Walmart 100 cases 1000$ Tender( Value Field) 100$( Discounted Price) So those 100$ were adjusted in Db 55( Retail Customer Channel)[Characteristic] 100$ Cr 85(Special Retail Customer Channel)[Characteristic] 100$ But all those discounted sales were assigned to a Dummy Customer(Created by us for this special purpose) but not the actual customers. REQUIRED DESIGN Now government are will to provide details at customer level, so we need to eliminate the role of DUMMY CUSTOMER but still the below pattern should continue Example Db 55( Retail Customer Channel)[Characteristic] 100$ Cr 85(Special Retail Customer Channel)[Characteristic] 100$ If I touch at customer level for me the postings are happening like this Db 55( Retail Customer Channel)[Characteristic] 100$ Cr 55( Retail Customer Channel)[Characteristic] 100$ So everything is canceling out. So you need to help me to eliminate the creation of dummy customer, have to touch sales in customer level and again have to make use the SPECIAL RETAIL CUSTOMER CHANNEL for crediting the discount. | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | wnash7658 SAP Logistics Sales and Distribution Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement Popular White Papers In the Spotlight IBM Helps Clients Exploit the Power of Cloud Computing. Click Here for IBM's Cloud Computing Virtual Briefing Center. _.____.__ |