How to Address an Item Not Linked Exception Type (Legacy)

Last Updated: May 22, 2024


Table of Contents

  1. Item Not Linked Exception Type
  2. Checking the Bill Item SKU
  3. Comparing a Bill Item to Order Items
  4. Linking a Bill Item to an Order Item
  5. Addressing a Bill Item that's not on the Order
    1. Complimentary Item
    2. Replacement Item
    3. Incorrect Item

Bill exceptions appear on bill items as part of the 3-way match process to ensure the bill matches with the order and receipt to make sure you aren't overpaying for items you've ordered. The Item Not Linked Exception Type appears when a bill item cannot be automatically associated with an order item. There are several reasons why a bill item can’t be automatically linked to an order item, and it’s important to check the order to ensure there isn’t a match. If the bill item does appear on the order, it can be easily linked to the order item. If the bill item is not on the order, there are several ways to address the issue depending on the scenario. 

Item Not Linked Exception Type

The Item Not linked exception type occurs when a bill item is unable to be automatically associated with an order item during the transcription process

When a bill is transcribed, the following process occurs:

  • The bill item is checked for a SKU.
  • If there is a SKU on the bill item, the system tries to find that SKU on the list of order items on the connected order that is an exact match.
  • If there is an exact match for the SKU on the order, the bill item is automatically linked to the order item.
  • If there is not an exact match for the SKU on the order, the bill item remains unlinked.

There are several reasons why a bill item SKU might not be found on the order. Some common examples are: 

  • The vendor formats their SKUs differently on bills
  • The vendor sent a different item than what was originally ordered
  • There was an incorrect SKU from the vendor on the bill
  • The vendor sent a complimentary item

Checking the Bill Item SKU

Sometimes, the bill item SKU can be transcribed incorrectly from the attachment. First, check to make sure the bill item's SKU matches the SKU that appears on the attachment. If the transcription of the SKU is inaccurate, follow the steps below to update it. 

  • Click on the Edit Bill button in the upper right corner of the Bill Tab. 

bill-detail-edit-bill-button

  • The Edit Bill modal will open. 
  • Scroll down on the right side of the bill modal until you reach the Line Items section.

bill-modal-line-items

  • Find the Line Item with the incorrect SKU. 
  • Update the Line Item with the SKU that appears on the attachment. 

bill-modal-line-items-sku

  • Click on the Save button in the lower right hand corner. 

bill-modal-line-items-save

  • Scroll down to the item on the bill to see if the Item Not Linked exception type has been resolved. 
    • If the exceptions badge is gone, the bill item is now linked to an order item and no other exceptions exist. 
    • If the exceptions badge is still present, click on the row to view the types of exceptions the bill item has.
  • View the list of exceptions under the Exception section in the Bill Item Detail Drawer

Comparing Bill Item to Order Items

An unlinked bill item will have the Item Not Linked exception type under the Exceptions section in the bill item detail drawer. 

To determine if the item is on the order:

  • Click on the "Link Item" button next to the exception. 

bill-exceptions-bill-item-detail-drawer-item-not-linked-button-png

  • The Link Line Item to Order Item drawer will appear. At the top it will have the selected bill item. Underneath the bill item will be a list of all of the order items on the connected order.

bill-exceptions-link-item-drawer-1

The information available for the order items are: 

  • Item: The item's image, description, and SKU. 
  • Quantity: The amount of the product that was ordered. 
  • Price: The unit price of the product that was ordered. 
  • Total: The total amount the item cost on the order. 
  • Has Link?: Indicates if the item is already linked to a bill item on the current bill. 

Using the information from the bill item, ask the following questions to determine if the bill item is able to be linked to an order item.

  • Does the bill item SKU match an order item SKU with different special characters?
    Examples: 
Bill Item SKU Order Item SKU
12-34-56 123456
12.34.56 123456

 

  • Does the bill item SKU match an order item SKU but have additional characters?
    Examples: 
Bill Item SKU Order Item SKU
123456-07 123456
07-123456 123456
A-123456 123456
123456-A 123456

 

If the answer is no to any of the above scenarios, follow the steps for addressing a bill item that's not on the order.

If the answer is yes to any of the above scenarios, ask the following questions to determine if you want to link the items together. 

  • Is the bill item's description similar to the order item's description? 
  • Is the bill item's unit price similar to the order item's unit price ?

If the answer is yes to all of the questions above, the bill item should be linked to the order item. Follow the instructions for linking a bill item to an order item.

 If the answer is no to any of the above questions or you are still unsure, follow the steps for addressing a bill item that's not on the order.

Linking a Bill Item to an Order Item

If you determine there is a match for the bill item on the order, click the Link Item button next to the order Item. 

bill-exceptions-link-item-drawer-button-png

This links the bill item to the order item. Checks are then run to see if there are any other exceptions between the unit price, quantity, and total between the two items. If any of those exceptions appear, follow the steps on the linked articles to fix them. If the exception section disappears, the bill item matches the order item and there are no further exception types to address. 

Addressing a Bill Item that's not on the Order

Sometimes a bill item can't be linked with an order item. Some common reasons this can occur are: 

Each scenario is listed below with ways on how to address the issue along with pros and cons of each solution.

Complimentary Item

Sometimes a vendor will add on a complimentary item to the order that has a total of $0. These items typically won't be on the original order, so they won't have an order item to be linked to. The options to address this issue are excluding the item or leaving the exception

 

Exclude the Item

Excluding the bill item removes it from the 3-way matching algorithm which removes it from having any exceptions.

Pros Cons
  • Removes the exception from the bill allowing for a 3-way match
  • Since the item is $0, it does not need to be checked for additional exceptions
  • Loses visibility into the bill item not being linked to an order item

  
To exclude the bill item:

  • Click the Exclude Item button in the Bill Item Detail drawer. 

bill-exceptions-bill-item-detail-drawer-item-not-linked-button-png 

Leave the Exception

Leaving the exception keeps the exception tag visible on the bill and allows the user to track approved and completed bills that still have exceptions. We recommend leaving a comment on the bill about why an exception is still present if choosing this method.

Pros Cons
  • Keeps visibility into the exception
  • Can never get a 3-way match on the bill

Replacement Item

If an item on the original order is out of stock or on backorder, sometimes vendors will send a similar item in its place. Since they are different items, they will have different SKUs and won't be automatically linked. The options to address this issue are linking the items, excluding the item, leaving the exception, or disputing the item

 

Link the Items

If you know a bill item is a replacement item for an order item, you can link the two items together to indicate the replacement.

Pros Cons
  • Removes the exception from the bill allowing for a 3-way match
  • Gives visibility into the unit price variance between the items
  • Will likely cause other exception types, such as unit price, as the items are different from each other
  • Loses visibility that the item is a replacement


To link the bill item to an order item:

  • Click the Link Item button next to the order item. 

bill-exceptions-link-item-drawer-button-png

Exclude the Item

Excluding the item removes it from the 3-way matching algorithm which removes it from having any exceptions.  If there are no other exceptions on the bill, the bill should be moved into the approved bill stage. This option should only be used if you are fine with paying the bill and not talking to the vendor about the issue later.

Pros Cons
  • Removes the exception from the bill item
  • Loses visibility that there was an exception

To exclude the item:

  • Click the Exclude Item button in the item detail drawer.

bill-exceptions-bill-item-detail-drawer-exclude-item-button 

Leave the Exception

Leaving the exception keeps the exception badge visible on the bill. This option should only be used if you are fine with paying the bill and potentially talking to the vendor about the issue later. If there are no other exceptions on the bill, it should be moved into the approved bill stage. We recommend leaving a comment on the bill about why an exception is still present if choosing this method.

Pros Cons
  • Keeps visibility into the exception
  • Can never get a 3-way match on the bill
  • Loses visibility into the pricing variance between the two items
  • Must be reimbursed by the vendor if you overpay

 

Dispute the Replacement

Disputing the replacement should be done if you need to discuss the replacement with the vendor before paying the bill. The bill should be moved to the blocked bill stage while talking with the vendor. We recommend leaving a comment on the bill about why the bill is in the blocked stage if choosing this method.

Some reasons to dispute the replacement are: 

  • The unit price variance between the bill item and order item are above your acceptable variance.
  • The bill item is not a comparable replacement for the order item
Pros Cons
  • Prevents overpaying for an item that wasn't originally ordered
  • Delays payment of the bill to the vendor

Incorrect Item

If the SKU and item description don't match anything on the original order, the vendor probably billed you for the incorrect item. This can occur if they enter the SKU incorrectly on their end when receiving the order or when creating the bill. 

Common errors are: 

  • 2 numbers on the original PO item have been swapped on the bill item. For example, order item 1234 and bill item 1243. 
  • 1 number on the original order item is incorrect on the bill item. For example order item 1234 and bill item 1235. 
  • The item has an extension where the original item did not. For example order item 1234 and bill item 1234-05. 

If the descriptions and unit prices for these items are off, chances are one of the above errors has occurred. The options to address this issue are excluding the item, leaving the exception, or disputing the item

 

Exclude the Item

Excluding the item removes it from the 3-way matching algorithm which removes it from having any exceptions.  If there are no other exceptions on the bill, it should be moved into the approved bill stage. This option should only be used if you are fine with paying the bill and not talking to the vendor about the issue later.

Pros Cons
  • Removes the exception from the bill allowing for a 3-way match
  • Loses visibility that the item is incorrect

To exclude the item:

  • Click the Exclude Item button in the item detail drawer. 

bill-exceptions-bill-item-detail-drawer-exclude-item-button 

Leave the Exception
Leaving the exception keeps the exception tag visible on the bill. This option should only be used if you are fine with paying the bill and potentially talking to the vendor about the issue later. If there are no other exceptions on the bill, it should be moved into the approved bill stage. We recommend leaving a comment on the bill about why an exception is still present if choosing this method.

Pros Cons
  • Keeps visibility into the exception
  • Can never get a 3-way match on the bill
  • Must be reimbursed by the vendor if you overpay

 

Dispute the Item

Disputing the item should be done if you need to discuss the price with the vendor before paying the bill. The bill should be moved to the blocked bill stage while talking with the vendor. We recommend leaving a comment on the bill about why the bill is in the blocked stage if choosing this method.

Pros Cons
  • Prevents overpaying for an item that wasn't originally ordered
  • Delays payment of the bill to the vendor

This article is used for documentation feedback only. For more help email help.me@curemint.io