Open Forum

Expand all | Collapse all

Open invoice in cash receipts

  • 1.  Open invoice in cash receipts

    Posted 10 days ago
      |   view attached
    I had a user get bumped out of GP while processing a cash receipt.  The four invoices are still showing open, but now can't be applied.
    I see the four documents in the RM20201 which are showing applied to the receipt number.
    When I run an inquiry on the document the amount remaining and open amount do not match (amount remaining is zero).

    I ran reconcile on Outstanding Doc Amount for the customer that resulted in no change.  Should I also reconcile Current Customer Information?

    Do I need to run check links on Receivables Open Transaction Files?

    Anything else?

    Thank you in advance!

    ------------------------------
    Bob O'Malley
    Lead, Business Analyst
    Stanley Healthcare
    Waltham MA
    ------------------------------

    Attachment(s)



  • 2.  RE: Open invoice in cash receipts

    TOP CONTRIBUTOR
    Posted 9 days ago
    Hi @Bob O'Malley

    I just want to verify that wen you have the Inquiry screen open on the document, what happens when you highlight the invoice paid and click on the "Amount Remaining" blue link?

    Is there a transaction number that the invoice is applied to, and if so, is it the same one that GP says does not exist?​

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

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



  • 3.  RE: Open invoice in cash receipts

    Posted 9 days ago
    Hi @Jo deRuiter,

    Yes, ​there is a transaction number that the invoice is applied to and it's the same one that GP says does not exist.  I was unable to run check links last night, but I did a reconcile on Outstanding Doc Amount and Current Customer Information for the customer which did not free it up.

    The phantom payment was the only thing to be applied to these invoices so I ran 

    select * from RM20101  where docnumbr = <your invoice number>

    Once I verified it was one row, I ran the following update

    update RM20101 set  CURTRXAM =  ORTRXAMT where docnumbr = <your invoice number> and  RMDTYPAL = 1

    This will now allow the invoice to be applied via cash receipts.



    ------------------------------
    Bob O'Malley
    Lead, Business Analyst
    Stanley Healthcare
    Waltham MA
    ------------------------------



  • 4.  RE: Open invoice in cash receipts

    TOP CONTRIBUTOR
    Posted 9 days ago
    Hi @Bob O'Malley

    Checklinks would likely not clean this one up, neither would the reconciles (unfortunately)

    You will need to contact your partner or other consultant to help get this one fixed.

    There are more tables involved that just the RM20101

    ​Look at the RM20201 and see if the transaction is in there and if so it may simply be missing some critical info you can update.

    There are also other triggers in the RM20101 that might keep these from being applied, such as DINVPDOF.

    Again, check that all of the fields and triggers in RM20101 look like any other unapplied transaction (you'll have to compare) and also look at what happened in the RM20201.

    If there were taxes on the transaction or Frieght, etc. we may be talking about several other tables as well.


    If you need help, feel free to contact me.

    If you are going to Summit, you may be interested in my presentation on Data Repair in Dynamics GP.

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

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



  • 5.  RE: Open invoice in cash receipts

    Posted 9 days ago
    Hi @Jo deRuiter,

    Thank you for the added info.  ​I did compare a few transactions in the RM20101 and did not see anything missing.

    I will not be attending Summit this year, but would've definitely attended your presentation if I was.

    ------------------------------
    Bob O'Malley
    Lead, Business Analyst
    Stanley Healthcare
    Waltham MA
    ------------------------------



  • 6.  RE: Open invoice in cash receipts

    Posted 9 days ago
    I think you will have to reach out the MS support to get the proper scripts needed to complete the transaction unless someone in the group already has them.

    These situations are no fun!


    ------------------------------
    Kevin
    ------------------------------



  • 7.  RE: Open invoice in cash receipts

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Bob,
    I would definitely run the check links and the recon routine first. I know there is an "index" table that connects the receipts to the open receivables. I am not sure of the number that gets updated on application. It sounds like it missed that last post to that table.
    Jeff

    ------------------------------
    Jeff Strait
    Controller
    Ideal Deals, LLC dba Ideal Aluminum Products
    St. Augustine FL
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role