User Tools

Site Tools


bankreconciliation:maintenance:banktransactions:createtransactions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
bankreconciliation:maintenance:banktransactions:createtransactions [2018/01/22 22:57] emorenobankreconciliation:maintenance:banktransactions:createtransactions [2018/10/18 20:12] (current) emoreno
Line 5: Line 5:
 //**Bank Reconciliation > Maintenance > Bank Transactions > Create Transactions**// //**Bank Reconciliation > Maintenance > Bank Transactions > Create Transactions**//
  
-<WRAP round intro>This tab is used to extract transactions from the Finance and Human Resources tables for bank reconciliation. +{{page>general:bankreconciliation:maintenance:banktransactions:createtransactions:body}}
- +
-Transactions are grouped and summarized as follows:  +
-  * **Cash Receipts** - Cash receipt number, date, and description +
-  * **Checks** - Vendor number, check number, check date, check void flag (voids are extracted) +
-  * **Payroll Checks** - Employee number, pay frequency, pay date, adjustment number (voids are extracted) +
-  * **Journal Vouchers** - JV number, JV description (the earliest date is extracted) +
-EFT payments are extracted as a JV with the following JV number (description for all is EFT Total): +
-  * **Vendor EFT**:  EFT-mmddyy where mmddyy is the month/day/year of the check date. +
-  * **Payroll EFT**: PAY EFT-mmddyy where mmddyy is the month/day/year of the pay date. +
-Payroll transfer transactions are extracted as a JV. +
-An additional extract for the same Bank Account Group, Accounting Period and/or Pay Date range does not create duplicate entries. +
-</WRAP> +
- +
- +
-====Create transactions:==== +
- +
-^ Field                                        ^ Description    /*Table with two rows*/ +
-^Bank Account Grp|{{page>general:bank_recon_bank_acct_grp}}| +
-^GL File ID|Click {{:images:dropdown.gif|}} to select a general ledger file ID. This field is required. | +
-^Accounting Period|Type the accounting period to be used. The leading zero is not required. Or, click {{:images:acct_period_image.png|}} to select an accounting period. Only one accounting can be used at a time. If this field is not populated, Finance data is not retrieved.| +
-^Pay Date From and To fields|Type or select from the calendar the from and to pay dates to be used. You can enter the same to and from date to retrieve data for a single date. If the pay date fields are not populated, Human Resources data is not retrieved.| +
- +
-^Execute|{{page>general:bank_recon_bank_acct_grp_execute}}| +
-^Process|{{page>general:bank_recon_bank_acct_grp_process}}| +
-^Cancel|Click to cancel the process and clear the data on the tab.|  +
- +
- +
-{{indexmenu_n>5}} +
- +
  
  
bankreconciliation/maintenance/banktransactions/createtransactions.1516661841.txt.gz · Last modified: 2018/01/22 17:57 (external edit)