Looking for some insight. I’m struggling with a BAQ import. We are switching part # from Part A to Part B. Where Part B is exactly the same, but is a new part # structure. The only thing that is changing is the part number. I need to move all the inventory from part A to part B.
My issue is when I remove the inventory from part A and put the inventory on part B, the FIFO sequences change from what they were originally on A and I have yet to figure out how to “control” or guide that so I end up with the same FIFO sequences to be able to successfully import FIFO layers against part B.
I also have to take into account bin location and where these parts are going at import and align the FIFO layers. Or at least I think I do.
I maybe overthinking this (likely am). What am I missing? Is there an “easy” way to accomplish this?
What do you mean by BAQ Import? Is this an updateable BAQ?
I don’t know if DMT may be better or not.
When you adjust in a quantity, Epicor creates the FIFO layer for you. But, you CAN set the transaction date… and hopefully create the correct sequences one-by-one.
If this is true, you’d need to adjust them in one layer at a time… and in the order you want them.
So, if you have Part ABC FIFO layers of
1/1/2024, Seq 1 = Qty 5
1/1/2024, Seq 2 = Qty 7
1/1/2024, Seq 3 = Qty 2
And you want to change that to PART XYZ… you would need to set your TranDate to 1/1/2024…
Then import Qty 5… that will create Seq 1.
Then import Qty 7… that will create Seq 2.
Then import Qty 2… that will create Seq 3.
That would be my approach.
I would test this by doing it manually in your test environment. If you can manually do it, then you should be able to do it via DMT, and I would assume Updateable BAQ… but if you’re paste-inserting, hopefully it pastes them in in the correct sequence.
Also, I should ask about your post title… “FIFO cost record is not available”.
Again, this is similar to the other post you mentioned. When making adjustments on FIFO parts… you have to do a Qty Adjustment FIRST… this creates the FIFO Layer. Then you can do the Cost Adjustment against it.
I’m not sure if your updateable BAQ (if that’s what you’re attempting) is trying to update cost as well? I’m assuming the UBAQ would need to call one BO to create the Layer and then another to adjust the cost… but again, I’ve never attempted this with an UBAQ.
Sorry - not updateable BAQ. What I meant to say was DMT, but my details are coming from a BAQ which I’m importing through the DMT process.
How would you approach the bin location issue? Or is it as simple as DMTing them all into one location (w/ correct FIFO layers) and then adjusting locations accordingly afterwards (some of these parts are in 3 locations).
In cases where you MAY have one FIFO layer/sequence spread over multiple bins… then, yeah, I would try the approach of importing the entire FIFO sequence qty into one bin, and then manually transferring.
Otherwise, it will probably create a new sequence for each row in your DMT.
That piece I understand…but since I was trying to get FIFO layer sequences in that happens at import of the quantity. Where I also have to enter in a BIN #. I have yet to figure out a way to pull out FIFO layers/seq’s where bin information is associated.