Customize the Open Purchase Orders Report. On the Edit Columns tab> Add Fields section, expand the Open Purchase Orders group and add the Exchange Rate field. On the Edit Columns tab> Add Fields section, click on the Add Formula Field button. Click the pencil icon for the Formula column, and set the following values: Formula Type = Ratio x/y x = Current Amount y = Exchange Rate The Formula column would then show the… Continue reading Open Purchase Order Report > Show Open Amount based on Transaction Currency
Tag: Customization report
Gross Profit Report
A customization report that shows Gross Profit for every month and download as CSV.
Gross Profit Report
A NetSuite customization report which displays gross profit details as a sublist.