MDGP 2013 Feature of the Day: Bin Transfer History

Microsoft Dynamics GPMicrosoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The third feature they’ve announced is Bin Transfer History.

Continue reading “MDGP 2013 Feature of the Day: Bin Transfer History”

MDGP 2013 Feature of the Day: Inventory Transaction Reason Codes

Microsoft Dynamics GPMicrosoft have started the Microsoft Dynamics GP 2013 Feature of the Day on the Inside Microsoft Dynamics GP Blog.

The first feature they’ve announced has been a long time coming. A regular question I’ve been asked by clients when implementing the Inventory Control module is how a reason can be assigned to the adjustment or variance and the best that could previously be done was to use part of the Batch ID.

Continue reading “MDGP 2013 Feature of the Day: Inventory Transaction Reason Codes”

Updating Item Purchasing Unit Of Measure From A CSV

Microsoft Dynamics GPAfter a slight mid-week diversion, here is another script I produced a while ago which updates the Item’s Default Purchasing Unit of Measure. It was produced when a client wanted to bulk update a large number of records which would have taken a long time manually but by script only minutes to write and run.

Continue reading “Updating Item Purchasing Unit Of Measure From A CSV”

Update Sales Transactions Distributions From Item

Microsoft Dynamics GPThis is a script I’ve had a few months now and, like the one I posted yesterday, thought it might be useful to others.

This script was created for a client who changed some of their account codes on some Item Classes and had rolled them down to the Items themselves but there were many Sales Transactions already on the system which had the old code on and needed to be updated to the new one.

Continue reading “Update Sales Transactions Distributions From Item”

Update Inventory Item Accounts From CSV

Microsoft Dynamics GPThis script was produced for a client who wanted to bulk update the accounts defined against selected Inventory Items in Microsoft Dynamics GP 2010 R2. This particular client did not have Integration Manager so I needed an alternative approach to doing the update.

I could have used a GP Macro to do the job (doing one while recording the macro to create a template to be populated from a CSV using Mail Merge) but it was easier to create a SQL script to do the job directly from the CSV (this is the same view I took for updating the Account Segment Master).

Continue reading “Update Inventory Item Accounts From CSV”

I Have A New Microsoft Dynamics GP Certification

Microsoft Certified Technology SpecialistGood news to end the week on. I’ve just returned home from the Prometric test centre with a brand new Microsoft Dynamics GP certification to add to my existing two.

The new one is MB3-862 Microsoft Dynamics GP 2010 Inventory & Order Processing.