Adjust the price onscreen; why is a discount forced on the invoice?

SUGGESTED

Hi,

SAGE 50 2020 Quantum. 5 users.

I make and preview an invoice (not posted).

Whoops! The price on the first one should have been $5, not $20. So, I go back to the screen and change the price of the first line to $5 each.

I would expect the preview to show 5 units x $5/unit = 25. However, it shows a Discount. Why is that? The numbers add up but it looks stupid.

The only solution I know of is to delete the entire row. Then re-enter the entire row. What a waste of time.

Parents
  • 0

    If you don't wish to expose and use the Base Price and Discount columns, then just turn them off.  Under Setup, Settings, Receivables, Discount, turn off the Calculate Line Item Discounts....

    The answer to why is that when you use any of those fields, the other fields are calculated.  Because you don't have the Base Price and Discount exposed, you can't see the values so you don't know you should change them until you preview the invoice.

  • 0 in reply to Richard S. Ridings

    Hello,

    This has nothing to do with Base Price and Discount ( I think). I just opened up a 'fake' company. Base Price and Discount are unavailable in the Customize Invoice Area.

    So to recreate the error:

    1) Make quantity 5, and price $50.   $250 before tax. All good in print preview.

    2) Then suppose there is a pricing error, and the clerk was confused. The error was caught before posting. It wasn't $50 a unit. It was $20. I go back and simply change the price.  Discount arises!

    Screenshot of print preview.

    Stupid program design. Again, base price and discount are inaccessible.  The only way to avoid this is to delete the entire line. Retype it.

  • 0 in reply to Mike Ott
    SUGGESTED

    While you are logged in as sysadmin in single-user mode, set up the invoice as you described in #1.

    Then expose the Base Price and Discount columns.

    What is in them?

    Then proceed with the columns exposed and do your step #2.

    What is in the columns now?

    When I did it before I answered you the first time, I still has the $50 price in the Base Price column and a discount showed up because the program does all the back calculations.

Reply
  • 0 in reply to Mike Ott
    SUGGESTED

    While you are logged in as sysadmin in single-user mode, set up the invoice as you described in #1.

    Then expose the Base Price and Discount columns.

    What is in them?

    Then proceed with the columns exposed and do your step #2.

    What is in the columns now?

    When I did it before I answered you the first time, I still has the $50 price in the Base Price column and a discount showed up because the program does all the back calculations.

Children
No Data