10
When doing standard cost changes in GP is there a table that stores the proposed cost changes prior to making the change??? All we can find is the 100+ page print out when you do the rollup. Looking for the GP table.
Hi Nathan,
I believe what you are looking for is essentially the ICIV0323 table. In the CT0003 the COST_I should be the current material cost and the PENDINGCOST_I should be the pending cost for the item. In the ICIV0323, the MATCOSTI_1 should be the current cost of the item, the MATCOSTI_3 is the pending value from the Routines rollup, and MATCOSTI_5 is the pending cost from the Override for this.
The tables that are involved in the rollup are the IV00101, CT00003, and ICIV0323. The ICIV0323 table stores 8 sets of columns for each value in the Standard Cost Maintenance window.
Meaning MATCOSTI_1, MATCOSTI_2, MATCOSTI_3, MATCOSTI_4, MATCOSTI_5, etc.... is the value for material cost.
MATCOSTI_1 is the material portion of the current cost that is in use today.
MATCOSTI_3 is the pending cost from the Standard Item Material Cost and Standard Cost Maintenance windows. This is only updated after the rollup has been performed.
MATCOSTI_5 is the override cost from the Standard Cost Maintenance window.
MATCOSTI_7 is the proposed cost from the Standard Cost Changes window.
If you use the rollup/revalue routine you would need to update the _3 columns, if you use Standard Cost Changes to rollup you would want to update the _7 columns.
For some clarification on my question, we are using standard costing. What I'm looking for is when we do a rollup to change the costs on a few items the proposed cost change can affect 100s of other components so what we are looking for is the table where those proposed cost changes are stored prior to us running a revalue of that inventory. Trying to determine how our inventory value is going to change prior to actually making the change to the standard cost.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
