MDGP 2013 Feature of the Day: Update Back Order Item Qty In Field Service

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

The thirty ninth feature they’ve announced is Update Back Order Item Qty In Field Service.

Microsoft Dynamics GP Service Call Management and Depot Management will now update the Item Quantity Master when they have a back ordered item. This will be visible in the Item Inquiry and Item Quantities Maintenance windows and give you a truer representation of your inventory quantities.

The example screenshots show Item 3-D2657A (DB 15 Male Adapter) with no items on back order in Item Inquiry;

Item Inquiry

Continue reading “MDGP 2013 Feature of the Day: Update Back Order Item Qty In Field Service”

MDGP 2013 Feature of the Day: Relate/Link Items for Suggested Sales

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

The nineteenth feature they’ve announced is Relate/Link Items for Suggested Sales.

With this feature it is now possible to link together items for suggesting during the entry of a Sales Order Transaction.

Continue reading “MDGP 2013 Feature of the Day: Relate/Link Items for Suggested Sales”

MDGP 2013 Feature of the Day: Item Standard Cost Adjustment

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

The seventeenth feature they’ve announced is Item Standard Cost Adjustment.

In Microsoft Dynamics GP 2013, a new window for changing the Standard Cost of an item has been introduced. When the Standard Cost of an item is changed, an adjusting entry will be made to the General Ledger which will keep the General Ledger and Inventory Control series in balance.

Continue reading “MDGP 2013 Feature of the Day: Item Standard Cost Adjustment”

MDGP 2013 Feature of the Day: SSRS Reports On Forms

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

The sixteenth feature they’ve announced is SSRS Reports On Forms.

This feature allows users to print SQL Server Reporting Services (SSRS) reports directly from a window in Microsoft Dynamics GP. This has been made available on a range of windows across General Ledger, Receivables Management, Sales Order Processing, Payables Management, Inventory Management, Human Resources and Payroll.

Continue reading “MDGP 2013 Feature of the Day: SSRS Reports On Forms”

MDGP 2013 Feature of the Day: Reconcile IV To GL

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

The fifteenth feature they’ve announced is Reconcile IV To GL.

Microsoft Dynamics GP 10 saw the introduction of the Reconcile to GL report which allowed the automation of the reconciliation of differences in Receivables Management and Payables Management to the General Ledger. In Microsoft Dynamics GP 2013 the Inventory Control module will be added to the Reconcile to GL to help users identify the differences between the Historical Inventory Trial Balance and the GL inventory accounts;

Continue reading “MDGP 2013 Feature of the Day: Reconcile IV To GL”

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”