Finance | Project Operations, Human Resources, ...

Invoices will not post into history

(0) Share

Report

Posted on by HarrisSeeds

I have invoices that will not post through our nightly invoicing process. Most do, but a few remain.

I ran the edit list and there is no errors on the invoices...any suggestions to manually post them through?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

Becky Berginski on at

Like (0)

Report

Hello HarrisSeeds,

Thank you for using Community Forums. My name is Becky and I will assist you.

I would try to post them and see what type of error you get when they do not post. Many times, the documents partially posted, and are in both work and history. If this is the case, follow the below blog to troubleshoot.

community.dynamics.com/.../troubleshooting-sop-invoices-that-are-in-both-work-and-history

Also, at the bottom of this blog are what values need to be in the SQL table in order for the invoice to successfully post.

Was this reply helpful? Yes No
HarrisSeeds 90 on at

Like (0)

Report

Good afternoon,

When I try posting them through our Sales Entry Batches...there is no errors given on the edit list.

Some of the invoices in the batch post through perfectly fine, but the past two weeks or so...there has been a number of them not posting through.

What should the next step in the process be do you believe?

Was this reply helpful? Yes No
Nicole Hellerud 1,712 on at

Like (0)

Report

Hello Harris,

Thank you for your update.

After the invoice fails the initial posting and you go to repost them, do you get an error at that time?

How are these invoices being brought into GP? Manually? Imported?

How are users accessing GP when posting?

I look forward to your update when available.

Wishing you and yours healthy and happy days ahead!

Nicole Fiskum

Support Engineer

Microsoft Dynamics GP

Was this reply helpful? Yes No
HarrisSeeds 90 on at

Like (0)

Report

Good afternoon,

There is no error after original posting fails, it just remains in the Sales Entry batch. Here is a screen shot example of one of the invoices.

Our orders are imported via web and also straight through GP if customers call in. They begin as ORD's and then translate into INV's once we ship product out. We run a nightly process for any filled items for the day to transfer over to INV.

Most of them go through fine, but the past two weeks we have had about 45 get stuck and not post through correctly. I have had IT review and they cannot seem to find any errors that stick out.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi,

The first steps when trying to fix some unposted documents in the SOP module would be to run some reconcile to see if GP can 'fix' it by itself in recalculating some totals.. Sometimes it might be the tax calculations that is off just by a few cents.. I can see that you're using AVALARA Tax calc, and that should prompt you to open a case eventually with them too..

The next step which is more invasive, would be to run some CheckLinks against the SOP module (work & history) to have GP fix any inconsistencies between the records. This is more invasive and can be destructive in some cases, so it's highly recommended that you take a full backup of the company data first and run this when nobody is in GP (off-hours), or even best, restore the backup into a TEST company and run it from there. The output report that is produced might help you identify the culprit and provide some hints to prevent further happenings of this issue.

Reconcile: Sales >> Utilities >> Reconcile

You may wanna look also into this : Sales >> Utilities >> Reconcile-Remove Sales Documents

Click on the HELP icon to understand what's all about this process.

CheckLinks: Microsoft Dynamics GP menu >> Maintenance >> Check Links

Select the Sales module and then select all tables related to "Transactions" from left to right.

Was this reply helpful? Yes No