The article outlines the steps to import Cost Sub Data from a CSV file.
FOLLOW STEPS BELOW:
1. Download the Template attached in this article
2. Edit the Template with your desired values, please note that the fields that begin with "UDF" are not required
Field | Detail |
Active | 0 or 1 (0 being inactive, 1 being active) |
ActiveMarkup | 0 or 1 (0 being inactive, 1 being active) |
MInQty | Minimum Quantity, Integer |
UnitCost | Number with two decimal places |
ExRate | Exchange Rate (Number with two decimal places) |
RetailSP | Retail Selling Price per Unit (Number with two decimal places) |
UnitSellingPrice | Selling Price per Unit (Number with two decimal places) |
VendorID | Integer Number |
ColourID | Integer Number |
CurrencyID | Integer Number |
CNType | Integer Number |
Date | Standard Date Format |
Code | Cost Sub Type Code |
Description | Any relevant description |
CostTypeID | Integer Number of Cost Type |
UnitType | Unit extension of Cost Sub Type |
3. Enter the Admin Portal
4. Click "Cost Sub Types"
5. Click the "Cost Type" where you want to Import the Cost Sub Type
6. Click the Import Button
7. Click "Browse"
8. Select Your Edited Template CSV
9. Tick "Halt on Error" to ensure if there are error in the CSV, the cost sub type will not be added
10. Click "Start"
NB. For a quick tutorial watch below