GP Caculation for previous invoices
"Gross Profit Base Price" was set to "Last Purchase Price" and the Unit Price in the Stock Records was set to "1st Price List" which was incorrect and resulting in the GP of 100% in the sales analysis report.
The "Document Settings>Calculate Gross Profit>Base Price Origin" has now been set to Item Cost (which is taken from Stock record). So for any new Sales Orders/Invoices the "Gross Profit Base Price" will be correctly set now.
But the problem is those records already set - Is there a way to fix the Gross Profit Base Price on previous Sales Orders/Invoices so that they equal the Item Cost and also fix the Gross Profit (and related fields) so that it properly reflects this change as well?
The GP % on the Sales Analysis is actually taken from the document rows so once the transaction is recorded with a certain Base price, it cannot be changed.
So, the Sales Analysis will reflect whats in the document and not the revised Base Price source