Sales order

[Former Member]

Somebody knows something about this:

1. how to find the sales order quantities that have not been invoiced. Is it just 0QUANT_B for the open order?

2. How do you find if an sales order is open or closed?

3. When is the order closed?

4.Should you include credit notes when you calculate invoiced quantity

Please, can somebody help me, I don´t know anything about this.

[Lakshmipathi · Accepted solution]

Dear Ruth

- Go to VA05 and execute the report where you find a field Open Order quantity which is nothing but quantity ordered but not invoiced

- In document flow, you can see whether the document is open or completed

- Once you despatch all the line items of a sale order, then it can be treated as closed

- No only original quantity what you despatched should be considered for invoiced quantity

thanks

G. Lakshmipathi

[Former Member]

I ask about this question because I need this information for a query in BW. So I need fields or tables where I can find this information.

In trnsaccion VA05 I can see information but I need to know how I can used it in BW reports.

All information help me, thanks for all.

[Former Member]

Sales and Distribution (SD) :

VBFA - Document flow (alg.)

VTFA - Flow shipping documents

Sales order :

VBAK - Header data

VBAP - Item data

VBPA - Partners in sales order

VBKD - Sales district data

VBEP - Data related to line items, delivery lines

Billing document :

VBRK - header data

VBRP - Item data

Shipping :

VTTK - Shipment header

VTTP - Shipment item

VTTS - Stage in transport

VTSP - Stage in transport per shipment item

VTPA - Shipment partners

VEKP - Handling Unit - Header Table

VEPO - Packing: Handling Unit Item (Contents)

Delivery :

LIKP - Delivery header

LIPS - Delivery item

Pricing :

KONH - Conditions header

KONP - Conditions items

KONV - Procedure ( billing doc or sales order)

KOND

Contracts :

VEDA - Contract data

Regards,

Rajesh Banka

[Former Member]

Hi,

1. how to find the sales order quantities that have not been invoiced. Is it just 0QUANT_B for the open order?

Ans: There is Standard Report VA05, inwhich you can see.

2. How do you find if an sales order is open or closed?

Ans: Go to Document flow in sales orer. Or press F5 in sales order you will seee.

3. When is the order closed?

When all the Quantities are delivered, billing is generate, and passed into accounting.

4.Should you include credit notes when you calculate invoiced quantity

No.

Thanks,

Raja