382
We have are implementing a scanning software that picks up invoice number, date, etc. and we were hoping to compare the invoice numbers scanned to the SQL database to verify all invoices were turned in to AR and none are missing. They would be scanned prior to posting and the invoices are entered in Invoice Entry not SOP. I looked in RM10301, but it was empty. I thought about using smartlist and exporting to excel, but I do not see any unposted invoices in smartlist either.
We do not import anything. Some of the Invoice numbers appear very old and some appear to be much more recent. Also, all of the recent voids that we started keeping history on are still in this table.
It looks like they may all be unused invoice numbers that are just hanging out for some reason.
Having unposted invoices without batch numbers is not allowed. Are you importing these transactions? What import tool are you using? Running check links on the invoicing table should assign a batch to them. You may need to run an update script first, however. Otherwise, CL may delete them.
Thank you!
Without adding "where DOCDATE = '2023-05-05'" I have 958 invoices in IVC10100 with no batch number, batch source, etc with a doc date of 1900-01-01. Does that make sense or should this table be clearing out after everything is posted?
Do you think this would be the best way to achieve what were after, or would there be a better way that comes to mind?
Also, how can I get unposted IVC to show on the smart list? I have tried adding post status etc to the columns under receivables transactions with no luck.
Hi Taylor-
The tables all start with IVC. The unposted invoices are in IVC10100, IVC10101, etc. If you go to the Microsoft Dynamics GP menu > Tools > Resource Descriptions > Tables. Keep the product drop down as Microsoft Dynamics GP, select Sales as the series and select Table Physical Name in the view by field.
You'll see all of the invoicing tables there.
I hope this helps.
Joe
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
