This article contains documentation to help you set up an Item Integration by using the Microsoft Dynamics GP Standard Adapter.
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
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
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
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
Site Display Options - 1 = All, 2 = Site ID
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
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.
Microsoft Dynamics GP 10.0
Microsoft Dynamics GP 9.0
Microsoft Business Solutions–Great Plains 8.0