Open Forum

Expand all | Collapse all

Rapid Start Error

  • 1.  Rapid Start Error

    TOP CONTRIBUTOR
    Posted 8 days ago
    I am trying to use rapid start to update product group codes and item category codes.  I have uploaded and applied and have several errors stating "the field product group code of table item contains a value that cannot be found in the related table (product group)".  I am clearly over looking something as the code is an option.

    ------------------------------
    Marguerite Manelski
    Director of Business Intelligence
    American Ring
    Solon, OH
    **Great Lakes Chapter Member**
    ------------------------------


  • 2.  RE: Rapid Start Error

    TOP CONTRIBUTOR
    Posted 7 days ago
    Marguerite,

    If you are sure that all of the values that you are importing are valid, you can uncheck the Validate Field checkbox for the fields creating the errors on the Config. Package Fields page.   If you have a test environment, it would be best to try it there first.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    -----------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl/
    ------------------------------



  • 3.  RE: Rapid Start Error

    TOP CONTRIBUTOR
    Posted 7 days ago
    @Lewis Rosenberg this appears to work I'm just curious to understand why I am receiving the error.  I am thinking that something is not set up correctly but I cannot figure out what. 

    ------------------------------
    Marguerite Manelski
    Director of Business Intelligence
    American Ring
    Solon, OH
    **Great Lakes Chapter Member**
    ------------------------------



  • 4.  RE: Rapid Start Error

    TOP CONTRIBUTOR
    Posted 7 days ago
    I've had issues with (I think) the Item Tracking field on the item card in the past.  I knew I was sending in the right valid value, but NAV continued to give me the error until I turned off the validation.​

    So, it could be that something is not setup, or it could be the way NAv is trying to validate a new value going in.

    Maybe someone else can shed some more light on this topic.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    -----------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl/
    ------------------------------



  • 5.  RE: Rapid Start Error

    Posted 7 days ago
    ​Not a rapid start expert, but I have imported data in many other ways. When loading the data, your Item Category table must be loaded first. Then the Product Group table is next, then your item table. This would be the correct order due to the dependency of each table. If all of your data loads are in one rapid start package, it may be doing individual validations on all tables before doing "any" inserts.

    ------------------------------
    Joseph Flynn
    Sr. Dynamics NAV Developer
    Gold Star Foods INC
    Ontario CA
    ------------------------------



  • 6.  RE: Rapid Start Error

    TOP CONTRIBUTOR
    Posted 7 days ago
    @Joseph Flynn is spot on.

    Another tip - You can set the processing order on each table, and validation can be turned off at the field level, though I don't recommend doing this unless absolutely necessary.

    An example of acceptable validation disabled would in the situation of Item's Base Unit of Measure. You can't assign a Base Unit of Measure until the Item Unit of Measure has been defined, and you can't define an Item Unit of Measure until the Item and Units of Measure have been defined.​ So you would set your processing order in Rapid Start for the tables as 1) Unit of Measure, 2) Item Unit of Measure, 3) Item and remove validation on the Item No. field of the Item Unit of Measure import.

    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------



  • 7.  RE: Rapid Start Error

    GOLD CONTRIBUTOR
    Posted 7 days ago
    I believe I ran into a similar problem yesterday. I was trying to update the sales price table and received an error that the customer code was not in the customer table when it should have been pulling Customer Price Group instead. The table was trying to import Sales Code before Sales Type.

    To fix it, I changed the order of the fields, moving the Sales type above Sales Code.



    ------------------------------
    Joshua McGee
    Information Systems Manager
    Cover-Pools, Inc
    West Valley City UT
    ------------------------------



  • 8.  RE: Rapid Start Error

    TOP CONTRIBUTOR
    Posted 7 days ago
    Thank you.  I will check that.  I have a feeling that the tables are in the wrong order based off of the request to change more fields after the report was created.

    ------------------------------
    Marguerite Manelski
    Director of Business Intelligence
    American Ring
    Solon, OH
    **Great Lakes Chapter Member**
    ------------------------------