For Example, two countries the Natural account for Cash Clearing account should hit 1460020, this is to identify the TnE Cash Reimbursements.
The following configurations needs to be updates
- Manage Account Rules
- Manage Accounting methods
- Go to Financials> Manage Account Rules
Create New Rule: TnE US_CA Cash Clearing Account
Short name: _TNE_US_CA_CASH_CLR_ACC
Description: TnE US_CA Cash Clearing Account
Chart of Accounts: COA Structure Instance
Rule Type: Segment- Natural Account
Rules
- Value Type: Constant
Value: 1460020
Rule 1 Condition: “Invoice Amount” != 0 ‘And’ ( “Payment Profile Identifier” = 300000004867453 ‘Or’ “Payment Profile Identifier” = 300000004867459 ) ‘And’ ( “Ledger Identifier for Payables Options” = 300000003956312 ‘Or’ “Ledger Identifier for Payables Options” = 300000003956319 )
*Select Natural Account segment in the Popup
- Value Type: Source
Value: Bank Cash Clearing Account
- Go to Financials> Manage Account Rules
Create New Rule: TnE US_CA Cash SubAccount
Short name: _TNE_US_CA_CASH_SUBACC
Description: TnE US_CA Cash SubAccount
Chart of Accounts: COA Structure Instance
Rule Type: Segment- SubAccount
Rules
- Value Type: Constant
Value: 0000
Rule 1 Condition “Invoice Amount” != 0 ‘And’ ( “Payment Profile Identifier” = 300000004867453 ‘Or’ “Payment Profile Identifier” = 300000004867459 ) ‘And’ ( “Ledger Identifier for Payables Options” = 300000003956312 ‘Or’ “Ledger Identifier for Payables Options” = 300000003956319 )
*Select Sub Account segment in the Popup
- Value Type: Source
Value: Bank Cash Clearing Account
- Go to Financials> Manage Accounting Methods
Standard Accruals> Rule Set: Payments Accrual Basis > Journal Line Rules: Cash Clearing
Assign the newly created Rule sets to the Natural Account Segment and Sub Account Segment
_Natural_Account: TnE US_CA Cash Clearing Account
_SubAccount: TnE Cash SubAccount
Save and Close
Activate the Payments Accrual Basis
Save and Close
