Skip to main content
M
MatthewAccenttMarble
September 20, 2021
Solved

Importing Non-Inventory Items - How do you load the Purchase items? Cost, Preferred Vendor, Expense

  • September 20, 2021
  • 2 replies
  • 0 views

I am working on importing Non-inventory items into the item list.  I have imported the correct data fields but the expense account, preferred vendor & cost will not load.  How do I get those fields to load for a Non-inventory Part? We don't keep certain items in inventory because I tested it and it loads all fields for an Inventory Part.  

 

I hope this isn't a case where you have to update them on a one by one case.  

Best answer by Fiat Lux - ASIA

@MatthewAccenttMarble 

Prepare the Item data with the following template

 

Item NameItem TypeIs ActiveSales DescriptionPurchase DescriptionTax CodeAccount/Income AccountExpense/COGS AccountAsset AccountCostPreferred VendorPrice or %Reorder PointManuf Part NumberUnit of MeasureMax
Green WidgetInventory PartYWidget SalesWidget PurchaseTax   General SalesGeneral Cost of Goods SoldInventory Asset10ABC Vendor151012345 30
General ServicesServiceYServices SalesServices PurchaseNonSpecialized SalesSpecialized Expenses 8DEF Vendor9    
General PartsNon-inventory PartYPart SalesPart PurchasesTax   General SalesGeneral Cost of Goods Sold 7GHI Vendor8    
Misc ChargeOther ChargeYMisc IncomeMisc ChargesNonGeneral SalesGeneral Cost of Goods SoldGeneral Expenses12GHI Vendor15    

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

2 replies

BigRedConsulting
BigRedConsulting
September 20, 2021

The import from Excel template worksheet doesn't appear to have these fields.  Instead it has only the most basic fields like item name, price and a couple of others.

 

You can import items including the purchase fields - and most other fields - via an IIF file. You can use our BRC List Importer  to convert your item list from an Excel worksheet to an IIF file for import.

    Fiat Lux - ASIA
    Fiat Lux - ASIAAnswer
    September 20, 2021

    @MatthewAccenttMarble 

    Prepare the Item data with the following template

     

    Item NameItem TypeIs ActiveSales DescriptionPurchase DescriptionTax CodeAccount/Income AccountExpense/COGS AccountAsset AccountCostPreferred VendorPrice or %Reorder PointManuf Part NumberUnit of MeasureMax
    Green WidgetInventory PartYWidget SalesWidget PurchaseTax   General SalesGeneral Cost of Goods SoldInventory Asset10ABC Vendor151012345 30
    General ServicesServiceYServices SalesServices PurchaseNonSpecialized SalesSpecialized Expenses 8DEF Vendor9    
    General PartsNon-inventory PartYPart SalesPart PurchasesTax   General SalesGeneral Cost of Goods Sold 7GHI Vendor8    
    Misc ChargeOther ChargeYMisc IncomeMisc ChargesNonGeneral SalesGeneral Cost of Goods SoldGeneral Expenses12GHI Vendor15    

     

    then utilize one of these importer tools

    https://transactionpro.grsm.io/qbd

    https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

     

      Terms & ConditionsAccessibility statement