Void not showing 'Void' Status in Smart List

(0) Share

Report

Posted on by Community Member

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 have the same question (0)

All responses (4)

Answers (0)

Tanner 360 on at

Like (0)

Report

RE: Void not showing 'Void' Status in Smart List

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Void not showing 'Void' Status in Smart List

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.

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,768 on at

Like (0)

Report

RE: Void not showing 'Void' Status in Smart List

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

Was this reply helpful? Yes No
coquisalsa 2,725 on at

Like (0)

Report

RE: Void not showing 'Void' Status in Smart List

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).

Was this reply helpful? Yes No