Feature Request - Report to show both Batch Field and Received Date

Chris
  • Edited

We would like a report in Cin7, that can show us our inventory stock, with the "received date" along with the “batch” field. The product availbility view does not have the “received date” (if it did it would be great), nor any other report as far as we are aware (have asked support).

Reasoning

  • We need to compare our batch data, to the received date, to verify the received dates align correctly (ticket 197413)
  • Sometimes we find that our receive date for our oldest stock is wrong (it has a newer date), than newer stock which may have an older received date, which usually is caused from a sequence of events that involve the original PO/setup of Cin7 combined with stock adjustments/returns thereafter.
  • It becomes an issue when the setting Recommend batch/serial no. for FIFO/FEFO = “Recommend and enforce” 

Summary

Cin7 prioritizes the Received Date rather than the batch label for FIFO/FEFO logic, which can lead to confusion if those received dates don’t align with your batch format; especially with legacy stock adjustments, returns, or original PO imports like in your PO-00001 case.

 

Edit

  • Found that Products > Export > Stock on Hand has the info needed and should suffice
  • Think that perhaps this could also be in the Reports too

Related to

1

Comments

0 comments

Please sign in to leave a comment.