Removing Pending Costs in Standard Cost Maintenance window

(0) Share

Report

Posted on by Jim Lines

Hello,

It’s been a while since I’ve done a standard cost update and currently need to do so on a couple hundred items. We’re running GP 2013 SP 2 with MFG installed. However, we do not use MFG for anything other than housing a few BOMs. My plan is to use the Standard Cost Changes window for each item and roll/revalue from there.

Using the Standard Cost Changes window, I tested one item to see the results (test company) and was surprised to see that someone had apparently set up some pending costs months ago and never rolled (probably a good thing). I was able to export the item numbers by querying SCV00002 and build a macro to from that last to update the pending cost to 0.00 (not the zero checkbox). This took care of that issue and there were no longer any pending changes. (SCV00002 is now empty.)

My concern now is when I look at the Standard Cost Maintenance window for an item that was pending in the STD Cost Changes window there is still a pending cost. In my test company I did a Roll Up from MFG>Utilities>Roll Up and Revalue and found that there are many, many items with pending cost there. Is there a way to clear out the pending costs from the Maintenance window? I don’t want someone to accidentally run the Roll/Revalue on these values. Obviously I don’t want to do this via SQL as I’m sure there are many linked table.

Hopefully someone has some insight they can share. Thanks in advance!

Jim

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (5)

Sort by

Verified answer

Redbeard 12,931 on at

Like (1)

Report
Copy link

Link copied!

Jim -

Here is an old post regarding Standard Cost Maintenance. Take a look at it, and see if it meets our needs, if not, please ask a follow up question.

community.dynamics.com/.../303850

Was this reply helpful? Yes No
Verified answer

Jim Lines 4 on at

Like (0)

Report
Copy link

Link copied!

Hey Harry,

Thanks for getting back to me. I actually followed your post to change the items that had proposed costs in the Standard Cost Changes window and was successful. But I still have several items with proposed costs in the Standard Cost Maintenance window. I thought one would update the other, but apparently not.

Do you have any suggestion as to how I can clear out those proposed costs? Example below. Thanks!

Jim

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (0)

Report
Copy link

Link copied!

Jim,

For a detailed explanation of the differences between the Standard Cost Maintenance Window (pictured above in your post) and the Standard Cost Changes Window, you can check out the GP help file under Standard Costing Windows - it is a good read.

In the Standard Cost Maintenance window, in order to override the pending Revalue Standard Cost, you need to check the override box, next to the category you want to override and the manually type (macro) the value you want instead, with an effective date that is equal to proposed effective date of the Pending number you want to be rid of.

You will ultimately need to run Revalue and Roll Up for these changes to take effect.

Was this reply helpful? Yes No
Jim Lines 4 on at

Like (0)

Report
Copy link

Link copied!

Harry,

Thanks for the hint on the help files; useful info there. My major question at the moment is how to remove all of the pending costs in the Standard Cost Maintenance window. Do I need to export all the items with a pending cost and create a macro to change the pending costs to equal the existing cost to get back to square one? I want to have things cleaned up before I do my real update, roll and revalue. Thanks!

Jim

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (0)

Report
Copy link

Link copied!

Jim,

There are some folks out there who have rebuilt the tables in question, one references assistance from Microsoft. The other purports to have a script that zeros the pending change, making it appear as if the item(s) were just added. I can see conceptually how this works, but would use the macro approach to be safe. If I had a script on this one, I would definitely give it a shot in my test environment/company before doing it in the live company.

community.dynamics.com/.../146536

Was this reply helpful? Yes No
Verified answer

Jim Lines 4 on at

Like (0)

Report
Copy link

Link copied!

Quick update.

Response from Harry:

"There are two tables, CT00003 and ICIV0323 in Dynamics GP, which contain pending standard cost changes. The Standard Cost Maintenance Window is looking at data in the ICIV0323 table, and the Standard Cost Changes Window is looking at the CT00003 table.

Table CT00003 can be quickly cleaned up by clicking on the Delete All button, which will confirm you want to delete all pending standard cost changes (just click yes). On the other hand table ICIV0323 cannot be rapidly cleaned up. You are right though, if you macro the window, you can check the Override column for any pending standard cost tables, and replace them with the original values, and the same effective date, and you will Override these recommended changes when you Roll and Revalue.

I believe the folks rebuilding standard costs, are updating the MATCOSTI_# fields with 0.00000 and MATCOSTEFFDATEI_# fields with 1900-01-01 00:00:00.000. Since it is possible to use a Macro in the Standard Cost Maintenance window, I am reluctant to recommend someone use a SQL script to rebuild pending standard costs (reset to zero) in the ICIV0323 table."

Thanks for clearing this up Harry. I can finally move forward. Have a great weekend!

Jim

Was this reply helpful? Yes No