Requirement
Implementing to charge customers for their pallets used. Anything over 10 cartons needs a pallet, and a pallet holds 32 cartons. So, for every 32 cartons of gel packs, it will be an additional $20.
So, if the quantity of the corresponding items is more than 10, then we need to charge $20 for the pallet. If the quantity is more than 32, then we need two cartons and so on.
This only applies to NZ and AU domains.
Our Solution
- We can create a custom checkbox field in the item record to mark the item that needs to charge pallet fee.
- Also, a service item is added for the item having the pallet fee in the sales order.
- Here we are tried this concept in other training account.
- We are taking here “ITEMBNG3882” as one of our gel pack, water pack items.
- Set its quantity as 11
- Total we are adding 3 items here with quantity 11,5,3
- Screenshots attached here
- Adding these items into cart.
- On the Checkout page the pallet fee is added as $20
- Please note according to our calculation the item quantity is more than 10, then charge $20.00 rupees as pallet fee
- Subtotal is the total price of the items and the “TOTAL” is showing with added the pallet fee.
- After place order a service item [Non – inventory item added] as a line item
- Here we are adding “BSAM” item as a line item with price $100.
- So, the Grand total is showing with adding the price of these item
Assumption
- Assume the pallet cost needs to be displayed only in the checkout page. Cart page implementation is not considered.
- Based on the custom checkbox field, items are charged pallet fee.
- We assume that no field is created for the item identification. If it is already existing, could you please share the field?
- We assume the calculation as below
- 10 quantity = 1 pallets so will take $20
- 10-32 quantity= 2 pallets so will take $20
- 33- 64 quantity= 3 pallets so we will take $40 and so on
- We are not considering half pallets scenario.
- If two items are together adding into cart [Gel pack and water pack items]at that time we are not considering adding two items, on that time according to the quantity of those item we have just updated the quantity of line item.
- In NetSuite we could not add an extra line on the summary section to show the pallet fee. The total cost shown in the summary section including the pallet fee as well as the price of the service item added.
Doubts
- In the above solution we are adding pallet fee to the total cost. Could you please confirm, whether we can proceed with this?
- Could you please elaborate the use of the “pallet charge outwards” service item. Do we need to consider it, since it is not accessible from the website?