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 | | Popular White Papers In the Spotlight _.____.__ |