Sage 100

I know there's no easy answer to this, but thought I'd check to see if anyone has been able to come up with reasonable report that helps search for information: when producing FIFO finished goods in WO, the material issue pulls raw materials that use lot valuation and the HEAT (lot) numbers are distributed as needed. Now the client would like to see that heat number that was associated with the finished good when shipping it out so we can reference it, print corresponding material certifications, etc. There's obviously no drill-down available for WO transactions and never will be, so my next options are to either have the client LOT-value the finished goods as well with the corresponding heat number, or write a complicated Crystal query to track backwards: SO line item > IM FIFO tier for finished good > WO completion > WO Material Issue > IM Lot number for raw material.

couldn't you have multiple material matieral issues with diffeferent lots hitting the same completion/FIFO tier? If not, maybe you could store that Lot # somewhere until the completion is updated and then push into the IM_Item Cost table - sounds like it might be worth getting a quote from a master developer.

Tracking lots inside of lots isn't even easy - I have always felt this is a big hole in MAS 90. I have been curious if there is a 3rd party solution. I know there are food companies that use it and I have wondered how they track it for recalls etc.

I agree Roberta - I'm really surprised there's never been any focus on allowing for easy drill-down of lot/serial components from BM or WO transactions.

maybe Sage can add this functionality when they update the Work Order module...... that was fun, and now we're back to reality.

If you used a Lot to Lot scheme, maybe add a UDF's for Raw_Item# & Raw_Lot# to ItemCostDetail(Lot), we could write some code to populate that UDF during the WO Trans Update with the material item and lot #, then it could be transferred to a UDF's in SO InvoiceTierDistribution and then to AR InvoiceHistoryLotSerial during the Sales Journal Update. (We are MD's).

Note: you can use UDF's to link to other MAS tables in Crystal, so once you have the linkage UDF's for a lot, you can link to a record for another (raw material) lot.

Thanks Lee - I will review this with the client. Just a shame it's not available in MAS.

ACS has a Work Order enhancement that writes the wo # to the IM Transaction files, including the Lot/Serial file instead of the wo transaction number. This would make it easier to write a report off the Lot/Serial History file by work order number.