Missing transactions from AP not posted to GL.

Posted By Raydelite over 9 years ago

Good day everyone,

I am using Sage 300 ERP 2012(6.1) PU4 using AP, AR,GL modules.

I was wondering if anyone here have faced this issue when posting invoices from AP?

Below are batches that were posted successfully and there were no error batches but they were not posted to the GL. While trying to find what is wrong, I printed the posting journal report and see that the transactions are missing from the Posting journal though the status says "POSTED".

Can anyone advise on what to do besides keying the invoices or amending from the tables? Moving forward, are there any possible reasons as why this had happened and any possible solutions?

Thanks in advance! Smile

0 IDLSystems over 9 years ago

This states that it has been posted in the AP system Not the GL system.

Have you gone to the GL Batch list to see if the batch is still waiting there to be posted ??

Have a look in AP setup (GL Integration) to check how the GL is updated
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 9 years ago

Go to AP Periodic Processing, Create GL Batch and run it for all transaction types, see if that creates any GL batches. Then make sure that all GL batches are posted.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Raydelite over 9 years ago in reply to Ettienne Schwagele

Hi, thank you for your advice. It was also one of the methods I tried and this happened... I did a backup and went to amend the BTCHSTTS to Ready to Post in APIBC and posted the affected batches again and it finally worked.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Missing transactions from AP not posted to GL.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING