Setting Templates for Recurring G/L Allocation Postings in Intercompany Solution

Setting Templates for Recurring G/L Allocation Postings in Intercompany Solution

Use this procedure to create a template for recurring G/L allocation postings and set its frequency and expiration date.


  1. In the SAP Business One Main Menu choose Financials → Recurring G/L Allocation Postings. 

The Recurring G/L Allocation Postings window appears.

  1. Specify the following information:
                  1 Header:
  1. Specify a unique code and an expressive description.
  2. Set the Frequency according to which you want system to create instances for the transaction. The default frequency is Monthly.
  3. In Next Execution field specify the required date for the next execution of the recurring posting.

Note

Next execution date must be later than the current date.

                        d.  To set a date after which system should not create instances of the transaction, use the Valid Until option.
                     2 Top matrix:
  1. In the G/L Account field specify the G/L account.
  2. Choose the currency code for the transaction. 
  3. Depending on the nature of the allocation, specify an amount in either the Debit (Income Allocation) or Credit (Expense Allocation) field.
  4. If Multiple Branches are enabled, Specify the branch code in the Branch Code field.
  5. All other fields are optional.
                3 Choose an option from Allocation Method dropdown list 
                   4 Bottom matrix:
  1. Specify the IC branch codes of the companies to which the allocation is to be made. You can use the Load All Branches button to automatically populate the IC branch codes of all branch companies.
  2. If receiver company is branch enabled, Specify the receiver company branch code in the Receiver Branch Code field.

Note

The system uses the Receiver Branch Code specified in the bottom matrix of the sender document to create the Journal Voucher/Journal Entry in the receiver system.

  1. If you specify the target company allocation account for a branch code in the Allocation Account Code field, this account will be used instead of the receiver company´s default expense account or default income account. The due to and due from entries will not be impacted in the receiver company.

Note

To set up the replication schedule for the allocation account, in the Administration Console, choose the Preferences option. In the left frame, choose Allocation Acct Scheduling and complete the setup. You can set the schedule to reoccur on a daily or weekly basis at a defined time. 

You can also synchronize the allocation account from SAP Business One by choosing Administration → System Initialization → Company Details  →  Accounting Data tab. In the Allocation Accounts Synchronization field, choose the Sync button.

  1. Depending on the selected allocation method, specify a value in either the Allocation % or Allocation Amount field. 
      3. Choose the Add button.
      4. System creates the recurring G/L allocation posting template.

Note

With allocation enhancement available for IC PL30 or higher versions, user is now able to select branch(s) of the self company (provided it is Multi-Branch Enabled) in the bottom matrix of the following features:


  1. G/L Branch Allocation 
  2. G/L Allocation Posting Templates 
  3. Recurring G/L Allocation Postings 
  4. A/P Service Invoice Allocation (only for G/L Type)


Next Step: Executing Instances of Recurring G/L Allocation Postings in Intercompany Solution