Verify, Analyse and Configure Excel Data for Vouchers
Once the Excel file is loaded, proceed verify, analyse and configure data before import
If the excel file is not loaded and any error pop-up, check the lists of errors for rectification.
Use the data grid features, such as filter, search & group to analyse the loaded data.
Click verify masters button (at the bottom of the screen), where the connected masters of the vouchers such as ledgers, cost centre, cost category, stock items, godown, units & voucher type of the loaded vouchers can be verified. (Missing masters can be created to tally directly in single click of button.)
Click the configuration button (top right on the grid), to select the default voucher type, the account name for the loaded data.