Sage 100 Advanced 2019 PU4
We switched the valuation method on raw material items from FIFO to Lot for a client that has Production Management installed. The Valuation Change utility ran fine, no errors and all files were updated except production management. The work ticket parent item valuation isn't stored in the PM data files so that was OK. The component items store the valuation method on each detail record in the work ticket detail and the work ticket history detail and that was not changed. When they went to issue materials using dynamic inventory it let them enter the quantity, did not prompt for a lot number and issued no parts from inventory with no error message.
We were able to add the valuation method field to the secondary grid in work ticket entry and drag it up to the primary grid and it allowed them to change it from a 3 to a 5. This amazingly also updated the record in the history file. That was a lot of data entry for them but it fixed the problem with not being prompted for a lot number.
They also had a work order with materials issued prior to the change that had to be cancelled and the components returned to inventory. We have not been able to find a way to get dynamic inventory to work for theses items. A work ticket material issue transaction for a negative quantity is a work around that takes care of inventory and costing on the work ticket but creates a duplicate of the component items with zero required and a negative quantity issued.
Just wanted to share this in case it might help someone avoid some of the fun we had with this. Maybe it's fixed in a newer version but I'm not holding my breath at this point.
------------------------------
Bernie Lehman
Partner
Lehman Wesley & Associates
Lansing MI
517-908-0760
------------------------------