Inter-Entity Transactions

Single Database Edition
(Automate Loan Account Entries)

• Works within one Sage 300 database
• Entities are defined by one or more segment values in the GL chart of accounts
• Due-to & due-from transactions are generated automatically
• Works on all General Ledger transactions, regardless of their origin
• User-definable routes
• Complex routes across multiple entities when there are no direct inter-entity account relationships between the transacting entities
• Balance transactions at the segment level (rather than just the Account level) for one or more segments
• Auto-reverse inter-entity entries bound for other companies
• Supports transactions between entities with different functional currencies
   

Multi-Database Edition
(Additional Features)

Includes all Loan Account automation features in the Single Database edition, plus:

• Works within one or across Sage 300 databases
• Loan Account Balance enquiry and report showing matching loan accounts across multiple databases
• Consolidated AR & AP Aged Trial Balance across multiple databases

Configuration options:

• Optionally post transactions based on date rather than fiscal period, to support entities with different Period and Year Ends
• Optionally set GL Accounts and GL Transactional Optional Fields to be auto-created in target databases
• Optionally set batches in target databases to auto-post 
• Generate batches for import into remote 'offline' company databases

Advanced Configuration Options

• Automatically trigger additional transactions (GL, AR and AP) to automate complex inter-entity transactions
• Account Substitution to reduce the need to replicate accounts in multiple entities
• Configure AP and AR charges to accumulate, allowing for periodic on-charges
• Use wildcards to simplify trigger account setup

Devloped in the Sage 300 SDK

• Supports standard Sage 300 functionality, e.g. GL Auto-Allocation and GL Reversing Entries
• Standard Sage 300 security, customization capabilities, import/export, data integrity checking 

Cash Management

Cash Management features are included in the Multi-Database Edition

• Allocate payments or receipts for invoices in one company, using a bank account in another company
• Transfer invoices from one company to another for consolidated processing
• Process bank transfers between companies

Cash Management: AP Payments

• Process a payment against a vendor in one company and have the payment come out of a bank account in another company
• Transfer AP invoices to another company for payment from that company
• Allocate a miscellaneous payment to GL accounts in one or more companies, while drawing the funds from a bank account in another company
• Combined AP trial balance across multiple companies

Cash Management: AR Receipts

• Allocate a receipt to a customer in one company and have the receipt go into a bank account in another company
• Transfer AR invoices to another company for receipting in that company
• Allocate a miscellaneous receipt to GL accounts in one or more companies, while receipting the funds into a bank account in another company
• Combined AR trial balance across multiple companies