|
Finally got round to trying this out. Unfortunately, whole order discounts still give the same issue. Just to give an example of the problem I'm getting, I have an item with unit price of 1.39 and a discount of 15%. If I order 1 of this item and apply the discount, on invoicing the discount shows as .21. However, if you calculate 15% of the price, the discount is actually .2085. It is this value, taken to 2dp without rounding i.e. .20 that the customer is expecting to see against the line, not the .21 that System 21 calculates. Any more ideas or suggestions? ======================================== Message date : Jun 11 2004, 04:15 PM >From : "Gary Shipp" To : "System 21 Users" Copy to : Subject : Re: Re: Re: [SYSTEM21] discount calculation Hi Amy, Partial shipments aren't an issue with our operation as they don't apply. We have a look at the order discounts and see if we can apply them. Let you know how we get on ======================================== Message date : Jun 11 2004, 03:01 PM >From : amyh@xxxxxxxxxxxxxxxx To : "System 21 Users" Copy to : Subject : Re: Re: [SYSTEM21] discount calculation 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 et> To Sent by: System 21 Users system21-bounces@ midrange.com cc Subject 06/11/2004 05:45 Re: Re: [SYSTEM21] discount AM calculation Please respond to System 21 Users 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. _______________________________________________ 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. -- 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
