Branch Sales Analysis Report in Intercompany Solution

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:

  1. In the SAP Business One Main Menu, choose Sales A/R → Sales Reports → Branch Sales Analysis Report.
  2. Specify the selection criteria and choose OK. 

Selection window contains two tabs:

  1. Customers: Analyze the sales volume for each customer across branches.
    1. Invoice, Order, Delivery Notes: Select the document type on which you want to base the sales analysis.
    2. Posting Date From ... To...: Specify a date range. All transactions with a posting date within the defined range are included in the report.
    3. Due Date From ... To...: Specify a date range. All transactions with a due date within the defined range are included in the report.
    4. Document Date From ... To...: Enter a range of document dates for the chosen transactions to be displayed in the report.
    5. Customer: Specify the range of customer to include in the report.
  1. Items: Analyze the sales volume per item across branches.
    1. Invoice, Order, Delivery Notes: Select the document type on which you want to base the sales analysis.
    2. Posting Date From ... To...: Specify a date range. All transactions with a posting date within the defined range are included in the report.
    3. Due Date From ... To...: Specify a date range. All transactions with a due date within the defined range are included in the report.
    4. Document Date From ... To...: Enter a range of document dates for the chosen transactions to be displayed in the report.
    5. Items: Specify the range of Items to include in the report.

The Branch Sales Analysis Report is displayed.

  1. To display the sales 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

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

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

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

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

    • Un-Posted Intercompany Transactions Report in Intercompany Solution

      This report displays the real-time view of all Interbranch transactions which have not been posted by the receiver companies. The following Interbranch transactions are included in this report: Journal Vouchers created as a result of G/L Allocations. ...