Purchase Order Change Import Format

Purchase Order Number

Purchase Order Line Number (leave blank for fields that affect the entire order instead of a specific line item)

Field to change (specify either the name or the number)

New Data

NJ000000049

Originator

Apprise

NJ000000049

1

21000

03:03PM

10300

Supplier-order-number

12

Character

Enter a supplier’s confirming order number.

Supplier's Confirming Order # field on the Main tab in Purchase Order Maintenance

10400

Originator

60

Character

Enter a valid user ID of the person from which the purchase order originated.

Originator field on the Main tab in Purchase Order Maintenance

10500

Requisition-number

12

Character

Enter a requisition number for the purchase order.

Requisition # field on the Main tab in Purchase Order Maintenance

10600

FOB

12

Character

Enter a valid FOB. For information on setting up FOB's, see Freight On Board Maintenance.

FOB field on the Main tab in Purchase Order Maintenance

10700

Ship-via

12

Character

Enter a valid shipper ID of the carrier that will deliver the ordered products to the ship-to location. For information on setting up shipper ID's, see Shipper Maintenance.

Note If you change the shipper entered in this field, it changes the shipper for all line items on the purchase order.

Shipper ID field on the Main tab in Purchase Order Maintenance

10800

Buyer

60

Character

Enter a valid user ID for the purchase order's buyer.

Buyer field on the Main tab in Purchase Order Maintenance

10900

Purchase-date

10

99/99/9999

Enter the date the purchase order is created.

Purchase Date field on the Main tab in Purchase Order Maintenance

11000

Delivery-date

10

99/99/9999

Enter the date products are to be delivered to the ship-to location. This date is used to calculate a promise date during order entry, and to determine the delivery date for DRP. This date is used as the default delivery date for line items entered on the purchase order.

If you change this date, all line items that have the same delivery date are also changed.

Delivery Date field on the Main tab in Purchase Order Maintenance

11100

Delivery-time

7

Character

Enter the time of day that products are to be delivered to the ship-to location. Use the following format: HH:MM, followed by AM or PM.

Example 03:03PM

Delivery Time field on the Main tab in Purchase Order Maintenance

11200

Ship-date

10

99/99/9999

Enter the date the products will ship from the supplier.

Ship Date field on the Main tab in Purchase Order Maintenance

11300

Required-date

10

99/99/9999

Enter the date by which you want to receive products in the ship-to location. If you need to inquire on a purchase order status based on the required date, you can mark the order as expedited, and then use Purchase Expedite Inquiry to view order status based on this date.

Required Date field on the Main tab in Purchase Order Maintenance

11400

Final-change-date

10

99/99/9999

Enter the date of the last change that can be made to this purchase order. You should not change an order after this date, unless you change this date. A warning message appears when you change a purchase order after this date if the Warn If the Final Change Date Is Prior to Updated Date check box in Purchasing Control Maintenance is selected.

This date is also used for DRP. If you are using DRP, there is functionality that can assist in determining if there will be excess inventory during a specific time period, e.g. the month of October. For example, circumstances may have changed: orders cancelled, forecasts changed, etc. If there is excess inventory in a specific time period, the software can then, as part of its DRP algorithms and logic, determine if there are purchase orders that can be changed; perhaps production or shipment/delivery dates can be pushed out. It will exclude purchase orders if the final change date has passed. This could indicate that production is already done, the order is already on a container being shipped, etc. If this is the case, the software will not alert a user to review the purchase order and change it.

Final Change Date field on the Main tab in Purchase Order Maintenance

11500

Rush

5

Logical

Enter YES, Y, TRUE, or T if you want to indicate the purchase order is a rush order, and if you want to be able to inquire about the order in Purchase Expedite Inquiry. Users can print custom messages on a purchase order that is a rush order.

Enter NO, N, FALSE, or F if you want to indicate the purchase order is not a rush order.

Rush check box on the Main tab in Purchase Order Maintenance

11600

Expedited

5

Logical

Enter YES, Y, TRUE, or T if you want to indicate the purchase order is an expedited order, and if you want to be able to inquire about the order in Purchase Expedite Inquiry.

Enter NO, N, FALSE, or F if you want to indicate the purchase order is not an expedited order.

Expedite check box on the Main tab in Purchase Order Maintenance

11700

Payment-terms

12

Character

Enter valid payment terms for the purchase order. You can only update the payment terms for a purchase order if the purchase order status is Open, Ordered, or Approved.

Payment Terms field on the Main tab in Purchase Order Maintenance

11800

Payment-method

17

Character

Enter a valid payment method that will be used to pay the supplier of the purchase order. You can only update the payment method for a purchase order if the purchase order status is Open, Ordered, or Approved.

Payment Method field on the Main tab in Purchase Order Maintenance

11900

Purchase Order User Defined 1

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

first purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12000

Purchase Order User Defined 2

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

second purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12100

Purchase Order User Defined 3

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

third purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12200

Purchase Order User Defined 4

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fourth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12300

Purchase Order User Defined 5

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fifth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12400

Purchase Order User Defined 6

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

sixth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12500

Purchase Order User Defined 7

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

seventh purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12600

Purchase Order User Defined 8

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

eighth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12700

Purchase Order User Defined 9

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

ninth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12800

Purchase Order User Defined 10

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

tenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

12900

Purchase Order User Defined 11

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

eleventh purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13000

Purchase Order User Defined 12

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

twelfth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13100

Purchase Order User Defined 13

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

thirteenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13200

Purchase Order User Defined 14

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fourteenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13300

Purchase Order User Defined 15

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fifteenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13400

Purchase Order User Defined 16

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

sixteenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13500

Purchase Order User Defined 17

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

seventeenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13600

Purchase Order User Defined 18

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

eighteenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13700

Purchase Order User Defined 19

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

nineteenth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13800

Purchase Order User Defined 20

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the purchase order. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

twentieth purchase order user-defined field on the Other Information tab in Purchase Order Maintenance

13900

use-fixed-curr-conv-rate

3

Yes/No

Enter Yes if you want to specify an override exchange rate for the purchase order.

Use Override Exchange Rate check box on the Main tab in Purchase Order Maintenance

14000

override-curr-conv-rate

14

>>>>9.99<<<<<<

Enter the exchange rate for the purchase order.

Override Currency Exchange Rate field on the Main tab in Purchase Order Maintenance

14100

Sales Contract Code

20

Character

Enter a sales contract code associated with the purchase order. For information on setting up sales contracts, see Sales Contract Maintenance.

Sales Contract Code field on the Main tab in Purchase Order Maintenance

Line Item Fields

20100

Delete-Line

1

Space

Enter a space to indicate the line item should be deleted.

You cannot delete a line item if any of the following are true:

• It is the only line item for the purchase order.

• The line item was already received.

• The line item was already invoiced.

• The line item is associated with a blanket purchase order release quantity.

• The line item is on a shipment.

• The line item is associated with a drop ship or special order sales order.

Delete button on the Main tab in PO Line Item Entry

20200

Qty-ordered

11

>>,>>>,>>9.99

Enter a positive order quantity of the product for the line item.

Note You cannot change the order quantity to a smaller quantity if it causes the following to be true:

• The quantity ordered is less than the quantity already received and on a shipment.

• The quantity ordered is less than the total blanket purchase order release quantity.

• The quantity ordered is less than the quantity required for future receipt reservations associated with the purchase order.

Qty field on the Main tab in PO Line Item Entry

20300

UM

8

Character

Enter a valid and active unit of measure for the order quantity for the line item. You must enter a unit of measure that is a purchasing unit of measure for the product location.

Note You cannot change the line item to a smaller unit of measure if it causes the following to be true:

• The quantity ordered is less than the quantity already received and on a shipment.

• The quantity ordered is less than the total blanket purchase order release quantity.

• The quantity ordered is less than the quantity required for future receipt reservations associated with the purchase order.

Unit U/M field on the Main tab in PO Line Item Entry

20400

Unit-cost

11

>>,>>>,>>9.99

Enter the cost per unit of the product ordered for the line item.

Cost field on the Main tab in PO Line Item Entry

20500

Cost-adjustment

11

>>,>>>,>>9.99

Enter a positive or negative adjustment to the cost of the product for the line item. If this value is negative, it cannot be greater than the unit cost.

Cost Adj field on the Main tab in PO Line Item Entry

20600

Line-fob

12

Character

Enter a valid FOB status of the product for the line item. For information on setting up FOB's, see Freight On Board Maintenance.

FOB field on the Main tab in PO Line Item Entry

20700

Line-ship-via

12

Character

Enter a valid shipper ID of the carrier that will deliver the product for the line item to the ship-to location. For information on setting up shipper ID's, see Shipper Maintenance.

Shipper ID field on the Main tab in PO Line Item Entry

20800

Line-required-date

10

99/99/9999

Enter the date by which you want to receive the product for the line item in the ship-to location.

Required Date field on the Product Information tab in PO Line Item Entry

20900

Line-delivery-date

10

99/99/9999

Enter the date the product for the line item is to be delivered to the ship-to location.

Delivery Date field on the Product Information tab in PO Line Item Entry

21000

Line-delivery-time

7

Character

Enter the time of day that the product for the line item is to be delivered to the ship-to location. Use the following format: HH:MM, followed by AM or PM.

Example 03:03PM

Delivery Time grid column on the Main tab in PO Line Item Entry

21100

Line-Ship-date

10

99/99/9999

Enter the date the product for the line item will ship from the supplier.

Ship Date field on the Product Information tab in PO Line Item Entry

21200

Purchase Order Item User Defined 1

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

first purchase order line item user-defined field in Line Item User Defined Fields

21300

Purchase Order Item User Defined 2

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

second purchase order line item user-defined field in Line Item User Defined Fields

21400

Purchase Order Item User Defined 3

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

third purchase order line item user-defined field in Line Item User Defined Fields

21500

Purchase Order Item User Defined 4

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fourth purchase order line item user-defined field in Line Item User Defined Fields

21600

Purchase Order Item User Defined 5

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fifth purchase order line item user-defined field in Line Item User Defined Fields

21700

Purchase Order Item User Defined 6

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

sixth purchase order line item user-defined field in Line Item User Defined Fields

21800

Purchase Order Item User Defined 7

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

seventh purchase order line item user-defined field in Line Item User Defined Fields

21900

Purchase Order Item User Defined 8

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

eighth purchase order line item user-defined field in Line Item User Defined Fields

22000

Purchase Order Item User Defined 9

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

ninth purchase order line item user-defined field in Line Item User Defined Fields

22100

Purchase Order Item User Defined 10

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

tenth purchase order line item user-defined field in Line Item User Defined Fields

22200

Purchase Order Item User Defined 11

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

eleventh purchase order line item user-defined field in Line Item User Defined Fields

22300

Purchase Order Item User Defined 12

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

twelfth purchase order line item user-defined field in Line Item User Defined Fields

22400

Purchase Order Item User Defined 13

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

thirteenth purchase order line item user-defined field in Line Item User Defined Fields

22500

Purchase Order Item User Defined 14

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fourteenth purchase order line item user-defined field in Line Item User Defined Fields

22600

Purchase Order Item User Defined 15

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

fifteenth purchase order line item user-defined field in Line Item User Defined Fields

22700

Purchase Order Item User Defined 16

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

sixteenth purchase order line item user-defined field in Line Item User Defined Fields

22800

Purchase Order Item User Defined 17

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

seventeenth purchase order line item user-defined field in Line Item User Defined Fields

22900

Purchase Order Item User Defined 18

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

eighteenth purchase order line item user-defined field in Line Item User Defined Fields

23000

Purchase Order Item User Defined 19

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

nineteenth purchase order line item user-defined field in Line Item User Defined Fields

23100

Purchase Order Item User Defined 20

400

Character, Date, Decimal, Integer, or Logical

Enter the appropriate user-defined information for the line item. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

twentieth purchase order line item user-defined field in Line Item User Defined Fields

23200

Item Sales Contract Code

20

Character

Enter a sales contract code associated with each line item. For information on setting up sales contracts, see Sales Contract Maintenance.

Sales Contract Code grid column on the Main tab in PO Line Item Entry

23300

Item Sales Contract Line

4

>>>9

Enter a sales contract line number for each line item that is associated with a sales contract line number.

Sales Contract Line Number grid column on the Main tab in PO Line Item Entry