Using Cash Management

Once Inter-Entity is configured for Cash Management, users enter and post transactions in Sage 300 as usual. See examples below.

Inter-Entity automates the required transactions for bank transactions, A/P payments and A/R Receipts as per the configuration. .

Users need to review the cash management audit logs regularly to check if any errors occurred.

Once the cause of the error is fixed, you can use Periodic Processing to reprocess any transactions in error.

For details on using Cash Management :

For Bank Transactions

As you post Bank transactions (withdrawals and deposits) in the source company for a bank setup in IET Setup > Cash Management Bank Setup, Inter-Entity will create the balancing entries to the Cash Management Clearing Account and transfer the bank entries to the target database.

After posting the Bank Transfer using a CM configured clearing account, IET CM generates a) a bank entry in the source to reverse the transaction in the source bank and b) a bank entry in the target to do the withdrawal or deposit.

Cash Management also supports Bank reversals if using 1-step processing.

Note: Bank entries themselves in the source company are not a trigger for Cash management to create bank entries in the target companies automatically.

For Accounts Payable Payments

If using One-step processing, when you post an A/P Payment batch for a bank setup in IET Setup > Cash Management Bank Setup, Inter-Entity will create the balancing entries to the Cash Management Clearing Account and transfer the bank entries (withdrawals) to the target database

If using Two-step processing,

Once a payment batch has been generated and posted in Accounts Payable, if the bank against which the payment is being posted is set up as a “CM Bank” with the “two step CM process” selected, Inter-Entity will create loan account entries and an A/P Invoice batch in the target Entity {database} defined on the CM Bank for all invoices, debit notes and credit notes applied to the A/P Payments.

This will enable the target company to create AP Payments applied to documents originating in several databases and consolidate processing (e.g. management company paying on behalf of several subsidiaries).

For Accounts Receivable Receipt processing

If using One-step processing, when you post an A/R Receipt batch for a bank setup in IET Setup > Cash Management Bank Setup, Inter-Entity will create the balancing entries to the Cash Management Clearing Account and transfer the bank entries (deposit) to the target database.

If using 2-step processing

When you post an A/R Receipt batch for a bank set up as a “CM Bank” with the “two step CM process” selected, Inter-Entity will create an A/R Invoice batch in the target Entity {database} as defined on the Cash Management Bank for all the invoices, debit notes and credit notes applied to the Posted A/R Receipts.

This will enable the target company to create A/R Receipts applied to documents originating from several source companies and therefore consolidated processing of receipts (e.g. management company collecting deposits on behalf of several subsidiaries).

Creating A/R Receipt batches

In addition, Inter-Entity includes a flexible function to create A/R Receipt batches.

Refer to IET Create Receipt/Refund Batch for details.