930
we have an invoice that is listed on my smartlist "documents not yet posted" but when I try to open it then pop up a message "This document is already posted"... this is weird because all important fields are empty.
How can I delete this document?
HB
*This post is locked for comments
Can you open the invoice in the Transaction entry window (I presume this is Sales Transaction Entry?)...if you can, then can you delete / void it.
If not, then you more than likely have a corrupt transaction (the fact that you say 'important' info. is missing backs this up). Note down as much information as is dispayed on screen. Try and find out which sale it belongs to so that you can re-enter the invoice if requred.
Find out if it is in the Debtors Enquiry. Find out if it generated a GL journal and if this was posted. Find out if it adjusted your inventory.
All of the above will inform on how you deal with it. If its not on the debtor record and it didn't create a GL Journal, and didn't update stock, then you might be safe running a delete query against the SOP History tables (Header and Lines)this document. And, then just re-entering it. It would be worth looking for it in the Sales Work tables as well just in case it exists in both Work and History).
If it has updated GL/Stock?RM, you can try and repair the transaction, updating the blank fields etc. through an MSSQL query. Again make sure its not in both the work and history. If it is, delete it from work.
This was probably caused by a crash during the posting process.
As with all queries, back up your databases first. If you have a test company, force restore the live into it and do the work here first to make sure all is ok before you repeat it in the live company.
Ian.
If it has updated stock / GL / RM you migh want to try ad fix the record
good day Hernan,
Please try the following
1.- Press the update button in the main page of GP, try twice (just in case)
2.-did you try opening the document in another computer.
3.- If the invoice hasn't been printed you can eliminate it and reuse the invoice number for a new sale, if the number sequence is not in order then i suggest you void it to keep a record.
Have a nice day :) Please keep me posted it.
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 (