|
midrange.com
I think the closest you can get to calculating at the invoice level is the
whole order discount ( I haven't checked to see what variances might occur
if the order is partial shipped, ie multiple invoices for the same order)
but regardless of whether the discount is based on the line value, quantity
or whole order discount, the only way System 21 calculates prices/discounts
is by taking the price times the quantity, times the discount. It uses 5
decimal places and rounds up or down as the final step. It will not apply
the discount to the single unit price, round, and then multiply by
quantity.
Amy Harris
The ROHO Group
amyh@xxxxxxxxxxxxxxxx
1-800-851-3449, ext. 2013
1-618-277-0514
Gary Shipp
<g.shipp@xxxxxxxx
et> To
Sent by: System 21 Users
system21-bounces@ <system21@xxxxxxxxxxxx>
midrange.com cc
Subject
06/11/2004 05:45 Re: Re: [SYSTEM21] discount
AM calculation
Please respond to
System 21 Users
<system21@midrang
e.com>
This is a combination of a rounding/decimal place issue and using different
techniques to calculate the discount.
Assume a line discount rate of 15% and a line with quantity 3, unit price
of £1.10 and gross line value of £3.30.
If you calculate the discount based on the line value and round down (as
System 21 does), you get a discount value of £0.49.
If you calculate the discount based on the unit price, round up (as a
customer is likely to) and multiply the result by the quantity, you get a
discount value of £0.51.
Perhaps another way of looking at the problem is the customer wants to
calculate discount based on the invoice gross value, rather than by the
individual lines.
This is demonstrated with an invoice on our system, for which the sum of
the line discounts is £56.02, whereas the sum of the discounts calculated
accurately (4dp) from the unit price is £56.06.
Just a thought but can discounts be calculated at invoice level within
System 21?
========================================
Message date : Jun 10 2004, 07:52 PM
>From : amyh@xxxxxxxxxxxxxxxx
To : "System 21 Users"
Copy to :
Subject : Re: [SYSTEM21] discount calculation
Gary,
I'm unclear what you mean by line price versus line value. The lines goods
value field is the unit price (with discounts applied, if any) times the
quantity.
You can have discounts based on line value, line quantity, or whole order.
Can you give an example of what is happening now vs what your customer
expects?
Amy Harris
The ROHO Group
amyh@xxxxxxxxxxxxxxxx
1-800-851-3449, ext. 2013
1-618-277-0514
Gary Shipp
et> To
Sent by: system21
system21-bounces@ cc
midrange.com
Subject
[SYSTEM21] discount calculation
06/10/2004 04:37
AM
Please respond to
System 21 Users
e.com>
Don't use the forum for a couple of months then need to post twice in one
morning!
We have a customer complaining because they are not receiving the discount
on sales invoices that they expect.
When I look at the data, I notice that the discount being allocated to each
line is based on the line value, wheras the discounts he seems to be
expecting the discount appear to be based on the original unit price. The
resultant rounding differences explain the missing pennies he's chasing.
Is there any way to structure the discount to be based on the line price
rather than value?
TIA
--
Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/
This email has been checked for most known viruses - find out more at:
http://www.wanadoo.co.uk/help/id/7098.htm
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
This transmission contains information and/or documents from The ROHO
Group Inc. The information contained therein is confidential and/or
legally privileged and the property of The ROHO Group. The
information and/or documents are intended only for the use of the
individual or entity named on this transmission sheet. If you are not
the intended recipient, any disclosure, copying, distribution or the
taking of any action in reliance on the contents of this transmitted
information and/or documents is prohibited. Any accompanying
documents should be returned to The ROHO Group immediately. If you
have received this transmission in error, please notify us by
telephone immediately so that we can arrange for the return of the
documents to us at no cost to you.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
--
Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/
This email has been checked for most known viruses - find out more at:
http://www.wanadoo.co.uk/help/id/7098.htm
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
This transmission contains information and/or documents from The ROHO
Group Inc. The information contained therein is confidential and/or
legally privileged and the property of The ROHO Group. The
information and/or documents are intended only for the use of the
individual or entity named on this transmission sheet. If you are not
the intended recipient, any disclosure, copying, distribution or the
taking of any action in reliance on the contents of this transmitted
information and/or documents is prohibited. Any accompanying
documents should be returned to The ROHO Group immediately. If you
have received this transmission in error, please notify us by
telephone immediately so that we can arrange for the return of the
documents to us at no cost to you.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
