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 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 fields 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



    • Related Articles

    • AP0100 Accounts Payable Vendor File Maintenance

      Maintenance Vendor File Maintenance Application Overview The Vendor File is used to store information on all companies and individuals from whom materials, supplies, and services are purchased. This application allows entry of information into this ...

    • Can I Edit the Ship Date Field in PO Line Item Screen?

      Q - I noticed that there is a "Ship Date" field in the Purchase Order Line Item screen. It is not editable right now. What settings are necessary to gain access to the Ship Date field? See sample screen below. A - Before answering this question, we ...

    • Feature - Multi-Currency Amount Display Support in Purchase Order

      Release Date: 4/14/25 Version: 8.5 and above This feature allows the purchase order application to show the line item cost in the vendor’s currency using currency conversion rates. This applies to the purchase order line item screen, several reports, ...

    • Canceled PO Line Items Still Exporting on EDI

      Released Date: 11/7/2022 Version: 8.5 & Up Q - We’ve seen this happen twice in the last month. We create a purchase order, then cancel line items on it. When we export the EDI document again, it still contains the cancelled line items on it, which we ...

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

      Release date: 10/18/2021 Updated: 4/16/2025 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 ...