SAP Knowledge Base Article - Public

3600899 - Unified Reporting Israel BKMVDATA File has Negative Sign for Credit Amount

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

  1. Navigate to the General Ledger Work Center.
  2. Select Unified Reporting - Israel.
  3. Search for the relevant Run ID AAA (where AAA is the Unified Reporting Run ID).
  4. Highlight the application log ID BBB (where BBB is the Application Log ID).
  5. Click on View Report Run Results.
  6. Switch to the Attachments tab.
  7. Download and open the BKMVDATA File in Notepad++.
  8. In Notepad++, format the File to see the special characters correctly as per: Encoding - character sets - hebrew - OEM 862.
  9. 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

  1. Go to the General Ledger Work Center.
  2. Go to the Unified Reporting - Israel view.
  3. Press New - Unified Report Run.
  4. Open personalization mode.
  5. Under Report Parameters, check the "convert sign" checkbox.
  6. Save it.
  7. Close personalization mode.
  8. 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