Skip to Content
0
Former Member
May 17, 2010 at 06:47 AM

Re: Distinguish different sales in report

37 Views

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