Consolidated Balances by Business Partner Report in Intercompany Solution

Consolidated Balances by Business Partner Report in Intercompany Solution


This report displays the real-time consolidated account balances of the business partners that are relevant to branch companies from across branch company databases, for example, business partners that have Global Business Partner selected on the Business Partner Master Data window.

Procedure

To run the report:

  1. In the SAP Business One Main Menu, choose Business Partners → Business Partner Reports → Consolidated Balances by Business Partner.
  2. Specify the selection criteria and choose OK. 
  1. Type: Select the business partner type (Customer or Vendor) whose balances should be displayed.
  2. Code: Select the business partner codes whose balances should be displayed. Leave this filter blank to display balances for all business partners.
  3. View: Select how the balances should be displayed. The summary view sums up balances for each business partner across all branch companies. The detail view displays balances for each business partner in each company.

The Consolidated Balances by Business Partner window is displayed.

​
  1. To display the business partner balances data, choose Refresh.


 Note

  1. The user can export the report data to CSV using the Export to CSV button in all the intercompany reports. When Intercompany reports are exported in CSV format, the data is typically structured in a plain text file with values separated by commas.

This format is easy to read and process, making it suitable for sharing data between different systems or for further analysis.

  1. The user can use the Copy to Clipboard button to paste the report data into different applications.

    • Related Articles

    • Consolidated Balances for Business Partners in Intercompany Solution

      This enhancement periodically replicates the account balances, delivery balances and order balances of global business partners across branch companies. To use this feature, on the Preferences page of the Intercompany Administration Console, set up ...

    • Branch Balances Report in Intercompany Solution

      This report displays the real-time consolidated account balances for all payables and receivables between branch companies. Note If you define the separate g/l accounts in due from and due to fields in branch account setup then this report will ...

    • Consolidated Credit Limit Check in Intercompany Solution

      This feature restricts the creation of sales documents for customers and prompts a warning message according to the following parameters setup on the BP tab of the General Settings window in SAP Business One. A warning message will appears if <the ...

    • Intercompany Transaction Report in Intercompany Solution

      Branch companies can use this report to determine all Interbranch transactions. Note The Intercompany Transaction Report displays a log of all outgoing and incoming intercompany transactions. This log does not confirm that an outgoing transaction has ...

    • Branch Sales Analysis Report in Intercompany Solution

      Branch Companies can use the Branch Sales Analysis Report to determine the sales across Branch companies. This report displays the real-time view of Sales data across branch companies. Procedure To run the report: In the SAP Business One Main Menu, ...