Skip to content

Feature - Negative Discount Percent Support

Release Date 9/14/17 
This feature allows the customer to establish an invoice price that is a markup above the normal selling price. To handle this scenario, the system will allow the entry of a negative discount percent at the customer maintenance screen, the order header entry screen and the order line item entry screen. The system will calculate this as markup instead of discount.

There are various flags that may stop using the discount percent, including: 

Item File Maintenance-> Field 69. Do Discounts Apply – default is “N” which means if item is on sales, do not apply discount percent.



Price Code File Maintenance-> Field 1. Ignore Cust Disc – default is “Y,” but the flag may be set to “N” which means the customer is already given a very good price with the price code’s price and no other discounts should apply.



Order Line Item Global Setup flag “14. Is Unit Price Before Discount Percent?” also affects the calculation. The default is “Y.” However, if it is set to “N,” the customer/order discount does not carry to the line item discount. Instead, it is applied to the unit price and the line item discount percent is set to zero.




Note: The negative discount percent will be applied even if the item is on sale. But for regular discounts, the setting described above will still apply to sale items.

Customer File Maintenance


Field 28 now allows the entry of a negative discount percent.

Order Entry


Field 23 on the order header screen now allows the entry of a negative discount percent. This field defaults to the discount percent that is defined in the customer file.



Field 5 on the order line item screen now allows the entry of a negative discount percent. The default for this field depends upon the setup values that are described above.  If Order Line Item Global Setup flag “14. Is Unit Price Before Discount Percent?”  is set to "Y," the discount percent will default to the discount percent entered on the order header screen. 



If Order Line Item Global Setup flag “14. Is Unit Price Before Discount Percent?”  is set to "N," the markup will be added to the line item unit price and the line item discount percent will be set to zero.
  

Invoice Form Maintenance - Screen 7-> Field 42



The line item discount amount now supports the printing of a negative discount percent. To implement this change, bring up the form in Invoice Form Setup, go to screen 7 and bring up field 42. Enter through the fields. This should change the mask to 999.99- and the length should change to 7. Save the form.

If the line item discount percent is negative, the percent will not print correctly on the invoice form.



Other applications

Support for the negative discount percent has been added to Sales Desk, Sales Order Import, Sales Order Export, Fill Back Orders, Recurring Orders, Add On Items, all of the edit lists, Order Inquiry, as well as web services.

Programs Changed: CPORDHDR.FD, CPORDLIN.FD, CPHODHDR.FD, CPHODLIN.FD, CPINVHDR.FD CPINVLIN.FD, CPRECHDR.FD CPRECLIN.FD, CPSLSQUO.FD, CPQUOITM.FD CPCONHDR.FD, CPINVHDO.FD, CPINVLIO.FD, CPORDHW.FD, CPORDCLW.FD, CPSTSHWK.FD, ARCUSFIL.FD, GUCUSFIL.FD, ARWRKIDX.FD, LINESCR.WS, CP01LINK.WS, GETPRICE.WS, ARCUSMNT, CP0101, CP0111, CPGETCOM, GETPRICE.PL, GETRELPC.PL, GETPRICE.PL2, GETPRREC.PL, CPRECGRO.WS. CPRECGRO.PL, CPINVPRT.WS, CPMASBIL.WS, CPORDPRT.WS,CPSQUPRT.WS, POCLSHDR.WS, SDLAYOUT.WS, SERRANGE,WS,WRKTBL.WS, ARCUSFIL.WSF, ARCUSFIL.WST, CPORDHDR.WSF, CPORDLIN.WSF, CPRECHDR,WSF, CPORDHDR.FDS, QUOTLINK.WS, CPEXTDAT.WS, CPLINEDT.WS, POASCII.FD, POASCII.WS, CPQUOTE.WS, CPQUOTE2.WS, CPRECLNK.WS, CPRECHDR, CPRECLIN, CPRECELR, CPRECGOP, CPRECPIP, CPSELLIN, CP1724P, CP0101CI, CP01P2, CP01P3, CP02P2, CP0304E, CP0305, CP0400, CP0403, CP0403A, CP0404, CPBOLMNT, CPORDINQ, CPSABPRC, CPSABPST, CPSELIMV, CPSHPVER, IMATPRP3, IMATPRPT, CP0112, CP0114, CPBATVEB, CPBATVER, CPFBCUSD, CPLINTST, CPRECBIL, CPFRMMNT, ARCUSMOT, IMATPLST, IMTSFVER, IMTSFVEB, ORDLINSN, CP0101CS, ARNUMCUS, CP01P1, CP0111S, CP0115BM, CP09P3, CP09P31, CPCUSWLS, CPCWLCHK, CPFNCBYI, CPLINEDT, CPSLSDSK, CPTAKIMP, IM0500, IM0500Q, QUOTEGEN, CPQUOGEN, CPORDIMP, CP0102, CP0110, CP0303, CP0307, CPAUTBIL, IMAONWIN
Copybooks Added: GETRELPC.PL2, GETRELPC.WS2
CLS




Feedback and Knowledge Base