APT Cheque Register Dated: 14-12-25
1. OBJECTIVE: Maintaining the Cheque Register using the data downloaded from APT. Very much useful in Cheque issuing Offices, mainly for HOs.
2. LIMITATIONS: NIL.
3. PRE-REQUISITES: ANY LATEST BROWSERS INSTALLED WINDOWS PCs and MS Excel.
4. PROCESS FLOW: BRIEF
4.1. Generate “Cheque Transactions” reports from “Banking” module [Transaction type all] and download in Excel format from APT App.
4.2. Rename the excel file with name as “cheque”.
4.3. Download all files from the link and save to same folder.
4.4. Open “OfficeMap.js” file with notepad. Edit the file i.e. replace “Office1/Office2” …etc with HO/SO names and replace “Drawing A/c” with actual drawing A/c of each Office. Add lines if required to include more office details. Any way at the end of each line [except the last line] “Coma” symbol should be there. Save and close the file. Do not change any other data in the file. This is only a one-time job.
4.5. Open “APT Cheque Register.html” file, select the Office name then the Drawing A/c No. will be displayed for the selected office. This is a must to correctly fetch Office Cheque data from the downloaded excel file, since it will contain all office data.
4.6. Click on browse button near “Upload New Cheques Data:” and select “Cheque.xls” file and click open.
4.7. All the required data will be displayed in a table without remarks data and in the order of Cheque Number.
4.8. Now you can add the remark for each Cheque from the beginning. Just type the remark in the “Remarks” text box corresponding to the cheque number and press Enter key. It will update the remarks column of the concerned cheque.
4.9. If any continuous Cheque Numbers are having same remark, then edit the “from / to Cheque Box”, type remark and press enter key. It will update remarks for all cheques in typed range.
4.10. Export to Excel: This option is used to export the updated Cheque data to excel file.
4.11. View CHQ Register: This can be used to view the updated Cheque data already saved in excel file.
4.12. Click on “PRINT” button to print the table data from the selected Cheque Number and with selected starting Sl.Number as given below:
4.12.1. To Print All data: Just give Cheque number in the first prompt box and then 1 in the 2nd prompt box.
4.12.2. Selected Cheque Print: This is option is mainly intended for those who prepare cheque register in manual register. Instead, the print using this option can be used for pasting to the register. Suppose in the already completed cheque register page, the last line is having Sl.No. as 250 & Cheque Number is 123400, then on Clicking Print button, Cheque number as “123401” in the first prompt box and then Sl.No. as “251” in the 2nd prompt box. It is also suggested to take printout of only completed pages for pasting. Other data when becomes a full-page data can then be printed later.
4.13. Search: This option can be used to search data from the table. This will search for the value typed in the search box, in all columns of the table.
5. Click refresh for the browser if you:
5.1. Have updated any office data in the “OfficeMap.js” file or
5.2. Want to do any anything freshly.
6. Link for Downloading the App [Save all files to same folder]:
Updates:
Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates
Post a Comment