AR Aging

(0) Share

Report

Posted on by YuliyaY

550

I need to match AR aging in sales to AR trial balance in financial. I put same date same customers but aging comes up with negative balances what do I do wrong ? Where to look for errors ?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: AR Aging

Have you looked at the GL Reconcile routine in Financial under Routines? It will show you the differences between what was booked to the general ledger vs what was booked in the subledger. This routine I believe gets you just what you want.

Kind regards,

Leslie

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: AR Aging

Nothing more valuable, just a video tutorial for the Reconcile to GL utility

Was this reply helpful? Yes No
YuliyaY 550 on at

Like (0)

Report

RE: AR Aging

I run P&L and there we double CM... where do I delete the batch with Credits that wasn't supposed to post when I integrated CM in sales module?

I think it piked up unposted batches too...

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: AR Aging

Hello again Yuliya

I believe you are talking about cash receipts that were duplicated, right ?

are they posted or not ?

Was this reply helpful? Yes No
YuliyaY 550 on at

Like (0)

Report

RE: AR Aging

Hi again :)

I am talking about double booking sales and creating CMs in sales module that weren't supposed to flow to GL, but they did ... and on my P&L I have double sales and double CM...

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: AR Aging

Hey Yuliya

Always welcome

I would like to better understand the problem before suggestion any associated answers. By now, we have double amounts on both the Sales and GL, this means the following:

Double sales invoices on the receivable module

Double General Ledger accordingly

What do you mean by creating CMs in sales ?

Was this reply helpful? Yes No
YuliyaY 550 on at

Like (0)

Report

RE: AR Aging

exactly, I have double sales and double credits... CM is Credit Memos that I created to get rid of twice integrated sales. Ok here is the store: I integrate sales in sales module twice -> they went to GL twice.

then I reverse my integration file and integrated again in Financial - GL, so double entries in GL are cancel each other out.

but the double integrated sales were still in sales ( receiving module) since I didn't do anything here. So following on a suggestion here I created Credit Memos,integrated, Posted it into sales module and manually applied it to those double entry sales. I think you or another person mention that to avoid those CM to be posted again in GL I need to change "Posted to" setting in "Posting", so I can delete the batch in Financial module... now where can I delete this batch? I dont see it under "Batches" in Financial tab ...

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: AR Aging

Okay Yuliya, we are clear by now

This is supposed to be a proceeding session of your previous case with the double sales invoices. I will illustrate the following chart to simplify how things are by now:

The following are to be considered:

Sales Invoices 119 and 120 are duplicated, and posted to GL. > It means both Sales and GL have double balance

As you already stated, the double entry on the GL have been manually corrected. The chart show 2 lines of corrective journal entries above. > Now the Sales Balance is doubled, and the GL balance is correct

Proceeding, you should have posted credit memos to revers the double entry (Credit memo for 119 and 120). These credit memos should not be posted to GL, since the GL balance is already correct. > Then, the sales module balance is correct. (To find the batches, go to Transactions > Financial > General, and check any journal entries resulting from the AR module)

Overall correction should lead you to a balances Sales and GL.

As mentioned above, the reconcile to GL utility shall provide you with a report that is similar to the graph I attached above. It will show you what is posted, and what is not posted along with the overall variance between the modules.

If you bring an attachment for the reconciliation report, it will be great to proceed.

Was this reply helpful? Yes No
YuliyaY 550 on at

Like (0)

Report

RE: AR Aging

Mahmoud, I would like to set up share screen with you and phone conference to show you what I have in Dynamisc. suggested way of fixing this didn't work...because posted credit memos somehow went to GL which caused double credits ... please !

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: AR Aging

Email me at mahmoodsaadi@live.com, and we will arrange accordingly.

Was this reply helpful? Yes No