At least 2-3 times a week we have to resort our key files for the inventory module. This requires me to walk around to each person and ask them to get out of MAS, which causes a huge problem if they are in the middle of something. Also all invoices must be updated to clear the lot quantities during the resorting of the files, this also causes a problem if we are not ready to update them. This is quite cumbersome considering it must be done frequently. I've been told this is an issue for many people and that Sage knows about it but won't fix it. Resorting the files to fix the problem is a terrible work-around and very frustrating to the clients who otherwise love MAS. Whatever is causing the inventory quantity available to become wrong SERIOUSLY needs to be addressed by Sage.
by: Heather G. | over a year ago | Sales & Distribution
Comments
What version are you on?
4.4, product update 2
Hi Heather -
Can I ask you a couple questions, please?
When you say inventory quantity available becomes wrong, what is exactly happening? Is the QOH higher or lower than it should be?
What valuation method(s) are currently being used? Does this affect all valuations (if different valuations are being used).
I ask because I am having the same issue with a client currently on 4.05, but they have an out of balance condition between the Lot/Serial History data, the IM Warehouse Detail and the Inventory Detail files. They only have this issue with the Lot items.
As to being told that "....Sage knows about it but won't fix it.....", I can HONESTLY say in my 19+ years working as a MAS90/200 Consultant I have NEVER had an issue reported to Sage they refused to fix.
Work with your Reseller to get this matter resolved to your satisfaction.
Sincerely,
Kathleen
I am on version 4.4 product update 3. The quantity on hand is generally correct, it's just not available. It gets hung up after someone starts to do a material issue in the work order module, then deletes it. It also happens in various other scenarios but that is the most common.
We use average and lot valutation, depending on what item it is. It seems to mostly affect the lotted items. But, having said that, it will not let you go into the negative on lot valuation while it will in average valuation. Plus, the majority of our component items are lot valuation items. So it's hard for me to gauge that.
I am totally open to suggestions if anyone has any!
I have the same issue if you are invoicing and have to get out for any reason. The inventory still shows as allocated to the order even though it was cancelled. The work around we have is in IM under Utilities. We use Muylti-bin so the option I have is "multibin recalculate quantity allocated". That releases the inventory back to available but is a major pain to have to do it all the time. It would seem to be an easy fix to just release the allocation when you release the order.