Open Forum

Expand all | Collapse all

problem with integration manager and inventory

  • 1.  problem with integration manager and inventory

    Posted 26 days ago
      |   view attached

    hello,

    #GP 2018 and 2018 R2

    #integration manager

    want to integrate inventory from one company "C" (consolidated) to another "L" (local) using the Integration Manager

    the situation:

    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 itemCode
    itemCode = 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 100
    Field 'Item Number' truncated at 30
    DOC 1 WARNING: Field 'Generic Description' truncated at 10
    DOC 1 ERROR: Value '0' cannot be converted to enumerated field 'Valuation Method'.
    Integration Failed
    Integration 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 30
    Integration Complete
    Integration 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

    ​​​

    ------------------------------
    stephen tan
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: problem with integration manager and inventory

    GPUG ALL STAR
    Posted 25 days ago
    Hi @stephen tan

    ​I don't think you've really given us enough information to help with this, but some insight may help:
    1) Item Numbers MUST be unique and if you are randomly trimming or trying to let it truncate the item numbers this may be causing an issue.
                 -Change the source file or alter it so that you can determine that the truncation is not creating duplicate records
     2) Are you certain you are integrating in ALL of the required fields on an integration?
                 -A good test is to hand-key an item and ensure that all of the 'required fields' are being filled out just the way GP needs them to be:
                                ie: Is the UofM already in GP, if you are inputting any tax options, are those setup, are you assigning them to an inventory class (a great thing to do) but is
                                      the class setup in the other company?

    And, how are the item numbers needing to be truncated if they are extant in another company? Are you appending information? Are the two companies in the same database?

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: problem with integration manager and inventory

    Posted 23 days ago

    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.

    cheers



    ------------------------------
    stephen tan
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role