DGreen
15 days agoCover User
Entitlement Balance errors
Hi, I have 2 staff members that resigned (leave entitlements paid out) and then were reinstated and now have wildly incorrect balances in the entitlement balance report even though their card files have the correct figures.
Please help.
Diane
- Hi , in 2019.2 you can run the Receivables & Payables Reconciliation Summary reports, and filter those two by currency, and tick the option to display ageing in originating currency. At the moment the detailed versions of those two reports do not have these options. I'm hoping to see them in the next release, but that won't be until August. A statement in foreign currency can't be produced either.
The API endpoint for item and service invoices includes "BalanceDueAmountForeign". For a file in a local library, there are ways to extract this data using Excel, and it could then be grouped by month and summarised in a pivot table.
Note that there is no foreign currency receivable account in the GL, as there used to be, so the f/c receivables reports can only be reconciled in your home currency.