Skip to Content
avatar image
Former Member

ISU Billing:Difference between Net amount in Billing doc header and Net amount in DBERCHZ3 table

Hi Experts,

I noticed difference between Net amount (energy charge) in Billing doc header and Net amount in DBERCHZ3 table while doing testing.

For Example: Net amount in Billing doc showing as 0.5 JOD (Jordian Dinar) where as in

DBERCHZ3 table it showing as 5.0 JOD. Ideally it should 5.0 JOD after valuating with energy consumption and energy price. Further same values are transferred to Print doc.

Note: Configuration setting related to Decimal Places in Currencies is done for JOD as 3 decimals (Table TCURX)

Please help me to resolve above issue.

Thanks,

Vaseem

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 18, 2016 at 12:53 PM
    -1

    Hi Vaseem,

    I hope you are aware that in EA22 -> SIngle Lines will only show the details of only particular line, ideally you should see Dec. Overview tab to see all the line items for the billing document. You can compare those with that of the tables DBERCHZ1 - DBERCHZ3.

    I think you might have applied filter(s)/sort etc... Can you please share screen-shot of EA22 Doc Overview and DBERCHZ3 tables - you can compare 'Line item' with DBERCHZ1-BELZEILE.

    Hope this helps to see your discrepency if any.

    Thanks,

    Srini

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 06:44 AM

    Dear Vaseem,

    could you please explain a little bit more in detail? What do you mean with Net amount in billing doc header? There is no Net amount stored within the header.

    Best regards
    Jörg

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2016 at 03:41 PM

    Dear Joerg,

    I mean to say Net Amount in Billing document tabs (i.e. Single Lines>Overview) screen there is field with Net amount.

    Here is the issue .For Example: Net amount in Billing doc showing as 0.5 JOD (Jordian Dinar) where as in

    DBERCHZ3 table it showing as 5.0 JOD. There is mismatch of Net amount.

    Ideally it should be 5.0 JOD after valuating with energy consumption and energy price. Further same values are transferred to Print doc. But in my case 0.5 JOD is passed to Print doc.

    Note: Configuration setting related to Decimal Places in Currencies is done for JOD as 3 decimals (Table TCURX)

    Please help me to resolve above issue.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 06, 2016 at 02:38 PM

    Hi Friends,

    Any solution or workaround to resolve above issue?

    Thanks,

    Vaseem

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 07:51 AM

    Dear Abdul,

    I'm sorry from this description it is hard to answer your question. I would recomment to prepare a example document and open an Incident. Within the incident we can have a look into your system and check what's going wrong.

    Best regards

    Jörg

    Add comment
    10|10000 characters needed characters exceeded