Frequently Asked
Questions

Find Solutions to Common Issues Related to data-conversion - master import export

FAQs

How do I import items in bulk from Excel?

You can import the items in bulk through excel from the below steps.
Step 1: Click on Administration
Step 2: Then Data Export Import
Step 3: Then Import masters from excel
Step 4: Select the required field which you want to import it in BUSY

Why is the export working fine in one accounting software system but not in the other one? How can I troubleshoot and resolve this discrepancy?

To troubleshoot and resolve the issue of export working in one system but not in another in BUSY, you can try reinstalling the software on the system where export is not working. or can check the MS office version

How can I change the date format in the exported CSV file

Pls Follow the Below Steps for Date Format :
Step 1: Open the CSV File
Step 2: Select the Data Column
Step 3: Right Click then Select Format Cells
Step 4: Select Date and Format Type

How can I switch the export format or template to ensure all necessary item details are captured in the excel export?

To switch export format in BUSY for complete item details, 
Step 1 : Go to Administration
Step 2 : Then Configuration
Step 3 : And select the desired format for export.

I imported my inventory data to BUSY but some items are showing the wrong quantity. How can I fix this?

To rectify the incorrect quantity issue in BUSY, you can modify in the item master manually or you can correct it by re importing an excel sheet with the precise quantity information.

Why are some items not showing up after import from excel?

Some items are not showing up after import from excel into BUSY due to might be import process might be not completed successfully. So you need to check after import again.

Is it necessary to import item details before importing the voucher through excel in BUSY?

No, it is not necessary to import item details before importing the voucher through excel. Further, you can either import master separately or can import while importing vouchers in BUSY.

Is there any specific format I need to follow while importing the masters through Excel in BUSY?

There is no specific format to import the masters through excel into BUSY, you just make sure all the required fields are correctly mapped with the correct excel column.

I see there are many old releases and updates installed in my BUSY. Could this be causing issues with exporting to Excel?

Yes there is a possibility that if there is multiple older release of BUSY in your system it might causing issue with exporting to excel

How long does it take to import a large number of items through excel in BUSY?

Time duration to import large number of item master in BUSY will depend on number of entries in excel as well as the system performance.