WDF 1938908 - How to Find Sales Type Intercompany Transactions That Need to Be Eliminated from Consolidation Company
Symptom
How can you find sales type Intercompany transactions that need to be eliminated from the consolidation company?
Cause
Functionality Description
Solution
Before you perform the financial consolidation process in the consolidation company, ensure that in the branch companies, you have defined the account type Sales for all revenue accounts available in the Chart of Accounts window.
Any transaction executed after you have fulfilled the above prerequisites will be marked with the elimination flag and additional information in the consolidation company.
To run the document journal report, perform the following steps:
- In the consolidation company, choose Financials → Financial Reports → Accounting → Document Journal.
- In the Document Journal - Selection Criteria window, specify the selection criteria for the document journal report.
- Choose the Expanded button.
- In the Expanded Selection Criteria window, choose the User-Defined Fields checkbox and choose the (…) Browse button next to User-Defined Fields.
- In the User-Defined Fields window, select Elimination (row); set Rule as Equal and Value as Y.
- Choose the OK button.
- In the Expanded Selection Criteria window, choose the Update button.
- In the Document Journal - Selection Criteria window, choose the OK button. The application displays the document journal report according to your selection criteria.
- In the Form Settings window, display the IC Branch Code (row) and the To Branch Code (row) fields.
Note:
The IC Branch Code field represents the company originating the transaction.
The To Branch Code field represents the company receiving the transaction.
The document journal report displays the details of Intercompany sales transactions with information on transacting companies. Users can create the elimination journal entries with the help of the Intercompany sales data provided in this report.
Other terms
elimination, sales type account, financial consolidation, JE, journal entry
Products
B1 INTERCOMPNY INTEGRATION 2.0
SAP B1 VERSION FOR SAP HANA all versions
SAP BUSINESS ONE all versions
Related Articles
WDF 2510017 - Fails to consolidate the Journal entries to the consolidation company
Symptom The following error occurs while importing the Journal Entries to the consolidation company: "BPE154 ScriptExecutor not yet initialized for function Further details:scriptGroup: /com.cxs.b1i.ipo/js/B1ifMathUtils.js(unified)" Reproducing the ...WDF 2520006 - The information from the Ref.1, Ref.2, and Ref.3 columns at the line level of the Journal Entry is being integrated into the consolidation company
The information from the Ref.1, Ref.2, and Ref.3 columns at the line level of the Journal Entry is being integrated from branch companies to the consolidation company. This enhancement ensures that all relevant reference information is accurately ...WDF 3156199 - Unable to replicate checkbox Adj. Trans. (Period 13) information at journal entry to participating consolidation company
Symptom Unable to replicate checkbox Adj. Trans. (Period 13) information at journal entry to participating consolidation company Reproducing the issue Prerequisites: You are using Intercompany Integration Solution PL44 or lower. Scenario: Unable to ...WDF 2177037 - Troubleshooting Tool for Intercompany Solution
Symptom The Troubleshooting Tool for Intercompany Solution is designed to help partners or customers to identify problems themselves or export all necessary information when creating support incidents. Any effort for operating or troubleshooting in ...WDF 2000012 - The error "Unable to fetch license information, please try again" occurs when running the consolidation process or intercompany report
Symptom The following error occurs while running the consolidation process or intercompany report: Unable to fetch license information, please try again. Reproducing the issue Prerequisites: You are using the intercompany solutions version 41 to ...