Not all ARTran records move to GLTran.

(0) Share

Report

Posted on by Community Member

Good afternoon, all! I hope that you are doing well and avoiding COVID-19.

My client has an AR Batch that shows as Unposted in GL. They tell me that the batch released in AR without issue, but when they attempt to post in GL they receive an "Out of Balance" error.

In SQL I looked at the Batch and GLTran records, and it is indeed out of balance. Stepping back a bit more and looking at ARTran, I found that a good number of the records did not release and are are still in the table with a Rlsed = 0 status.

My question is twofold:

1. Any idea on how this would happen?

2. How to go about fixing this? my initial thought was to change the batch to "S" status and release it again, but I'm not sure how that would affect the records already in GLTran.

Any help, as always, is greatly appreciated.

Stuart Nottingham

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

I reset the batch record to 'S' and the Rlsed field in Batch to 0. I then ran ARDEBUG on the batch and got the results below. The only obvious error relates to the HistSlsTax table; since there are five (verified) records in that table related to the "Released" records in the AR batch, I would expect the error. Anyone see anything in here I'm missing? I'd like to clear this up for the client.

debug_5F00_200317.txt

Was this reply helpful? Yes No
Verified answer

CFROTON 4,710 on at

Like (0)

Report
Copy link

Link copied!

Dear Stuart,

What are the gl trans, do they represent the released artrans only?

You can create a new AR batch by opening up the invoice screen putting in a transaction and saving..you can then delete the transaction.

Now you can update the unreleased trans to the new batch number and release it.

The original Gl batch can be corrected by just changing its total to have it recalculate.

Best Regards,

Jana MacDonald

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response, Jana. Yes, the GLTran records do reflect the released ARTran records. I was thinking of exactly the process you suggest to rectify the problem, and am glad to get the verification that's the correct procedure to follow. Will update once I have the solution in place.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

That did the trick, Jana! Thanks!

Was this reply helpful? Yes No