Partial Deliveries against Sales Order

[Former Member]

Dear Team,

Query1: How to see the salesorders list for whose more than one delivery happened in the system?.

Query2: How to see the list of invoices that were created with reference to sales Order?

Regards,

Varma

[Former Member · Accepted solution]

Hi,

Query: 1

Use Table : VBEP to find sales order which have more one schedule lines / delivery date.

Query: 2

Use table VBFA

Pass sales document in VBFA u2013VBELV and maintain VBTYP_N value as M Invoice to get list of billing documents which was created with reference to particular sales document.

Best Regards,

Chandra

[Former Member]

hello,

if you are looking single doc then use doc flow. If looking for multiple sales order pl use Tables VBFA and VBEP etc.

thx

Dilip Sadh

[Former Member]

Hi,

Query1: How to see the salesorders list for whose more than one delivery happened in the system?.

To see list of sales orders created with more than one check the same in VBEP Table.

Query2: How to see the list of invoices that were created with reference to sales Order?

If you want to see list of sales order related invoices which are due for billing. Go to VF04 and Tick Order related check Box and execute.

Br,

Tushar

[Former Member]

Hi,

Please check this criteria also

delivery will be split if the below fields are different

Shipping point

ship to party.

Route.

confirmed qty dates

Also if you have any custom splitting rules, please check your copy control setting in T code VTLA from order to delivery.

if you manually break the schedule lines, and if stock is available for the order quantity , then delivery split will not happend and whole ord quantity will be delivered, even if there are varying schedule lines for the line item.

Hope this helps

Br,

Tushar

[Former Member]

hi

Query1: How to see the salesorders list for whose more than one delivery happened in the system?.

VA02 - if thre are no of schedule lines against each schedule line if delivery quantity is filled you can see the same in VBEP table

in the same VA02 select line item go to schedule line and go to display document flow you can find the number of deliveries taen place against each schedule lines.

Query2: How to see the list of invoices that were created with reference to sales Order?

in VBFA_VBELV - but i am not sure on this.

[Former Member]

You find the details in the document flow of the sale order