Skip to Content
Former Member
Sep 23, 2008 at 05:14 AM

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?