Welcome to Marg Care - Marg Books

Home > Marg Book > Bills > What is the process of Purchase Import from CSV in Marg Books ?

What is the process of Purchase Import from CSV in Marg Books ?

207

Ans.1
  • Firstly, click on 'Purchase > Bill'.

  • Click on 'Create' button.

  • The user will enter 'Entry Date' as per the requirement.

  • The user will select party whose purchase bill needs to be imported.
  • Suppose select 'A2Z Pharmacy' and press 'Enter' key on it.

  • In 'Invoice No.' field, the user will press 'F11' key.

  • In 'Import From' option, the user will select 'Marg CSV Import'.

1. File Path: The user will select CSV File which needs to be imported.

2. Show Un-Match: The user can select whether to display only unmatched items or to display all items, including both matched and unmatched ones.

3. Mapping Base: The user will select either the product code or product name as the basis for mapping.

Then, click on 'Save'.

  • The user needs to press 'Enter' key to map the imported items with the software's existing items. Alternatively, they can press 'F2' key to create a new item in the software if it doesn't already exist. 
  • Suppose, press 'Enter' key to import already created item.

  • The user will select the item which need to map with the items created in the software.
  • Suppose select 'Amifru 40' and press 'Enter' key on it.

  • Now, the user will proceed to map all the items and click on 'Import' button.

Fig1: View of a Purchase Imported Bill from CSV.

The user will click on 'Save' button in order to save bill.

After following the above steps, the user can easily Import Purchase Bill from CSV in Marg Books.


Submit Feedback