How can I filter both of reports to match the total. GL Transaction and AP vendor Transaction report totals do not match for same month.
How can I filter both of reports to match the total. GL Transaction and AP vendor Transaction report totals do not match for same month.
Typical points to check:
- GL Data not yet sent by AP - force send using AP Perdioic Processing / Create GL batches
- unposted GL batches - especailly error batches.
- deleted GL batches - especially error batches.
- Direct GL journal entires to the GL Control account - look for entries not fomr source ledger AP. Suggest in GL you setup Source Journal profiles for this and then use the Source Journals report
- Compare tranaction in GL to those in AP by printing / exporting to Excel the AP G/L Transactions report for that period.
Typical points to check:
- GL Data not yet sent by AP - force send using AP Perdioic Processing / Create GL batches
- unposted GL batches - especailly error batches.
- deleted GL batches - especially error batches.
- Direct GL journal entires to the GL Control account - look for entries not fomr source ledger AP. Suggest in GL you setup Source Journal profiles for this and then use the Source Journals report
- Compare tranaction in GL to those in AP by printing / exporting to Excel the AP G/L Transactions report for that period.
*Community Hub is the new name for Sage City