Dynamics GP - Price List Details SQL Script

It's been a while, back with more SQL scripts for Dynamics GP. This one provides a summary for all Dynamics GP prices lists including all price levels

Price List Details

CREATE VIEW [dbo].[Vw_PriceListDetails]

AS   

SELECT  A.ITEMNMBR ,

        RTRIM(LTRIM(B.ITEMDESC)) AS ItemDescription,

        RTRIM(LTRIM(A.CURNCYID)) AS Currency ,

        RTRIM(LTRIM(A.PRCLEVEL)) PriceLevel ,

        RTRIM(LTRIM(C.DSCRIPTN)) AS PriceLevelDescription,

        A.UOFM AS UnitOfMeasurement,

        A.FROMQTY AS FromQuantity,

        A.TOQTY AS ToQuantity,

        A.UOMPRICE AS 'Unit Of Measurement Price',

        A.QTYBSUOM 'ConversionFactor',

             A.UOMPRICE 'Price without Tax'

FROM    [IV00108] AS A

        LEFT OUTER JOIN IV00101 AS B ON A.ITEMNMBR = B.ITEMNMBR

             LEFT OUTER JOIN dbo.IV40800 AS C

             ON C.PRCLEVEL = A.PRCLEVEL

GO

Best Regards, 

Mahmoud M. AlSaadi

Vehicle Management - Dynamics GP Extender

Dynamics GP is a core provider ERP that delivers added value for the organization regarding their financial and supply chain functions primarily. Although, in certain cases, there are certain processes which requires to be automated and to be supported by the ERP system due to the fact that they are highly interconnected with financial or suppl chain functions in the system. 

In a recent implementation of Dynamics GP for one of the big 5 trading and distributions companies here in Jordan, there has been a strong demand to automate the vehicles management processes which represents a very essential function in the company, processes include but not limited t:

• To define drivers, vehicles profiles, vehicle expense types, preventive maintenance schedules and vehicle cost centers (which will be later on reflected on the Analytical Accounting module)
• To capture the daily meter reading of the vehicles and provide distance reports and analytical details
• To capture the daily vehicles expenses registry details (which will be integrated with the Accounts Payable with analytical accounting details)
• To provide notifications on the routine tasks for vehicles as derived from the preventive maintenance schedules
• To record and process vehicle custody and ownership, which means that each vehicle is associated with a driver. In case a vehicle custody is assigned to another driver, transfer vehicle transaction must be recorded in order to keep track
• Many other vehicle management processes which could partially have a financial impact.

The only robust solution for such complicated requirement is represented with one product only, eOne Extender. The various capabilities provided by Extender omits any obstacles in Dynamics GP and open the limits for unlimited horizon for the clients requirements.

Backed with complex SQL procedures and Crystal Reports, Extender allowed us to create a complete new module in Dynamics GP to manage the vehicle management processes. Cards, Transactions, transnational and analytical reports. 

Dynamics GP Extender - Cards

Dynamics GP Extender - Transactions

Vehicle Expense Registry

In the next posts, further more details about the vehicle management module for Dynamics GP will be illustrated.

Best Regards,
Mahmoud M. AlSaadi

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

As part of the Macro Essentials Series, another tool is being delivered today which aims to make the data entry process into Dynamics GP easier and more efficient. The purpose of this tool is to do the following:

• Enter inventory transfers into Dynamics GP using the "Transfer" form in the inventory module. 

In order to use this tool, you need to follow the steps below:

1. Fill out the the transfer details on the excel sheet, which includes (Item Number, From Location, To Location ..etc)
2. Fill out the quantities to be transferred from one site to another
3. Copy the Macro column into Word (to preserve the code formatting), then into a Macro file. 
4. Run he Macro on the Inventory Transfer form as illustrated in the short video below

Inventory Transfer Macro Generator - Short Demo

 You can download the transfer macro from the following Download Link.

Best Regards,
Mahmoud M. AlSaadi