asked on

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.

Victoria Yudin

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.

pstre

ASKER

When I run the last script, I get "NULL" as the results. I put in my batch number

ASKER CERTIFIED SOLUTION

Victoria Yudin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial