Finance | Project Operations, Human Resources, ...

Unposted Invoice Entry Table

(0) Share

Report

Posted on by Taylor_Greenwood

403

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.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Joseph Markovich 3,976 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Taylor_Greenwood 403 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Taylor_Greenwood 403 on at

Like (0)

Report

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.

Was this reply helpful? Yes No