Skip to Content
0

Reconcile purchase details to sales to end customer

Jan 13, 2017 at 05:23 AM

85

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Yugank Arora Jan 13, 2017 at 11:24 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
G Lakshmipathi
Jan 13, 2017 at 12:08 PM
0
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.

Share
10 |10000 characters needed characters left characters exceeded
fortian . Jan 13, 2017 at 12:36 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Jan 14, 2017 at 08:53 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded