4,818
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
Usually release of the order and opening it back forces recalculation. Alex A mentioned this already, I support this idea.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (