Prior Frozen Qty

[chrism2278]

Is there anywhere in the system that holds the prior freeze qty & date?

Trying to come up with a crystal report that has begin frozen qty, detail, and end frozen qty.

Thnks

 

[kscheeler]

The only way I've done this is to do the freeze inventory with my own stored procedure and copy the frozen qty, cost and date into my own table before refreezing the inventory in the standard fields.

I did it that way because it was faster than the internal process but you could do it more simply by just copying out the frozen qty, cost and date into your own table whether it was an Access table or SQL before running the standard freeze inventory process.


Kevin Scheeler