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

Microsoft Dynamics AX 2012: Inventory Replenishment

In Microsoft Dynamics AX 2012, by setting up some item coverage settings and default order settings, you’ll easily be able to have Microsoft Dynamics AX recommend inventory replenishment when running master scheduling. Below are the steps to set this up.

Navigate to Product Information Management > Common > Released Products and select the item in edit mode.

  • On the Plan FastTab, select the appropriate coverage group for your company and item.

Inventory Replenishment

 

  • On the Plan tab of the action pane at the top, select item coverage and use the wizard to create the item coverage settings based on the coverage group selected (i.e. site, warehouse, minimum inventory, maximum inventory, lead times, etc), then click close. (See screen shot below)

 

  • On the Plan tab, select default order settings then set your purchase site, inventory site, minimum order quantity and purchase lead time, then click close. (See screen shot below)

 

  • On the Plan tab, add the site specific order settings such as site, purchase warehouse and inventory warehouse, then click close. (See screen shot below)

Inventory Replenishment

Next you’ll need to know which planning strategy to use with Master Scheduling. There are three types of plans to choose from to support your company’s operations. Dynamic plan is for short term planning and can be updated every time the master data changes. Forecast plan is for plans involving forecast and demand. Static plan is for long term planning, which remains unchanged until the next time you run master scheduling. These plans can be configured in the Master Plans form in the Master Planning module under setup then under plans. For example, if you have an item in which you want to maintain a minimum inventory level for the long term, then you would choose static plan.

 

On the Plan tab of the released product, click on Net Requirements. Select the plan type from the drop down menu at the top. Then in the middle section on the overview tab, select update > master scheduling and click ok. This runs the master scheduling to determine if inventory of this item needs to be replenished.

Inventory Replenishment

 

You can also run master scheduling from Master Planning > Periodic > Master scheduling. By running master scheduling from the Master Planning module, you can select multiple items to run at the same time.

 

Once the master scheduling job has completed, if AX determines that inventory should be replenished, it will automatically create a planned order for the item(s) that were included in the master scheduling run. The next step is to convert any planned orders (purchase, production, transfer) to actual orders.

Once you’ve converted your order, you can return to the released product form to view the status of your item under Net requirements. If you run master scheduling again from this screen while there are existing orders (planned or firmed), and/or on-hand inventory, and the quantities are at or above the minimum inventory quantity as set in the item coverage settings, then AX will not generate a planned order. If there are no planned orders, no open purchase orders and on-hand inventory is below the minimum, then AX will generate a planned order when you run master scheduling.

This article was written by Tracey Schebera, Dynamics AX Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider. www.trideapartners.com