Ad Magic oversees inventory management on behalf of their clients, facilitating order fulfillment while charging a fee for their services. Presently, they determine these fees by gathering order and receipt data from various sources, a process that is both time-consuming and susceptible to errors. Their goal is to streamline this process and enhance its overall reliability.
Field Name | Field Help |
|---|---|
Pallet Received Single SKU Service Rate | Per pallet charge |
Pallet Received Multiple SKU Service Rate | Additional charge per SKU > 1 SKU per pallet |
Carton Received Single SKU Service Rate | Per carton charge |
Carton Received Multiple SKU Service Rate | Additional charge per SKU > 1 SKU per carton |
Floor Loaded Container Received Service Rate | Additional charge for floor loaded container |
B2C Automated Order Service Rate | Per order charge for imported B2C order |
B2C Automated Line Item(s) Service Rate | Additional charge per line for imported B2C order |
B2C Manual Order Service Rate | Per order charge for manually entered B2C order |
B2C Manual Line Item(s) Service Rate | Additional charge per line for manually entered B2C order |
B2C Crowdfunding Additional Upload Service Rate | Additional charge for crowdfunding order upload |
B2B Automated Order Service Rate | Per order charge for imported B2B order, only apply to Breaking Game |
B2B Automated Line Item(s) Service Rate | Additional charge per line for imported B2B order |
B2B Manual Order Service Rate | Per order charge for manually entered B2B order |
B2B Manual Line Item(s) Service Rate | Additional charge per line for manually entered B2B order |
B2B Pallet Service Rate | Per pallet charge |
Transfers, Tradeshows and Removals Service Rate | Hourly rate for time spent on transfer,tradeshow and removal order fulfillment. |
Transfers, Tradeshows and Removals Order Minumum Rate | Minumum rate charged to fulfill transfer,tradeshow and removal order. |
Field Name | Field Help |
|---|---|
Number of Pallets | Use to calculate total charge for signle SKU pallets received. |
Number of Cartons | Use to calculate total charge for signle SKU cartons received. |
Total Mixed Pallet | Use to calculate total charge for mixed SKU pallets received. |
Total SKUs in Mixed Pallet | Use to calculate total charge for mixed SKU pallets received. |
Total Mixed Carton | Use to calculate total charge for mixed SKU cartons received. |
Total SKUs in Mixed Carton | Use to calculate total charge for mixed SKU cartons received. |
Floor Loaded Container | If checked, Additional Floor Load Container Received service charge will applied. |
Field Name | Field Help |
|---|---|
Number of Hours Spent | Record hours spent to fulfill transfer, tradeshow and removal order. |
Warehouse Receipt
Fields will be available for users to capture pallets, cartons, and SKU information in the Warehouse Receipt header.
Warehouse Shipment
Fields will be available for users to capture hours spent on fulfilling the Transfers, Tradeshows, and Removal orders in the Warehouse Shipment header.
New Table - Service Charge Calculation
Field Name | Field Help |
|---|---|
Customer | Lookup to the Account table |
End of Month | Last date of the month |
Year/Month | For example, 2023/08 |
Total Billable Service Charge Amount | Roll-up summary of Amount from Service Charge Calculation Line |
No. of Lines | Number of Service Charge Calculation Lines created |
Table - Service Charge Calculation Line
Field Name | Type |
|---|---|
Service Charge Calculation | Master-Detail(Service Charge Calculation) |
Line No. | |
Service Group | Receiving, Fulfillment |
Description | Service Description |
Quantity | |
Unit Rate | |
Amount | |
Document Posting Date | Posting of the Warehouse Shipment or Warehouse Receipt |
Warehouse Shipment | |
Warehouse Receipt |
Navigate to the Service Charge Calculation tab
Click the Calculate Service Charge button
Month End defaults to the previous month’s last date.
The system will process the below transactions in the month:
For each Whse. Receipts
Calculate per pallet charge
Calculate additional charge if pallets have more than 1 SKU
Calculate per carton charge
Calculate additional charge for cartons that have more than 1 SKU
Calculate additional Floor Loaded Container service charges if applicable.
For each Whse. Shipments
Determine whether the shipment is B2B or B2C based on the Sales Order Sales Type.
Determine whether an order was manually entered or imported by routines.
Calculate per order charge
Calculate the total line charge
For B2B, calculate per pallet charge if applicable
Calculate B2C crowdfunding additional charge if applicable
Calculate additional Transfer, Tradeshow, and Removal order fulfillment fees if applicable.
Users run reports and review data
Click the “Create Sales Invoice” button to generate Sales Invoices
When generating the invoice, who should be billed?
How can we distinguish between automated and manually entered entries? Should we utilize the existing Sales Order Source field or implement a new checkbox?
What is the method for recognizing Crowdfunding, Transfer, Tradeshow, and Removal orders?
Could you provide information about what constitutes an Allocated Destination? Is it equivalent to the Ship-to address in GF? We require this data to formulate the logic for calculating fulfillment fees for "Transfers, Tradeshow, and Removals."
Excel Design Doc:
Blackbox Warehouse Service Invoicing Flow Design.xlsx