Announcements
105
Our sales invoices are imported into Receivables Management and in error a negative invoice was posted. I have tried to apply a Debit Memo to it, but you cannot apply negative invoices in GP. I have also tried to void via the RM Posted Sales Transaction screen, but receive the message that it first must be unapplied, but it is not applied.
Does anyone know how to remove?
Thank you
*This post is locked for comments
I ran into a similar issue today where one of the returns got posted as an invoice but found a solution which worked for me, where I was getting the similar error on the invoice and the invoice would not show up on the Apply Sales Document window.
Under Tools>Utilities>Sales>Reconcile, and selected the customer with the negative invoice for reconciliation, which made the negative invoice start showing up on the Apply Sales Document Window as well as became available to void.
After that, it was the standard process to void the invoice and post it again correctly as a proper return.
NOTE: Please make sure that you have a restorable backup prior to performing any troubleshooting steps.
1. Test in a test company with live company data.
2. Create a complete backup of live before processing in live.
3. Run the following select and update statement to correct the Current Transaction amount.
a. Use the select statement to verify the correct record is being updated.
Select * from RM20101 where DOCNUMBR = JC205251
b. Run the update statement to update the amount.
update RM20101 set CURTRXAM = '-56974.17000' where dex_row_id = 71586
4. Once you have verified this is the correct record and have updated the Current Transaction Amount you can now void the Invoice.
a. Sales | Transactions | Posted Transactions.
b. Document Type = Sales/Invoices
c. Number = the Invoices Document Number.
d. Enter the correct Void and Posting Date.
e. Click Void
f. Verify the report.
5. Post the GL batch that was created from the void.
6. Verify your reports are correct.
If you have solved this problem, can you post for the knowledge of the others that might be experiencing this type of error.
I have not seen this happen, but am interested to know how you fixed the situation.
Hi,
From my very short test, GP doesn't seem to like these Negative RM Sales Transactions.
Advice:
1.) Run paid transaction removal. This will put the document in History
2.) Run Reconcile on Customer Debtor Information (this will adjust the figures by taking this negative amount out of the Customer Balances).
3.) Back out the transaction from GL.
4.) You may need to also check any of your Tax tables (just to see if they need adjusting).
5.) Re-enter the transaction as a positive value.
Thanks,
Justin
How did you import this transaction. Did you try to run checklink against RM.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
