Trade Payables Balance Mismatch Issue

Error

TB 2023 - Trade payable - foreign 1,508618.56

Payable report foreign - 1,496,723.52

Users have posted this JE but it shows no difference, so reversed the entry. Users noticed the Trial balance report and the payable report not matching. (even if posted the entry, it is not showing on the foreign payable?)

Solution

Currently there is a mismatch between the TB and the Aging report as an old entry for Greiner was posted directly to the G/L Account instead of it being posted to the account through a vendor. The aged accounts payable report will only show the entries that have been passed through a vendor. Due to this, the old entry is affecting the G/L Accounts balance but it will not show in the aged accounts payable report.

To identify the entries that have been directly posted to the account, please follow these steps:

-Go to the trade payable account entries

-Filter the source type and select all of the options except vendor 

-This will show all of the entries that have been posted directly to the account, including currency adjustments. 

-The relevant Greiner document nos. are: G00183|G00184

How to fix the balance:

-Reverse the two entries mentioned above and post the new entries by selecting a vendor if the invoice has not yet already been created yet.