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

• Related Articles

• 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 ...

• Feature - Support for Discount Amount and Reference in Cash Receipts Detail Interface

  Date Released: 2/15/22 Updated: 3/29/22 Version: 8.5 and Above In this enhancement, we improve A/R cash receipt detail CSV file interface in the following ways: Discount Amount and Reference columns are now supported. We now allow negative amounts ...

• Feature - Enter Due Days and Discount Days in Buyers Desk

  Release Date: 7/18/24 Version: 8.5 and Above Previously, Buyers Desk users could only enter the terms description and discount percent for the purchase order they are reviewing. This feature also allows the entry of the due days and the discount ...

• Feature - Buyer Desk Negative Target, Adjustment Pct, CSV Support

  Release Date: 8/9/21 Version: 8.5 and Above Buyer Desk will now allow the user to consider the situation where sales have slowed and the buyer should review the data to determine if they they should consider canceling existing purchase orders. In the ...

• Feature - Add Original Price and Discount Pct to PO Line Items

  Release date: 10/18/2021 Version: 8.5 and Above This new feature involves the addition of Original Price and Discount fields to the PO Line Item file. The concept of this change is that the default cost for a PO line item will be copied to the new ...