OK so the inventory end of day adjustment solution is not suitable.
This point potentially pushes back towards my method.
With some creative automation you might be able to report it a used inventory (unlike my original setup) but if you were able to link in an auto update price to inventory cost price you could separate but taking total inventory usage and removing the ‘waste sales’ value at the updated sale price (actually cost price using automation)
As kendash said there is not a simple solution.
To try and more cleanly explain.
use a POS side automated flow to make a ‘waste ticket’ which puts through transaction at cost price including inventory use then total inventory use minus reported wast transaction value would give actual inventory sold and the date as reported.
Perhaps with a separate ticket type it might help keep accounts more structured.
This still however will not allow for individual ingredient wastage rather than sellable/PLU/product wastage.
For that you would undoubtedly need to create a whole set of profits with direct inventory relation perhaps in a separate menu.
Again not simple…
Perhaps an alternative approach would be to create a waste/theft warehouse you could transfer to rather than EOD record remove it. Then perhaps do a routine warehouse empty for that warehouse?
having never used the sambas inventory system I cannot really make too stronger recommendations of a inventory side solution. Perhaps kendash can comment on this idea?