Hi all, I'm fairly new to GP and need some help. One of our users created an invoice by mistake and transferred it to a backorder instead of voiding it. The transfer placed the original invoice in history with the original QTY. The problem is this shows are a sale and it is not correct. I don't seem to have a way of excluding this document from my reports. I can provide any additional info if needed. Your thoughts please? Thanks PD
*This post is locked for comments
Hi Richard, this is a little late but this did the trick, thank you.
Now, I have 4 SOP Order documents that have been voided but their status is unposted. What is the best way to move these docs to history?
Thanks
And the plot thickens!
Step 1) Make a backup
Step 2) Have everyone out of GP
Step 3) Go into SSMS
Step 4) Run these scripts
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS.. SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
Then SELECT * from SY00500 against your company database.
Look for MKDTOPST and BCHSTTS these need to be zero. First look under Batch Recovery and see if you have any stuck batches. If batch recovery does not help then set these values to zero and then go back into GP and into the modules in which these batches reside. Print an edit list and see if they need to be posted.
On my test system I tried to run the remove sales history and I got "You can't remove history when interrupted batches exists"
PD
Richard,
Updating the status sounds good. One thing to keep in mind is that since we don't use SOP returns and we issue negative QTY on invoices to account for them, if I use qty fulfilled, I will miss and overstate my QTY since QTY fulfilled is never a negative (at least it should not be)
PD
Boy you are good Victoria! Your query exactly matched my query when all i had done was looked for QTYTOINV<>QTYFULFI. Glad you are on our side!
Actually, looking at our data, any invoice with a negative in the Quantity has both Quantity Fulfilled and Qty to Invoice as zero. So in that case you may be better off using Quantity as long as you've tested this and everything else is correct.
Something else to confirm - I believe if the total of the invoice where you are entering negative quantities is negative, GP will automatically convert that to a return. If that ever happens in your data, again, you may not be getting the correct results on your reports.
PD,
What you could do to address the issue with this one invoice is run the following in SQL against your company database. Make sure to change YourInvoiceNumber on the 3rd line to the invoice number in question:
update SOP30200
set VOIDSTTS = 1
where SOPTYPE = 3 and SOPNUMBE = 'YourInvoiceNumber' -- << change this
The above will change the status of this invoice to Voided, even though it really was not.
OR...better yet, change your reporting to use Quantity Fulfilled instead of QTY and this becomes a non-issue.
Hi Richard,
In our data, the only time QTYFULFI <> QTYTOINV is for voided invoices, in which case I believe the QTYFULFI is correct, since that is 0 and the QTYTOINV is not. Here is the query I used in case it helps you check this against your data:
select VOIDSTTS, QTYFULFI, QTYTOINV, d.*
from SOP30300 d inner join SOP30200 h on h.SOPTYPE = d.SOPTYPE and h.SOPNUMBE = d.SOPNUMBE where QTYFULFI <> QTYTOINV and d.SOPTYPE = 3
Please let me know if you're not finding the same results. There may be something else going on in your data that I have not accounted for.
Victoria, I am curious on the use the QTYFULFI field. I just scanned an SOP30300 table and found 6 records out of 496,000 where there was a difference. Each time the QTYFULFI incorrectly had a value of zero where the QTYTOINV field had the correct value. Under what circumstances would the values in these two fields be different for an invoice?
You are not able to void an historical invoice however you can remove it from history. Since it was a zero dollar invoice no AR docuiment was created. Tools->Utility->Sales.->Remove Sales History. BE VERY CAREFUL to make sure you remove jsut this document. Doing a backup firfst would be a good idea.
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 (