GL Transactions in Rootstock are the lowest level of GL postings / individual GL postings.
Every business transaction posted to the GL consists of at least two GL Transactions, one debit and one credit.
The GL Transactions selection on the GL menu displays a list of all financial transaction records at the debit/credit level. Individual transactions can then be selected, examined in detail, and traced back to their source transactions.
Each record provides GL Transaction detail with interactive links to the source documents supporting the transaction.
Navigation
GL Transactions
Processing
Each record represents a financial transaction at the bottom debit/credit level. Each record can be further viewed by clicking the link under the Name column.
Header Section
Fields
Name:Randomly generated unique identifier for each transaction.
Company Number: Financial company assigned to a particular GL transaction.
Division: The Division (if any) assigned to the transaction. A Division is assigned to transactions originating in Rootstock ERP and may optionally be assigned to transactions originating in Rootstock Financials.
GL Account: The General Ledger account impacted by this transaction.
Debit Amount: The amount debiting the given GL Account with this transaction for the Fiscal Year/Period defined.
Credit Amount: The amount crediting the given GL Account with this transaction for the Fiscal Year/Period defined.
Type of Control Account: This field carries the Type of Control Account defined on the GL Account for this transaction.
Transaction Number: System-generated sequential identifier for the transaction.
Source: Identifies the source and purpose of the transaction. See the Source NumberLegend section for further explanation.
Transaction Date: The date the originating source business transaction is deemed to have occurred.
Accounting Date: The effective date of the transaction in the general ledger. It is either the Transaction Date or a date in a later Period if the Period for the Transaction Date is closed at the time of posting.
Fiscal Period: The reporting month in which the transaction is recorded. Note that Fiscal Periods are defined in the Fiscal Year menu selection.
Fiscal Year: The reporting year in which the transaction is recorded.
Dimension 1-Dimension 8: The dimension values (if any) associated with the transaction. The meaning and possible values of dimensions are defined on the Rootstock ERP side.
Fixed Asset Transaction: The Fixed Asset Transaction record associated with this transaction.
Statement GL Distribution: The Statement GL Distribution record (GLBANKSTMTDIST) that is the source of this transaction.
Related Fixed Asset: The fixed Asset related to this transaction.
Source Description: Description of the Source for this transaction.
Account Category 1: This field categorizes GL Accounts within their specified Account Type.
Account Category 2: This field categorizes GL Accounts within their specified Category 1.
Account Category 3: This field categorizes GL Accounts within their specified Category 2.
Account Category 4: This field categorizes GL Accounts within their specified Category 3.
Grand Parent Company Number: The Grandparent Company is the Parent Company's Parent Company. If the company that performed this transaction has no Parent Company OR if it has a Parent Company with no Parent Company of its own, this field will be blank.
Grand Parent Company Currency: This field identifies the currency of the Grand Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Credit Amount in Grand Parent Currency: This field carries the transaction credit amount converted to the currency of the Grand Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Debit Amount in Grand Parent Currency: This field carries the transaction debit amount converted to the currency of the Grand Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Exchange Rate to Grand Parent Currency: This field identifies the exchange rate used to convert this transaction to the currency of the Grand Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Grand Parent GL Transaction Summary: This field identifies the GL Transaction Summary record to which these transactions Grand Parent Currency Amount was added.
Home Currency: This field references the home currency in which this transaction was created.
Parent Company Number: The Consolidate-to-Parent Company of the Company where this transaction occurred.
Credit Amount in Parent Company Currency: This field carries the transaction credit amount converted to the currency of the Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Parent Company Currency: This field identifies the currency of the Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Debit Amount in Parent Company Currency: This field carries the transaction debit amount converted to the currency of the Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Exchange Rate to Parent Company Currency: This field identifies the exchange rate used to convert this transaction to the currency of the Parent Company for transactions created in a subsidiary company and consolidated into a parent company with a different currency.
Parent Company GL Transaction Summary: This field identifies the GL Transaction Summary record to which this transaction's Parent Currency Amount was added.
Created By User: This field carries the Salesforce User who created the transaction associated with this GL Transaction record. (Asynchronous processing may override the traditional Created By field.)
PO Line Number: This field stores the Purchase Order Line Number from the associated Cost Transaction or GL Transaction associated with the Purchase Order process.
Payable Transaction Line: This field holds the Payable Transaction Line that was the source of this transaction.
Net Transaction Amount: This formula field presents the transaction amount as a ‘net value’ (positive for a debit amount and negative for a credit).
Rootstock Cost Transaction: The ERP cost transaction record (if any) that was the source of this transaction.
Manufacturing Department: The Manufacturing Department associated with this transaction.
Project: Financial project (if any) impacted by this transaction.
VAT Transaction Number: The VAT Transaction Number (if any) associated with this GL transaction.
Cost Transaction Detail: The Journal Detail record (GLJED) is created on the Manufacturing side for an Inventory Cost Transaction (aka Rootstock Cost Transaction).
NOTE When the GL Transaction is created from an ERP General Journal Detail (GLJED) and references a 'GL Account' that is also referenced as 'Associated GL Account' on a Bank Account, then the system creates a new Bank Account Transaction (for Debit or Credit) record with 'Transaction Type' as 'Transfers/Adjustments Made by JE'.
Inventory Item: The Inventory Item associated with this transaction.
Related GL Transaction: Related GL Transaction, if applicable. For example, if a GL transaction represents a reversal, a Related GL Transaction will be a link to the original entry.
Journal Entry Detail: The General Journal Entry detail record (if any) that was the source of this transaction.
Transaction Group: An identifying number that links the separate GL transactions that arise from a single business transaction. Assigned mechanically at the time of posting.
Transaction Link: A link to the transaction group, a list of all the GL debits and credits that flow from the source transaction.
Beginning Balance Transaction: When this field is checked, it indicates that the transaction represents a component of a beginning balance for the GL Account in this Fiscal Year.
EXAMPLE The current year's earnings are rolled at year-end into retained earnings in Period 0 of the new fiscal year.
Year End Adjustment: If checked, this indicates that this is a year-end adjustment transaction. These transactions are posted to Period 13.
Foreign Exchange Gain/Loss on Invoice: A link to the foreign exchange gain/loss on the Vendor Invoice (if any) that was the source of this transaction.
Foreign Exchange Gain/Loss on App: A link to the foreign exchange gain/loss from the vendor credit application (if any) that was the source of this transaction.
General Journal: The Journal Header associated with this transaction.
GL Transaction Summary: The GL Transaction Summary object associated with this GL transaction. Rootstock Financial Analytics uses GL Transaction Summary objects.
GL Project Rollup: This summary amount represents all transactions recorded to the Project. By clicking on the amount, you will see a record showing details of total debit and credit amounts recorded in each period for a project.
Non-System GLATO Transaction: This field identifies the GL Transactions imported outside of Rootstock Financial operations.
NOTE When the GL Transaction is created from a manually added GL Add Transaction Object (GLATO) that has a 'GL Account', which is also referenced as 'Associated GL Account' on a Bank Account. The system creates a new Bank Account Transaction (for Debit or Credit) record with 'Transaction Type' as 'Transfers/Adjustments Made by JE'.
IMPORTANT The Bank Account Transaction will be created only when 'Non-System GLATO Transaction' is True or 'Cost Transaction Detail' has a value.
Order Line: This field carries the Line Number from the Cost Transaction when the transaction references a Sales Order or Purchase Order.
Transaction Has Been Reconciled: This user-accessible field can denote that this transaction has been reconciled.
Cost Transaction ID: This field stores the Transaction ID from a Cost Transaction.
Vendor Name: This field stores the Vendor Name from the associated Cost Transaction or GL Transaction associated with the Purchase Order process.
PO Number: This field stores the Purchase Order Header Number from the associated Cost Transaction or GL Transaction associated with the Purchase Order process.
PO RCPT Number: This field stores the Purchase Order Receipt Number from the associated Cost Transaction or GL Transaction associated with the Purchase Order process.
Work Order Number: This field stores the Work Order Number from the associated Cost Transaction or GL Transaction associated with the Work Order process.
Project Number: This field stores the Project Number from the associated Cost Transaction or GL Transaction.
Inventory Item Number: This field stores the Inventory Item Number from the associated Cost Transaction or GL Transaction.
Product Number: This field stores the Product Number from the associated Cost Transaction or GL Transaction.
VAT Class: This field stores the VAT Class associated with the transaction.
NOTE This 'VAT Class' will be populated from one of the following conditions:
Defaults from the VAT Class associated with the 'VAT Transaction Number' if it is not blank.
If the 'Receivable Session Distribution' is not blank,
Defaults from the 'Associated VAT Class' (if not blank) on the 'Receivable Session Distribution'.
Else, it defaults from the VAT Class associated with the 'Receivable Transaction'.
If the 'Payable Session Distribution' is not blank,
Defaults from the 'VAT Class' (if not blank) on the 'Payable Session Distribution'.
Else, it defaults from the VAT Class on the Payables Line associated with the 'Payable Session Distribution'.
Defaults from the VAT Class associated with the 'Payable Transaction Line' if it is not blank and the 'Payable Session Distribution' is blank.
Defaults from the VAT Class associated with the 'Journal Entry Detail' if it is not blank.
Defaults from the VAT Class associated with the Purchase Order Line of the 'PO Receipt Transaction' (if not blank) on the 'Rootstock Cost Transaction'.
Foreign Currency: System generated - This field carries the original transaction currency when different from the Home Currency.
Currency Exchange Rate: System generated - This field stores the Foreign Exchange Rate associated with the transaction.
Currency Transaction Amount: System generated - This field stores the Foreign Exchange Amount associated with the transaction.
NOTE When the 'Credit Amount' on this transaction is greater than zero, this 'Currency Transaction Amount' field value will be displayed as negative.
IMPORTANT For the following gain/loss GL Transaction Sources, the 'Currency Exchange Rate', 'Currency Transaction Amount', and 'Foreign Currency' fields will be blank:
Vendor: The Vendor Company associated with this transaction.
Payment Session Detail: A link to the payment session detail (if any) that was the source of this transaction.
AP Transaction Home Amount: The AP Transaction Home Amount for this transaction.
AP Payment Home Amount: The AP Payment Home Amount for this transaction.
Payable Session Transaction: A link to the payable session transaction (if any) that was the source of this GL transaction.
Payable Session Distribution: A link to the payable distribution record (if any) associated with this transaction.
Payables Application: A link to the payable application transaction (if any) that was the source of this transaction.
Payable Invoice Number: This field stores the Invoice Number from the GL Transaction associated with the Payables process.
AR Section
Fields
Customer: The Customer Company associated with this transaction.
Receivable Transaction: A link to the receivable transaction (if any) that was the source of this transaction.
Receivable Session Distribution: A link to the receivable session detail (if any) that was the source of this transaction.
AR Cash: A link to the cash receipt distribution record (if any) that was the source of this transaction.
Cash Receipts Detail: The Cash Receipts Detail for this transaction.
AR Cash Post Date: This transaction's Posted Date for the AR Cash Receipt.
AR Cash Deposit Date: This transaction's Deposit Date for the AR Cash Receipt.
AR Cash Txn Document Amount: The Document Amount displayed in Document Currency from the Receivable Transaction Scheduled Payment for this transaction.
AR Transaction Home Amount: The Transaction Amount (Home Currency) from the Receivable Transaction for this transaction.
AR Cash Inv Document Number: The Document Number of the Receivable Transaction for this transaction.
AR Invoice/Memo Txn Number: The Transaction Number of the Receivable Transaction for the transaction.
AR Invoice/Memo Txn Type: The Transaction Type of Receivable Transaction for the transaction.
AR Invoice/Memo Sched Pay Amount: The Transaction Amount of Receivable Transaction Scheduled Payment for the transaction.
AR Invoice/Memo Txn Date: The Transaction Date of Receivable Transaction Scheduled Payment for the transaction.
AR Cash Application Date: The transaction date of the AR Application for this transaction.
AR Cash Application Tran Type: The transaction type from the AR Application for this transaction.
AR Cash Application Amount: The AR Cash Transaction Amount for this transaction.
AR Cash Distribution Source: The Posting Type of AR Cash Distribution for this transaction.
AR Cash Distribution Account: The AR Cash Distribution Account associated with this transaction.
Customer Name: This field stores the Customer Name from the associated Cost Transaction or GL Transaction associated with the Sales Order process.
SO Number: This field stores the Sales Order Header Number from the associated Cost Transaction or GL Transaction associated with the Sales Order process.
Shipper Number: This field stores the Shipper Number from the associated Cost Transaction or GL Transaction associated with the Sales Order process.
Sales Invoice Number: This field stores the Sales Invoice Number for transactions AR that originated from a Sales Invoice.
Receivable Transaction Number: This field stores the (Internal) Transaction Number from the Receivable Transaction associated with this GL Transaction.
Receivable Document Number: This field stores the Document (Invoice) Number from the Receivable Transaction associated with this GL Transaction.
RMA Number: This field stores the RMA Number from the associated Cost Transaction or GL Transaction associated with the RMA process.
GL Transactions Adjustments
The user can make changes to an existing posted GL Transaction using the GLTXN Adjustment button in the list view. The system uses GLADJO (GL Transaction Adjustment Object) transaction object to adjust an existing posted GL Transaction. The supported adjustments are:
Dimension Change
Account Change (and Dimensions if needed)
Transaction Split (spreading the existing transaction across up to 4 Accounts with Dimensions)
Any GL transaction that carries a Control Account is not eligible for the adjustment process.
When the source GL transaction originates from a transaction distribution (ARINVDIST, APINVDIST, etc.), the new adjustment GL transactions will be similarly linked to the original source object.
