Integration Manager for Microsoft Dynamics GP Item destination schema

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

APPLIES TO