AP Invoice Approval Workflow Spreadsheet Conversion Date

Summary:

Current Rule Evaluation Currency is looking at Conversion Date = Invoice Date. We need it to be Rule Evaluation Currency Conversion Date = Invoice Header.Conversion Date

Content (please ensure you mask any confidential information):

In the Payables Approval Workflow spreadsheet loader, we're making use of a threshold using 'Invoice Amount' on header.

Since our ledger is in EUR, I've also added the attribute 'Rule Evaluation Currency' = EUR in my spreadsheet loader. To make sure USD or other invoices are evaluated in EUR using the Corporate conversion rate.

Now recently gone live, we noticed that invoices with an invoice date in January are entered in the system. The Conversion Date on the Invoice Header = Accouting Date = System date. Meaning it takes the Conversion Date = 4/APR/2025, which exists in the daily rates table.