Sage 100

Does anyone know if it's possible to have a VI import automatically select the oldest FIFO tier(s) when importing into Inventory Transaction Entry? I have a source file that has the item, whse and quantity but does not have the FIFO tier in it. Was thinking there might be perform logic I could add to force it to pick the oldest tier during the import. Thanks!

I think that might require a Script or custom programming, unless maybe there's an available enhancement.

Are your imported transactions deducting from inventory? What type of file is your source file?

Yes, I'm importing Adjustments to reduce inventory - which could present an additional problem. If I'm trying to adjust out a qty of 5, I may need to distribute across multiple FIFO tiers. It's a CSV file.

@DawnKulbacki, how'd you make out with this?

I didn't get anywhere with it. Ended up entering them manually. Some of the transactions imported correctly and others failed but I couldn't determine why they failed - the error was that the line wasn't distributed. If I extracted the 'failed' lines and imported them again, alone, they would sometimes import. I didn't have time to keep messing with it, so I just keyed them in.

I'm now realizing that importing into Phy Count Entry might be the better way to go vs. I/M Trans Entry because Phy Ct Entry doesn't prompt for the FIFO tiers via the Distribution Entry screen pop-up like Trans Entry does; during _manual_ entry (haven't tried importing yet), it creates a new Phy Ct tier if increasing the on-hand qty, and it appears to decrease the oldest tiers first if decreasing the on-hand qty.