Customer Transation History

(0) Share

Report

Posted on by MLFDJ

240

Just wondering how to get rid of an invoice from Receivables Transaction Inquiry that show an applied payment when you drill down, but is still showing. I have tried Paid Sales Transation Removal and it returns 0 results with everything slected to be removed for that customer. I am using GP2010 and this has me scratching my head. I have done checklinks as well with no results. Anyone know how to get rid of this transaction as it has already been paid and won't go away? Thanks.

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

soma 24,410 on at

Like (0)

Report

Remove Paid Transaction Removal process is not remove the transactions from Receivables Transactions Inquiry/GP. It will move the open transactions to Historical status. Not from GP.

If you want to remove these transactions, go to Remove Transaction History(Tools-->Utilities-->Sales-->Remove Transaction History) window to clear the transactions from GP. Make sure you have a backup of company database before running this process.

Note: This utility will remove only the historical receivables transactions.

Hope this helps!!!

Was this reply helpful? Yes No
MLFDJ 240 on at

Like (0)

Report

Yes, moving them to history is exactly what I am trying to do. I don't want to remove the history, I want to get it so that it no longer shows in my Receivables Transaction Inquiry window as it was already paid and should have moved into history. How do I either make it not show in Receivables Transaction Inquiry or switch it over into history permanently. Thanks.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

The Receivables Transactions Inquiry window shows all status of records(Work, Open & Hist). We can't restrict them.

If you want to see only the work & open transactions, go to the Receivables Transactions Inquiry - Customer window and then un-mark the History check box and enter customer id & document number to view the inquiry transactions.

Hope this helps!!!

Was this reply helpful? Yes No
MLFDJ 240 on at

Like (0)

Report

I think I am confusing both of us. I have attached a picture of what I am talking about. The line for $441.83 is paid and should not be listed on this screen as it is shown here. Perhaps this will make it easier to follow me. It is open and paid, when it was paid, it should have moved it from open to History and it didn't. Does that make more sense now? Thanks again for baring with the mental patient. :)

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

If you select the $441 transaction, and then zoom back on the 'Amount Remaining' field, you should get a window that shows you which documents were applied to the invoice. That is the first thing I would check. Is it possible that there's a document that has not been fully applied. I'm guessing 'no' since nothing else is showing up in the open table. It could, however, be hiding in the work table. You could have an unposted applied document.

If there's nothing in the work table, then we have some file surgery to do. I presume you've run all of the usual suspects: Remove Paid Trx, Reconcile, Check Links. If those are exhausted and it's still messed up, launch SQL Server Studio Manager and look at the raw tables.

You'll need to check the following tables for the existence of the Sale as well as the cash receipt:

RM10201 (unposted Cash Receipts)

RM20101 (Open transactions)

RM20201 (Open transactions apply)

RM30101 (Historical transactions)

RM30201 (Historical transactions apply)

Let us know what you find.

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

In GP, for Sales, once the document is fully applied for a customer. it always remains in open. once we do Paid Transaction Removal process the document is moved to history state.

if in case of National Accounts(2 or more customers) involved in the process then we need to do Paid Transaction Removal process for the associated customers to change the document from open to history state.

but in Purchase, once the document is fully applied it moves to History state.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Run the below query against company database and attach the result to us.

SELECT ORTRXAMT,CURTRXAM,* FROM RM20101 WHERE DOCNUMBR = 'SHIP-1022938'

Was this reply helpful? Yes No
MLFDJ 240 on at

Like (0)

Report

Sorry Leslie, but I have never used SQL other than to do what I am told. I have just enough knowledge to really get myself in trouble, so I always ask first. I assume the check is going to be... SELECT RM10201 WHERE DOCNUMBR = 'SHIP-1022938' etc, etc...

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

Have you ran Reconcile for the customer?

If not, go to Dynamics GP-->Tools-->Utilities-->Sales-->Reconcile and choose Outstanding Document Amount and enter the customer in form & to field then click process.

After completed the above step, run the Paid Transaction Removal routines for this customer and check the inquiry window.

Hope this helps!!!

Was this reply helpful? Yes No
MLFDJ 240 on at

Like (0)

Report

Soma, it tells me invalid name RM10201

Was this reply helpful? Yes No