Versions Compared

Old Version 2

changes.mady.by.user Brian Dixon

Saved on

compared with

New Version Current

changes.mady.by.user Brian Dixon

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To do operations on existing Equipment lines, you need to provide the Equipment Catalog path. If there are multiple items that have the same Equipment Catalog path, then you will also need to provide the Price or Units.

Fields

PO Number

Required

Datatype is String

There are some keywords for this field that will produce specific behavior.

    • AUTO - This will create a new Purchase Order using the automatic next Purchase Order Number.
    • PREVIOUS - This will update the Purchase Order that was last successfully added or updated by the same import file.

Any other value will be treated as an actual Purchase Order Number. If the Purchase Order Number already exists, then the import will do an update. If the Purchase Order Number does not exist, then either you will get an error, or the value will be used to create a new Purchase Order. The behavior will depend on how the ALLOW_CUSTOM_PO_NUMBER configuration setting is set.

...

Defaults to Pending for new records. New records must be Pending. Pending an can update to Open, and Open can update to Closed.

A Purchase Order can not update to Open if it has no Equipment items.

A Purchase Order a not update to Closed if it has any Pending Equipment items.

Warehouse

Datatype is String

Required for new Purchase Orders.

This value must be an existing Location that has the Warehouse flag set.

...

This optional field can be used to specify the right Warehouse Location if you have multiple Locations with the same name and different Location Types.

Vendor

Datatype is String

Required for new Purchase Orders.

This value must be an existing Vendor.

...

The Attn fields let you specify a Vendor Contact. The value must be an existing Contact that has the Vendor flag Contact Type and is listed as a Contact on the Vendor record.

Vendor Order Number

Datatype is String


Note: The following fields relate to the Purchase Order Equipment grid content

Action

Datatype is String

Required for any operations on the Purchase Order Equipment

...

Datatype is Hierarchical Path

Required for any operations on the Purchase Order Equipment

Ordered Date

Datatype is Date

Default value: Today

Quantity

Datatype is Number

Required for any operations on the Purchase Order Equipment

Default value: 1 for Adds. For other Actions, you must provide a value.

...

The number of Units in each Quantity.

Please read this article, if you don't know whether Quantity or Units should be used.

...

Canceled Date

Datatype is Date

Default value: Today

Only used for the Cancel Action.

Received Date

Datatype is Date

Default value: Today

Only used for the Receive Action.

...

Only used for the Receive Action.

Let's you Lets the User set the Equipment ID during a Receive. Will cause an error if a duplicate value is being created.

This value can only be used if the Quantity is 1. If the Quantity is greater than 1, then a value here will cause an error.

Received Asset Tag

Datatype is String

Only used for the Receive Action.

Let's you Lets the User set the Asset Tag during a Receive. Will cause an error if a duplicate value is being created.

This value can only be used if the Quantity is 1. If the Quantity is greater than 1, then a value here will cause an error.

Received MAC Address

Datatype is String

Only used for the Receive Action.

Let's you Lets the User set the MAC Address during a Receive. Will cause an error if a duplicate value is being created.

This value can only be used if the Quantity is 1. If the Quantity is greater than 1, then a value here will cause an error.

Received Serial Number

Datatype is String

Only used for the Receive Action.

Let's you Lets the User set the Serial Number during a Receive.

This value can only be used if the Quantity is 1. If the Quantity is greater than 1, then a value here will cause an error.

Errors

Purchase Order Errors

A blank value was provided, for a field with a required value

Toggle cloak
 Cloak
  • "Error : Missing Required Warehouse for New Purchase Order"
  • "Error : Missing Required Vendor for New Purchase Order"
The value provided is not acceptable for the record type being created
 Toggle cloak
 Cloak
  • "Error : No previously successful save for PREVIOUS keyword"
  • "Error : Invalid PO Number"
  • "Error : Provided Warehouse Location "<WAREHOUSE>" does not have the Warehouse flag set"
  • "Error : The Warehouse may not be Updated on an existing PO"
  • "Error : The Vendor may not be Updated on an existing PO"
  • "Error : The supplied Attn Contact is not on this Vendor"
  • "Error : Status must be "Pending" for new Purchase Orders"
  • "Error : This PO is Closed. No updates are allowed"
  • "Error : Pending Status can only update to Open"
  • "Error : Open Status can only update to Closed"
  • "Error : This order cannot be opened. No equipment has been added."
  • "Error : There are still <PENDING_COUNT> items pending. The order cannot be closed."
System was unable to save the record
 Toggle cloak
 Cloak
  • "Error : Failed to save Purchase Order <PO_NUMBER>; <errorMessage>"
Purchase Order Equipment Errors
A blank value was provided, for a field with a required value
 Toggle cloak
 Cloak
  • "Error : Missing Equipment Action Flag"
  • "Error : Missing Equipment Catalog for <ACTION> action"
  • "Error : Missing Quantity for <ACTION> action"
  • "Error : Missing Units for <ACTION> action"
  • "Error : Missing Price for <ACTION> action"
The value provided is not acceptable for the record type being created
 Toggle cloak
 Cloak
  • "Error : Invalid Equipment Action "<ACTION>"
  • "Error : Equipment action <ACTION> is not allowed with this PO Status"
  • "Error : Invalid Ordered Date "<ORDERED_DATE>"";
  • "Error : Invalid Cancelled Date "<CANCELLED_DATE>"";
  • "Error : Invalid Received Date "<RECEIVED_DATE>"";
  • "Error : MAC Address "<MAC_ADDRESS>" is not in a valid format."
  • "Error : Multiple matching Equipment for <ACTION> action. You need to specify a Lookup Price or Lookup Units"
  • "Error : No matching Equipment for <ACTION> action"
  • "Error : Provided Recv Warehouse Location "<RECV_WAREHOUSE>" does not have the Warehouse flag set"
  • "Error : The supplied Equipment Catalog is not available from this Vendor"
  • "Error : Quantity is not allowed to be less than zero' . " for <ACTION> action"
  • "Error : Units are provided for a Non-Units Equipment"
  • "Error : Price per Unit is provided for a Non-Units Equipment"
  • "Error : Provided Price per Unit does not agree with provided Price per Quantity"
  • "Error : The Cancel Date is provided, but this is not a Cancel action"
  • "Error : The Cancel Quantity is Zero"
  • "Error : The Cancel Quantity is greater than the Pending Quantity"
  • "Error : There are values present meant for the Receive action, but this is not a Receive action"
  • "Error : You can only specify an Equipment ID, Asset Tag, Serial Number, or MAC Address if the Equipment Catalog is an Asset or Cabling type';
  • "Error : You can only specify an Equipment ID, Asset Tag, Serial Number, or MAC Address if the Quantity is 1 or -1';
  • "Error : This Receive would create a duplicate Equipment';
System was unable to save the record
 Toggle cloak
 Cloak
  • "Error : Failed to <ACTION> Purchase Order Equipment; <errorMessage>"