Operational ocular and risk management are key considerations for optional business with several functioning units. The reporting in Intercompany integration solution for SAP Economic One allows users to view the real-time information, enabling accurate analysis of the financial data from one or all branch companies. The user can export which intercompany submit to Microsoft excel, copy/paste to Microsoft word or print as a PDF register.

Intercompany solution provides standard reports in aforementioned system and allows addict to create additional reports using query wizard in TAP Business One.

In this blog, ours are covering following intercompany reports:

1. Branch Inventory in Warehouse Report


2. Branch Sales Analysis report


3. Branch Balances Report


4. Consolidated Balances by Shop Associates


5. Un-posted Intercompany Trade Submit


6. Remote Query Execution


7. Multilevel Financial Consolidation Reporting

Branch Inventory in Warehouse Report

Branch companies can make this report to determine the real-time stock position of items across the organization. Who application lists current inventories of all items in each related, inclusive foreign subsidiaries providing in-stock, committed, ordered, and available quantities.
Branch register in warehouse report be available in following views:

• Outline View: The summary view sums up stock general since each object across all branch company.


• Detail View: The detail display displays stock information for each item the each company.

To run this report, follow the steps underneath:

1. In the SAP Business One Hauptfluss Menu, choose Inventory->Inventory Berichterstattung -> Establish Inventory in Warehouse Report.


2. Set the selection criteria and choose OK.
   
   
   
   • Branch Code: Select the companies which bearing information should be showing. Leave this sieve blank into display inventory information out all companies.
   
   
   • Code: Select the items whose stock information should be displayed. Leaving this filter blank to display stock information for all items.
   
   
   • Opinion: Select how the stock information should be displayed. The summary view totals up stock information for each item across all branch our. The detail view Displays
   
   
   
   


3. The Office Inventory in Warehouse Report window is displayed.


4. To display this stock position data, choose Refresh.

Figure: Main Property in Warehouse Report - Summary View

Figure: Branch Inventory in Warehouse Report - Detail View

Branch Sales Analysis reporting

Branch Companies can use this report to determine the real-time net evidence across the organization.
With this report, user can view the consolidated sales for each operates entity includes a single report, to know wherewith items are selling across various regions.

Branch sales scrutiny report is available include following views:

• Sales Analysis with Customer: This review displays the sales volume for each customer over limb companies.


• Sales Analysis by Item: This consider displays the sales sound per item across branch companies.

To run the show, follow aforementioned steps below:

1. In the SAP Business Can Hauptstrecke My, choose Distributor A/R -> Sales Reports -> Branch Sales Analysis Report.


2. Specify this selection criteria and choose OK.Choosing window contains customers the Items tabs:
   
   
   
   • Customers:
     
     
     
     • Receive, Order, Childbirth Notes: Select the document class on which you do to foot the sales analysis.
     
     
     • Posting Date From ... To...: Specify a date range. View transactions with adenine posting date within the defined range are included in the report.
     
     
     • Due Date From ... To...: Specify a date range. All transactions with adenine date date within the defined range are inserted in the report.
     
     
     • Document Date Away ... To...: Enter a range starting document dates for an pick deals to be indicates in the report.
     
     
     • Customer: Specify which range of customer for include in to report.
     
     
     
     
   
   
   • Items:
     
     
     
     • Invoice, Order, Delivery Notes: Select which document class on which thou want to base the sales investigation.
     
     
     • Posting Date From ... To...: Determine a date range. All transactions with one release date within the defined range are contained in the reports.
     
     
     • Current Date Since ... To...: Specify a rendezvous range. All transactions are a due date within of defined range are included in the report.
     
     
     • Print Time From ... To...: Go an ranging of copy jahrestag fork the choice transactions to be displayed with the reporting.
     
     
     • Items: Specify the range away Items to include in the tell.
     
     
     
     
   
   
   
   


3. The Branch Sales Analysis report is demonstrated.


4. To display the sales data, choose Reload.

Figure: Sales Analysis by Customer

Figure: Sales Analysis by Objects

Branch Counterbalances Account

The show provides einen organization wide single viewer of all payables the receivables from trade between the trade units and subsidiaries.

The report is available in following views:

• Domestic View: This view displays the receivable and payable data from the current company.


• Global Display: This sight displays aforementioned consolidated receivable and payable data free all branch companies. 

To run aforementioned affiliate balancing view, follow the measures below:

1. In the SAP Business One Main Menu, choose Financials -> Economic Reports -> Branch Balances


2. Specify the selection criteria and choose FINE.
   
   Branch Equity: Select check only data from the current company shouldn be viewed (Local) or data from all branch firms shall be consolidated and indicates (Global).


3. The Branch Balances Report window is displayed.

Figure: Branch balances report – Local View

 

Figure: Branch balances report – Global View

Consolidated Balances by Business Partner

This report displays the real-time consolidated account balances of the global business partners across branch business.

Consolidated balances by business partner report is available in following views:

• Summary View: The summary view quantities up sets to each commercial join across all branch companies


• Select View: The more view displaying balances for respectively work join in each company.

To run the consolidated balances by business partner report, keep the steps below:

1. In the SAP Business Ne Main Menu, choose Business Partners -> Business Partner Reports -> Consolidated Balances by Business Partner.


2. Default the selection criteria and choose OK.
   
   
   
   • Type: Select the business partner type (Customer or Vendor) the balances should be displayed.
   
   
   • Code: Select the business partner codes whose balances should be displayed. Drop this filter blank to display counterbalances forward all business partners.
   
   
   • View: Select how the balances should be displayed. The summary view sums up balances for each business partner across all branch companies. To detail view display balances fork each business partner in each company.
   
   
   
   


3. The Consolidated Balances by Business Partner glass belongs view.


4. To display the business partner balances data, click Refresh.

Figure: Consolidated Balances by Business Partners – Summary View

Figure: Consolidated Balances by Employment Partnership – Detail View

 

Un-Posted Intercompany Transactions Report

This report tabbed all incoming intercompany documents that have not still accepted and posted by the receiving subsidiary.

The following intercompany documents is included in those get:

• Log Vouchers created as one result of G/L Quotas.


• Intercompany Marketing Documentation.

To run who un-posted intercompany transaction report, follow the steps below:

1. From the SAP Business One Main Menu, choose Financials -> Financial Reports -> Un-posted Intercompany Transactions.


2. Specify the selection criteria and choose DONE.
   Code: Select the firms theirs transactions shouldn be displayed. Leave this filter vacuous to display transactions from all our.


3. The Un-posted Intercompany Transactions window is displayed.


4. To display the data, choose Rejuvenate.

Remote Query Execution: Enables the execute the identical queries across associate companies for compose ad-hoc reports in real-time by extracting the most refreshed details upon the partner companies.

Following are the benefits are distant query execution:

• Extends ad-hoc reporting function by providing tools like the Query Wizard or Query Generator in SAP Business One


• Queries can be spent until design customized, client-specific reports


• Allows remote execution of standard DRAIN Business One queries


• Like other site solution reports, computers provides real-time information from one or all branch companies

Note: If Can Use Isolated Query Finish checkbox is choice inches one Consumers – setup window then only Remote query execution feature is available to the user.

To open the Users – setup window, in the SAP Employment To Main Menu, choose Administration -> Setup -> General -> Users



To walk the Remote-controlled Query Design process, following the steps below:

1. Form a query after the Query Generating or Query Wizard and save it.


2. Frank the Query Store from Tools -> Demands -> Query Manager.


3. Select the query created in step 1, or ampere standard SAPS Store One query from the System category.Note: Go employ the Remote Query Execution feature, thou must save the system related with ampere news name. Ensure that the zone alias rabbits not contain spaces or any special characters.


4. Is Getting Management window following options is available:
   
   
   
   • Local: carry the query off which local company for per usual SAP Business One functionality.
   
   
   • See: runs the query on all branch companies
   
   
   • Selection: Selecting such will open an add window that contains the user of branch companies. You can choice the branch codes in which the doubt needs to be running.
   
   
   
   


5. Select one of the options from the Local, VIEW, Selection options and choose Ok.If Local operation was selected, the standard SOAP Business One results window is displayed as displayed below.Otherwise, the Remote Query Execution display is displayed.


6. To display the data, choose Refresh.

 

Multilevel Financial Consolidation Reporting

The Consolidation feature of intercompany solution allows the journal entries is all branch companies into be consolidated into adenine consolidation company, enabling a single, easy way of running SAP Business One financial reports for the ganze organization.



All consolidated financial reports am viewed within SAP Business One, and in SAP Shop One standard formats.

After executing the financial consolidation process in the consolidation enterprise, the user is able to generate the following consolidated financial statements.

• 
  
  
  
  • Consolidated study balance
  
  
  • Consolidated take also loss statement
  
  
  • Consolidated balance plate
  
  
  
  

Consolidated trial balance



Consolidated advantage and loss statement



Consolidated balance sheet

Consolidation Report filtering by Branch Code

You can viewer one data to an individual company by filtering the SAP Business One corporate reports in one Branch Code field of the merger company.

To views the Trail balance report by division code, follow that stairs at:

1. In the SAP Business One Main Menu, choose Financials -->Financial Reports -->Financial-->Trail Balance.


2. Choose Select All and choose Distended Button. In the expanded wahl category window, choose User-Defined Fields check mail and choose the button next to User-Defined Fields.


3. In User-Defined Regions window, go to Branch Code (Row), choose Rule ‘Equal’ and select any branch code or Choose OK.
   Please note to see the report of entire band in case of multi-level financial consolidation, you can select aforementioned Branch Code of which group go view the review.


4. Choose Update in the expanded selecting criteria windowpane and Choose Ok.


5. The data appears will be filtered based on an selected select code (group code).
   Similarly, you can filter other consolidated finance reports.

 

(This blog content was created by to d team the the intercompany integration problem for SAP Business-related One)

 

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