3PL Costs to 4PL (4PL Billing)

3PL Costs to 4PL displays and manages warehouse service costs that 3PL warehouses charge to the 4PL. This view allows you to view, add, edit, and manage all fee codes and their associated costs used to calculate warehouse invoices.

This functionality is essential for maintaining a complete record of all service costs that 3PL warehouses charge to the 4PL, enabling accurate billing management between the 4PL and 3PL warehouses.

What is 3PL Costs to 4PL?

3PL Costs to 4PL is a list of warehouse services (services_wh) that defines fee codes, descriptions, and costs that 3PL warehouses use to bill the 4PL. Each service includes information about the fee code, description, costs, and price applied to the 4PL.

This view allows you to manage all warehouse services that affect billing between the 4PL and 3PL warehouses, ensuring costs are correctly defined and updated.

Why use 3PL Costs to 4PL?

Centralized Management

Manage all warehouse service costs in one place, facilitating maintenance and rate updates.

Billing Accuracy

Ensures service costs are correctly defined for accurate billing between the 4PL and 3PL warehouses.

Cost Transparency

Provides complete visibility of all service costs that 3PL warehouses charge to the 4PL.

Quick Updates

Allows quick updates to costs and prices through inline editing or grid edit.

Efficient Search

Search services by fee code or description to quickly find the information you need.

Billing Integration

Costs defined here are automatically used in warehouse invoice calculations.

How to Access 3PL Costs to 4PL

Log in to ShipEdge Core as a user with WMS Admin permissions (level 2 with UserWH=1) or Admin (level 3).
Navigate to Warehouse menu in the main navigation bar.
Select “3PL Billing” from the Warehouse menu.
Click “4PL Billing” within the 3PL Billing submenu.
Select “3PL Costs to 4PL” from the 4PL Billing submenu.

Table Columns

The table shows the following columns:

Column	Description
ID	Unique identifier of the warehouse service
Fee Code	Service fee code (required, maximum 15 characters, automatically converted to uppercase)
Fee Description	Service description (required, maximum 255 characters)
Cost	Service cost for the 3PL warehouse
Cost 1	Alternative service cost
Price	Price charged to the 4PL
Type	Service type (maximum 11 characters)

Main Features

Search and Filtering

Basic Search:

Search by fee code (FeeCode) or description (FeeDescription)
Search options:
- Exact phrase: Search for the exact phrase
- All words: Search for records containing all words
- Any word: Search for records containing any of the words

Sorting:

Click any column header to sort by that field
Arrow icons indicate sort direction (ascending or descending)

Service Management

Add a New Service:

Click “Inline Add” at the top of the table
Complete required fields:
- Fee Code: Fee code (required, maximum 15 characters)
- Fee Description: Service description (required, maximum 255 characters)
- Cost: Service cost
- Cost 1: Alternative cost (optional)
- Price: Price charged to the 4PL
- Type: Service type (optional)
Click “Insert” to save or “Cancel” to cancel

Edit an Existing Service:

Inline editing: Click “Inline Edit” in the row of the service you want to edit
Grid edit: Click “Grid Edit” at the top to edit multiple services at once
Modify necessary fields
Click “Update” (inline editing) or “Save” (grid edit) to save changes

Special Features:

Fee codes (FeeCode and FeeCodeU) are automatically converted to uppercase when saving
Services with code PRINTCOLOR automatically update the printing_fee_color field in preferences_wh
Services with code PRINTBW automatically update the printing_fee_black_and_white field in preferences_wh

Pagination

Records per page: Select how many records to show (10, 20, 50, 100, 200, 500, or All Records)
Navigation: Use First, Previous, Next, and Last buttons to navigate between pages
Information: The table shows the current record range (e.g., “Records 1 to 20 of 50”)

Integration with Billing System

Services defined in this view are automatically used in warehouse invoice calculations:

Cost Calculation: Costs defined here are used when warehouse invoices are generated for the 4PL
Fee Codes: Fee codes (FeeCodeU) are used to identify specific services in the billing system
Automatic Updates: Changes to costs are automatically reflected in newly generated invoices

Best Practices

Keep Codes Consistent

Use consistent and descriptive fee codes to facilitate service identification.

Update Costs Regularly

Review and update service costs regularly to ensure they reflect current warehouse costs.

Document Clear Descriptions

Provide clear and detailed descriptions for each service to facilitate cost understanding.

Verify Prices

Verify that prices charged to the 4PL are correct and reflect agreements with 3PL warehouses.

Use Grid Edit for Multiple Changes

Use grid edit when you need to update multiple services at once for greater efficiency.

Review Special Services

Note that PRINTCOLOR and PRINTBW services automatically update warehouse preferences.

Troubleshooting

I can’t see the “3PL Costs to 4PL” option in the menu:

Verify that 3PL Billing and 4PL Billing modules are enabled
Confirm that you have WMS Admin permissions (level 2 with UserWH=1) or Admin (level 3)

I can’t add or edit services:

Verify that you have edit permissions on the services_wh table
Confirm that required fields (Fee Code and Fee Description) are complete

Changes don’t reflect in invoices:

Changes only affect new invoices generated after the update
Existing invoices maintain the costs they had at the time of generation

Error saving changes:

Verify that the fee code is not duplicated (must be unique)
Confirm that numeric values (Cost, Cost1, Price) are valid
Make sure required fields are complete

Next Step: All Transactions - View all warehouse billing transactions

Related:

4PL Billing Overview - Overview of the 4PL Billing module
Statements - Consolidated warehouse account statements
Dispute Verdicts - Manage dispute verdicts related to billing