Creating G/L Allocation Transactions in Intercompany Solution

Creating G/L Allocation Transactions in Intercompany Solution

To create a G/L allocation transaction, perform the following steps in the sender system.

  1. In the SAP Business One Main Menu choose Financials  G/L Branch Allocation to display the G/L Allocation window.
  2. Specify the following allocation information:
            1. Header:
  1. Due Date, Posting Date and Document Date are mandatory fields.
  2. All other fields are optional.  

The data in the window header is common for all allocation lines in the top matrix.

            2. Top matrix:
  1. In the G/L Account field specify the G/L account from which the allocation is to be made.
  2. Choose the currency code for the allocation 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.
  6. If required, add additional allocation lines in the top matrix.
  7. Each row in the top matrix can correspond to multiple rows in the bottom matrix. Highlight the individual rows in the top matrix to populate corresponding allocation information in the bottom matrix. 
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 IC branch code in the Allocation Account Code field, then this allocation 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 at a defined time on a daily or weekly basis. For more information, refer to the Intercompany Integration Solution for SAP Business One Administrator’s Guide.

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. 
  1. Choose Add.

The system creates a separate journal entry corresponding to each row in the top matrix. The nature of the journal entry depends on the nature of the entry (debit or credit) made against the G/L account in the top matrix. 

  1. If the entry is a credit, then the system automatically chooses the due from accounts (from the branch accounts Setup) of the branches to which the allocation is to be made (branches selected in the bottom matrix) as balancing accounts for the journal entry.
  2. If the entry is a debit, then the system automatically chooses the due to accounts (from the branch accounts setup) of the branches to which the allocation is to be made (branches selected in the bottom matrix) as balancing accounts for the journal entry.
  1. A journal voucher / journal entry is automatically created in the receiver systems – companies to which allocation is made.

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: Accepting G/L Allocation Transactions in Intercompany Solution