× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.