Branch Balances Report in Intercompany Solution

Branch Balances Report in Intercompany Solution


This report displays the real-time consolidated account balances for all payables and receivables between branch companies. 

Note

  1. If you define the separate g/l accounts in due from and due to fields in branch account setup then this report will include the balances from the following:
    1. For receivables this will include the balance for the customer account and the due from account
    2. For payables this will include the balance for the vendor account and the due to account.


  1. If you define the same g/l account in due from and due to fields in branch account setup then this report will include the balances from the following:
    1. For receivables this will include the balance for the customer account and the account define in due from/due to  account 
    2. For payables this will include the balance for the vendor account.

Procedure

To run the report:

  1. In the SAP Business One Main Menu, choose Financials → Financial Reports → Branch Balances
  2. Specify the selection criteria and choose OK. 

Branch Balances: Select whether only data from the current company should be displayed (Local) or data from all branch companies should be consolidated and displayed (Global).

The Branch Balances Report window is displayed.

  1. For the global view, to display the 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 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 ...

    • 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 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, ...

    • Branch Inventory in Warehouse Report in Intercompany Solution

      Branch companies can use this report to determine the real-time stock position of items that are relevant to branch companies, that is, items that have Global Item selected in the Item Master Data window. Note Global Items code and their description ...

    • 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 ...