Symptom
- The execution of Unified Reporting Israel presents an issue with a negative sign for the Credit amount in the BKMVDATA file in section B100 and B110.
- Some Tax Authorities in Israel only accept the Credit Amount without negative sign in the BKMVDATA file.
Environment
SAP Business ByDesign
Reproducing the Issue
- Navigate to the General Ledger Work Center.
- Select Unified Reporting - Israel.
- Search for the relevant Run ID AAA (where AAA is the Unified Reporting Run ID).
- Highlight the application log ID BBB (where BBB is the Application Log ID).
- Click on View Report Run Results.
- Switch to the Attachments tab.
- Download and open the BKMVDATA File in Notepad++.
- In Notepad++, format the File to see the special characters correctly as per: Encoding - character sets - hebrew - OEM 862.
- Search for B100 in the file.
There is a negative sign just right in front of the Credit Amount usually in column 207 (after the "2" in column 203 which already announces a Credit amount. For your reference a "1" is a Debit amount and accompanied by a plus sign).
Cause
In the BKMVDATA File the standard Display of Credit Amount is with a negative sign before the amount.
Resolution
- Go to the General Ledger Work Center.
- Go to the Unified Reporting - Israel view.
- Press New - Unified Report Run.
- Open personalization mode.
- Under Report Parameters, check the "convert sign" checkbox.
- Save it.
- Close personalization mode.
- Tick the checkbox "convert sign", fill out the other parameters and run the Unified Report Run.
This way in the BKMVDATA File the credit amount will not have a negative sign.
Keywords
Unified Reporting Israel, General Ledger Work Center, BKMVDATA file, incorrect entries, B100, B110, Debit, Credit, sign reversal, convert sign, negative Credit Amount , KBA , SRD-FIN-GLO-REP , GLO - Statutory Reporting , Problem
Product
SAP Business ByDesign all versions