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 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 ...WDF 2490019 - Text type UDF is not visible in the UDF Data Replication screen after it is created using the UDF Structure replication process
Symptom Text type UDF is not visible in the UDF Data Replication screen after it is created using the UDF Structure replication process in Intercompany Solutions. Reproducing the issue Prerequisites: You are using Walldorf Intercompany version "48 or ...WDF 3042698 - Unable to sync mobile phone of contact in Dynamics 365 Sales to contact person of BP master in connected B1 company
Symptom Mobile phone of contact in Dynamics 365 Sales does not synchronize in contact person of BP master in connected SAP Business One company. Reproducing the issue Prerequisites: You are using Intercompany Integration Solution PL41 or lower. ...