#GP 2018 and 2018 R2
want to integrate inventory from one company "C" (consolidated) to another "L" (local) using the Integration Manager
1. inventory in C was imported into IV00101 successfully from csv, a list of over 4k items.
all item type are "services".
2. next i created a new integration to "import" selected item number from C to L using source Before Query script
Dim itemCodeitemCode = InputBox("Enter Inventory Item CODE to Import","ITEMNMBR")Query.AdditionalCriteria = "ITEMNMBR = '"+trim(itemCode)+"'"
the source - destination source fields mapping are done for:
item number, description, short description, generic description, item type, valuation method, u of m schedule id, quantity decimals and currency decimals
3. running integration user is prompted for input and for example enters itemnmbr 011-008-01-005-00
* Error when the integration properties is set to Insert Only:
Opening source query...Establishing source record count...Beginning integration...DOC 1 WARNING: Field 'Description' truncated at 100Field 'Item Number' truncated at 30DOC 1 WARNING: Field 'Generic Description' truncated at 10DOC 1 ERROR: Value '0' cannot be converted to enumerated field 'Valuation Method'.Integration FailedIntegration Results 1 documents were read from the source query. 1 documents were attempted: 0 integrated without warnings. 0 integrated with warnings. 1 failed to integrate.
** Error when the integration properties is set to Insert and Update:
Opening source query...Establishing source record count...Beginning integration...DOC 1 WARNING: Field 'Item Number' truncated at 30Integration CompleteIntegration Results 1 documents were read from the source query. 1 documents were attempted: 0 integrated without warnings. 1 integrated with warnings. 0 failed to integrate.
1 integrated with warnings but the code input is actually NOT integrated.
actually nothing is integrated not 1.
assistance, help appreciated
Hello, thanks for responding.
details: both "C" company and "L" company databases are on the same SQL server.
the idea is to control creation of item number/codes by restricting (by policy) users to only create (unique) item numbers only in "C" or consol/consolidated database and use IM to integrate from "C" to any "L" (local or actual) companies that needed item numbers. so that each item has the same item number across all companies.
i am not sure why IM reports truncation of item number. the mapping from source to destination is "straight" without any script on this field or any other fields.
after posting here, i dug further into the gp installation folders... and found in the "samples" folder an integration for inventory and worked out from there what to do and happily the issues are now resolved. my source-destination mappings are rather basic, only 6 inventory item fields, with item type set constant to "services".
now i can integrate from C to L (with reported truncations warnings on descriptions and uom schedule id) inventory item master successfully.
one thing to note is that the "destination edit mode" must be set to "insert only" to be successful. setting to "insert and update" fails to import/integrate even though the log report says "integrated with warning". i am not sure why but at this time i don't need to find out.
If you've found this thread useful, dive deeper into User Group community content by role