AP Entry not showing in GL

(0) Share

Report

Posted on by CalebA

I posted an AP entry into the Purchasing system without using a batch. It posted through and I can find it in the AP Ledger, but it's not showing up in the GL. It seems to be stuck in limbo. When I search for the Journal entry that the SmartList gives me, the system says the number doesn't exist....

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: AP Entry not showing in GL

Posting in Dynamics GP without a batch doesn't post to GL automatically even if your setup is to post to GL on the AP module, that has been the behavior of the system.

You should be able to find a "saved" batch in the General Ledger with AP source, look for it in the General Ledger journal transaction entry window.

If you are quite sure that there is nothing in the general ledger; which I doubt, you may proceed with a manual journal entry with the corresponding values.

Please never hesitate to share any further inquiries,

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: AP Entry not showing in GL

First check if any batches are pending in Financial module with related to AP. If so, post them. Then open the Account Transaction Smart list and add a column "Originating Document Number", then add a filter to this column with equal to your posted AP document number. Then click ok to view the smart list for the JE.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AP Entry not showing in GL

I have one Invoice Batch which has 67 transactions out of which 66 transactions are posted to GL and one transaction is got failed. As mentioned by Soma I have checked required GL tables and Smartlist with Originating Master ID and Originating Document No.. Also I have checked with Audit trail. I found that in GL only 66 entries got created for that particular batch. I know I can create a manual entry but I want to know following :

1. Does GP stores these kind of transactions in any of existing or temporary table?

2. How we can find out this transactions in any of GP table?

Regards,

Sanjay

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AP Entry not showing in GL

Is there any idea to know why that transaction could not got posted in GL. Not even that entry got created.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: AP Entry not showing in GL

Sanjay, if you have a 67 transaction batch and 1 fails - go back to the source of the posting and look for a batch with 1 transaction. If a transaction fails, is is left in the original batch location.

You should be able to select the Batch - in the Batches menu, not the series post - and from this point, you should be able to print / edit and figure out the problem.

Normally this is caused by missing GL accounts but it could be any number of things depending on the original source of the posting.

Hope this helps.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

RE: AP Entry not showing in GL

Sanjay, you might want to post this to a new thread if you do not get any more responses, as this thread is 2 or 3 years old and not often looked at.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AP Entry not showing in GL

Hi Bill,

Thanks for your response. I have a Payable transaction batch which has 67 invoices and all those invoices posted correctly in Payable module. But in GL one Invoice was failed to post.

If account is missing/inactive then in Payable itself it would not get posted or it would be in Batch Recovery.

I am wondering why only 1 transaction is not get posted in GL and I need to find a reason for that.

Regards,

Sanjay

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AP Entry not showing in GL

Yes Bill, definitely I will open a separate thread for the same.

Thanks & Regards,

Sanjay

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

RE: AP Entry not showing in GL

Hi Sanjay,

Are you able to go to the invoice and drill down to GL for the missing transaction. Have you tried to reconcile the GL if so please try check link for both financial and payable. Please take a backup before doing this.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: AP Entry not showing in GL

Hi All,

I found what was an issue, While Importing Invoices one of the Accounts was active but before posting invoice the same account got inactivated by an end user. As we have Post to GL setting at Posting Set up. The invoices at AP got posted but GP deleted the transaction entry during posting. Due to which we could not see that transaction in GL. I have made same GL entry and updated the GL20000 table.

Regards,

Sanjay

Was this reply helpful? Yes No