ID #1340

Is it possible to import Stock Journal in FusionRetail 6?


Now you can also import Stouck Journal entries from Excel file. Please use the following steps.

  • Create an excel file with the Columns mentioned in the following table.
Brand Brand name of the product
Department Department of the product
Field1 to Field6 Matrix details as size, color, design etc.
Location Location name
Matrix Name Name of the matrix as Garment Product, General Products, etc
MRP MRP of the product
Narration Narration of the Stock Journal
PM Field1 to PM Field 10 User defined fields for  Product master import
Print Name Print Name of the Product
Product Group Name Product’s Group Name
Product Child ID Child ID of the product
Product ID Product ID
Purchase Rate Purchase rate of the product
Qty Product Quantity
Sale Rate Sale rate of the product
Sub Group Sub group of the product
Tax at Purchase Product’s purchase Tax
Tax at Sale Product’s Sales Tax
Type Provide Type as Production, Consumption, Excess, Shortage or Wastage
UDF1 to UDF10 User Defined Fields for Transactions
Unit Name Product’s Unit name as Kg, Gm, Ltr, Mtr etc.
UPC/EAN Universal Code of products
User Defined Code User Defined Code of the products
Vch Date Voucher date of the product
Warehouse Name Warehouse name, for which you are creating stock journal import.


  1. New Product will be created from here just like "Purchase import" or "Opening Import".
  2. Product Child will be Imported only when “Type = Production"
  3. When "Production" is present in your selected file then only "Purchase Rate" and "Sale Rate" selection is mandatory
  4. If Type is other than "Production" then during Import it will take first available Child


For more details please visit:

Tags: Import Data, Setup, Stock journal

Related entries:

You cannot comment on this entry