Sage 100

 View Only

  • 1.  Transaction Entry VI Import wiht Lot distribution

    Posted 03-24-2020 20:18
    I have a client with several lots with 0 quantity and remaining value.  I'm trying to create an import to enter the correcting transaction entry adjustment to bring in a quantity of 1 at a cost of 0 so that I can then create the adjustment of -1 at the remaining cost.  

    The problem:  In data entry, after lot distribution, the cost is set to the lot cost.  After distribution, I can manually override the lot cost to be 0 to accomplish my goal.  In VI, it won't allow me to override the cost.  Suggestions?

    ------------------------------
    Janna Crowther
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: Transaction Entry VI Import wiht Lot distribution

    Posted 03-24-2020 20:59
    Create a new lot using today's date or something other consistent lot number with a cost of $.01.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 3.  RE: Transaction Entry VI Import wiht Lot distribution

    Posted 03-25-2020 10:23
    I am working on the same thing (and running into fun with Multi-Bin for this customer... but that is another story).
    Use the tier's UnitCost for the +1 transaction, then calculate that plus the existing ExtendedCost for the -1 transaction.  Don't try to force $0 for the +1 transaction.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Transaction Entry VI Import wiht Lot distribution

    Posted 03-25-2020 10:27
    Oh, and when cleaning up old data, watch for TierType not aligning properly with the item Valuation.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Transaction Entry VI Import wiht Lot distribution

    Posted 03-25-2020 15:09
    Thanks Kevin Moyes, I didn't even THINK about just letting the total value calculate for itself on the negative entry!  That worked!  Appreciate all of the other suggestions as well, but this was the winner!!

    ------------------------------
    Janna Crowther
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 6.  RE: Transaction Entry VI Import wiht Lot distribution

    Posted 03-25-2020 10:38
    What you are describing is how Sage 100 is designed, you may need a script or custom program to perform the update of the cost after the distribution.  I am not sure using a different Lot ID will work since you need to affect the actual lot with the errant value.

    ------------------------------
    Bruce Kern
    SWK Technologies Inc.
    ------------------------------



  • 7.  RE: Transaction Entry VI Import wiht Lot distribution

    Posted 03-25-2020 14:59
    You could import the lot items to the inventory valuation change table, change the valuation to average cost, make the +1 / -1 transaction entry, then change the valuation back to lot.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



Related Content