ABL / BBC Review Manual-Input / Assets / Inventory

Assets / Inventory

The Assets / Inventory page shows the summary of the assets and inventory values for the BBC period, if applicable.

Users may manually enter data here or you can navigate to Menu → ABL → Data Upload Review/Input → Assets/Inventory to enter the data.

You can view the total sub-limit calculation and the details of the manually added ineligible reasons and ineligibles amount of the receivables for the selected BBC date.

Navigation: ABL → BBC Review / Manual Input → Assets / Inventory

Refer to the Screenshot:

Fields and Descriptions

To manually add an asset or inventory collateral data, perform these steps:

1. In the Collateral Name field, select the collateral type from the drop-down list.  
2. Click the  button.  
3. In the Description field, enter the description name. Note that the same description name will be listed under the Product Group field for the respective collateral.  
4. In the Actual Value field, enter the actual value for the selected collateral.  
5. In the COGS field, enter the COGS value for the selected collateral.
6.  Click the  button.

The system calculates the value of the collateral available. The system auto-populates the values for the rest of the fields.

On approving the next BBC, the system will automatically carry-forward the actual value only for the manually created product group. The actual value will be reset to 0.00 for the system-generated product group on approval of the next BBC.

If the Reserve Before Sublimit flag is ON under the Basic Parameters page:  

• The Available for Advance is calculated as follows: 
  Available for Advance = MIN( Borrowing Base, Sublimit)  
• Total Inventory Reserve will be considered before Sublimit, and Inventory Collateral Value will be calculated by comparing Collateral Value - Total Inventory Reserve with MIN(Inventory Sublimit, AR Reliance, Loan Percent).
• The Inventory Collateral Value is calculated as follows, Inventory Collateral Value = MIN(Collateral Value - Total Inventory Reserve, MIN( Inventory Sublimit, AR Reliance, Loan Percent))
• If the Reserve Before Sublimit flag is ON for a particular BBC, Reserves will be considered before Sublimit and Borrowing Base will be calculated by deducting Reserves from Inventory Available and also Available for Advance will be calculated as
  MIN( Borrowing Base, Sublimit).

Ineligible Amount

This displays the ineligible amount of inventory. You can manually add the ineligible amount to the inventory and the system calculates the ineligible amount based on the parameters set under the Client basic parameters page.

The same ineligibles will be posted to the BBC Availability page. The system calculated ineligibles cannot be modified or deleted. For more information related ineligibles calculations refer to Client Ineligible calculations.pdf

On approving the BBC, these ineligibles should be rolled forward and available under the same product groups and collateral in the new BBC summary page. If any new assets are added to the details page which is linking to the same collateral, then the ineligibles should be overwritten.

The ineligibles that are manually added to product groups in the summary page, should be rolled forward and available under the same product group in the new BBC and should not be overwritten even if there is a new input via manual entry or upload linking to the collateral that created the product group.

To manually add the ineligible amount and reason, perform these steps:

1. In the Collateral Name field, select the collateral to add the ineligibility details.  
2. In the Product Group field, select the product group from the drop-down list. Note that the system displays the list of product names which has been created for the respective collateral.  
3. Click the  button. A new row is highlighted.  
4. Select the ineligibility reason and enter the ineligible amount. You can simultaneously add multiple client ineligibles records if required.  
5. Click the  button.  
6. Click the  button to simultaneously edit multiple ineligible records.

If there are no entries of COGS in this page, then you can manually enter the COGS value per inventory type. Once the COGS is manually entered and saved, the system automatically calculates and displays the Inventory Turn days.

If a user tries to edit manually-entered or system-defined Ineligible Amount or Ineligible Reason fields without selecting the collateral name and the product group, then the system notifies you to select the collateral name and the product group.

Refer to the screenshot: