Hi all,
When I run an invoice listing in Smartlist from Sales transactions, with the column "Void Status" I am getting inaccurate results. Some invoices that are voided are showing in the list as "Normal" instead of "Voided". When I run a similar report in Receivable transactions I get accurate information using the field "void date".
Does anyone know why I cannot run an accurate voided sales transaction report or am I possibly misinterpreting the fields?
*This post is locked for comments
Thank you Leslie, really appreciate it!
Hi,
You would need your network or SQL administrator to grant you select access to the SQL tables. If you don't have the SQL client tools on your desktop (most people don't), you can make the connection perhaps using Excel. You could download the client tools, but you should probably get with your administrator or partner to make sure you have access.
Kind regards,
Leslie
Hi Victoria and Leslie,
Thank you for taking the time to answer my question. I've only worked on SQL in Microsoft Access and don't have much prior experience with SQL in GP. Can you please let me know how I can go about in finding out if I have access to SQL and to edit the codes?
Thank you for your time in advance!
Leslie is exactly right. If you have access to SQL, you can run the script in my blog post here to see the discrepancies in voided transactions between the two modules.
Hi,
Sales Transactions is a SOP document. If the document is Voided, that means it was voided in the SOP transaction entry screen. Receivables voids are done from the Receivables Posted Transaction Maintenance window. They are two different things. A SOP invoice moves to receivables once it is posted. Really, a SOP invoice should not be voided in Receivables if any inventory items appear on the invoice, a SOP return should be used instead.
Kind regards,
Leslie
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (