Great Plain (GP 2013) - PM30200 unapplied amounts

We had a posting interruption on our weekly check run in AP.  We figured out what checks didn't post, set the batch status to 110 since the checks were already printed. How can I tell how much the batch posted for? In the PM30200 for this batch, there are unapplied amounts and I don't think that is correct.

This batch # was NOT in the PM10300 or the PM20000 but it was in the PM30200 table.
pstreAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Victoria YudinOwner / Dynamics GP ConsultantCommented:
When you say "unapplied" amounts, are you looking at the CURTRXAM column? The only transactions that should have non-zero amounts in that column in PM30200 are voided ones. If you run the following query do you get any results?

select * from PM30200 where CURTRXAM <> 0 and VOIDED = 0

Open in new window


You should expect to not get any results with that. If you do get results, there may be a data issue that you want to check on with either your GP partner or Microsoft support.

Separately to get the total of a batch, you can use the following code, don't forget to change the batch ID on the last line:

select sum(DOCAMNT) from PM30200 
where VOIDED = 0 
and DOCTYPE = 6 and 
BACHNUMB = 'YourBatch'

Open in new window


This assumes that all of the checks in your batch are fully applied and posted.
0
pstreAuthor Commented:
When I run the last script, I get "NULL" as the results.  I put in my batch number
0
Victoria YudinOwner / Dynamics GP ConsultantCommented:
What do you get if you run the following?

select * from PM30200 
where VOIDED = 0 
and DOCTYPE = 6 and 
BACHNUMB = 'YourBatch'

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.