Amount in the sales header

(0) Share

Report

Posted on by snoppy

4,824

Hi expert, Does the field amount in the sale header reflect the total amount field of the sales for the sales? In our system, the amount for most of the sales orders is correct, but some orders has zero in the amount in the sales header even though there are values in the sales line. Please advise! Thank you!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Amount in the sales header

Usually release of the order and opening it back forces recalculation. Alex A mentioned this already, I support this idea.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

RE: Amount in the sales header

If the value goes as 0 then try releasing sales order as Alex mentioned.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Amount in the sales header

If you want to see the Total Amount field of Sales Line, you can create new flow field as Order Amount in Sales Header with following expression.

Sum("Sales Line"."Line Amount" WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.)))

Line Amount field in Sales Line would be always updated and hence you would always get the accurate result.

Existing Amount field will only gets updates as mentioned by Alex and hence you would not see the Amount for few of the order, which are not yet released or posted.

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (1)

Report

RE: Amount in the sales header

HI,

Adding some more to what Alex have said, this technology is called SIFT and the Amount field is a FlowField. You still use Amount field on the Sales Header for report calculations, but you have to use CALCFIELDS method to calculate it.

If your Sales Header Amount field is showing 0 then as Alex suggested, open the Statistics window and check.

Hope it helps.

Was this reply helpful? Yes No
Suggested answer

Alex A 2,451 on at

Like (3)

Report

RE: Amount in the sales header

It is used to calculate the invoice discount of the sales order. To preserve database performance during sales order entry, the Amount field is only updated when a calculation of the sales invoice discount is required, in the following situations:

When you post (invoice) the sales order partially or fully.

When you calculate the sales invoice discount manually.

When you open the Sales Statistics window for the sales order.

When you release the sales order.

In fact, this field doesn't really exist in the table. If you want to calculate the Sales amount for reporting purposes, Sum the [Amount] or [Amount Including VAT] field from the Sales Order Line table.

Was this reply helpful? Yes No