Reconcile purchase details to sales to end customer

[Former Member]

Hi,

I have the below scenario

Scenario

1. A sell to B

2. B sell to end customer.

Objective

Match B's sales record to initial purchase from A

Is there any table or reports with which we can get the material number, vessel details, value or purchase and value of sales.

Thanks and Regards,

SWL

[JL23]

If your purchase order is not a third-party order or has no account assignment with the sales order then you have not much to reconcile. In this case you buy to your neutral warehouse stock which has no relation to your sales order, so you do not know from which receipt the goods were used for the delivery of your sales order. this could only be done by best bet if your stock will always reach zero before you re-order it, or if you use batch management and you create individual batches per receipt and purchase order.

You also did not tell in which transaction you enter a vessel number and where you see this number later.

[fortian]

Hi,

Are A and B plants belonging to different company codes?

What process are you using to record sales from A to B? Are you using the standard SAP replenishment process?

Regards

Fortian

[Lakshmipathi]

Is there any table or reports with which we can get the material number, vessel details, value or purchase and value of sales.

If you maintain somewhere in SAP, yes it is possible. When you say the current process, you have missed out to mention how it is currently being captured in SAP which is the most important criteria to propose a suitable suggestion. You should be knowing, in standard, once you bill an end customer, you cannot track the goods.

[Former Member]

Dear Wei,

What is the document process flow? If sales order from B to A is initiating step, then can you please check table: VBFA for the details that you are looking for? You can enter this sales order number as preceding doc.

Looking forward to you response.

Thanks and Regards,

Yugank Arora