INVENTORY CHARGE CREATION

 

 

High Level Flow

 

Normally, inventory billing is setup using the Add or Update button on the Setup – Accounts Screen.  Use the following method for billing inventory charges only when you need to have different charges for different area categories or location types billed by Inventory Quantity, Inventory Cube, Number of Locations used, Total Volume Capacity of Locations used or Number of Areas used.

 

Inventory Charges are setup for each account using the        Setup – Charges to Apply Tab and become applied using the Apply Charges for Events Tab.  When the charges are applied, they will be included on an invoice which includes Inventory Charges over a date range that includes their Charge Date.

 

 

Details of this flow are as follows:

 

  1. Go to the Apply Charges for Events Tab:
    1. In the Setup Charges group:

                                                               i.      Select an Account.

                                                             ii.      Select Type of  Inventory

    1. In the Event Filters group, select a Type of Current Inventory Levels

 

  1. The center list will display the number of Inventory Charges already created for this account that have not yet been billed.  These charges can be displayed on the Adjust Applied Charges Tab.

 

  1. On the left, a list of the Charges to Generate appears.  Highlight the Setup Charges that you want to Apply.

 

  1. Click the Generate Charges Button.  The center list update and display the number of Inventory Charges created for this account that have not yet been billed.  These charges can be displayed on the Adjust Applied Charges Tab.

 

  1. Go to the Create Bill Tab:
    1. Select the Account, Date Range, and Bill Type. 
    2. Enter a comment if desired. 
    3. Make sure that Include Inventory Charges is checked. 
    4. Click Generate Bill.

 

  1. A bill will be created that includes the inventory charges generated.

 

 

Setup

 

Setup for this Billing Type is done using the Setup – Charges to Apply Tab.

 

  1. Change the Account filter to the desired account and click the Add Button.

 

  1. Select Inventory as the Charge Type

 

  1. Select Flat Rate – No

 

  1. Enter a Comment as desired. 
    1. For example Storage for WH A Picking.

 

  1. Enter the Bill Rate and Bill Unit as desired. 
    1. For example

                                                               i.      $.10 (bill rate = .10) per cubic foot (bill unit = cf)

                                                             ii.      $.25 (bill rate = .25) per location (bill unit = loc)

                                                            iii.      $300 (bill rate = 300.00) per area (bill unit = area or bay)

 

  1. Qty Source.  There are 5 selections here:
    1. Cube

                                                               i.      Bill Qty is the Total Cube of items in inventory.

    1. Locations

                                                               i.      Bill Qty is the number of locations used by the account’s inventory.

    1. Quantity (base Units)

                                                               i.      Bill Qty is the total number of base units of inventory.

    1. Volume Capacity

                                                               i.      Bill Qty is the Total Volume Capacity of the locations used by the account’s inventory.  The Volume Capacity is set on the Locations screen for each bin.

    1. Areas

                                                               i.      Bill Qty is the number of Areas used by the account’s inventory

 

  1. Check Auto Insert Charge

 

  1. Automation

 

    1. There are two filters available to determine which inventory records to include when creating this charge.  Neither, One, or Both of them can be used.

 

                                                               i.      Always – Include all Inventory Records for this account.  When this is selected, the two fields on the right are not used.

 

                                                             ii.      Area Category – Include Records where the area category is equal to the data entered in the last field.

 

                                                            iii.      Location Type – Include Records where the location type is equal to the data entered in the last field.

 

    1. Examples:

                                                               i.      To include all charges

1.      WHEN – Always AND Always

 

                                                             ii.      To include all charges for a given area category:

1.      WHEN  - Area Category IS Equal To A AND Always

 

                                                            iii.      To include all charges for a given Location Type:

1.      WHEN  - Location Type IS Equal To PickingUnslotted AND Always

 

                                                           iv.      To include all charges for a given Location Type in a given Area Category:

1.      WHEN  - Location Type IS Equal To PickingUnslotted AND Area Category IS Equal To A

 


  1. EXAMPLE SETUPS

 

 

The above example would charge $0.25 for each cubic foot of capacity used to store the inventory in the Refrigerated Location Type of Warehouse (Area Category) B.

 

 

The above example would charge $.10 for each unit stored in the Frozen Location Type for All Warehouses (Area Categories).