AVT Container Management solution for NetSuite allows wholesale import businesses to track and receive shipments and manage Landed Cost allocations in an easy-to-use process in NetSuite. Users can track Shipment Reference Numbers(SRNs), bulk receive Purchase Orders(POs), consolidate POs and evaluate Landed Cost allocations by either Weight, Volume, Quantity, or Amount. The Bulk receipting process and Landed Cost Calculators improve staff productivity and efficiency and simplify the process of managing and receiving containers.
Features:
Landed Cost Calculator
• Calculate and apply landed cost in Bulk over multiple POs
• Calculate Landed Cost by Weight, Volume, Quantity, and Amount
Consolidate POs
• Ability to Consolidate multiple POs lines and Receive as a single receipt
Manage Container and SRN
• Track Shipment Reference Numbers and PO allocations
Shipment Management
• Shipment Listing
• Shipment Record
• Shipment Record Purchase
• Shipment Bill Purchases

Processes in the AVT Container Management SuiteApp
1.Shipment Reference Numbers(SRNs)
It is sent from the supplier/vendor and is imported as a .csv file to NetSuite.
2. Tracking containers by SRNs
SRNs are imported as a .csv file to NetSuite for tracking the Shipment reference numbers from the PO lines.
3. Receiving containers by SRNs
Navigation: AVT Container Management > Purchases > Receive orders
- Select the Shipment Reference Numbers(SRNs) and receive those containers.
- Click Submit.
- The system will automatically find the PO lines that are tracked to the selected SRNs.
- Set the location and click on ‘Create Item Receipt’. The system will automatically create the receipts across multiple POs.
- Once the receipts are created then we can allocate the landed cost.
- Navigation: AVT Container Management > Purchases > Allocate Landed Costs.
- Then again we select the SRNs that we received and ‘Submit’ them.
- Now we can select the cost category, cost method, and cost on the Shipping Reference List.
- On the Item Receipt list, we can see all the PO lines that have been received.
4. Landed Cost Calculator
- By clicking the ‘Calculate Landed Cost’, it will calculate the duty and freight charges provided on each line based on the given landed cost category.
- After clicking the ‘Allocate Landed Cost’, it will apply the landed cost to the receipts.
- Now on the receipt, we can see the landed costs.
- The landed cost on the summary levels of the Item Receipt has been allocated and on the line level, the same information has been translated.
- We can re-apply another landed cost category to the same Shipment Reference Numbers(SRN) by clicking the ‘Reload’ button.
5. PO Consolidation.
Navigation: AVT Container Management > Purchases > Consolidate POs
- Select a vendor and then choose all the POs that we wanted to consolidate and click ‘Consolidate’.
- That will automatically call the lines from the POs that are selected and create a single PO for that particular vendor.