GP Caculation for previous invoices

[Former Member]

"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?

[Former Member · Accepted solution]

Thanks Gordon and Suda,

Appears that

1. 'Base Price Origin' is NOT changed in the Sales Analysis report

2. 'Caculated % gross profit as' IS changable in the Sales Analysis.

Can you please confirm that this is the case

[former_member583013 · Accepted solution]

Lisa,

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

Suda

[Former Member]

Your GL should be correct - it always posts to COGS based on the item cost, regardless of the GP base.

If you don't have a huge number of incorrect invoices, you can copy each one to a credit memo and then recreate the invoice with the correct GP base. But if you have a lot of them, there's not much you can do.

Marcia

[former_member583013]

Lisa,

G/L Transaction once posted can be changed and thats why you might be able to change the GP Base price

Suda

[Former Member]

Hi Lisa,

I am afraid that is not easy job because the history is history, you can not change the fact. Unless you commit to try manually recreating all wrong documents in the previous preriods, there are little you can do to change them. Although you can repost JE directly, you might lose transparency and consistancy in dealing with history.

Thanks,

Gordon