Create import job selecting the Table Name PO_ReceiptHeader

The following fields are required for the import job:

• H.BatchNo
  • If Receipt Entry Batch Processing is enabled in Purchase Order Options
  • For Next Batch Number, set Operation to Assign and leave Default value blank
• H.ReceiptType
  • Assign I for Receipt of Invoice
  • Assign G for Receipt of Goods
• H.ReceiptNo
  • For Next Receipt number, set operation to NEXT
• H.PurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
• H.APDivisionNo
  • Assign to 00 if Accounts Payable Divisions is not enabled in AP Options
• H.VendorNo
• L.ItemCode
• L.OrderLineKey
  • This field is required if Receipt is to be applied to Purchase Order
  • This is the Line key of the original PO
  • A new line will be created on the original PO if the wrong value is used
• L.AppliedPurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
  • This field is only available on version 2020 and higher
• L.QuantityReceived
• Note: Additional fields may be added, but the fields that are listed the minimum to create an import job
• L.OriginalQtyOrdered & L.BalanceQtyBackordered will also be needed if importing additional items not on applied Purchase Order

Create import job selecting the Table Name PO_ReceiptHeader

The following fields are required for the import job:

• H.BatchNo
  • If Receipt Entry Batch Processing is enabled in Purchase Order Options
  • For Next Batch Number, set Operation to Assign and leave Default value blank
• H.ReceiptType
  • Assign I for Receipt of Invoice
  • Assign G for Receipt of Goods
• H.ReceiptNo
  • For Next Receipt number, set operation to NEXT
• H.PurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
• H.APDivisionNo
  • Assign to 00 if Accounts Payable Divisions is not enabled in AP Options
• H.VendorNo
• L.ItemCode
• L.OrderLineKey
  • This field is required if Receipt is to be applied to Purchase Order
  • This is the Line key of the original PO
  • A new line will be created on the original PO if the wrong value is used
• L.AppliedPurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
  • This field is only available on version 2020 and higher
• L.QuantityReceived
• Note: Additional fields may be added, but the fields that are listed the minimum to create an import job
• L.OriginalQtyOrdered & L.BalanceQtyBackordered will also be needed if importing additional items not on applied Purchase Order

Create import job selecting the Table Name PO_ReceiptHeader

The following fields are required for the import job:

• H.BatchNo
  • If Receipt Entry Batch Processing is enabled in Purchase Order Options
  • For Next Batch Number, set Operation to Assign and leave Default value blank
• H.ReceiptType
  • Assign I for Receipt of Invoice
  • Assign G for Receipt of Goods
• H.ReceiptNo
  • For Next Receipt number, set operation to NEXT
• H.PurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
• H.APDivisionNo
  • Assign to 00 if Accounts Payable Divisions is not enabled in AP Options
• H.VendorNo
• L.ItemCode
• L.OrderLineKey
  • This field is required if Receipt is to be applied to Purchase Order
  • This is the Line key of the original PO
  • A new line will be created on the original PO if the wrong value is used
• L.AppliedPurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
  • This field is only available on version 2020 and higher
• L.QuantityReceived
• Note: Additional fields may be added, but the fields that are listed the minimum to create an import job
• L.OriginalQtyOrdered & L.BalanceQtyBackordered will also be needed if importing additional items not on applied Purchase Order

Create import job selecting the Table Name PO_ReceiptHeader

The following fields are required for the import job:

• H.BatchNo
  • If Receipt Entry Batch Processing is enabled in Purchase Order Options
  • For Next Batch Number, set Operation to Assign and leave Default value blank
• H.ReceiptType
  • Assign I for Receipt of Invoice
  • Assign G for Receipt of Goods
• H.ReceiptNo
  • For Next Receipt number, set operation to NEXT
• H.PurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
• H.APDivisionNo
  • Assign to 00 if Accounts Payable Divisions is not enabled in AP Options
• H.VendorNo
• L.ItemCode
• L.OrderLineKey
  • This field is required if Receipt is to be applied to Purchase Order
  • This is the Line key of the original PO
  • A new line will be created on the original PO if the wrong value is used
• L.AppliedPurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
  • This field is only available on version 2020 and higher
• L.QuantityReceived
• Note: Additional fields may be added, but the fields that are listed the minimum to create an import job
• L.OriginalQtyOrdered & L.BalanceQtyBackordered will also be needed if importing additional items not on applied Purchase Order

Create import job selecting the Table Name PO_ReceiptHeader

The following fields are required for the import job:

• H.BatchNo
  • If Receipt Entry Batch Processing is enabled in Purchase Order Options
  • For Next Batch Number, set Operation to Assign and leave Default value blank
• H.ReceiptType
  • Assign I for Receipt of Invoice
  • Assign G for Receipt of Goods
• H.ReceiptNo
  • For Next Receipt number, set operation to NEXT
• H.PurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
• H.APDivisionNo
  • Assign to 00 if Accounts Payable Divisions is not enabled in AP Options
• H.VendorNo
• L.ItemCode
• L.OrderLineKey
  • This field is required if Receipt is to be applied to Purchase Order
  • This is the Line key of the original PO
  • A new line will be created on the original PO if the wrong value is used
• L.AppliedPurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
  • This field is only available on version 2020 and higher
• L.QuantityReceived
• Note: Additional fields may be added, but the fields that are listed the minimum to create an import job
• L.OriginalQtyOrdered & L.BalanceQtyBackordered will also be needed if importing additional items not on applied Purchase Order

Create import job selecting the Table Name PO_ReceiptHeader

The following fields are required for the import job:

• H.BatchNo
  • If Receipt Entry Batch Processing is enabled in Purchase Order Options
  • For Next Batch Number, set Operation to Assign and leave Default value blank
• H.ReceiptType
  • Assign I for Receipt of Invoice
  • Assign G for Receipt of Goods
• H.ReceiptNo
  • For Next Receipt number, set operation to NEXT
• H.PurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
• H.APDivisionNo
  • Assign to 00 if Accounts Payable Divisions is not enabled in AP Options
• H.VendorNo
• L.ItemCode
• L.OrderLineKey
  • This field is required if Receipt is to be applied to Purchase Order
  • This is the Line key of the original PO
  • A new line will be created on the original PO if the wrong value is used
• L.AppliedPurchaseOrderNo
  • This field is required if Receipt is to be applied to Purchase Order
  • This field is only available on version 2020 and higher
• L.QuantityReceived
• Note: Additional fields may be added, but the fields that are listed the minimum to create an import job
• L.OriginalQtyOrdered & L.BalanceQtyBackordered will also be needed if importing additional items not on applied Purchase Order