Sales Order Report

[johnsmith]

Hi

icreate report for sales order which display each sales order item with sum of lineamount(net amount)

but iwont to create the total for sales order net amount .

RGDS

[Andrew_Cooper]

There is a field on the sales header table called amount, this is the total of that order.

Andrew

[Alex_Chow]

Try using the field called Outstanding Amount (LCY). This will give you what’s outstanding.

The problem with the Amount field is that you have to release the order first in order for the amount to display.

[johnsmith]

Hi

thanks

RGDS

[David_Singleton]

Try using the field called Outstanding Amount (LCY). This will give you what’s outstanding.

The problem with the Amount field is that you have to release the order first in order for the amount to display.

Is that for AX or NAV [;)]