How to use a Misc Charges item with a Periodic item (Standard Cost) with Microsoft Dynamics GP Manufacturing


Introduction


The article describes how to use a Misc Charges item with Microsoft Dynamics GP Manufacturing so it will process correctly with the correct accounts. The same can be done with Service or Flat Fee items.

Step By Step


To setup a Misc Charges item with Microsoft Dynamics GP Manufacturing, follow these steps:

1. You first have to use SQL Query Analyzer to update the correct Valuation Method on the Misc Charges item: You cannot add a Misc Charges item to a Periodic (Standard Cost) Bill of Materials.Make sure you have a good functional backup before using SQL to update any table.Valuation Method Values are the following:

Null (Item does not track costs) = 0
FIFO Perpetual = 1
LIFO Perpetual = 2
Average Perpetual = 3
FIFO Periodic = 4
LIFO Periodic = 5 


a. Depending on the version of Microsoft SQL Server that you use, start SQL Server Management Studio, or start SQL Query Analyzer. To do this, use one of the following steps:

•If you are using SQL Server 2005, open SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

•If you are using SQL Server 2000 or SQL Server 7.0, open SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

b. Use one of the following steps:

•In SQL Server Management Studio, expand Databases in Object Explorer, and then click Dynamics. Click New Query, type the following select statements in the query pane, and then click Execute. You will have to provide the Misc Charges item in the first script to get the correct DEX_ROW_D for the second update script.

 SELECT * FROM IV00101 where ITEMNMBR='MISC CHARGES ITEM'

UPDATE IV00101 SET VCTNMTHD ='4' where DEX_ROW_ID ='<XXX>"

•In SQL Query Analyzer, type the following select statement in the Query pane, and then click Execute.

SELECT * FROM IV00101 where ITEMNMBR='MISC CHARGES ITEM'

UPDATE IV00101 SET VCTNMTHD ='4' where DEX_ROW_ID ='<XXX>"

When you update the item to set the VCTNMTHD ='4' it also will add a record to the ICIV0323 and CT00003 tables.

These are required for standard cost items in order to Rollup and revalue them correct. If the items are imported it is necessary to check the Standard Cost tables.

2.The next step is to add cost to your Misc Charges item. Make sure you only have Cost in the Material cost bucket only! 


Method 1: Use the "Roll Up and Revalue Inventory" dialog box

1. Enter the revalued costs in the Standard Item Material Costs dialog box or in the Standard Cost Maintenance dialog box.

Note You can use the Standard Item Material Costs dialog box to revalue items that have the Replenishment Method field set to Buy. You can use the Standard Cost Maintenance dialog box to revalue items that have the Replenishment Method field set to Buy or to Make.

•To enter the revalued costs in the Standard Item Material Costs dialog box, follow these steps:

a. Click Cards, point to Manufacturing, point to Inventory, and then click Std Item Mat Costs.

b. In the Standard Item Material Costs dialog box, enter the revalued costs for the item in the Pending area, and then click Save.

•To enter the revalued costs in the Standard Cost Maintenance dialog box, follow these steps:

a. Click Cards, point to Manufacturing, point to Inventory, and then click Std Cost Maintenance.

b. Click to select the Override check box.

c. In the Override Standard area, enter the revalued costs for the item, and then click Save.


2. Click Tools, point to Routines, point to Manufacturing, and then click Rollup and Revalue.

3. Type a date in the Roll up Date Field or leave the today's default date.

4. Click Roll up, and then click Process.

5. When you receive the following message, click OK:

Rollup Complete.

6. When you are prompted to print the Item Cost Revaluation Report, select a print destination, and then click ok. Make sure the costs are correct on the report.

7. Click Revalue, and then click Process.

8. When you receive the following message, click OK

A standard cost revaluation batch was created. Standard unit cost changes will take effect.

Method 2: Use the "StandardCostChanges" dialog box

1. Click Cards, point to Manufacturing, point to Inventory, and then click Standard Cost Changes.

2. Enter the revalued costs for the item in the Proposed StandardCost column, and then click Save.

 3.In the StandardCostChanges dialog box, click Roll Up. 

4. When you are prompted to save changes, click Save. 

5. When you receive the following message, click OK:
Rollup Complete

6. When you are prompted to print the Item Cost Revaluation Report, select a print destination, and then click ok. Make sure the costs are correct on the report.

7. In the StandardCostChanges dialog box, click Replace Costs.

8. When you receive the following message, click OK

A standard cost revaluation batch was created. Standard unit cost changes will take effect.

9. When you receive the following message, click OK:

All proposed costs have been deleted


When the Standard Cost is changed and revalued go to the Item Maintenance window and make sure the Current Cost is equal to the new Standard Cost

In the future if you change the Standard Cost the Current Cost has to be updated to be equal to the new Standard Cost.