How do you post to AR subledger (i.e. customer account) only? Historical Aged TB does not tie to AR TB account.

(0) Share

Report

Posted on by jkburnell

How do you post to AR subledger (i.e. customer account) only? Historical Aged TB does not tie to AR TB account.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (7)

Answers (0)

Gavin 2,508 on at

Like (0)

Report

Hi,

You can do this via the "Posting Setup" window. Amongst other things the settings in this window control how the subledgers interact with the GL.

You can temporarily switch off the link to the GL as per below.

First select "Tools > Setup > Posting > Posting"

Then select the series and origin and untick "Post to General Ledger" and click OK. (in this case I've chosen "Sales" and "Receivables Sales Entry")

You can now post a transaction via "Transactions > Sales > Transaction Entry" and the GL won't be updated.

Ensure you switch this back on once complete and also that no other users are posting when you untick this.

Hope this helps

Thanks

Gavin

P.S. You can also leave those settings as they are and post the AR transaction in the Sales Ledger and reverse the journal manually in the GL if you prefer. (via "Transactions > Financial > General" either manually or using the Correct function)

Was this reply helpful? Yes No
jkburnell 20 on at

Like (0)

Report

Thanks, Gavin.

When I ran the AR Module reconcile, I found these items were only posted in the AR module and did not hit the GL. Will give this a try.

JB

Was this reply helpful? Yes No
PTC 35 on at

Like (0)

Report

if they've already posted in AR but didn't hit the GL, then just make JE in the GL.

If you need to adjust a customer bal in AR, then you can create an AR Trans and post both DR and CR to same GL account, that will adj customer balance but not affect the GL

Was this reply helpful? Yes No
jkburnell 20 on at

Like (0)

Report

Ok, so the GL balance for AR is correct, since the transactions in question are actually credits to AR (AR historical TB is showing a lower amount than TB since).

However, when I followed the instructions, I posted an invoice that is now showing on the AR Aging report. Is there anyway to delete the original transactions?

Was this reply helpful? Yes No
Gavin 2,508 on at

Like (0)

Report

Hi Jeremy

Apologies if I misunderstood your original request. As you mentioned in the original post you wanted to post to AR sub ledger (customer account) only, I provided steps that enabled you to post a transaction that would hit the customer account but not update the GL.

If you want to just update the GL, and not the AR sub ledger, then as Michael suggested, you just post a manual journal to the AR GL code via "Transactions > Financial > General".

With regards deleting an entry, you can't delete a posted transaction, but you can void it. You do this via "Transactions > Sales > Posted Transactions". Just select the customer and transaction and click "Void"

This will remove the transaction from the Historical Aged TB and create a GL journal to reverse the entry in the GL.

I hope this helps

Thanks

Gavin

Was this reply helpful? Yes No
jkburnell 20 on at

Like (0)

Report

Thanks again.

Final question, when posting directly to the GL, do you just use the AR account for both sides of the entry?

What about posting directly to the subledger? Same idea as posting to the AR account?

Was this reply helpful? Yes No
Jeff Grant on at

Like (0)

Report

Hello JK,

If you are posting to the GL only to tie out the AR accounts from past processing in the RM/SOP modules at this point in time you would use the Transactions | Financial | General | Transactions Entry window to create and post the GL adjustment, which will not update the RM module in any manner. Once the AR accounts are balanced between the GL/RM modules it should be easier to reconcile the two modules on a periodic/daily basis going forward.

Please note that the RM Trial Balance will only include transactions in the RM Open (RM20101) table while the RM Historical Trial Balance will also include information from the RM History (RM30101) table as well. When RM transactions are fully processed in Dynamics GP they will reside in the RM20101 table indefinitely unless the Tools | Routines | Sales | Paid Transaction Removal routine is ran, which pushes completed documents to the RM30101 table for purposes of historical reporting, while freeing up space in the RM20101 table to improve processing performance in the RM module accordingly.

Best Regards,

Jeff Grant
Microsoft Dynamics GP Support

Was this reply helpful? Yes No