Release Date: 4/14/25

This feature allows the purchase order application to show the line item cost in the vendor’s currency using currency conversion rates. This applies to the purchase order line item screen, several reports, and PO Invoice Processing. This change does not apply to vouchering. Vouchering against a purchase order will use the expected FOB cost which is in US Dollars.

NOTE: This feature is not about supporting multi-currency handling. Elliott does not support this functionality at this time. This feature is about showing the amount in the purchase order application.  The currency gain or lost will need to be handled manually internally outside of Elliott.

This functionality is enabled via a new flag - Global Setup -> Dist -> PO Global Setup-> 47. Calc PO Cost Using Vendor INVCURRENCY Attrib?

47. Calc PO Cost Using Vendor INVCURRENCY Attrib – Default is N. If set to Y, various purchase order applications will verify that the INVCURRENCY attribute is on file for the vendor to determine the default currency code, exchange rate and if the application should multiply or divide using this rate.

This feature relies on the information set up for each vendor in the INVCURRENCY attribute. This attribute can be created by running System File Setup-> Maintenance-> Attribute File-> Create-> Other Attributes.

This will create the attribute definition for the INVCURRENCY attribute. This attribute should be added to each vendor where the line item cost on the purchase order line item screen should also be shown in the vendor’s currency.

The purchase order line item screen supports a new field 24. Exchg Rate.

24. Exchg Rate - This field will default to the exchange rate set up in the INVCURRENCY attribute for the vendor. The value in this field will affect the currency List Price and Unit Cost shown on the screen. These are calculated display fields and not stored in the database.

Choosing the option to display and search the list of line items also shows the currency rate and converted value for each line item.

The exchange rate and the converted cost are printed on the Purchase Order Edit List.

Purchase Order & Receiving-> Processing-> Purchase Order Processing-> Change CSV Import now supports the import of the currency exchange rate for purchase orders with vendors that support multi-currency. The exchange rate is supported in column W of the CSV import file.

Import of the CSV file will update the currency exchange rate that is stored on the purchase order line item record. This will mark the line item as changed and the purchase order will need to be reprinted.

The exchange rate and the converted cost are exported to CSV when printing the New PO Scheduled Receipts report and choosing “C=Detail+Cost” print format.

Legacy PO Receiving Posting and Warehouse Receiving Posting both update the Receiving Audit Trail File with the currency exchange rate entering on the purchase order line item record at time of posting. The exchange rate and the converted cost are exported to CSV when printing the Receiving Audit Trail Report.

The exchange rate and the converted cost are exported to CSV when printing the Summary version of the Receiving Audit Trail Report.

Purchase Order Export supports the export of the exchange rate from the purchase order line item file.

Purchase Order Invoice Processing shows the unit cost with the exchange rate applied on the Invoice Line Item screen.

Programs Modified: NSCTLFIL.FD, NSCTLFIL.W40, NSCTLINI.CBL, NSCTLMN3.CBL, POAUDWRK.FD, POORDASC.FD, POORDLIN.FD, PORECAUD.FD, PO0101.CBL, PO0111.CBL, PO01P1.CBL, PO04P1N.CBL, PO05P1.CBL, PO05P3.CBL, PO2002.CBL, POCHGIMP.CBL, POEXPPO.CBL, POINVLMN.CBL, POINVMNT.CBL, POORDEXP.CBL, POREQPOP.CBL, POWHRLST.CBL, POWHRPST.CBL

CLS