Invoice item field for cost price rather than last cost price (stock field)
Posted: 21 Oct 2022, 14:15
Hi,
Is there such a field. E.g. cost price equivalent of these sales price fields.
INVOICE_ITEM.FOREIGN_UNIT_PRICE
INVOICE_ITEM.FOREIGN_NET_AMOUNT
So that I can run historical Inv profit reports and profit is correct,as its referencing the inv cost price at the time of inv (as does for fields above rather than STOCK.SALES_PRICE). Rather than current Last Cost price for stock items.
Reference what we have spoke about before (we dont have stock switched on/your recommendation of notional spare stock field for cost price)....
...I know that would work in relation to below topic we spoke about but dont think it would for historical inv item report?...as notional field still in STOCK table and not Inv Item table?...stumped tbh.
viewtopic.php?t=4236
I wish to run a excel Query for Inv profit reports but Im guessing it would recalc cost price and therefore all inv profit (upon refresh) based on current Last Cost price from stock field? Undoing historical invs which (should be loosely accurate as im currently exporting this as sage report into excel on a weekly basis). Everything else on this manual report I know I could do as a query.
Not got a clue how to get around this
Many Thanks
Gareth
Is there such a field. E.g. cost price equivalent of these sales price fields.
INVOICE_ITEM.FOREIGN_UNIT_PRICE
INVOICE_ITEM.FOREIGN_NET_AMOUNT
So that I can run historical Inv profit reports and profit is correct,as its referencing the inv cost price at the time of inv (as does for fields above rather than STOCK.SALES_PRICE). Rather than current Last Cost price for stock items.
Reference what we have spoke about before (we dont have stock switched on/your recommendation of notional spare stock field for cost price)....
...I know that would work in relation to below topic we spoke about but dont think it would for historical inv item report?...as notional field still in STOCK table and not Inv Item table?...stumped tbh.
viewtopic.php?t=4236
I wish to run a excel Query for Inv profit reports but Im guessing it would recalc cost price and therefore all inv profit (upon refresh) based on current Last Cost price from stock field? Undoing historical invs which (should be loosely accurate as im currently exporting this as sage report into excel on a weekly basis). Everything else on this manual report I know I could do as a query.
Not got a clue how to get around this
Many Thanks
Gareth