often our COGS invoices (allocated to item cost via expenses TAB in purchases) are received after we invoice our customer. This reflects an incorrect margin forever in DEAR systems unless you go back and UNDO the purchase and sale to reflect the true item cost after all COGS have been entered.
If this could be fixed, it would help enormously as it would reflect a true value of historical landed costs, we can't always remember to go back and UNDO everything to show the true correct landed cost!
Needs a fix please - one where a simple refresh changes the item cost and consequently sales order/invoice margin calculations.
Hi Mohammad, that's the entire point, why should we rely on an UNDO function to show the correct landed cost of the product and consequently the invoice margin??
It needs a fix please.
Hi All, Why you can't use the reports below to see actual profit and margin % (not an estimate as you can see on sales quote/order/invoice) ?
- SALE PROFIT SUMMARY REPORT
- SALES BY PRODUCT SUMMARY REPORT
- PROFIT & LOSS BY PRODUCT REPORT
The sales profit summary, and sales by product report does not match the actual gross profit in the P&L that is exported to Quickbooks though. Outside of custom pricing for different customers this is the biggest issue with DEAR.