Sage 100

 View Only
  • 1.  Adding Multi Bin Primary Location to Inventory Maintenance Panel - v2022

    Posted 02-06-2025 10:57
    Edited by Jeff Schwenk 02-06-2025 18:38

    I am trying to add the primary bin location (Scanco table) to the item maintenance view on tab one.  The tip for adding fields to the ALE by @David Overholt and @David Speck II doesn't seem to apply when adding to this view.

    Am I missing something?  Is there a different method for the panel or just not possible at my skill level?

    Thanks in advance



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 2.  RE: Adding Multi Bin Primary Location to Inventory Maintenance Panel - v2022

    Posted 02-06-2025 12:23

    Hi Jeff,

    Did you mean to say that the tip for ALEs DOES NOT seem to apply?

    Also, do you mean using VI Export Job Maintenance to maintain links between tables?



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 3.  RE: Adding Multi Bin Primary Location to Inventory Maintenance Panel - v2022

    Posted 02-06-2025 12:34

    Also, what table and column are you after from the Scanco MB tables?

    I did do a brief test using VI Export Job Maintenance to create a link from IM_ItemWarehouse to another table and said table was not selectable when adding fields to the list box via Customizer Selection.  

    Depending on your target table, column, and the criteria to match a record, it may be possible to do this with a script on the post-read of CI_Item and the post-load of the Main tab.  The script would have to modify the IOList of the listbox used to load it and make use of the XEQ function to call perform logic in another script file to read the target table and return the value you want.



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 4.  RE: Adding Multi Bin Primary Location to Inventory Maintenance Panel - v2022

    Posted 02-06-2025 18:45

    @David Speck II - Correct, it should be DOESN'T.  Trying to display the primary bin location from the 140_IM_itemlocation (From memory, so spelling may be off).  Personally, this should be part of the Scanco installation (at least have the table appear for selection).  What you describe sounds a bit like the script you did for me four years ago (which worked great).  I was just hoping for a QAD solution for them. no scripting.  They already think I'm pricey.  I think they are spoiled...



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------