Purchase Order (Summary) Import

 

Summary purchase orders may be imported.  This will not record details like what was bought at what quantity for what price with what tax code(s), but merely the commitment amount(s) recorded and the general ledger account(s) to which such commitments were applied.  

 

Field Name

Size

Mandatory

Comments

Number

12

Y

The purchase order number being imported - must not already exist in K212 Finance

Freight On Board

50

 

The FOB for the order - reference purposes only

End Use Instructions

50

 

End Use instructions if applicable - reference only

Special Instructions

50

 

Special Instructions if applicable - reference only

Shipping Instructions

50

 

Shipping Instructions if applicable - reference only

Payment Terms

10

Y

Number of days to pay when invoice is received

Discount Rate

10

Y

% Discount allowed if payment is made within the Payment Terms

Approved By

100

 

PO approver if applicable - reference only

Delivery Date

8

Y

Date by which the order is to be received - reference only

Order Date

8

Y

Purchase order date - reference only

Tender Number on Purchase Order

20

 

Tender number associated with the order - reference only

Buyer Code

100

 

The buyer code associated with the order - reference only

Is Closed ?

1

 

A 'Y' in this column will signify that the purchase order is closed

Is Printed ?

1

 

A 'Y' in this column will signify that the purchase order is printed

Ship To Location Code

10

Y

The location code to which this order belongs

Vendor Number

10

Y

The vendor number to which this order was made

Original Commitment

10

Y

The amount committed for the general ledger account specified below. 

G/L Account Number

25

Y

The general ledger account impacted by the commitment amount above.

Tax Code

1

Y

The tax code associated with this commitment