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


FieldDetail
Active0 or 1 (0 being inactive, 1 being active)
ActiveMarkup0 or 1 (0 being inactive, 1 being active)
MInQtyMinimum Quantity, Integer
UnitCostNumber with two decimal places
ExRateExchange Rate (Number with two decimal places)
RetailSPRetail Selling Price per Unit (Number with two decimal places)
UnitSellingPriceSelling Price per Unit (Number with two decimal places)
VendorIDInteger Number
ColourIDInteger Number
CurrencyIDInteger Number
CNTypeInteger Number
DateStandard Date Format
CodeCost Sub Type Code
DescriptionAny relevant description
CostTypeIDInteger Number of Cost Type
UnitTypeUnit 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