Creating G/L Allocation Posting Templates in Intercompany Solution

Creating G/L Allocation Posting Templates in Intercompany Solution


To create a G/L allocation posting templates, perform the following steps in the system.

  1. In the SAP Business One Main Menu choose Financials  G/L Allocation Posting Templates to display the G/L Allocation Posting Templates window.
  2. Specify the following information:
  1. Header:
  1. Specify a unique Code and Description for the template.
  1. Top matrix:
    1. In the G/L Account field specify the G/L account.
    2. Choose the Currency Code for the posting template. 
    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.
  1. Bottom matrix:
                  1. Specify the IC branch codes of the companies to which the allocation is to be made.
                        You can choose the Load All Branches button to automatically populate the IC branch codes of all branch companies.
  1. 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. You can 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 in the receiver company will not be impacted.

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

                        4. Specify a value in Allocation % field. 
  1. Choose Add. The G/L allocation posting template is saved in the database.

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: Removing G/L Allocation Posting Templates in Intercompany Solution