Skip to Content
author's profile photo Former Member
Former Member

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 06:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 05:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 05:41 AM

    Lisa,

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

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 09:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.