Sage 100

 View Only

  • 1.  Changing Item Valuation in DFDM

    Posted 09-17-2020 15:25
    I have a customer who has a serialized item which has a QOH in the IM_ItemCost table of the FIFO tier.  Customer has gotten all of their SN's out of the inventory and tried to change the valuation from Serialized to FIFO, but the system wouldn't let them due to records in SO Invoice Data Entry.  This customer is not a good candidate to either post all of the invoices or delete/rekey them, nor do I believe they will be very excited about not invoicing items if we copy the SO_Invoice tables, reinitialize them, adjust out the FIFO tier, and put the original SO_Invoice tables back in place.  

    Is it safe, or what considerations should I be aware of, to change the Valuation of the item to FIFO using DFDM, have them make the changes to the QOH as needed, and use DFDM to change it back to Serialized?

    Chris

    ------------------------------
    Chris Love
    Accounting Systems, Inc. (ASI)
    ------------------------------


  • 2.  RE: Changing Item Valuation in DFDM

    Posted 09-17-2020 15:29
    Edited by Jim Woodhead 09-17-2020 17:59
    Can you export the SO Invoice details. .  Delete them, then do  the valuation change and then reimport the Invoices?
    Sent via my IPad
    Jim Woodhead | VP of Professional Services
    DSD Business Systems
    direct: 858.550.5900 ext. 125 | mobile: 619-990-3946





  • 3.  RE: Changing Item Valuation in DFDM

    Posted 09-17-2020 15:33
    Buy yourself some time and avoid DFDM issues direct editing the file:
    1. Setup a new Item with all the specs of the serialized item but with a FIFO valuation.
    2. Discontinue/inactive the serialized item to prevent further orders against it.
    3. Tell the customer they have X days/weeks to finish and update invoices with the old serial item
    4. After serial items last update, merge the serialized and the FIFO item numbers together.

    ------------------------------
    Moira Goggin
    Chismet Consulting Corp.
    Long Beach CA
    ------------------------------

    Original Message


  • 4.  RE: Changing Item Valuation in DFDM

    Posted 09-17-2020 15:42
    Does the merge utility allow you to merge an valuation type "6" with a valuation type "4"?

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------

    Original Message


  • 5.  RE: Changing Item Valuation in DFDM

    Posted 09-17-2020 15:45
    I don't believe that it will let you do that. We would have to get the original PN into the FIFO valuation in order to merge the 2 I believe.

    ------------------------------
    Chris Love
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 6.  RE: Changing Item Valuation in DFDM

    Posted 09-17-2020 15:34
    @Karen O'Lane suggested something similar.  Make a copy of those tables, reinitialize, then put the original files back in place.  However, coordinating this with the customer to stay out of those tables/tasks will be difficult to do. Trying to avoid that if I can.​

    ------------------------------
    Chris Love
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 7.  RE: Changing Item Valuation in DFDM

    Posted 09-17-2020 16:26
    How did the FIFO tier get into a Serialized item?  How would the inventory re-balancing utility (*UTL) deal with it?
    I'd experiment with editing the TierType in IM_ItemCost to see if normal serial adjustments might be possible.

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



  • 8.  RE: Changing Item Valuation in DFDM

    Posted 09-18-2020 15:03
    Not sure how the FIFO tier got included in a serialized item.  The only thing I can speculate is something I experienced with another customer.  They created an item on the fly in a Purchase Order as Average Cost, but before they saved the PO, they went into Item Maintenance and changed the item to Serialized.  So the system let them save it as Average and they would receive a serialized item in as average cost. This is a little bit different though. The day before the item was received, they changed the valuation from FIFO to Serialized. Just makes me think the item was on some kind of order when they changed the valuation and it was just perfect timing of things.

    ------------------------------
    Chris Love
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 9.  RE: Changing Item Valuation in DFDM

    Posted 09-18-2020 15:42
    @Beth Bowers gave me a good suggestion.  After reviewing the IM_ItemWarehouse and CI_Item tables, the QOH in these tables do not include the 10 units in the FIFO tier.  Therefore, it seems like it may be safe to just delete the tier altogether.   ​This way, I don't even have to do anything to the valuation.

    ------------------------------
    Chris Love
    Accounting Systems, Inc. (ASI)
    ------------------------------

    Original Message


  • 10.  RE: Changing Item Valuation in DFDM

    Posted 09-18-2020 15:48
    Whenever I run into anything odd with inventory files I always run the *UTL re-balancing utility to see how everything matches up afterwards.

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

    Original Message


Related Content