Skip to Content

Journal Voucher gone missing

Hi all

Any idea is this a system bug in SAP Business One Hana when Journal Voucher Numbers gone missing by itself when user have not posted with that number?

User also claim they did not accidentally deleted the Journal Voucher Number.

There is no trace in obtf Query Table at all.

Kedalene

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Dec 08, 2016 at 01:29 PM

    Hi Kedalene,

    Are the Journal Voucher numbers determined manually, or are they a running number ?

    You could check if it was made with this little query (just input the missing voucher number):

    SELECT T1.[TransId], T1.[BatchNum] 
    FROM OBTD T0
         INNER JOIN OJDT T1 ON T0.BatchNum = T1.BatchNum 
    WHERE T0.[BatchNum] = [%0]

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 09, 2016 at 06:03 AM

    Hi,

    Can you please share a screenshot of the issue if possible?

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 03:56 AM

    Hi Jitin

    Please see screenshot. This happens to several company Hana databases.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 05:05 AM

    Hi,

    Can you let us know, if you or user can reproduce the issue?

    It seems that the Journal Voucher was deleted when in draft mode and the next number in the Journal Voucher has not updated to the correct one.

    Kindly check in DEMO Database by entering 3 JV's in DEMO database and delete the JV number 2 and see if the number gets updated for the 3rd JV to 2nd or not.

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 07:00 AM

    Hi Jitin

    If user claims that they did not manually delete Journal Voucher, how to trace for evidence?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 08:03 AM

    Hi,

    There is not table which stores the data for such deletion.

    Since this is only a draft document (for Journal Entry), its removal does not have any impact on the database values and hence the trail is missing.

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 04:17 AM

    Hi Jitin

    I witnessed in our client's HANA Client computer, a Journal Voucher Number is skipped and missing when I click add Entry to New Voucher then closed without saving.

    However it is intermittent only.

    Any such problem if multiple SAP Users are using Journal Vouchers? I temporarily set all other Users to READ only Authorizations except one User for observation.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 08:00 AM

    Hi Kedalene,

    I think it would be best if you report this issue to SAP support. It may help if you can specify the dates and approximate times the issue occured.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 08:34 AM

    Journal Voucher Numbers are skipped and missing when Users did not manually remove any Open status Journal Entry.

    Actually the skipping number occurs to the first Journal Voucher added everytime logging B1.

    SAP development team had already looked into this issue and confirmed it is the current behaviour in SAP Business One version for SAP HANA as described in Note 2401654 and 1966134.

    We now have to submit request for this missing functionality affecting HANA database.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2017 at 04:44 AM

    Hi all

    We have received confirmation from SAP Support Center Development Team this is a current system behaviour in SAP Business One version 9.2 for SAP HANA as described in relevant SAP Notes 2401654 and 1966134.

    We have helped submitted the idea for improvement of this missing functionality at https://ideas.sap.com/D39874 for regional voting. Please help to vote for better change and improvement, thanks!

    Kedalene

    Add comment
    10|10000 characters needed characters exceeded