Sage 100

Does anyone know what table has the lot\serial number and bin number for an inventory transaction adjustment? The IM_TransactionDetail does not have these fields. The customer has Multi-Bin.

Just realized the lot\serial number is in the IM_TransactionTierDist, no bin number. I may need to ask DSD if the bin number can be added to this table if it doesn't exist elsewhere for transaction entry. @NicoleRonchetti

Multi bin maintains it's own files. You can find that data in IM404_TransactionTierDist

For DSD/ScanForce Multi-Bin the file is MB_IMTransTierBinDistribution

Sorry, I assumed you meant ACSG (Scanco) Multi Bin

Thank you!@NicoleRonchetti