Standard Cost Rollup & Revaluation Reporting

(0) Share

Report

Posted on by Community Member

Using GP2013 with Mfg

Searching for a script or otherwise to export the equivalent of the Item Pending Cost Revaluation Report. Possibly someone has a solution.

Also would like to be able to export data which indicates which GL accounts will be hit by the revaluation prior to actually revaluing.

Thank you in advance

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Duffy,

This query pulls both potential sources of Standard Costs Changes - CT00003 and IV00101 (Inventory) as well as the ICIV0323 (Manufacturing)

Any pending changes entered into the Standard Item Material Costs window will be reflected in the CT00003 table and rolled into the IV00101 standard cost.

Changes made in the Standard Cost Maintenance window are also used. These values are stored in the ICIV0323 table.

------------------

select

'Manufacturing' 'Source',

SCM.ITEMNMBR Item_ID,

IVI.ITEMDESC Item_Description,

cast(SCM.TOTALCOSTI_1 as money) Current_Cost,

Convert(varchar(10),SCM.MATCOSTEFFDATEI_1,101) CC_Effective_Date,

cast(SCM.TOTALCOSTI_3 as money) Pending_Cost,

Convert(varchar(10),SCM.MATCOSTEFFDATEI_3,101) PC_Effective_Date,

COA.ACTNUMST SC_Reval_Acct

from ICIV0323 SCM

inner join IV00101 IVI on IVI.ITEMNMBR = SCM.ITEMNMBR

Left Join GL00105 COA on IVI.IVSCRVIX = COA.ACTINDX

Union All

select

'Inventory' 'Source',

SCID.ITEMNMBR Item_ID,

SCID.ITEMDESC Item_Description,

cast(IVC.STNDCOST as Money) Current_Cost,

convert(varchar(10),IVC.MODIFDT,101) CC_Effective_Date,

cast(SCID.COST_I as Money) Pending_Cost ,

convert(varchar(10),SCID.EFFECTIVEDATE_I,101) PC_Effective_Date,

COA.ACTNUMST SC_Reval_Acct

from CT00003 SCID

Inner Join IV00101 IVC

on SCID.ITEMNMBR = IVC.ITEMNMBR

Left Join GL00105 COA

on IVC.IVSCRVIX = COA.ACTINDX

order by Item_ID,Source

------------------

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Redbeard it works well. Leads to another ? or two.

It is using the Standard Cost Revalue Index that apparently was added for 2013. The standard cost functionality has not been maintained here so this account has not been implemented yet.

It appears that when we revalue for items in inventory the item's assigned inventory account is hit. Am I correct in assuming if the SC Revalue Index is populated, that account would be hit in place of the inventory account?

Lastly I am also trying to confirm which GL account is hit for the other side of the GL entry. In test it seems it is PPV or at least what account is entered in the item master in the PPV account default.

Can you shed any light on this?

Thanks again in advance.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Duffy,

The value I have returned is the 2013 Standard Cost Revalue account setting - IV00101.IVSCRVIX.

Accounts can be maintained by clicking on Item Engineering Data > Goto Menu > Item Account Maintenance:

The 2013 SCR account is maintained in this window

The SCR for GP Manufacturing is maintained in this window

Both Windows open when navigating from Item Engineering Data

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Redbeard. Am familiar with the accounts maintenance windows.

What I was trying to ask but not clear on is:

If there is no account entered into Standard Cost Revaluation which account will be posted? Inventory?

Assuming an increase in item value, where Inventory will have a debit entry, how does GP decide what account receives the offsetting credit?

Maybe this is drifting to a new thread but hoping we can close with this info.

Thanks

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (0)

Report

Duffy,

No worries.

PPV and SCR are two different things.

PPV results when the purchase price of items vary from their expected cost. This only happens when GP is configured to treat transactions in this way.

Standard Cost Revaluation is a discreet activity where you change items' standard cost and revalue inventory accordingly. The accounts involved in SCR are Inventory, which is offset to the Standard Cost Revaluation account defined in Dynamics GP.

In your example the Cost of Inventory is increased (Debit) and the offset would be a Credit to the SCR Account (Credit).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No