Frequently Asked
Questions
Find Solutions to Common Issues Related to configurations - bulk updation
Is there an option to set sales prices globally across all items or do I need to set each one individually?
To update in bulk item sale price in item master follow below given steps.
Step 1: Take a latest backup of the data.
Step 2: Go to administration menu and select bulk updation option.
Step 3: From bulk updation option select multiple item creation/modification.
Step 4: In the next window of mulitple item creation/modification click on select field option.
Step 5: Then select item sale price field and save button to add item sale price column.
Step 6: Then click on load data to select item to be updated either all item or group of item.
Step 7: After loading data click on save button to save the change in bulk.
Is there a way to update the prices of items without modifying each voucher individually?
If you want to update item's prices in vouchers without modifying it in bulk you need to follow these steps:
Step 1: Open your company then go to Administration.
Step 2: Select Bulk Updations and click on Bulk Voucher Creation / Modification.
Step 3: Select the voucher type such as Sales, Purchase ,etc and click on Configure button.
Step 4: Here, you need to Add Format and configure all the fields used in the voucher.
Step 5: Now, select the format you have created and press F2 and you will see every field columns.
Step 6: Here you will see price column and you can update it then save.
Note: Take backup of your data before making any changes.
How do I update the date for vouchers without opening it one by one?
If you want to update vouchers date without opening it one by one, you need to follow these steps:
Step 1: Take backup of your company.
Step 2: Open your company then go to administration.
Step 3: Select Bulk Updations and click on bulk voucher creation / modification.
Step 4: Select the voucher type such as sales, purchase, etc then click on configure button.
Step 5: Here, you need to add format and configure all the fields used in the voucher.
Step 6: Now, select the format you have created and press F2 and you will see every field columns.
Step 7: Here you will see date column in that you can update the date as required then save.
How can I view and edit the sales prices for existing items?
To update in bulk item sale price in item master follow below given steps.
Step 1: Take a latest backup of the data.
Step 2: Go to administration menu and select bulk updation option.
Step 3: From bulk updation option select multiple item creation/modification.
Step 4: In the next window of mulitple item creation/modification click on select field option.
Step 5: Then select item sale price field and save button to add item sale price column.
Step 6: Then click on load data to select item to be updated either all item or group of item.
Step 7: After loading data click on save button to save the change in bulk.
How can I update sale price in bulk?
For Update sale price in bulk follow these steps:
step 1: Go in administration then go in bulk updation
step 2: Go in Multiple Item creation modification
step 3: Click on modify existing master then take key field name or alias
step 4: Click on select field and take field item name and item sale price or item alias and item sale price if take alias in key field.
step 5: Field must be show in fields select column and save
step 6: Click on Load master then click on show list
step 7: Select item in which you want to update sale price or select all
step 8: Mention sale price and save window.
How do I change the tax category for multiple items at once? It seems to have changed from % to % incorrectly.
If you want to update tax category for multiple items you can do through various option such as bulk updations and excel import
For excel import follow these steps:
Step 1: Go to administration menu
Step 2: Then click on data export import
Step 3: Afterwards click on import masters from MS excel
Step 4: Then click on items
Step 5: Then tick the modify existing master masters option
Step 6: Then select the field and import data from excel accordingly
For bulk updation follow these steps:
Step 1: Go to administration menu
Step 2: Then click on bulk updations
Step 3: Then click on update item tax category/HSN code or multiple item creation/modification option to update tax category for multiple items
How can I zero the opening of all the items in my data?
To update opening stock as zero of items in BUSY, you need to follow these steps:
Step 1: Open your company then go to Administration.
Step 2: Select Bulk Updations and click on Multiple Item Creation / Modification.
Step 3: Click on Modify Existing Masters and select then Key field as Name or Alias.
Step 4: Here, already a column appear of Op. Stock if not showing you can add it by click on Select Fields.
Step 5: Now, Load Master and enter the opening stock as zero in the relevant column then save.
Note: Take backup of your data before making any changes. And opening can be edit in the begining financial year of a company
How can I modify existing items in bulk in BUSY?
To modify items in bulk, you need to follow these steps: (Make sure to take backup of your data before making any changes).
Step 1: Go to Administration menu and click on Bulk Updations.
Step 2: Select Multiple Item Creation / Modification and click on Modify Existing Master.
Step 3: Choose Name in the Key Field and click on Select Fields.
Step 4: Locate the field that you want to modify and double-click on it to select it. Then, save your changes.
Step 5: Click on Load Master, you can load either ALL or Group.
Step 6: After masters appearing in the table you can modify the details and save changes.
How can I change all aliases for a specific range of items in BUSY Accounting Software?
You can Change alias from Bulk updation option but you need to follow these steps:
Step 1: Go to administration and click on Bulk Updations.
Step 2: Now click on Multiple item creation or modification.
Step 3: Now select Modify existing master and select key field as Name.
Step 4: Now click on select Fields option and select alias in field available.
Step 5: Now click on greater than symbol and alias will show in field selected and save the configuration.
Step 6: Now click on Load Master option and select item after click on show list.
Step 7: Now click on OK Option and then change alias in one window of bulk updation and save it.
How can I update the opening stock for all the items in bulk?
To update the opening stock for all the items in bulk, you need to follow these steps:
Step 1: Open your company then go to Administration.
Step 2: Select Bulk Updations and click on Multiple Item Creation / Modification.
Step 3: Click on Modify Existing Masters and select then Key field as Name or Alias.
Step 4: Here, already a column appear of Op. Stock if not showing you can add it by click on Select Fields.
Step 5: Now, Load Master and enter the opening stock in the relevant column then save.
Note: Take backup of your data before making any changes. And opening stock can be updated in the begining financial year of company.