Inter-Entity (Cash Management) and Sage 300 Options
G/L Integration Option in Bank Services
The G/L batches resulting from bank entries created by Cash Management can be auto-posted, depending on the G/L Integration options in Bank Services.
Bank Setup G/L Integration Tab
Option 1: Configure the Create G/L Transactions by option to Creating and Posting a new batch
The resulting G/L Batches for all Bank Entries (both auto-created by Inter-Entity Transactions and manually entered Bank Entries) are auto-posted, except G/L Batches resulting from reversal bank entries created by Cash Management.
When posting a reversal in Bank Services, you get the error message "No active transactions allowed for auto-post."
This is because you have configured the G/L Integration option in Common Services > Bank Services > Bank Setup to "Create G/L Transactions by" to "Creating and Posting a New Batch".
Although you get the error above when posting an A/P or A/R reversal in Bank Services, Cash Management is actually creating the bank entries according to the configuration for banks configured in Cash Management. The resulting G/L Batch is created correctly. But you need to post the resulting G/L Batch manually.
This error message is a known issue because Cash Management supports additional sub-classing of Bank Reversals, but Bank Services does not.
This option is a good choice if you want to auto-post G/L batches and rarely create bank reversals, as long as you're okay with ignoring the occasional error message.
Option 2: Configure the "Create G/L Transactions by" to "Creating a New Batch"
The resulting G/L Batches for all Bank Entries (both auto-created by Inter-Entity Transactions and manually entered Bank Entries) must be posted manually.
-
You will not receive an error message when using Bank Services -> Bank Transactions -> Reverse Transactions.
-
You will need to post all G/L Batches resulting from Bank Entries manually.
This option is suitable if you don't want to auto-post batches in the G/L or frequently create bank reversals and find the error message confusing.
The error message that you can ignore if using option 1
Default Options in Bank Options
The default values in the Common Services -> Bank Services -> Bank Setup -> Bank Options > Processing tab should be blank as Cash Management will set the G/L Accounts based on the Inter-Entity transaction routes.
Note: This applies to AP/AR 1-step and AP/AR 2-step processing transactions.
If you have configured "Default Options" for your Bank Options in the company where Bank Entries are created, the IE auto-generated Bank Entry will fail with the following message:
Error: Bank Entries Header. Attempt to change read-only field 'Bank Entry Type'.
If you get this error, remove all Default Options in Bank Options in the Bank Options and use IET Periodic Processing - Cash Management Tabto process the transactions in error.
Bank Options Fields on Processing Tab
and in Transaction Options
Error message examples
When posting a transaction
In the IET Cash Management Audit log
