AR - Payment applied full but no invoices applied.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

I'm facing with a problem that I have a history payment(X) that applied for 4 invoices(A,B,C,D). But in GP, it only show the payment applied for 1 history invoice(A), so 3 invoices(B,C,D) are still outstanding.

--Detail SQL queries:

select * from RM30101 where DOCNUMBR in (X, A, B, C, D)

-- Result 2 rows

+ X with CURTRXAM 0

+ A with CURTRXAM 0

---------

select * from RM30201 where APFRDCNM='X'

-- Result 1 rows:

+ A

---------------

Now, I want 3 invoices move from OPEN to HISTORY and also allocate it to the payment.

Could you please advice me for this case.

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: AR - Payment applied full but no invoices applied.

Hi Jeffrey for your suggestion, but I'm so new with GP system,

Could you please explain more detail?
Suggested answer

twelvestrikes 3,657 on at

Like (0)

Report

RE: AR - Payment applied full but no invoices applied.

Hi Trang

Install the PSTL (Professional Services Tool library)

One of the tools is the RM Transaction Unapply

You can use this to return the payment to the open file by unapplying the one invoice

Then you can reapply the payment to the open invoices.

Make a backup of your database before performing this action. Ideally try it out in a test company first.
Community Member Microsoft Employee on at

Like (0)

Report

RE: AR - Payment applied full but no invoices applied.

I also not can void the history payment too.