Invoice
Purpose: Use the Invoice screen to review an invoice, and to approve or reject a Held invoice.
When is an invoice held? Order Orchestration holds an invoice if the invoice unit cost on one or more invoice detail lines exceeds or falls below the PO unit cost by more than the Unit Cost Threshold you have specified for the vendor. For example, if you set the Unit Cost Threshold to 10%, Order Orchestration holds the invoice if any invoice detail line’s cost is more than 10% higher or lower than the original PO unit cost. These lines are considered out-of-balance.
Approve or reject an invoice:
-
Click Approve to open the Approve Invoice window if you do not require the vendor to edit the invoice before it is eligible to post to your system.
-
Click Reject to open the Reject Invoice window if the vendor needs to edit the invoice before it is eligible to post to your system.
Note:
Only users with Invoice Inquiry and Invoice Maintenance authority can advance to these windows. See Roles for more information.
Email notification: When a vendor submits an invoice that includes an out-of-balance line, Order Orchestration generates a notification to the Invoice Balance Notification email address specified at the Email tab of the Drop Ship Preferences screen if the Invoice Balance Notification flag is selected. See the Out-of-balance invoice notification email to retailer for a sample.
How to display: Select Display for an invoice at the Invoice Inquiry screen.
Note:
-
Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry authority can display this screen. See Roles for more information.
-
If the Invoice screen was already open in another tab when you clicked the edit icon, you advance to this screen with the previous invoice information displayed.
Fields at this screen
Fields | Description |
---|---|
Invoice Information |
Unlabeled area at the top of the screen. |
Invoice Number |
The invoice number specified by the vendor when creating the invoice. |
Organization |
The name or description of the organization associated with the invoice. See organization. |
Merchandise |
The current extended price of all invoice lines. |
Currency |
A currency of USD is displayed regardless of the currency on the purchase orders included on the invoice. |
Invoice Status |
Possible statuses are:
|
Vendor |
The name or description of the vendor assigned to fulfill the purchase order. Up to 40 positions. The vendor code follows in parentheses. Up to 10 positions. From the vendor_cd in the CreateDSOrder message. |
Total |
The total amount on the invoice, including:
|
Header tab: Invoice summary fields | |
Invoice Date |
The date the vendor specified for the invoice. Format is based on the locale selected through the Users screen. |
Invoice Description |
The description the vendor entered for the invoice. Informational only. |
Other Description |
A description of the additional charges on the invoice. Informational only. |
Freight |
The total freight amount at the header level of the invoice. |
Handling |
The total handling charge amount at the header level of the invoice. |
Other Charge |
The total “other” charge amount at the header level of the invoice. |
Detail Freight |
The total freight charges on all invoice detail lines. You can review the freight charges for an invoice detail line at the Browse Invoice Detail window, available by clicking the Display icon () at the Detail tab. |
Detail Handling |
The total handling charges on all invoice detail lines. You can review the handling charges for an invoice detail line at the Browse Invoice Detail window, available by clicking the Display icon () at the Detail tab. |
Detail Other Charge |
The total “other” charges on all invoice detail lines. You can review the “other” charges for an invoice detail line at the Browse Invoice Detail window, available by clicking the Display icon () at the Detail tab. |
Header tab: Payment Terms fields |
Use these fields to review the payment terms, if any, the vendor has specified for the invoice. Note: The Vendor Portal does not validate the payment terms fields. For example, it does not confirm that the vendor enters a Discount Percent if specifying a Discount Days Due. |
Discount Percent |
The percentage discount to apply when paying the invoice within the Discount Days Due. Can include a 2-position decimal. |
Discount Days Due |
The maximum number of days in which to pay the invoice in order to qualify for the Discount Percent. Up to 3 positions. |
Gross Days |
The number of days in which payment is due for the invoice. Up to 3 positions. |
Detail tab |
This tab displays information about the line(s) the vendor is billing on the invoice, and includes options to display additional information about the line(s). Separate shipments? Each shipment included in the invoice is listed separately, even if the shipments are for the same item on a purchase order. For example, if the vendor ships 3 units of item ABC123 separately for purchase order 456, all 3 shipments can be included on the invoice, and each unit is listed separately at the Detail tab, even if each of the fields described below (PO Number, PO Line #, Order Number, Item #, etc.) is the same. Note: If the vendor uploaded the invoice and consolidated multiple shipments for a PO line into a single DETAIL record with full shipped qty, then there is not a unique invoice_line_no for each shipment of the PO detail line. |
PO Number |
The number or code identifying the purchase order in the originating system. Case: If the originating system includes any lowercase letters in the purchase order number, Order Orchestration converts them to uppercase when creating the purchase order. |
PO Line # |
The original purchase order line number for the shipment. |
Order Number |
The number or code identifying the sales order in the originating system. |
Item # |
Your item number or code. Hold the pointer over the Item # to display a description of the item. |
Shipped Date |
The date when the shipment occurred. Format is based on the locale selected through the Users screen. |
Invoice Qty |
The total quantity included in the shipment and being billed on this invoice. Each shipment creates a separate invoice detail line, even if it is for the same purchase order detail line. |
PO Unit Cost |
The original unit cost from the purchase order. |
Invoice Unit Cost |
The unit cost the vendor is billing for the shipment. Multiplied by the Invoice Qty. If the cost entered by the vendor exceeds or falls short of the original PO Unit Cost by more than the Unit Cost Threshold, the invoice detail line is out-of-balance: for example, you set a threshold of 10%, and the vendor changed the unit price by 15%. The invoice remains in Held status until you either approve or reject it. |
Balanced |
The out-of-balance icon () indicates if the invoice detail line is currently out-of-balance because the current Invoice Unit Cost> differs from the original PO Unit Cost by the Unit Cost Threshold. |
Display |
Click the Display icon () to advance to the Browse Invoice Detail window to review additional information about the invoice line. |
PO Inquiry |
Click the PO Inquiry icon () to advance to the Purchase Order Inquiry screen, where you can review the details of the purchase order, such as the sold-to and ship-to address, items, history, and messages. |
History tab |
This tab displays an entry for each activity that occurs related to the invoice. |
Action Type |
Possible action types:
|
Status |
The status of the invoice as a result of the action. See the Invoice Status, above, for a listing of possible statuses. |
Date / Time |
The date and time when the action occurred. Format is based on the locale selected through the Users screen. The date and time can be the same for a series of actions when some of the actions take place automatically. For example, if you create an invoice that is not out-of-balance and it is submitted immediately, the Created, Submitted, and Posted actions can all have the same date and time. |
User |
The user ID of the person who performed the action. A user of Admin indicates that the action takes place automatically without user intervention. |
Source |
Possible sources are:
|
Transaction Notes |
Possible notes include:
|
Browse Invoice Detail
Purpose: Use the Browse Invoice Detail window to review information about a detail line on an invoice.
How to display: Select the icon () in the Display column at the Detail tab of the Invoice screen.
Note:
Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry authority can display this window. See Roles for more information.Fields at this window
Field | Description |
---|---|
PO Number |
The number or code identifying the purchase order in the originating system. Case: If the originating system includes any lowercase letters in the purchase order number, Order Orchestration converts them to uppercase when creating the purchase order. |
Order Number |
The number or code identifying the sales order in the originating system. |
PO Line # |
The original purchase order line number for the shipment. |
Item # |
The code or number identifying the item. The description of the item follows, separated by a hyphen (-). |
Vendor Item # |
The vendor’s item number or code. The vendor’s description of the item follows, separated by a hyphen (-). |
Shipped Date |
The date when the shipment occurred, or the shipment date indicated by the vendor, if different. Format is based on the settings at the Users screen. |
Invoice Qty |
The total quantity included in a shipment and being billed on this invoice. |
PO Unit Cost |
The original unit cost from the purchase order. |
Invoice Unit Cost |
The unit cost the vendor is billing for the shipment. Multiplied by the Invoice Qty. Different unit cost? If the vendor specifies an invoice unit cost that exceeds or falls short of the original PO Unit Cost by more than the Unit Cost Threshold you have specified for the vendor, the invoice detail line is out-of-balance. For example, if you set the threshold at 10%, and the vendor changes the invoice unit cost (higher or lower) by more than 10%, the invoice detail line is out-of-balance. Held invoice? When the vendor submits an invoice that includes any out-of-balance lines, the invoice goes into Held status, and you need to either approve or reject the invoice. If you accept the invoice, it posts to the originating system. If you reject the invoice, the vendor can edit the invoice, including the Invoice Unit Cost, again, and resubmit the invoice; or the vendor can delete the invoice. Email notification to vendor: The vendor receives an email notification when you accept or reject an out-of-balance invoice if indicated by the Invoice Balance Notification setting at the Email folder of the Preferences tab of the New Vendor or Edit Vendor screen. |
Extended Invoice Cost |
The current Invoice Unit Cost * the Invoice Qty. |
Freight |
The total freight charge for this invoice detail line. |
Handling |
The total handling charge for this invoice detail line. |
Other Charges |
The total “other” charge for this invoice detail line. |
Other Description |
A message about the invoice detail line. Informational only. |
Last Update |
The last date and time when the vendor updated the invoice detail line. Not updated when you accept or reject an invoice. Format is based on the settings through the Users screen. |
Approve Invoice
Purpose: Use this window to confirm approval of an out-of-balance invoice.
How to display: Click Approve at the Invoice screen when you are reviewing an invoice that is in Held status because it is out-of-balance.
Note:
Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry and Invoice Maintenance authority can display this window. See Roles for more information.Completing this window:
-
Enter the reason for approving the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal.
-
Click Save to approve the invoice; otherwise, click Cancel to leave the invoice in Held status.
Updates: When you approve a held invoice:
-
The invoice status changes to Approved, and then changes to Posted as soon as Order Orchestration receives the getDSInvoices request message from the originating system and includes the invoice in the getDSInvoices response message. This activity is tracked in invoice history; see the History tab of the Invoice screen.
-
If indicated by your Invoice Balance Notification settings for the vendor at the Email folder of the Preferences tab on the New Vendor or Edit Vendor screen, Order Orchestration sends an email notification to the vendor that the invoice was approved. See the Out-of-balance invoices approved or rejected notification email to vendor for a sample.
Fields at this window
Field | Description |
---|---|
Invoice Number |
The number or code assigned by the vendor to identify the invoice. |
# of PO lines |
The total number of shipments included in the invoice. An invoice can include multiple shipments for the same purchase order line, and can include lines from multiple purchase orders. |
Reason |
The reason for approving the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal. Required. |
Reject Invoice
Purpose: Use this window to confirm rejection of an out-of-balance invoice.
How to display: You can display this window by clicking Reject at the Invoice screen when you are reviewing an invoice in Held status because it is out-of-balance.
Note:
Available if Use Vendor Portal is selected at the Tenant screen. Only users with Invoice Inquiry and Invoice Maintenance authority can display this window. See Roles for more information.Completing this window:
-
Enter the reason for rejecting the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal.
-
Click Save to reject the invoice; otherwise, click Cancel to leave the invoice in Held status.
Updates: When you reject a held invoice:
-
The invoice status changes to Rejected. This activity is tracked in invoice history; see the History tab of the Invoice screen.
-
If indicated by your Invoice Balance Notification settings for the vendor at the Email folder of the Preferences tab on the New Vendor or Edit Vendor screen, Order Orchestration sends an email notification to the vendor that the invoice was rejected. See the Out-of-balance invoices approved or rejected notification email to vendor for a sample.
The vendor can edit a rejected invoice and resubmit it, or the vendor can delete the invoice.
Fields at this window
Field | Description |
---|---|
Invoice Number |
The number or code assigned by the vendor to identify the invoice. |
# of PO lines |
The total number of shipments included in the invoice. An invoice can include multiple shipments for the same purchase order line, and can include lines from multiple purchase orders. |
Reason |
The reason for rejecting the invoice. This information is displayed to the vendor under invoice history in the Vendor Portal. Required. |