Business

User Tools

Site Tools

Trace: • warehouse_account_code_general_ledger_inquiry • Create 1099 Work Table - FIN7400

Sidebar

Table of Contents

finance:utilities:create1099worktable
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

This is an old revision of the document!

Create 1099 Work Table - FIN7400

Finance > Utilities > Create 1099 Work Table

This utility is used to create a 1099 work table from the check transaction table or delete all 1099 records by date range at the end of the current year. The check date in the check transaction is used for comparison with the dates specified on this page. The following transactions are not extracted:

  • Check transactions that have been reversed or voided.
  • Check transactions that do not have a check date.
  • Check transactions that have a check number of PAYABL or REVRSL.
  • Check transactions for vendors not marked as 1099 eligible.

Create a 1099 work table:

Field Description
Beginning Date

Type the starting date in the MMDDYYYY format to use as a range to select check transactions to be added or deleted from the 1099 work table.

If no beginning date is specified, 01-01-YYYY, where YYYY is from the from School Year field on the Tables > District Finance Options page is used as the default date. If there is no data in the School Year field, an error is generated.

Ending Date

Type the ending date in the MMDDYYYY format to use as a range to select check transactions to be added or deleted from the 1099 work table.

If no ending date is specified, 12-31-YYYY, where YYYY is from the from School Year field on the District Finance Options page is used as the default date. If there is no data in the School Year field, an error is generated.

Use 1099 Object Codes TableSelected by default to only extract transactions for 1099-eligible vendors with object codes in the Object Code table. If not selected, all transactions for all 1099 eligible vendors are extracted.
Delete

❏ Click Delete to clear any existing work tables.

  • It is recommended that you export both the current and previous file IDs before deleting the 1099 work table, since an export prompt is not offered and since the 1099 work table includes transactions from two file IDs.
  • Specify the beginning and ending dates for deleting transactions; if no dates are specified, all 1099 work table transactions are deleted.
  • It is recommended that you review the FIN2050 - 1099 Report to verify that all transactions are deleted.
Add

Other functions and features:

Delete a row.
finance/utilities/create1099worktable.1502221144.txt.gz · Last modified: 2017/08/08 14:39 (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.