3,795
There is a posted SOP invoice, which has been wrongly voided at RM side and not SOP side (Transaction >Sales >Posted Transaction)
Actually, the correct way is to "Create Return", but the SOP Invoice was wrongly voided at RM site, but the effect only on RM and GL, but not SOP and not Inventory....So, how can I make correction of my mistake.
Many thanks in advance.
*This post is locked for comments
Since the receivable is already corrected ( if you have not done anything else) simply enter an inventory transaction to add the item back into stock and offset to the COGS account.
Thanks Ian
that will correct the return
the only problem is that the 2nd SOP invoice will have to be voided again (i mean phisically)
so in the sales registry (the legal one) that invoice would be marked as voided too.
well ill make something up to tell the controller hehe
Thanks!
Well...you could post a SOP Invoice to correct the wrong Return?...and then process the return correctly (to cancel out the original invoice)...you end up with 2 Invoices and 2 Returns - all cancelling each other out. You are now back at square one, and can enter the Invoice correctly.
Hi Ian
please how could you void a sales return?
the user made a wrong sop then to fix He made a sales return but it was wrong again
I thought about a RM transaction and an inventory entry but i dont know if this is correct or there is another way
thanks a lot
Hi William, comments below.
Because of : Wrongly voided a posted SOP invoice using "Posted transactions" window (then this clear RM side, but not SOP and not Inventory) - Correct
So, my further steps to ensure other module get updated (eg. Inventory & SOP side) can get updated for the voiding. -
<1> Create a Receivable Transaction (Document Type = Invoice) with the amount same as the original SOP Invoice and post it. [ This step will correct the debtor account back to the stage just like SOP Invoice not yet voided ]. - Correct
<2> Create a SOP Return for all items and all Quantity, and then post it and then apply this SOP Return with the RM Invoice (created in the Step 1) - Correct
<3> Re-create a brand new SOP invoice. - Correct
In the GP, there is no way for me to trace(find) the wrongly voided transaction for the posted SOP invoice in RM module.
Not sure I understand this exactly. In RM Enquiry you will end up with the Original SOP Invoice (It will have an asterisk beside the document number to show it is voided...if you drilled back on this you would get to the original SOP Invoice). You will also have a new RM invoice, and new SOP Return...which cancel each other out in RM...and a new SOP Invoice. Your Debtors account will be correct, your Inventroy will be correct, and any sales reporting you do from SOP will be correct (2 SOP Invoices and 1 SOP Return - equals 1 SOP Invoice...if you see what I mean).
Best regards,
Ian.
Appreciate a lot for your reply. Could please correct my understanding.
Because of : Wrongly voided a posted SOP invoice using "Posted transactions" window (then this clear RM side, but not SOP and not Inventory)
So, my further steps to ensure other module get updated (eg. Inventory & SOP side) can get updated for the voiding.
<1> Create a Receivable Transaction (Document Type = Invoice) with the amount same as the original SOP Invoice and post it. [ This step will correct the debtor account back to the stage just like SOP Invoice not yet voided ].
<2> Create a SOP Return for all items and all Quantity, and then post it and then apply this SOP Return with the RM Invoice (created in the Step 1)
<3> Re-create a brand new SOP invoice.
In the GP, there is no way for me to trace(find) the wrongly voided transaction for the posted SOP invoice in RM module.
Please advise, and many thanks in advance.
Hi,
If it was me, I would let the distributions default from GP, and go with these.
For the RM transaction it will debit your Receivables GL account, and credit your GL Sales (no stock movement GL journals since it is only an RM document).
When you voided the SOP Invoice - only Receivables and Sales distributions were reversed - (remember it only voided the RM side of the SOP transaction)....so by entering an RM transaction you are reversing this void transaction, both for the transaction itself and for the distributions that were voided.
Now you process your SOP return and let it handle the distributions (it will credit receivables,debit sales, debit inventory and credit COGS).
Then process the 'new' SOP Invoice and also accept the defaults.
For your other question - You can't really trace the wrong voiding transaction. You will always be able to drill back from the voided RM transaction back to the original SOP transaction. Also, you can apply the SOP Return to the RM transaction you enter to 'correct' the mistaken void. This will also help link the transaction flow.
Hope this helps.
Many thank for you reply.
In order to rectify for the voiding entry (SOP invoice voided at RM module instead of 'Create Return'). As you have suggested to create RM trx for the voided invoice amount, but what about the GL entries? does it Distribution same as the SOP invoice ? or debit/credit for the same account number to prevent effects to GL ?
One more question,
Since I know that the SOP invoice has been voided at RM side but not create Return, so how can I trace this wrong Voiding transaction ? In other words, even though SOP invoice voided at RM side, but how to find this voiding transation?
Hi William, the Void process only ever affects RM. It does not change transactions in the SOP History table. So the behaviour you are seeing (Voided in RM, but not marked as Void in SOP) is correct.
You are right, the correct way to 'reverse' a sales transaction that was wrong, is to process a return.
If you want to undo the void, then the simplest way is to re-enter an RM transaction for the original invoice. This gets your Debtors account correct. This is fine if all you want to do is get your debtors account correct. (But if you still want to be able to drill back from the debtors account and see a SOP Invoice then this is no good).
You can go a step further then, and process a return in SOP - You can apply this to the RM invoice you just posted to reverse the Void. Your debtors account is now back to where it was before you entered the SOP Invoice originally. Now re-enter the SOP Invoice.
The original SOP transaction is still in the SOP history, but it has been returned, and sold out again, so overall your SOP is correct.
Hope this helps.
By the way, there is a VOID field in the SOP Tables. Some transactions in SOP history may well be marked as void, but this has nothing to do with the RM Void process. These are SOP Invoices that were printed before being posted. Then you decide not to post the invoice because maybe the sale is cancelled. GP won't let you delete the invoice (for fraud reasons because it is printed)...so you're only option is to 'Void' it by selecting VOID from the 'Actions' dropdown on the SOP entry window.
Best regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (