Symptom
- An issue is encountered with the application "Unified Reporting - Israel" under "General Ledger".
- The generated file is incorrect and missing several essential fields.
- The Error Message associated with this issue in the backend is "Processing of message &1 stopped; message already in process".
Environment
SAP Business ByDesign
Reproducing the Issue
- Navigate to the General Ledger Work Center.
- Access the Unified Reporting - Israel view.
- Display all runs and select run ID XX (where XX is the Unified Reporting Run ID).
- Highlight Application Log ID YYY under Details (where YYY is the Application Log ID).
- Click on View Report Run Results.
- Switch to the Attachments tab.
- Download the BKMVDATA and INI files.
- In Google Chrome open page https://secapp.taxes.gov.il/TmbakmmsmlNew/frmCheckFiles.aspx (you might need to change VPN settings to open that page).
- Translate Page to English via clicking on the three dots on top right of the Browser - Translate - English.
- Under "You have to choose" select Windows (ANSI).
- Upload the two files INI.TXT and BKMVDATA.TXT here via clicking on choose File option.
- Again translate the result and you can see the Errors.
- Click on the detailed Report of the Errors below in the same window.
- You can see two errors in INI file check and a lot of errors in BKMVDATA file test.
- In the INI file the two errors mean: 1003: "the ID of the tax number is not found" and error 1018 "the name of the Business is not found".
- In the BKMVDATA file there are way more errors.
- Open BKMVDATA file with Notepad++
- Click on Encoding - Character Sets - Hebrew - OEM 862 to see the correct file structure.
If you go from the beginning of the file there are zeros when you scroll to the right from column 194. This is not as expected. There should be
values here.
Also when you search for AR and AP when you scroll to the right you can only see empty (zero) lines. Here also values would be expected.
Cause
The issue arises due to the absence of a corresponding Business Partner for the Company ID ZZZ (where ZZZ is the company ID) in the Business Partner BO (BUSINESS_PARTNER_TMPL). This discrepancy is due to the allocated Number Range in the Business Partner Number Range Type under Business Configuration. Development needs to do a backend correction here.
Resolution
Please open a case to Technical Support with permission for backend correction.
See Also
For reference, please refer to KBA 3447032 - Unified Reporting Israel - Incorrect files which doesn't have any data for B100 records and VAT Registration number in the summary form.
Keywords
Unified Reporting, Israel, Incorrect File, Missing Fields, Business Partner, Company ID, Number Range, Business Configuration, Document Type, NB, UB, Conditions, STO, ID of Tax Number not found, Name of the Business is not found , KBA , SRD-FIN-GLO-REP , GLO - Statutory Reporting , Problem