- Knowledge Base
- HOW TO GUIDES
- REPORTING
LANDED COST EXPORT REPORT
You may export the Landed Costs for your items by creating a customized schema on the Excel Export tool.
CREATING THE EXPORT SCHEMA
1. Login as Admin
2. Admin >> Utilities >> Excel Import/Export Tab
![1](https://help.advanceprotech.com/hs-fs/hubfs/LANDED%20COST%20EXPORT%20REPORT/1.png?width=610&name=1.png)
3. Click Export Products
![2](https://help.advanceprotech.com/hs-fs/hubfs/LANDED%20COST%20EXPORT%20REPORT/2.png?width=597&name=2.png)
4. Create a Schema with the fields that you need. Note that LANDED_COST is not readily available on the list.
5. Create a Custom Formula with the following details:
Column Name: LANDED_COST
Formula: C002_LANDED_COST
![3](https://help.advanceprotech.com/hs-fs/hubfs/LANDED%20COST%20EXPORT%20REPORT/3.png?width=585&name=3.png)
Click Verify and Update
6. You will then see the LANDED_COST Column listed on the new schema
![4](https://help.advanceprotech.com/hs-fs/hubfs/LANDED%20COST%20EXPORT%20REPORT/4.png?width=573&name=4.png)
EXPORT THE EXCEL FILE:
1. On the Ready to Export Tab, enter a Folder, File Name, and select the schema you had created for Landed Cost
![5](https://help.advanceprotech.com/hs-fs/hubfs/LANDED%20COST%20EXPORT%20REPORT/5.png?width=575&name=5.png)
2. You may filter the products as you would like. Hit Export when all parameters are ready