|
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
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.
midrange.com
