MDGP 2013 Feature of the Day: Default View Stores Sort Order

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty seventh feature they’ve announced is Default View Stores Sort Order.

Customers have the ability to choose additional sorts or custom sorts within lookups and can choose Set as Default View. Once this has been chosen as the default, the next time the user enters the lookup the list will populate based off the sort they Set as Default View.

This gives the customer the flexibility to set the lookups based off how they need to see the data and can save them valuable time in the application. The Set as Default option is available within the Customer and Prospects, Vendors, Items, Salespeople and Employees lookups;

Customers and Prospects Lookup

Continue reading “MDGP 2013 Feature of the Day: Default View Stores Sort Order”

MDGP 2013 Feature of the Day: Update Item Allocation Inquiry In Field Service

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty third feature they’ve announced is Update Item Allocation Inquiry In Field Service.

In the Item Allocation Inquiry window, Field Service now appears in the Module Restrictions box. You can now view item quantities allocated from Service Calls, RTVs and Depot work order documents. You can also use the Document Number field zoom to open the Field Service series inquiry window displaying the original document;

Service Call Entry/Update

Continue reading “MDGP 2013 Feature of the Day: Update Item Allocation Inquiry In Field Service”

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”