Hello all,
I have a client that is trying to validate and analyze their inventory values.
They utilize lot tracking with FIFO costing and have bins enabled.
What I've found is that you can use the bin contents page with the lot visibility personalization. However, we still don't see the details of the costing layers.
I believe we need to create a web service to pull in the lot buffer (7351) and connect that with item ledger and warehouse ledger entries in a PowerBI report or something for them to use. But I'm concerned that still won't be accurate.
Attached is a snip of the bin contents example; but we still need additional cost details.
Has anyone worked through these details previously or have any ideas?
