Feature - Purchase Order Line Item Discount

Feature - Purchase Order Line Item Discount

Release Date: 4/14/25

Version: 8.5 and Above

This feature adds a second option for handling purchase order line item discounts. The feature is controlled by the Global Setup, PO Global Control, field "43. Enter PO Line Item Original Price & Disc%.”

 

Enter PO Line Item Original Price & Disc%. This Global Setup option support three choices – N=No, Y=Yes(MfgPrc – Disc%=FOB), and D=(DispListPrce=FOB/(1-Disc%/100)). Default is N.

  1. If set to N, no discount is entered.
  2. If set to Y, the application will function as documented in the knowledge base article: https://support.netcellent.com/portal/en/kb/articles/feature-add-original-price-and-discount-pct-to-po-line-items.
  3. If set to D, the purchase order line item screen will show a list price which represents the vendor's list price. Using this option does not cause the expected cost on the purchase order to be recalculated.

Vendor File Maintenance

Vendor File Maintenance now allows the entry of a default discount percent if field "43. Enter PO Line Item Original Price & Disc%” is set to Y or D.





















21. Default Disc Pct – The default is zero. A value can be entered in this field if Global Setup PO Global Control, field 43. Enter PO Line Item Original Price & Disc% is set to “Y” or “D.” This value will be used as the default value for the discount percentage on the purchase order line item screen when adding a new line item. If Global Setup PO Global Control, field 43. Enter PO Line Item Original Price & Disc% is not set to “Y” and not set to “D,” then the value entered in this field must be zero.



Purchase Order Processing

If Global Setup PO Global Control field 43 is set to D, field 9. Line Disc% is available on the purchase order line item screen. 

 

9. Line Disc% - Entering the line discount percentage will cause the List Price field that is displayed on the purchase order line item screen to be recalculated. Entering this amount does not cause the FOB cost to be recalculated.

Choosing the option to display and search the list of line items also shows the discount percentage for each line item.


Purchase Order Change CSV Import

Purchase Order & Receiving-> Processing-> Purchase Order Processing-> Change CSV Import now supports the import of the discount percent if Global Setup, PO Global Control, field 43. Enter PO Line Item Original Price & Disc% is set to D. The discount percent is supported in column V of the CSV import file.

Import of the CSV file will update the line discount percent that is stored on the purchase order line item record. This will mark the line item as changed and the purchase order will need to be reprinted.



New PO Scheduled Receipts Report 

The discount percentage is exported to CSV when printing the New PO Scheduled Receipts report and choosing “C=Detail+Cost” print format.

Receiving Audit Trail Report

Legacy PO Receiving Posting and Warehouse Receiving Posting both update the Receiving Audit Trail File with the discount percentage entered on the purchase order line item record at time of posting. The discount percentage is exported to CSV when printing the Receiving Audit Trail Report.

Receiving Audit Trail Summary Report

The discount percentage is exported to CSV when printing the Summary version of the Receiving Audit Trail Report.

Purchase Order Export

Purchase Order Export supports the export of the exchange rate from the purchase order line item file. 

Programs Modified: NSCTLMN3.CBL, APVENFIL.FD, POORDLIN.FD, POAUDWRK.FD, POORDASC.FD, PORECAUD.FD, POCRDLIN.PL, AP0101.CBL, PO0101.CBL, PO0111.CBL, PO01P1.CBL, PO04P1N.CBL, PO05P1.CBL, PO05P3.CBL, PO2002.CBL, POCHGIMP.CBL, POEXPPO.CBL, POINVLMN.CBL, POORDEXP.CBL, POREQPOP.CBL, POWHRLST.CBL, POWHRPST.CBL

CLS