Integration Manager for Microsoft Dynamics GP Item destination schema

TechKnowledge Content

SUMMARY

This article contains documentation to help you set up an Item Integration by using the Microsoft Dynamics GP Standard Adapter.

MORE INFORMATION

Item destination

Adapter: Microsoft Dynamics GP

Required Fields - New Items

Item Number - The item number that is being integrated

Description - Description of the Item Number entered

Sales U of M Schedule ID - The schedule for the U of M this item will use

Other Fields
Some fields in Integration Manager require specific values if they are going to be mapped. Below are fields for an Item integration that require specific values if they are mapped and what values are.

Item Type - 1 = Sales Inventory, 2 = Discontinued, 3 = Kit, 4 = Misc Charges, 5 = Services, 6 = Flat Fee

Valuation Method - 1 = FIFO Perpetual, 2 = LIFO Perpetual, 3 = Average Perpetual, 4 = FIFO Periodic, 5 = LIFO Periodic

Sales Tax Option - 1 = Taxable, 2 = Nontaxable, 3 = Base on Customers

Purchase Tax Option - 1 = Taxable, 2 = Nontaxable, 3 = Base on Vendor

Quantity Decimals - 0 = 0, 1 = 1, 2 = 2, 3 = 3, 4 = 4, 5 = 5

Currency Decimals - 0 = 0, 1 = 1, 2 = 2, 3 = 3, 4 = 4, 5 = 5

Options Collection

Track - 1 = None, 2 = Serial Numbers, 3 = Lot Numbers

Item Planning Type - 1 = Normal, 2 = Master Schedule

Allow Back Orders - True, False

ABC Code - 1 = None, 2 = A, 3 = B, 4 = C

Pricing Collection

Price Method - 0 = Currency Amount, 1 = % of List Price, 2 = % Markup - Current Cost, 3 = % Markup - Standard Cost, 4 = % Margin - Current Cost, 5 = % Margin - Standard Cost

Qtys/Sites Collection

Site Display Options - 1 = All, 2 = Site ID

Vendors Collection

FOB - 1 = None, 2 = Origin, 3 = Destination

Default Purchasing U of M Type - 1 = From Item, 2 = From Item Vendor

Sample Source File

Item Number Description U of M Schedule ID Valuation Method
BLPH - 123 Blue Phone PHONE 1 1
PHHKUP - 1 Phone Hookup SERVICE 3
GRPH - 123 Green Phone PHONE 1 1
RDPH - 123 Red Phone PHONE 1 1


This article was TechKnowledge Document ID: 31048

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS. 

APPLIES TO