Resolution for a Dynamics GP Error Message

Resolution for Error Message “The Cost of Goods Sold distribution is incorrect and will not be posted. Do you want to save with errors?”

Dynamics GP Error Message

Many users often encounter the above error message when trying to complete (save or post) a return in the Dynamics GP Sales Transaction Entry window. Unfortunately, the error message is obscure and doesn’t always tell you what the solution is.

The first step to diagnosing this error message is to check the accuracy of the distribution amounts and the costs associated with all items on the transaction. This analysis can be done on the Sales Transaction Entry Window, the Sales Distribution Window and from running SmartLists. There have been instances when users find errors with the Distributions and Costs, but upon trying to make the corrective adjustments they once again receive the above error.

What did we do? Well we looked within the Sales Header and Line Item tables in SQL to compare the different amounts (extended costs and distributions). After analyzing the data from the two tables, it seemed as though the extended costs in the Header tables did not match the extended costs within the Line Item tables, resulting in the Cost of Goods Sold distribution error. After updating the extended costs in the Header table to match the costs within the Line Item Table the users were able to move forward and save/post their Return.

This article was written by Andrea Stenquist, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider.

Dynamics GP 2016 R2 Feature of the Day

Enjoy your Microsoft Dynamics GP 2016 R2 Feature of the Day!

Requisition inquiry visual when all quantities will not be fulfilled

Dynamics GP 2016 R2 Feature of the Day

Are you a Tridea client interested in installing Microsoft Dynamics GP 2016 R2?

Contact us first!  Tridea Partners 858.755.3700 or info@trideapartners.com

By Tridea Partners, Microsoft Dynamics Partner www.trideapartners.com

Read original post at: http://community.dynamics.com/gp/b/gpteamblog/default.aspx

Are you ready for 1099 reporting?

1099 REPORTING IS JUST AROUND THE CORNER!

Tridea recommends that you start testing your 1099 reports to allow plenty of time for report refinements.

We recommend that you:

  • Start reviewing your vendors for potential 1099 recipients
  • Begin identifying amounts to be reported as 1099
  • Print test reports to verify form alignment

Tridea is here for you!  Please contact us for training or questions at info@trideapartners.com .

Microsoft Dynamics GP 2016 R2 Feature of the Day – Cancel PO when Linked to a Requisition

Enjoy your Microsoft Dynamics GP 2016 R2 Feature of the Day!

Cancel PO when Linked to a Requisition

Cancel PO when Linked to a Requisition

Are you a Tridea client interested in installing Microsoft Dynamics GP 2016 R2?

Contact us first!  Tridea Partners 858.755.3700 or info@trideapartners.com

By Tridea Partners, Microsoft Dynamics Partner www.trideapartners.com

Read original post at: http://community.dynamics.com/gp/b/gpteamblog/default.aspx

Dynamics GP Year-End Close Webinar

Join Tridea for our annual Dynamics GP year-end close webinar! We will share best practices related to year-end processes for your Microsoft Dynamics GP system. We will cover the top three modules General Ledger, Accounts Payable and Accounts Receivable.

register here

Event Details: Wednesday: December 14, 2016 at 11:00 AM – 12:00 PM (PST)

Presenter: Kaydee Baker – Tridea Partners

This is one of our most popular webinar. Don’t miss it!