Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Field Help

Pallet Received Single SKU Service Rate

Fee Ad Magic charges to process receiving.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 RateFee Ad Magic charges to process the fulfillment

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 transfer,tradeshow and removal order fulfillment.

Transfers, Tradeshows and Removals Order Minumum Rate

Minumum rate charged to fulfill transfer,tradeshow and removal order.

Add New Fields to Whse Receipt

...

Field Name

Field Help

Number of Hours Spent

Use to record Record hours employee spent to fulfill transfer, tradeshow and removal order.

...

Field Name

Type

Service Charge Calculation

Master-Detail(Service Charge Calculation)

Line No.

Description

Quantity

Unit Rate

Amount

Document Posting Date

Warehouse Shipment

Warehouse Receipt

Month-End Process Flow

  • Introduce a new button on Navigate to the Service Charge Calculation list page labeled “tab

  • Click the Calculate Service Charge”.Upon activation of this button, a pop-up window will prompt the user to input a date range, specifically the Start Date and End DateCharge button

  • Month End defaults to the previous month’s last date.

  • The system will perform a query on posted Warehouse Shipments and Warehouse Receipts with Posting Dates falling within the user-specified Start Date and End Dateprocess the below transactions in the month:

    • For each Whse. Receipts

      • Calculate per pallet charge

      • Caculate additional charge if pallets have more than 1 SKU

      • “Pallet Received Single SKU”

      • Calculate the additional service charge for “Pallet Received with Mixed SKU”

        • ….

      • Calculate….

      • Calculate

    • For each Whse Shipments

      • Look at Sales Chanel, B2B, B2C

      • Look at automatic or manual

      • Calculate per order charge

      • Calculate total line charge

      • For B2B, charge more….

  • Users run reports, review data

  • Click a button to create Sales Invoices

  • .

  • For Warehouse Receipts, the system will utilize the pallet, carton, and SKU information gathered from the warehouse receipt header. It will then combine this data with the service rates configured in the company setup to compute the total service charge. In cases where a warehouse receipt pertains to the receipt of a floor-loaded container, a flat rate designated for "Floor Loaded Container Received Service" will be applied.

  • When processing Warehouse Shipments, the system will determine whether the shipment is categorized as B2B or B2C based on the Sales Order Sales Type. Additionally, the Sales Order Source field will be examined to ascertain if an order was manually entered or automatically generated by routines. If the Source field is empty, it indicates manual order creation by the user. The system will then fetch the appropriate rates from the setups to calculate the overall service charge.

    • B2B Automated Order only applied to Breaking Game. (Sell-to?)

    • For Transfers, Tradeshows, and Removals orders, the fees will be calculated by multiplying the hours recorded in the warehouse shipment by the "Transfers, Tradeshows, and Removals Service Rate."

  • Another button, “Create Sales Invoice”, will be added to the Service Charge Calculation list page

    • An individual invoice will be generated for each of the accounts, and the system will establish a link between the invoice and the corresponding Service Charge Calculation entry.

...