Hi all,
Assuming I have different type of sales process within a company.
Company purchases Product A to process and manufacture Product B. However, there will be a scenario where manufacturing capacity has reached its peak or when factory is down etc., then there will be a surplus of Product A to be processed.
As such, Product A is sold to another Plant for processing.
1. Standard Sales of Product B to Company DCE.
2. Intercompany sales of Product A to Company XYZ.
3. Standard Sales of Product A to External Company ABC
The issue here is, where monthly sales figure reporting is concern, all the above scenarios are captured as a total lump sum figure in the Sales report.
Need some feedback on how we can separate the sales for Item (1) and Item (2) + (3) so that they are both identifiable as a separate sales figure in management report.
For example:
It will appear as:
Sales (1) = USD2,000
Sales (2) + (3) = USD 3,500
Instead, it should not appear as:
Sales (1) + (2) + (3) = USD5,500
Thanks in advance for your assistance and feedback.
Edited by: PKW on May 17, 2010 2:47 PM
Edited by: PKW on May 17, 2010 3:21 PM