Daily Storage

Daily Storage lets you view and analyze daily inventory storage in your warehouse. It shows detailed information about which products are stored in which bins, how much space they occupy, and when they were stored. This view is essential for understanding storage space usage, calculating storage costs, and analyzing inventory patterns over time.

Why use Daily Storage?

Space Usage Analysis

See exactly how storage space is being used in each bin, by SKU and by location.

Cost Calculation

Access detailed information needed to calculate daily storage costs per OMS account.

Flexible Time Filters

Analyze storage by specific day, week, or month. Filter by custom periods according to your needs.

Advanced Search

Search by company, SKU, bin, type, location, and more. Find specific information quickly.

Historical Tracking

Access historical storage data up to 5 years back for trend analysis and audits.

Data Export

Export data to CSV, Excel, PDF, or print reports for external analysis or documentation.

Access Daily Storage

You can access Daily Storage from:

1. Billing Menu: Navigate to Billing > Daily Storage
2. Directly: Access /dailyStorage.php

Availability

Daily Storage is available when the 3PL Billing module is not activated. If you have 3PL Billing activated, this option may not be visible in the menu.

Table Fields

The table shows the following columns for each storage record:

Billing Information

• Partial Invoice ID: ID of the associated partial invoice. Shows -- if the record has not been invoiced (Not Charge).

Account Information (Administrators Only)

• Company Name: Name of the OMS company that owns the stored inventory. Only visible to users with access level 2 (administrators).

Product Information

• Sku: SKU code of the stored product.
• Product Qty: Number of product units stored in the bin.
• Product Volume: Total volume of the stored product (calculated based on product dimensions).

Bin Information

• BIN: Code of the bin where the product is stored.
• BIN_Volume: Total volume of the bin.
• Type: Type of bin where it is stored:
  • Shelf: Standard shelf
  • Top: Top shelf
  • Floor: Floor space
  • Special: Special space
  • Pallet: Pallet

Location Information

• Location: Physical location within the warehouse.
• Location Volume: Total volume of the location.

Date Information

• Date: Date when the product was stored in the bin (init_date). Shows only the date without time.

View Daily Storage

1. Access Daily Storage

   Navigate to Billing > Daily Storage or access directly at /dailyStorage.php.

2. Select a time filter

   At the top, select one of the available time filters:

   • Today: Shows only records from the current day
   • This Week: Shows records from the current week (default)
   • Last Week: Shows records from the previous week
   • Monthly: Select a specific month from the dropdown menu

3. Review the table

   The table shows all storage records that match the selected time filter. By default it shows 25 records per page.

4. Navigate between pages

   Use the Previous and Next controls at the bottom to navigate between result pages.

5. Adjust records per page

   Select the number of records you want to see per page from the dropdown menu. Available options: 25, 50, 100, 200, 500, 1000, 1500, 2000, 2500, 5000.

Filter by Time Period

Quick Filters

1. Today

   Click the Today button to see only records from the current day.

2. This Week

   Click This Week to see records from the current week (Monday to Sunday according to ISO 8601). This is the default filter.

3. Last Week

   Click Last Week to see records from the previous week.

Monthly Filter

1. Open the Monthly menu

   Click the Monthly button at the top of the page.

2. Select a month

   A dropdown menu will appear with available months (up to 5 years back from the minimum available date). Click on the month and year you want to view.

3. Review the results

   The table will automatically update to show only records from the selected month.

Search and Filter Records

Search by Specific Field

1. Locate the search fields

   In the second row of the table header, you’ll find search fields for each column.

2. Search by text

   For text fields (Partial Invoice ID, Sku, BIN, Product Volume, BIN_Volume, Product Qty, Date, Location Volume):

   • Type the search term in the corresponding field
   • Press Enter or wait a moment for the search to execute automatically
   • The table will filter to show only matching records

3. Search by selection

   For fields with dropdown menus (Company Name, Type, Location, Sku, BIN):

   • Click on the dropdown field
   • Start typing to search available options
   • Select the desired option from the list
   • The table will filter automatically

4. Clear filters

   For text fields, click the “X” that appears when there is entered text. For dropdown fields, use the clear button (X) from Select2.

Combine Multiple Filters

You can combine multiple filters to refine your search:

• Time filter + field filter: Select a time period and then apply additional filters by company, SKU, bin, etc.
• Multiple fields: You can filter by several fields simultaneously (for example, specific SKU + specific Type + specific Location).

Understanding Bin Types

Bins are classified by type according to their physical location:

• Shelf: Standard storage shelves (default type)
• Top: Top shelves, generally higher
• Floor: Floor space in the warehouse
• Special: Special spaces or designated for specific products
• Pallet: Complete pallets

Bin type affects how storage costs are calculated, as each type can have different rates.

Partial Invoice ID

The Partial Invoice ID field shows:

• Invoice number: If the storage has already been invoiced, it shows the partial invoice ID
• --: If the storage has not yet been invoiced (status “Not Charge”)

This helps you identify which storage has already been included in invoices and which is pending invoicing.

Export Data

1. Locate the export buttons

   At the top of the table, you’ll find buttons to export data.

2. Select the format

   Click the button for the desired format:

   • Copy: Copies data to clipboard
   • CSV: Exports to CSV file
   • Excel: Exports to Excel file (.xlsx)
   • PDF: Generates a PDF file
   • Print: Opens the print dialog

3. Apply filters before exporting

   Exported data will include only visible records according to applied filters. Make sure to apply desired filters before exporting.

View Storage by Partial Invoice

If you access Daily Storage with a piid parameter in the URL (for example, /dailyStorage.php?piid=12345), the table will automatically show only records associated with that specific partial invoice.

This is useful when:

• You’re reviewing details of a specific invoice
• You need to verify which storage was included in an invoice
• You’re auditing a partial invoice

Best Practices

Use Time Filters

Always select a specific time period before analyzing data. This improves performance and gives you more relevant results.

Export for Analysis

Export data to Excel for more detailed analysis outside the system, especially when you need to compare periods.

Review Partial Invoice ID

Verify billing status using the Partial Invoice ID field to understand which storage has already been invoiced.

Filter by Bin Type

Use the Type filter to analyze usage of different types of storage space (Shelf, Floor, Pallet, etc.).

Combine Filters

Combine multiple filters to get very specific views of the data you need to analyze.

Review Volumes

Compare Product Volume with BIN_Volume and Location Volume to understand space usage efficiency.

Troubleshooting

I don’t see data in the table

Problem: The table is empty or shows “No matches found”.

Solution:

• Verify that you’ve selected an appropriate time filter
• Check that field filters are not too restrictive
• Make sure there is storage data for the selected period
• Verify your access permissions (non-administrator users only see data from their own account)

Filters don’t work

Problem: Filters are not applying correctly or the table doesn’t update.

Solution:

• For text fields, make sure to press Enter after typing
• Wait a moment after typing for the search to execute automatically
• Clear all filters and reapply them one by one
• Reload the page if filters seem blocked

I can’t select a specific month

Problem: The Monthly menu doesn’t show the month I need or is empty.

Solution:

• Verify that data is available for that month (the system shows up to 5 years back)
• The menu is generated dynamically based on the minimum available date in the data
• If you need older data, contact the system administrator

The table loads very slowly

Problem: The table takes a long time to load or show results.

Solution:

• Apply more specific time filters (day or week instead of full month)
• Reduce the number of records per page
• Use additional filters to reduce the dataset
• Avoid exporting large amounts of data without filtering first

I don’t see the Company Name column

Problem: The Company Name column doesn’t appear in the table.

Solution:

• This column is only visible to users with access level 2 (administrators)
• If you’re a regular OMS account user, you’ll only see data from your own account and this column is not necessary
• Verify your permissions with the system administrator if you think you should see this column

Related Links

• Dashboard - Overview of warehouse operations
• Reports - Billing and operations reports
• Statements - Account statements and billing
• OMS Accounts - OMS account management