Field Descriptions

Table Information

 


Transactions

What can I do in this subtask?

Use this subtask to view transaction-level detail for the selected line.

The table window displays the individual transactions supporting the account balance for the selected line from the main screen. Information displayed includes the journal code (APV-Posted Vouchers, CR-Post Cash Receipts, AJE-Post JEs, etc.) and posting sequence, as well as the project or reference number charged.

Examples of fields displayed include the Voucher, PO Number, Journal Entry, Cash Receipt or Bill Number, Vendor Name, Invoice Number, and Check Information.

When should I use this subtask?

Use this subtask whenever you need to review transaction detail supporting the balance of a given fiscal year/account/organization combination.

Field Descriptions

FY, Account, Org, YTD Balance

These non-editable fields display the Fiscal Year, Account, Organization, and YTD (Year-to-Date) Balance for the selected line from the main screen.

Table Window

Pd

This field displays the period in which the transaction was posted for the selected line on the main screen.

Subpd

This field displays the subperiod in which the transaction was posted for the selected line on the main screen.

Journal

This field displays the type of journal posted (APV-Post Vouchers, AJE-Post JEs, etc.) for the selected line on the main screen.

Project

This non-editable field displays the project used in the transaction.

Vendor Name

This non-editable field displays the vendor name for each transaction linked to the selected record from the main screen.

The Vendor Name field is populated from the Vendor Labor subtask of the Enter JEs screen (Accounting\Transactions\Journal Entries).

The Vendor Name field can also be populated with the vendor name entered in the Vendor Labor subtask of the Enter AP Vouchers (Accounting\Transactions\Vouchers) or the Enter PO Vouchers screens (Accounting\Transactions\Vouchers).

Transaction Description

This non-editable field displays the description for each transaction linked to the selected record in the main screen.

Employee Name

This non-editable field displays the employee name for each transaction linked to the selected record in the main screen.

The Employee Name field is populated from timesheets or from the Employee Labor subtask of the Enter JEs screen (Accounting\Transactions\Journal Entries).

The Employee Name field will be populated with the vendor employee name when entered in the Vendor Labor subtask of the Enter AP Vouchers (Accounting\Transactions\Vouchers) or the Enter PO Vouchers screens (Accounting\Transactions\Vouchers).

Amount

This non-editable field displays the amount posted for each transaction linked to the selected record in the main screen. The amount is stated in terms of your company's functional currency.

Trans Amount

This non-editable field displays the amount of the transaction currency entered for the transaction source entry.

Transactions are entered in the transaction currency.

Trans Currency

This non-editable field displays the currency in which the source transaction entry was made.

If the transaction currency and the functional currency are the same, the values in the Trans Amount and the Amount fields will be equal.

Running Balance Amt

This non-editable field displays the total amount of the year-to-date activity for the FY/Account/Org displayed in the main screen.

The functional amount of each detail record is added to the prior record's running balance amount to derive the current running balance amount.

Voucher

This non-editable field displays the voucher number for each transaction linked to the selected record in the Posting subtask.

Invoice

This non-editable field displays the invoice number.

The invoice number displays for posted vouchers if an invoice number was entered in the Header Info tab of the Enter A/P Vouchers (Accounting\Transactions\Vouchers) or the Enter PO Vouchers (Accounting\Transactions\Vouchers) screens.

Invoice numbers will also display for posted bills.

PO

This non-editable field displays the PO number associated with posted PO vouchers that are linked to the selected record in the Posting subtask.

JE

This non-editable field displays the journal entry number associated with posted journal entries that are linked to the selected record in the Posting subtask..

Cash Recpt

This non-editable field displays the cash receipt number associated with posted cash receipts that are linked to the selected record in the Posting subtask..

Check

This non-editable field displays the check number.

The check number will display for posted cash disbursements as well as for posted cash receipts if a check number was entered when the cash receipt was entered.

Posting User

This non-editable field displays the name of the user who posted the transaction.

Entry User

This non-editable field displays the name of the user who entered the transaction.

Ref 1

This non-editable field displays the Ref 1 item, if applicable.

If you do not use reference numbers in data entry, this field will be blank.

Ref 2

This non-editable field displays the Ref 2 item, if applicable.

If you do not use reference numbers in data entry, this field will be blank.

Posting Seq

This field displays the posting sequence number of the journal posting (1,2, etc.).

The posting sequence number is assigned by journal code (AJE-Post JEs, APV-Post Vouchers, LD-Post Labor Distribution) and period.

The posting sequence number is a unique number that is assigned when journals are printed prior to posting.

Transaction Comments

This non-editable field displays any notes entered on the entry transaction.

Since this is a large field, you have the ability to open the field to show all notes entered.

Table Information

This screen accesses data stored in the GL_POST_SUM (GL Posting Summary) and the GL_DETL (GL Detail) tables.

Top of Page