Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Change Item Standard C...
Microsoft Dynamics GP (Archived)

Change Item Standard Cost Macro

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have about 450 items that need to have standard cost updated.

I'd love to go direct to DB and simply update the Item master but I know better.... My normal macro process is to capture a few entries via the macro record tool but the tool is not capturing the TypeTo field 'Item Number', and TypeTo field 'Standard Cost'. I have GP power tools and when I enable the debugger and record a macro I get the values, but the format changes significantly.

My question is: Is there a better way? A better way to capture the for the Macro? Maybe use integration manger?

Thanks!

*This post is locked for comments

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Change Item Standard Cost Macro

    Sorry for the late reply, but I am not aware of any stored proc that will recalculate the inventory.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Change Item Standard Cost Macro

    Thanks Mariano, I was using the Change Item Standard Cost Screen. This seems like basic functionality to me. It's interesting M$ has not provided a viable method of automating the process.

    IF I manually update the STNDCOST in IV00101 is there a stored procedure that I can call that will automatically recalculate all existing inventory?  

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Change Item Standard Cost Macro

    The primary assumption here is that you know that you can only change the standard cost of an item by using the Change Item Standard Cost window (Inventory > Utilities > Change Item Standard Cost). With that said, I was able to confirm that the macro is not recording any of the MoveTo Field or TypeTo Field statements, as shown here:

    # DEXVERSION=18.00.0010.000 2 2
CheckActiveWin dictionary 'default'  form 'IV_Item_Standard_Cost_Change' window 'IV_Item_Standard_Cost_Change' 
  CommandExec dictionary 'default'  form 'IV_Item_Standard_Cost_Change' command 'Process Button P_w_IV_Item_Standard_Cost_Change_f_IV_Item_Standard_Cost_Change' 
NewActiveWin dictionary 'DEX.DIC'  form 'Report Ask' window 'Report Type' 
  ClickHit field '(L) Screen'  # 'TRUE'
  MoveTo field '(L) OK' 
  ClickHit field '(L) OK' 
NewActiveWin dictionary 'default'  form 'IV_Item_Standard_Cost_Change' window 'IV_Item_Standard_Cost_Change' 
# Print To Screen:  'IV Item Standard Cost Change Exception'
NewActiveWin dictionary 'default'  form sheLL window sheLL 
WindowSize dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' pointh 450 pointv 30 
NewActiveWin dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' 
WindowSize dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' pointh 450 pointv 30 
ActivateWindow dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' 
WindowMove dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' pointh 0 pointv 2 
WindowSize dictionary 'DEX.DIC'  form 'Reports Screen' window 'Report Screen' pointh 635 pointv 40 
ActivateWindow dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' 
ActivateWindow dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' 
CloseWindow dictionary 'DEX.DIC'  form 'Reports Screen' window 'Screen Output' 
NewActiveWin dictionary 'default'  form sheLL window sheLL

    I then went ahead and attempted to add the MoveTo and TypeTo field statements. It worked for the item number, but I could not get it to tab off the field, therefore the MoveTo for the 'New Standard Cost' field failed. Unfortunately, the macro system does not have a way to send keyboard commands in.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans