We had over 356 document numbers for orders but now GP only shows up to document order 319. Does anyone know why it is no longer showing document numbers up to 356?
*This post is locked for comments
Angel -
Failing the ability to access the database using SQL tools, Jorje's post above covers the best tool for the job, but it sounds like you have already tried to use the inquiry screen, and it didn't shed any light on the problem. You may try running Checklinks and Reconcile, as Jorje outlined above, but you should definitely have a SQL backup prior to proceeding with this, as it may well change your database. I feel a bit like we're bumbling around in the dark, and for that I apologize. Do you have any technical folks or a partner you can plug into this conversation? If not, we'll keep at it, but the next step is definitely to run Checklinks and Reconcile, and see if what, if anything that does to your data.
The invoices posted. You will have to be more detailed of where to look. I don't know where the tables are at. We don't do anything with the SQL.
Under Inquiry-Sales-Documents - I do not see the missing order numbers. History is blank, nothing there. However, when I was testing yesterday trying to locate one of the missing order numbers and I typed it in, I typed it as 374 rather than REC ORDER 0000374. I soon found that it was a unique order number when I exited the order window and it asked if I wanted to save it. I clicked yes and it is now out there in the document number list. So apparently when I had been making new orders and clicking the save icon within the order window, GP has not been saving the document numbers.
The process we have been using is to create an order, save it, then transfer it to an invoice. The invoices did post. It's just the document numbers with the new orders that are missing.
I do not know anything about the SQL.
Angel,
Did you try the Sales Order Processing Document Enquiry window as I suggested?
Enquiry > Sales > Sales Documents
In this window look for the ‘missing order numbers’ under ‘History’ and ‘Unposted’.
If they appear only in ‘History’:
Select the line and open the order, do you see any missing fields in the Sales Transaction Enquiry Zoom window?
Do you have access to the SQL tables? If you do, run this SQL script to check if the field BCHSOURC is empty from those orders. BCHSOURC shouldn’t be empty.
SELECT SOPNUMBE, BCHSOURC FROM SOP10100 WHERE BCHSOURC = ''
If they appear in both ‘Unposted’ and ‘History’:
There has been an error while transferring the order to an invoice which means the order exits in both Open and History tables. A Sales Order transaction should only exist in one or the other, but not in both.
You can also try the Reconcile – Remove Sales Documents tool
Microsoft Dynamics GP > Tool > Utilities > Sales
You can also try the Check Links maintenance tool
Microsoft Dynamics GP > Maintenance
Angel -
I think you need to take a look at the tables in GP to determine what might be wrong. If I don't miss my guess, someone went to transfer these Orders to Invoice, and it failed (perhaps because all the posting accounts were not properly defined). This process starts by writing the records to the History tables then, once that's done removing the records from the Work Tables. When I have seen this error, in past situations, it is because a records for these orders exist in both the Work and History tables. Here is a link to a prior post with a similar situation that identifies tables, provides queries and the like. If you are not technical and/or do not have access to SQL tools, you will need to get a technical resource, perhaps your GP partner involved in this problem.
Try typing one the ‘missing’ Document numbers directly in the field, is the order displayed?
It gives me an error "This document number already exists. Please enter a new document number." The filter is "all unposted sales transactions, and document type =order. But even when I have document type = all, it only shows document numbers up to 319 as being saved. For some reason GP is not saving the documents when I click the save icon inside the order with a new document number.
Angel,
Try typing one the ‘missing’ Document numbers directly in the field, is the order displayed?
If the Order is displayed, check the filters setup on the Document Number lookup window.
If the Order is not displayed, try the Sales Order Processing Document Enquiry window, perhaps the Order has already been transferred to Invoice. Can you see the 'missing' orders in the Enquiry window?
Sales
Sales Transaction Entry
Change "Quote" to "order"
tab, tab
Document No field shows next number is 377
click on magnifying glass for document no field - it shows the highest existing number as being 319.
I manually created 4 new orders this morning using new document numbers which brought me up to 377 and I clicked on Save. They are not in the list.
We don't import anything. There was no backup restored lately. No error messages on anything that I've done. Last month GP was saving the new document numbers, now it is not.
When you say create an order, are users typing orders into Dynamics GP, or are they being imported? Are there any customizations in place? What tool/method is in use for importing, if any? Was a backup recently restored? Are any error messages presenting?
It is not common for Dynamics GP, in an unmodified state, to fail to save a transaction, and not provide an error message.
When I click on sales transaction and change it to 'Order', and click on the document number it shows me document number 1 through 319. If I were to create a new order, the next available document number is 373. So what happened to all document numbers from 320 through 372? At the end of last month's billing I realized that the new orders with new document numbers were no longer there even though I had saved them. The last one showing was 356 at that time. Today I logged in and the highest document number is 319. It makes no sense. No one in my office has deleted anything. Additionally, 372 which I just created and saved is no longer there. 319 still shows as the highest document number to select from those that I have used in the past.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (