|
General Ledger Module |
  
|
|
General Ledger Module |
|
GL_Account - G/L Account Combined.
| • | CompanyCode - Set to consolidation company code |
GL_AccountHistory - G/L Account Combined.
GL_PeriodBudgetDetail – combined.
| • | AccountKey – G/L Account Conversion |
| • | DebitAmount - summed |
| • | CreditAmount – summed |
GL_PeriodPostingHistory - combined.
| • | AccountKey - G/L Account Conversion |
| • | BeginningBalance - summed |
| • | DebitAmount - summed |
| • | CreditAmount - summed |
GL_DetailPosting - increment sequence.
| • | AccountKey - G/L Account Conversion |
| • | DocumentNo – changed to match converted document number (i.e. Invoice number in AP_OpenInvoice) |
| • | DocSequenceNo changed to match converted document sequence (i.e. Invoice Sequence Number in AR_InvoiceHistoryHeader) |
| • | SequenceNo - incremented |
GL_AccountCategory - combined.
GL_AccountType – combined.
GL_AccountGroup – combined.
GL_AccountMemo - increment sequence.
| • | AccountKey - G/L account conversion |
| • | SeqNo - incremented |
GL_AccountMemoSettings - increment sequence.
| • | AccountKey - G/L account conversion |
| • | SeqNo - incremented |
GL_MainAccount - combined.
| • | CompanyCode - Set to consolidation company code |
GL_MainAccountMemo - increment sequence.
| • | SeqNo - incremented |
GL_MainAccountMemoSettings - increment sequence.
| • | SeqNo - incremented |
GL_SubAccount - combined.
GL_SourceJournalHistory - combined.
| • | DebitAmount - summed |
| • | CreditAmount – summed |
| • | Deleted – if this variable is set to “Y”, the record will be removed |
GL_TransactionJournalHistory - increment sequence.
| • | OffsetAccountKey - G/L account conversion |
| • | SequenceNo - incremented |
GL_RecurringJournalHeader - change to create unique key.
| • | Reference - changed to create unique key |
GL_RecurringJournalDetail - change to create unique key.
| • | Reference - changed to match reference in the GL_RecurringJournalHeader file |
| • | AccountKey - G/L account conversion |
GL_RecurringJournalHistory - change to create unique key and increment sequence.
| • | Reference - changed to match reference in the GL_RecurringJournalHeader file |
| • | SequenceNo - incremented |
GL_Bank - combined.
| • | CashAccountKey - G/L account conversion |
GL_AllocationHeader - change to create unique key.
| • | AllocationNo - changed to create unique key |
| • | SourceAccountKey - G/L account conversion |
GL_AllocationDetail - change to create unique key.
| • | AllocationNo - changed to match allocation number in the GL_AllocationHeader file |
| • | AccountKey - G/L account conversion |
| • | LinkedAccountKey - G/L account conversion |
GL_GeneralJournalHistory - increment sequence.
| • | AllocationNo - changed to match allocation number in the GL_AllocationHeader file |
| • | SequenceNo - incremented |
GL_Budget - combined.
GL_BudgetOptions - combined.
GL_CheckMicr - combined.
GL_CompanyMemoManagerSettings - combined.
GL_FinancialReport - combined.
GL_FinancialReportGroup - combined.
GL_FinancialTerminology - combined.
GL_PayAccount - G/L Account Combined.
| • | AccountKey - G/L account conversion |
GL_PayActivity - increment sequence.
| • | SequenceNo - incremented |
GL_PayBank - combined.
| • | OffsetAcctKey - G/L account conversion |
GL_PayOptions - combined.
GL_Rollup - combined.
| • | CompanyCode - Set to consolidation company code |
GL_SalesTax - combined.
| • | ARSalesTaxAccountKey - G/L account conversion |
| • | APSalesTaxAccountKey - G/L account conversion |
| • | APUseTaxAccountKey - G/L account conversion |
| • | NonRecoveryTaxAccountKey - G/L account conversion |
GL_SourceJournal - combined.
| • | OffsetAccountKey - G/L account conversion |
GL_SummaryDetailDrillDown - increment sequence.
| • | AccountKey - G/L account conversion |
| • | APDivisionNo – Convert A/P division |
| • | ARDivisionNo - Convert A/R division |
| • | DocumentNo – changed to match converted document number (i.e. Invoice number in AP_OpenInvoice) |
| • | DocSequenceNo changed to match converted document sequence (i.e. Invoice Sequence Number in AR_InvoiceHistoryHeader) |
| • | SequenceNo – incremented |
GL_Audit - increment sequence.
| • | SequenceNo – incremented |
| • | AccountKey - G/L account conversion |
GL_GeneralJournalMemo - increment sequence.
| • | SeqNo – incremented |
GL_GeneralJournalMemoSettings - increment sequence.
| • | SeqNo – incremented |
GL_TransactionJournalMemo - increment sequence.
| • | SeqNo – incremented |
GL_TransJournalMemoSettings - increment sequence.
| • | SeqNo – incremented |