100
I had wrongly made a Sales Return in GP 8.0 but had not posted it. To avoid any effect , I voided the document. Now my SOP Inventory Sales Report from GP 8.0 shows additional amount which is the difference of this return.
How can I rectify this error through SQL script or from with GP 8.0.
I need to rectify this error so as to generate my month end report.
Thanks
Ashok
*This post is locked for comments
The VOIDSTTS is kept in the SOP30200 table so you'd need to do something like:
select * FROM SOP30300 where SOPNUMBE IN (select SOPNUMBE from SOP30200 where VOIDSTTS = 0)
Thanks Matt for your reply.
The Sales Return was done wrong so I voided it before posting from SOP. I generate a Sales report from my customized reports, the voided transaction is included in the report. The report is using the SOP Transactions Amount History Table and the restriction used is SOP_Line_Hist.SOPType >=3 or >=4, is there any other field restriction to be added in order not to include Voided Transaction in my Report.
Is there a SQL View or Query where I can set a range of Date to View my Daily Sales and import the same into Excel.
Thanks
Ashok
Thanks Tristan for your reply.
Item Quantity is correct but when I remove a Sales report from my customized reports, the voided transaction is included in the report. The report is using the SOP Transactions Amount History Table and the restriction used is SOP_Line_Hist.SOPType >=3 or >=4, is there any other field restriction to be added in order not to include Voided Transaction in my Report. Is there a SQL View where I can set a range of Date to View my Daily Sales and import the same into Excel.
Thanks
Ashok
Hi Ashok,
Since you did not post the Sales Return, it should not have any impact to Inventory and other modules (Receivables and General Ledger).
I haven't checked the report you mentioned but like Matt said, try excluding voided transactions.
You can verify your items' quantity by doing an Item Transaction Inquiry on it to determine if the Sales Return really did an impart to the numbers.
Unless... you voided the Sales Return in Receivables Management rather than Sales Order Processing. Where did you void the Sales Return anyway?
There is no way to unvoid a transaction through the application. Is there any reason why you wouldn't just want to create a new return that is exactly the same as the one that was voided?
Or is it just the report that is wrong? How are you running the report? Maybe the report just needs to be updated to not include voided transactions.
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
