Business

User Tools

Site Tools

Trace: • Mass Update Pay Date - HRS3200
general:bankreconciliation:maintenance:banktransactions:createtransactions:body

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
general:bankreconciliation:maintenance:banktransactions:createtransactions:body [2018/10/18 20:12] – emorenogeneral:bankreconciliation:maintenance:banktransactions:createtransactions:body [2021/01/26 19:35] (current) – emoreno
Line 1: Line 1:
-<WRAP round intro>This tab is used to extract transactions from the Finance and Human Resources tables for bank reconciliation.+<WRAP round intro>This tab is used to extract transactions from the Finance and Payroll tables for bank reconciliation.
  
 Transactions are grouped and summarized as follows:  Transactions are grouped and summarized as follows: 
Line 5: Line 5:
   * **Checks** - Vendor number, check number, check date, check void flag (voids are extracted)   * **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)   * **Payroll Checks** - Employee number, pay frequency, pay date, adjustment number (voids are extracted)
 +**Note**: The original and voided check transactions are extracted even if the two transactions have the same date. 
   * **Journal Vouchers** - JV number, JV description (the earliest date is 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): EFT payments are extracted as a JV with the following JV number (description for all is EFT Total):
Line 11: Line 12:
 Payroll transfer transactions are extracted as a JV. 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. An additional extract for the same Bank Account Group, Accounting Period and/or Pay Date range does not create duplicate entries.
 +
 +**Note**: Accounts with an **Investment Type** selected on the [[bankreconciliation:tables:bankaccountfundgroups:bankaccountgroupfunds|Bank Reconciliation > Tables > Bank Account Fund Groups > Bank Account Group Funds]] tab are not extracted.
 +
 </WRAP> </WRAP>
  
Line 16: Line 20:
 <div head3>Create transactions:</div> <div head3>Create transactions:</div>
  
-{{page>general:bank_recon_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|Drop-down Arrow}} 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|Account Period Selection Scroll Arrows}} 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|Type or select from the calendar the from and to pay dates to be used to retrieve payroll data. If you do not need payroll data, leave these fields blank. You can enter the same to and from date to retrieve data for a single date.| 
 + 
 + 
 +{{page>general:bank_recon_bank_acct_grp_execute}} 
 + 
 +{{page>general:bank_recon_bank_acct_grp_process}} 
 + 
 +VCV Click **Cancel** to cancel the process and clear the data on the tab. 
  
  
general/bankreconciliation/maintenance/banktransactions/createtransactions/body.1539893536.txt.gz · Last modified: 2018/10/18 15:12 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.