Creating Allocation Transactions – G/L Type Allocation in A/P Service Invoice Allocation in Intercompany Solution

Creating Allocation Transactions – G/L Type Allocation in A/P Service Invoice Allocation in Intercompany Solution

To create an allocation transaction, perform the following steps in the sender system.

  1. Navigate to an open A/P service invoice, and choose the Open Allocation button.
  2. Specify the following allocation information:
  1. Top matrix:
  1. Select allocation type as G/L. All other fields in the top matrix are drawn automatically from the A/P service invoice. All other fields except posting date in the top matrix are read-only. Each line in the top matrix corresponds to a line in the A/P service invoice.
  2. Highlight the individual rows in the top matrix to populate corresponding allocation information in the bottom matrix. 
  1. Choose an option from the Allocation Method dropdown list.
  2. Bottom matrix:
  1. Specify the IC branch codes of the companies in bottom matrix 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.

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 to save the allocation information, and then choose Allocate.

The system creates a separate journal entry corresponding to each row in the top matrix. 

  1. A journal voucher 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)