You’re offline. This is a read only version of the page.
Hi,
We had to void a few invoices about two weeks ago. I am now running smart list report and one of the filter was 'where VOID is equal to VOIDED'. Those invoices are not showing in this report. They are not appearing in the customer statement. They do show up with an '*' next to the word 'OPEN' in document inquiry window.
Would any one know how can we actually VOID these ?
Thanks,
Zeeshan
*This post is locked for comments
I agree with Victoria that you probably voided an SOP invoice, which only voids the receivables portion of the invoice. I'm not aware of another way to identify them other than the SQL script or possibly creating a smartlist in smartlist designer. As far as a fix, when you void an SOP document, only the AR and Sales distributions are reversed. Your Inventory and COGS are not affected, which is why it is always best to enter a return to offset an SOP invoice rather than void it. You can't reverse the void, so I would enter an inventory adjustment to put the items back in inventory at the cost they were taken out at and change your distributions to credit the same COGS account that was hit on the original invoice.
Thanks Victoria. That probably is the case. However, although I do day to day troubleshooting for users, I have never really run a script on SQL. We have outsourced such work. Is there any way I can identify such invoices without running the script. Or, can I create a smart list to identify this discrepancy.
If I do find it to be the case, how do we resolve it.
Zeeshan,
You might be running into an issue with an invoice being voided in Receivables, but not SOP. I have a script on my blog that can help you identify these:
victoriayudin.com/.../sql-script-for-comparing-voids-between-rm-and-sop-in-dynamics-gp
I don't know which SmartList you are referring to, but when an invoice is voided, the invoice is moved from the WORK tables (SOP10100, SOP10200) to the HISTORY tables (SOP30200, SOP30300).
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (