![]() ![]() Many companies do not enter all their payables in a timely manner and/or do not use due dates properly in GP, so it may mean a big change to the payables procedures for the accounting staff to allow this type of reporting to work. Another issue that may come up is what data is actually in payables. The best you could do from GP tables is get historical data for deposits and only what is currently entered in payables. And if you create one, then someone has to keep populating it and updating it. I am not sure this would work because there is nowhere in GP for you to store your projections for future deposits. If this is not possible to leave the data alone and it absolutely has to be fixed, I would recommend working with either your GP Partner or Microsoft Dynamics GP support to come up with the appropriate scripts to fix all the tables needed. The reason is that if you don’t do this exactly right you are going to break a lot of the drillback and linking in GP and could cause data issues afterwards for aging reports, check links and reconcile functions, and who knows what else. If at all possible, I would recommend making a list of the ‘mapping’ – real check numbers to the GP check numbers and keeping it with the accounting records, to be used for auditing/reconciling, and then leaving the data alone. ![]() So they will be in numerous Payables tables (transaction tables, apply tables, distribution tables, keys table) and also in GL tables and Bank Rec tables. The check numbers are in A LOT of tables because the check number becomes the Document Number (DOCNUMBR) in Payables. GRANT SELECT ON view_Checkbook_Register TO DYNGRPĭisclaimer: I tested this on limited data, if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone. Leave this section off if you do not want to grant permissions **/ ** the following will grant permissions to this view to DYNGRP, ON T.Xfr_Record_Number = X.Xfr_Record_Number WHEN T.CMTrxType = 7 AND T.CHEKBKID = X.CMFRMCHKBKID WHEN T.CMTrxType = 7 AND T.CHEKBKID = X.CMCHKBKID WHEN T.CMTrxType = 7 AND X.CMCHKBKID = X.CMFRMCHKBKID The same checkbook (thanks to Max Toledo for this suggestion) Updated to include code for bank transfers from and to Transaction types (thanks to Siva Venkataraman for this suggestion) Updated to link to CM40101 table instead of hard coding ~~~~~ CREATE VIEW view_Checkbook_Register You can find other Dynamics GP views on my GP Reports page. To add deposit detail to you report, you can join table CM20300 on CM20200.CMTrxNum = positnumber. It does not show details for the deposits because I wanted to keep this to one line per transaction, as it appears on the Checkbook Register in GP. Print the form, add your signature and date, and submit to the company who requested the information.The view below will return all Checkbook transactions for Dynamics GP.Review the Account Information form with your account information including transit number, institution number, and account number.Select the “Void cheque/direct deposit info” link from the “Manage My Account” dropdown.Sign into CIBC Online Banking and select “My Accounts” from the menu.Using the online form saves time and lets you type in your information. You can also ask for a paper copy of the Payroll, Direct Deposit, or Pre-Authorized Payment Form at your CIBC Banking Centre. If you are sending the form by email, remember to scan your signed copy so that the electronic version contains your signature. Submit the form to the company depositing the payment into your account or to the billing company.You will need to print a copy in order to sign the “Customer Signature” space. Fill out each field by typing in the requested information.Download the Payroll, Direct Deposit, or Pre-Authorized Payment Form (PDF, 180 KB) Opens in a new window.There are two ways to access the form: Use the form on For most void cheque information requests, you can use a form provided by CIBC that collects account information in place of a void cheque. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |