Distinguish different sales in report

[Former Member]

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

[Former Member]

Hi,

You have to distinguish the sales report on the basis or your organization unit.

Assuming you have created diff DC for inter company and external sales transaction.

So you can take out sales report based on your DC .

[Former Member]

Hi,

Thanks for your reply.

Unfortunately, the implemented system does not cater to this, and we only have "Local" or "Export" Dist Chnl..

As such, since the scenario are carried out locally, the DC for all scenarios mentioned earlier, are the same.

Thanks.

[Former Member]

Hi,

If u are having different account group for customer than u can take report based on that .

[Former Member]

Hi Krishna,

Thanks again for your reply.

Again, unfortunately, we have "Trade" and "Non-trade" Account Groups, and for the above mentioned scenarios, the customers are all categorised as "Trade" Account Group for this matter..

Thanks.

Rgds.

[Former Member]

Hi,

Than you need to bifurcate based on Customer group if u have created any !!!!!! Or else based on the customer and delivering plant u need to bifurcate

[Former Member]

Hi,

Have u managed to pull the report .

Please post your feedback on the forum and close the thread .

Regards,

Krishna Kant Oza

[Former Member]

No.. Is still not answered.

I am closing the thread anyhow.

Thanks for the feedback.