Microsoft Dynamics GP Lot Number Tracking Logic – Highlights For Developer


Visitors: 209

If your company is retailer and you integrate Microsoft Retail Management System with Microsoft Dynamics GP Great Plains, you probably were already thinking about lot number tracking integration challenges. Below we would like to describe elegant lot numbering schema, which maps to Microsoft RMS items. In GP we control Purchasing, inventory (inter-stores) transfers, new items/lot creation and barcode labels printing

  • Barcode labels. You receive new or existing inventory items in GP and print labels for RMS stored, containing GP Item Number plus Lot Number – as you sell different lots in RMS with different price and cost

  • Purchase Receipts. You receive Items which are lot tracked and you propagate them to MS RMS Headquarters. In Purchase Receipts you specify item location code, which is mapped to RMS store. In this case you should program MS RMS HQ worksheet and mark it as approved – it will go automatically by RMS HQ logic down to the store

  • RMS Stores Inventory transfers. This is probably the most challenging logic to be synchronized back in GP. Tables to consider in GP are IV10200, IV00300 plus GP looks into original posted inventory transfers: IV30200, IV30300

  • Standard GP-RMS Integration. Out of the box integration doesn’t support Lot numbering complicated schema, this is why we recommend you to research your needs in case if you need lot numbering and barcoding

  • Dexterity customization. Additional features could be added via dex custom GP logic. Integration itself uses Dexterity screens to set up integration mapping: company to RMS store, company inventory site to RMS store. Integration is flexible and supports multicompany to multistore mapping. Typically you integrate on the level of Microsoft RMS Headquarters, however you could also integrate on single RMS store level. In our opinion integration targets primarily HQ model with minimum of 5 RMS stores

    Andrew Karasev, Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918, local service is available in Chicago: Naperville, Aurora, Plainfield, Orland Park, Lisle, Downers Grove, Wheaton, Westchester, Westmont, Hinsdale; Houston: Richmond, Sugar Land, Katy, Rosenberg, Galveston, Dallas. USA/Canada nationwide support: Ontario, Quebec, Manitoba, California, Illinois, Texas, Virginia, New York, Florida, Washington, Minnesota, Wisconsin, Michigan, Arizona, New Mexico, Colorado, Nevada, Utah, Hawaii, Louisiana, North Dakota, Kansas, Ohio, Iowa.

  • (392)

    Article Source:

    Rate this Article: 
    Workflow in Microsoft Dynamics GP 10.0
    Rated 4 / 5
    based on 5 votes

    Related Articles:

    SAP Business One vs Microsoft Dynamics GP - Highlights for Consultant

    by: Andrew Karasev (November 25, 2005) 
    (Computers and Technology/Software)

    Business Portal - Microsoft Dynamics GP 9.0 - Highlights for Consultan

    by: Andrew Karasev (November 17, 2005) 
    (Computers and Technology/Software)

    Microsoft Dynamics CRM 3.0 Customization, Reporting Integration Highlights

    by: Andrew Karasev (November 15, 2005) 
    (Computers and Technology/Software)

    Microsoft Dynamics Gp Business Portal Implementation - Requisition Management ..

    by: Andrew Karasev (July 17, 2007) 
    (Computers and Technology/Software)

    Microsoft Axapta - Dynamics AX: Brazilian Portuguese Version - Consultant ..

    by: Andrew Karasev (January 09, 2006) 
    (Computers and Technology/Software)

    Microsoft Dynamics GP/NAV/CRM Implementation in South East Asia - Highlights

    by: Andrew Karasev (December 02, 2005) 
    (Computers and Technology/Software)

    Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW - ReportWriter - ..

    by: Andrew Karasev (May 16, 2005) 
    (Computers and Technology/Software)

    Microsoft Dynamics GP - Renovated Microsoft Business Solutions Great Plains ERP

    by: Andrew Karasev (September 26, 2005) 
    (Computers and Technology/Software)

    Microsoft Great Plains Integration with Microsoft Access - Overview for ..

    by: Andrew Karasev (September 09, 2004) 
    (Computers and Technology/Software)

    Workflow in Microsoft Dynamics GP 10.0

    by: Monique Tatum (December 28, 2007) 
    (Computers and Technology/Software)