Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Saturday, November 19, 2016

Inventory Adjustment Macro Generator - Macro Essentials Series (Free Tool - Beta Version)



Last year, I have proposed a new concept for data integration in Dynamics GP, which is built upon Macro. Macro are widely known by Dynamics GP users, and is always used with Word - Mail merge functionality. Which seems to me quite static, and lack the capability of building generic coding. 

The previous posts delivered one of the most complicated processes in Dynamics GP, Analytical Accounting with General Ledger journals. You may review the process, watch a video tutorial and download the tool from the following link Analytical Accounting Entry (Excel to Dynamics GP) – Free Tool (Beta).



In this post, another tool is being provided for the community, through which inventory adjustment can be integrated through the same excel-based macro generator functionality. Although, I have not linked this excel with the SQL server considering the fact that this one is mostly delivered to End-users with no SQL knowledge. In this essence, all they need to do is to fill out the template and import data into Dynamics GP.

To try the inventory adjustment Macro Generator, follow the steps below:

  • Download link for the Inventory Adjustment Macro Generator - Link
  • Go to Inventory > Transactions > Transaction Entry 
  • Create a new batch, make sure that you place the cursor at the type (Adjustment)
  • Go to the Excel, and fill out the required details for the adjustments you want to make
  • Copy the Column highlighted in the screen shot below into word (to preserve the format)
  • Copy it from Word to note pad (with extension .mac) as a macro file 
  • On the adjustment entry window, play the macro

Inventory Adjustment - Macro Generator

Please remember to create a batch, and be aware that a single adjustment number will be created for every location.


This is a  pilot for the macro generator, your suggesstions will be taken in further releases. 
Your feedback is highly appreciated 


Best Regards, 
Mahmoud M. AlSaadi

13 comments:

  1. Hi Mahmood, do you have this macro for Dynamics GP 2016?
    Thank you

    ReplyDelete
    Replies
    1. It must be working well with 2016, have you encountered any issues ?

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  2. Hi Mahmood, do you happen to have a version of this for Bins? I can update the code but just looking for the easy button. Thanks.

    ReplyDelete
    Replies
    1. We can create one, contact me on my primary email address for further details

      mahmoodsaadi@live.com


      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  3. Hi Mahmood, How can I update the excelsheet to work for serialized mass adjustment. I want to use serial 001 for all of the items.

    ReplyDelete
    Replies
    1. Hello Edress
      We can create one, contact me on my primary email address for further details

      mahmoodsaadi@live.com


      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  4. Hi Mahmood,

    With this tool, how do I ensure the macro is going to run past the last line on the visible window in GP?

    For instance I have 45 items to enter but on 21 are entered before the error message "Field on Window is inactive or disabled. (line#472)

    ReplyDelete
  5. I found the error. There was a corrupt line in the macro. Thanks

    ReplyDelete
  6. Spent a half0day trying to come up with my own solution until I found this blog. Works slick!

    ReplyDelete
  7. Dear Mahmoud,
    Can you send excel Template for Adjustment Stock Items ,Create new Items Issued and Receving New Shipment.for GP

    ReplyDelete
  8. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete