Find Solutions to Common Issues Related to accounting-reports - account books
If some sales data are missing in the report, then you can try these steps to resolve it:
Step 1: The transactions might be deleted. So if the transaction deleted then you need enter again.
Step 2: The transactions might be hidden. You can press ALT+F9 to unhide the transactions and see them in the report.
Step 3:The report has been opened with a different voucher series than the transactions. You can check the voucher series of your transactions and the report and make sure they match.
Step 4: The report has been opened with a different material center than the transactions.
Step 5: The report has been opened with a wrong date range. You can check the date range of your report and make sure it covers the period of your transactions.
In BUSY, there is no default sales report with billing and shipping details. However you can add columns in sale list by using custom column feature. To know how to add custom columns follow the below steps:
Step 1: Open the sales report in which you want to add a column.
Step 2: Click on custom column option available in the report’s header part.
Step 3: Create a format name and click on add new column. enter the details such as heading, position, data type, etc. for the new column.
Step 4: Select a category and click on fields. Search for the billing and shipping fields that you want to add and select it. save your changes.
Step 5: Reopen the report with the format name that you created. You will see your new column with the appropriate data.
We can change column size by Dragging it and In Custom Column Option, we add it required Field in reports.
Pls Follow the Below Steps for Custom Column in Reports:
Step 1: Click on Custom Column Option
Step 2: Mention the Format Name
Step 3: Click on Add New Column or Add New Row
For New Column :
Step 1: Mention the Heading, Position ,Data type Field and Alignment as per your need.
Step 2: Select the Field Value - Data field , Formula Based and SQL Query
Step 3: Select the Category and required field.
For New Row :
Step 1: Enable the sub details option
Step 2: Mention the Show After and Column Field, For when should show and under Which Column.
Step 3: Select the Category, Column Name and Required Field.
For More Customization as per your requirement can contact to Channel Partner.
To add custom columns in reports in BUSY, you can follow these steps:
Step 1: Open the desired report that you want to add a column to.
Step 2: Click on "Custom Columns" in the report’s header part.
Step 3: Create a Format Name and click on Add New Col.. Enter the details such as heading, position, data type, etc. for the new column.
Step 4: Select a category and click on Fields. Search for the field that you want to add and select it. Save your changes.
Step 5: Reopen the report with the format name that you created. You will see your new column with the appropriate data.
If you need any assistance you can reach out to us on our 24X7 helpline number: 8282828282 or 011 40964096. You can also email us your query at support@busy.in.
If account ledger is showing both debits and credits balance for an account, you can follow these steps to stop from showing credits balances:
Method 1: With the help of Custom Column
Step 1: Open the ledger of an account.
Step 2: Click on the custom column and create a new format for a new report.
Step 3: Hide the credit side column and save the configuration successfully.
Step 4: Now, you can view only debit balances of an account.
Method 2: With the help of Sorting
Step 1: Open the ledger of an account.
Step 2: Double-click on the debit side column, all debit balances figures will appear first.
Note: Custom column is a feature of the standard and enterprise models. It will not work in the basic model. You can upgrade the basic model to the standard and enterprise models.
If you want to check account balance then follow the given steps :
Step 1: Go to Display menu
Step 2: Click on Account books
Step 3: Then click on Account ledger option
Step 4: Then click on Account wise option
Step 5: Then click on standard option
Step 6: Then select particular account or all account as per your requirement
Step 7: Then Specify date range and click on Ok button
Step 8: Here you are check the balance of the account
Note : If you are having difficulty accessing this report, please verify that you are logged into the company using the sub-user login credentials. If yes, then it indicates that you do not have the necessary rights to access it.
If the formatting of report is incorrect in BUSY, you can adjust or reset through custom column option by follow these steps:
Step 1: Open the required report in BUSY.
Step 2: Click on Custom Column in the report’s header part.
Step 3: Create a Format Name and click on Add New Col.
Step 4: Now, add the custom columns as per requirement and save the format.
Step 5: Reopen the report with the format name that you created. You will see your new column with the appropriate data.
The Custom Column feature is only available in the Standard and Enterprise editions of BUSY. If you are using the Basic edition, you can add columns by using the Columnar option from the configuration tab under Administration.
To add custom columns in reports in BUSY, you can follow these steps:
Step 1: Open the desired report that you want to add a column to.
Step 2: Click on "Custom Columnsin the report’s header part.
Step 3: Create a Format Name and click on Add New Col.. Enter the details such as heading, position, data type, etc. for the new column.
Step 4: Select a category and click on Fields. Search for the field that you want to add and select it. Save your changes.
Step 5: Reopen the report with the format name that you created. You will see your new column with the appropriate data.
If you need any assistance you can reach out to us on our 24X7 helpline number: 8282828282 or 011 40964096. You can also email us your query at support@busy.in.
To check if any vouchers are non-taxable, you need to follow the below steps:
Step 1: Go to Display, then select Account Books.
Step 2: then select Account Registers (standard), then select Sales Register or which report you want to check, then select date range and relevant information, then select all sales types.
Step 3: then select All parties, then select the sales registered date range for which you want to check the non-taxable.
Step 4: In that, you will find the option to show bifurcation of amounts. Set yes to this option.
Step 5: and then press F2 or OK to load the report; it will show the bifurcated tax amount, in that you can see the GST amount bifurcation in that you will the taxable value and not-taxable value.
If you are operating two companies and having issues with getting separate sale reports for each then follow the steps
Step1 open BUSY and go to open company option
Step2 select your first company out of two companies and open it
Step3 then go to Display menu and click on account books
Step4 click on account register standard then click sale register
Step5 click on all sale type then all parties and set date range for sale report
and enable bifurcation of amount then press Ok
Step6 after opening the report click on export and then select excel option and set the path for export the sale details then export
like the same way open the other company and export the report