Open Forum

Expand all | Collapse all

IV00101, Item Maintenance Screen and Currency Decimals

  • 1.  IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 07, 2019 04:47 PM
    I am working on uploading a number of inventory items.  I am using Smart Connect to do this, but am having some difficulties with currency decimals.  I want the currency decimals on the item maintenance screen to show 4.  From my understanding this would be 5 in the deplcur field in inv00101 and the create item mapping.  As I look through the inv00101 table sometimes deplcur of 5 will result in a 4 for currency decimals and sometimes it will result in 5 for currency decimals.  Shouldn't a 5 in deplcur always be a 4 for currency decimals?

    When running the smart connect map I can only get the currency decimals to end up being 5 on the item maintenance screen.

    I can create the item by hand in GP and select whatever i'd like for currency decimals.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    Posted Aug 08, 2019 04:49 PM
    If decplcur is 5 for all your items in iv00101, I would check iv00105 and see if decplcur has the same value in that table.

    ------------------------------
    Cal Quigley
    KIP America
    Novi MI
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 09, 2019 11:18 AM
    The decplcur in iv00101 does match iv00105, however we have some that have a decplcur of 3 and some with a decplcur of 5....

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 09, 2019 11:44 AM
    I spoke too soon.  I had accidentally looked at my live DB instead of the test one i've been working in.  The items that i did import with smart connect got a decplcur of '5' on the iv00101 table, but a decplcur of '6' in the iv00105 table. The only mapping that i have is to the create/update item. Is there another place I should be mapping to?

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    Posted Aug 09, 2019 12:08 PM
    I am not sure why this happens.  When I do an import using smart connect to the IV00101 I have learned to always import to the IV00105 table at the same time.  If I don't have prices I update the records with 0.

    ------------------------------
    Cal Quigley
    KIP America
    Novi MI
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 09, 2019 12:57 PM
    I'm assuming you have to assign a currency id then?

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    Posted Aug 09, 2019 02:07 PM
    Yes

    ------------------------------
    Cal Quigley
    KIP America
    Novi MI
    ------------------------------

    Conference-GPUG_200x200


  • 8.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 23, 2019 03:18 PM
    i've tried about everything i can think of and still can't get the darn currency decimals to be set to '4'.  I emailed eone and they responded asking me a question and have responded to my two emails afterward.....I tried to do this upload of inventory items as a macro too, but it constantly bombed out.  Any other suggestions on how to get this to work?  Would really be nice if smartconnect worked.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


  • 9.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    Posted Aug 23, 2019 03:58 PM
    I just ran a test with smart connect 20.12.0.22 and GP 2010 SP4.

    If I use 2 for DECPLCUR in the excel file used for the map, I get 2 decimal places in GP.  In the IV00101 table DECPLCUR is 3.  Smart connect is changing the value from the file to value GP uses on the IV00101 table.  It does the same thing for the IV00105.

    So if you want 4 decimal places in GP, I think you should put 4 in the file you are using to upload.  The IV00101 and IV00105 table should then have 5 in the DECPLCUR column.

    ------------------------------
    Cal Quigley
    KIP America
    Novi MI
    ------------------------------

    Conference-GPUG_200x200


  • 10.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 23, 2019 04:48 PM
    my iv00105 table is actually getting two rows.  one with a blank curncyid and decplcur = '6' and one with a currencyid and decplcur = '5'.  Any thoughts?  The iv00101 has deplcur = '5'.  Currency decimals on item card shows 5 (which would translate to a table value of 6 i believe)

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


  • 11.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    Posted Aug 26, 2019 09:01 AM
    Are there records in your file used with the import that have a blank currency id?  Do you somehow have a blank currency ID setup in GP?  It seems odd that smart connect would import a record if the currency ID did not exist.

    If you delete the records from iv00105 with decplcur = 6, do decimal places in GP look correct?

    ------------------------------
    Cal Quigley
    KIP America
    Novi MI
    ------------------------------

    Conference-GPUG_200x200


  • 12.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 26, 2019 10:25 AM
    I wasn't using a currency id for the upload originally. I just tried doing it now and the interesting this is the iv00105 gets a deplcur of '5' with only one row per item loaded, but when i go into the item card in GP the currency decimals says 5 and once I open the item card the iv00105 table gets an additional row with deplcur of '6'.  I'm not sure why opening the card is causing another row in that table.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


  • 13.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 28, 2019 10:03 AM
    Can anyone tell me what the negative impact would be if the decimals were set to 5 instead of 4?

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


  • 14.  RE: IV00101, Item Maintenance Screen and Currency Decimals

    GOLD CONTRIBUTOR
    Posted Aug 29, 2019 10:44 AM
    Another update to my testing.  If i use smart connect I can get everything onto the item card as I want it, with the exception of deplcur.  To resolve the deplcur issue I can delete the row from iv00105 where deplcur is setting to '6' and that seems to resolve my problem.  Anyone see any fallout with that resolution?

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Conference-GPUG_200x200


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