Skip to Content
Author's profile photo Former Member

Intercompany integration solution for SAP Business One – Allocation of Income and Expenses across partner companies

Growing organizations that control more than one legal business entity are sometimes faced with the challenge of how to share data between partner companies.

The Intercompany integration solution for SAP Business One enables businesses running SAP Business One to manage Intercompany transactions for multiple companies by automatically replicating corresponding transactions across multiple company databases. Automating the replication of such transactions significantly reduces the amount of end-user effort needed to maintain Intercompany financial statements.

Intercompany Solutions allows user to allocate income and expenses such as travel, payroll, and audit fees across branch companies.

In this blog, we are covering following broad sections  on allocations:

  1. G/L Branch Allocation
  2. G/L Allocation Posting Templates
  3. Recurring GL Allocation Postings
  4. A/P Service Invoice Allocations

G/L Branch Allocation

User can use the G/L Branch Allocation feature to allocate income and expenses to other branch companies. For example, you can allocate income and expenses from the head office company to sales or distribution subsidiaries, or vice versa. The G/L branch allocation allows interbranch transactions to be posted automatically.

At the end of the month, an accountant can allocate a portion of any centrally incurred expenses across all organization units that contribute to, or benefit from, that expenditure/income, based upon a calculation that represents a reasonable allocation of how that expense/income should be split.

For example, marketing expense incurred in head office (ACME NY) company ledger is allocated to subsidiary 1 (ACME CA) and subsidiary 2(ACME TX).

 

Steps to create the G/L Allocation Transactions:

  1. To create a G/L allocation transaction,Choose Financials-> G/L Branch Allocation to display the G/L Allocation window.
  2. Specify header information i.e Due Date, Posting Date and Document Date etc.
  3. In the top matrix,specify an amount in either the Debit (Income Allocation) or Credit (Expense Allocation) field depending on the nature of the allocation.
  4. If required,you can add additional allocation lines in the top matrix.
    Please note 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.
  5. In the bottom matrix,Specify the 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 branch codes of all branch companies.
  6. If you specify the target company allocation account for a 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.
  7. Choose add.
  8. A journal voucher / journal entry is automatically created in the receiver systems – companies to which allocation is made.
  9. In the journal voucher/journal entry, user can click the Intercompany detail button to see the sender company details and G/L allocation information.
  10. Before posting the journal voucher, you can change the default expense account or the default income account to any other specific G/L account.
  11. Change the Status field to Accept or Reject depending on your decision.
  12. If you choose the status as Accept and update the journal voucher, the system sends an alert message to the Alert User of the sender system, indicating an update of the journal voucher.
  13. Post the voucher.
  14. The journal voucher is saved as a journal entry.
  15. The status of the journal voucher is updated in the bottom matrix of the Allocation window in the sender system.

GL Allocation Posting Templates

Commercial organizations may have allocation transactions presented in a template format where only the recorded amounts vary from transaction to transaction. This feature enables the user to create pre-defined templates for expenses or profit allocation that can be used to record recurring transactions. For example, overall marketing expenditure to be allocated in a pre-defined percentage amongst the subsidiaries can be setup as a template.

Steps to create the G/L Allocation Posting Templates:

  1. To create the G/L Allocation Posting Templates window, choose Financials->G/L Allocation Posting Templates.
  2. Specify header information i.e Code and Description.
  3. In the top matrix, Specify an amount in either the Debit (Income Allocation) or Credit (Expense Allocation) field depending on the nature of the allocation.
  4. In the bottom matrix, Specify the 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 branch codes of all branch companies.
  5. If you specify the target company allocation account for a 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.
  6. Choose add.

 

Recurring GL Allocation Postings

Every business may have recurring transactions, say on daily, weekly, monthly or annual basis. This feature enables to create templates for recurring allocation postings, which can be executed based on the recurring frequency. Such recurring transactions can be configured in the Recurring G/L Allocation Postings screen. If the recurring transactions have been configured, the application prompts the user at application startup to post the scheduled recurring transactions.

Steps to create and execute the Recurring G/L Allocation Postings:

  1. To create the Recurring G/L Allocation Postings, choose Financials->Recurring G/L Allocation Postings.
  2. Specify header information i.e Code and Description and set the frequency according to which you want system to create instances for the transaction
  3. In the top matrix, Specify an amount in either the Debit (Income Allocation) or Credit (Expense Allocation) field depending on the nature of the allocation.
  4. In the bottom matrix, Specify the 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 branch codes of all branch companies.
  5. If you specify the target company allocation account for a 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.
  6. Choose add.
  7. To execute the created instances,Go to Financials->Recurring G/L Allocation Postings->Confirmation List. The Confirmation of Recurring G/L Allocation Postings window appears, where each row represents one instance of a recurring G/L Allocation posting template.Please note to set the automatic display of this window, choose Administration->System Initialization -> General Settings -> Services. Select Display Recurring Postings on Execution checkbox.

 

A/P Service Invoice Allocations

Another way to allocate expense amounts to other branch companies is by using the allocation feature on the A/P Service Invoice document.
The application allows for allocation of expenses booked through AP service invoices across branch companies.

The Intercompany integration solution support following two methods of allocating expenses from an A/P service invoice.

  • Allocation by Invoice – In this method of allocation, system creates draft A/R invoice as a result of allocation in the sender company. On adding these draft A/R service invoices, the system will automatically create draft A/P service invoices in the receiver companies.
  • Allocation by G/L – This method of allocation is similar to G/L allocations. System creates the journal voucher in the receiving company as a result of allocation in the sender company.

Steps to create the Invoice Type Allocation:

  1. Navigate to an open A/P Service Invoice and choose the Open Allocation button.
  2. In the top matrix, select allocation type as Invoice. All other fields in the top matrix are drawn automatically from the A/P service invoice.
  3. In the bottom matrix, specify the 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 branch codes of all branch companies.
  4. Choose Allocate button.
  5. The system creates a separate interbranch draft A/R invoice for each branch company to which the allocation is to be made.
  6. In the Documents Drafts Reports – Selection Criteria window,From the User dropdown list, choose the user and choose OK to display the interbranch draft A/R invoice
  7. Open the draft and specify any additional information, if required, and choose Add.
  8. The solution create the draft A/P invoice in the receiver system.
  9. Open the draft A/P invoice document.
  10. Before adding the document,you can change the default expense account to any other specific G/L account.
  11. Choose the status as Accept and add the draft A/P invoice.
  12. The system sends an Alert message to the Alert user of the sender system, indicating an update of the A/P invoice.
  13. The A/P Invoice information is updated in the sender A/R invoice document on Intercompany Tab.
  14. From the A/R Invoice ,user can open the allocated A/P Invoice by clicking the allocation Invoice reference number.
  15. Also, the receiver companies A/P Invoice information is updated in the bottom matrix of the Allocation window in the sender system.

Steps to create the G/L Type Allocation:

  1. Navigate to an open A/P Service Invoice and choose the Open Allocation button.
  2. In the Top matrix, select allocation type as G/L. All other fields in the top matrix are drawn automatically from the A/P service invoice.
  3. In the bottom matrix, specify the 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 branch codes of all branch companies.
  4. Choose Allocate button.
  5. The system creates a separate journal entry corresponding to each row in the top matrix.
  6. A journal voucher / journal entry is automatically created in the receiver systems – companies to which allocation is made.
  7. Before posting the journal voucher, you can change the default expense account or the default income account to any other specific G/L account.
  8. Change the Status field to Accept or Reject depending on your decision.
  9. In the journal voucher/journal entry, user can click the Intercompany detail button to see the sender company details and allocation information
  10. If you choose the status as Accept and update the journal voucher, the system sends an alert message to the Alert User of the sender system, indicating an update of the journal voucher.
  11. Post the voucher.
  12. The journal voucher is saved as a journal entry.
  13. The status of the journal voucher is updated in the bottom matrix of the Allocation window in the sender system.

 

(This blog content was created by the development team of the intercompany integration solution for SAP Business One)

 

Find a list of all blogs on Intercompany integration solution for SAP Business One in this central blog.

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Adrian Lauchlan
      Adrian Lauchlan

       

      Hi Peter

      What is the best way to set up a loan between two companies. Up till now we have raised separate journals one in each company posting the money out of the bank account and into the loan account in one company and posting the money into the bank account and the loan account in the other. Is there a way of doing one journal that would do this in one company and post the other side in the other?

      Author's profile photo Pankaj Sharma
      Pankaj Sharma

      Hi Adrian,

      You can use G/L Branch allocation feature of intercompany solution to get the desired results.

      Lets take your example, we have three companies Head Office, Company A and Company B.

      From the Head Office company, post the loan transaction to the Company A and Company B using G/L Branch Allocation feature for the amount of USD 10000 and allocate USD 4000 to Company A and USD 6000 to Company B.

      Company Head Office

      Credit Debit
      Bank Account 10000
      Due From Company A 4000
      Due From Company B 6000

      System automatically post the below transaction in the receiver companies  i.e company A and Company B to which allocation is made.

      Company A

      Credit Debit
      Bank Account 4000
      Due To Head Office Company 4000

      Company B

      Credit Debit
      Bank Account 6000
      Due To Head Office Company 6000

      If this is the recurring transactions, then you can also use the Recurring GL Allocation Postings feature.

      Hope this reply help.

       

      Author's profile photo Adrian Lauchlan
      Adrian Lauchlan

       

      Hi Pankaj

       

      Thanks for this- I tried this but now getting another issue - it hasn't been copied across because of the error below - how do I get it to retry and why am I getting lots of errors like this meaning intercompany transactions are not posting

      ntercompany Transaction :
      -----------------------------------------------
      Sender System: US_LIVE
      Sender Transaction Type: G/L Allocation
      Sender Transaction Number: 8939
      Receiver System: US_LIVE
      Receiver Transaction Type: Journal Voucher
      Receiver Transaction Number:
      Action:
      Status: Failure

      Error Details: com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: java.lang.Exception: Could not create native thread!

      Author's profile photo Pankaj Sharma
      Pankaj Sharma

      Hi Adrian,

      This error is a soft exception. You can retry this error from the intercompany message log.

      You can add the following parameters in the Java options for tomcat6w.exe to prevent this error in the future:

      -XX:+UseSerialGC
      -XX:+ReduceSignalUsage
      -XX:+DisableAttachMechanism

      Also, you can configure the Automatic retry of error messages in the Preferences tab of the intercompany administration console. So that such error can automatically go through.

      Author's profile photo Adrian Lauchlan
      Adrian Lauchlan

      Thanks Pankaj - we increased the Java memory and things are going through - will look at implementing your suggestions as well.

      Next question!

      The Allocation account field doesn't return any accounts. It did in my test environment but nothing displays now in the live account. I am guessing I have missed a setting. Could you tell me how to get the list of accounts available

      Author's profile photo Jenine Leymir Leonen
      Jenine Leymir Leonen

      Hi Intercompany Team,

       

      I'm currently trying to use the GL Branch Allocation feature of Intercompany, but I'm having an issue with it. Here is the scenario:

       

      I have 6 company database including the Consolidation Company, so lets say Company A B C D E and Consolidation.

       

      If I use Company A to allocate income/expense to other Companies, it will send an alert to other company databases that there was an allocation made or it will show the journal vouchers. But if I use the other company database to allocate, there is no alert/journal voucher made.

       

      I'm using SAP Business One 9.2 pl 7 and Intercompany Integration 2.0 version 22.

       

      I hope someone can help me on this.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Dear Jenine, Thanks for your question but unfortunately you just added this as a comment to this blog. This way, hardly anybody will be able to see the question you raised, it doesn't appear in generic streams and updates. If you still face that issue, please create a question on it. Thanks, Peter

      Author's profile photo Eric Alo
      Eric Alo

      Hi,

      Can the inter-company and consolidation add-on manage cost center reporting?
      The scenario is that we have x number of subsidiaries and all of them have the same Dimensions and Cost Centers (Eg. Department).

      Example Head Office pays IT expenses, HR expenses. HO sends an AR Invoice to Affiliate 1 with department breakdown.  Affiliate 1 allocates this to the different subsidiaries by sending an AP Invoice with department cost centers also.

      Will the consolidation/intercompany add-on handle the cost center component so that when we generate the consolidated reports the department cost center don't get charged multiple times.

      Thanks

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Eric, Affirmative, you can manage dimensions and cost centers. Both have to be defined on global level, then you can have corresponding reporting in the consolidation company.

      It's better to file questions like this separately under the ICO tag, here under the blog it might get missed/not answered due to the notification concept.

      Best regards, Peter