Skip to Content
0

Journal Voucher gone missing

Dec 08, 2016 at 09:53 AM

137

avatar image

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

10 |10000 characters needed characters left characters exceeded

Hi all

Is it possible to trace whether Journal Voucher has been deleted manually without posting or it is system error?

0
* Please Login or Register to Answer, Follow or Comment.

10 Answers

Johan Hakkesteegt Dec 08, 2016 at 01:29 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Johan

Journal Voucher Number is system generated, it just disappeared and cannot be found in Journal Voucher window and backend Query.

0

without posted accounting entries

0
Jitin Chawla
Dec 09, 2016 at 06:03 AM
0

Hi,

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

Regards,

Jitin

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Dec 29, 2016 at 03:56 AM
0

Hi Jitin

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


poiij.png (334.1 kB)
6fff4.png (146.9 kB)
Share
10 |10000 characters needed characters left characters exceeded
Jitin Chawla
Dec 29, 2016 at 05:05 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Dec 29, 2016 at 07:00 AM
0

Hi Jitin

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

Share
10 |10000 characters needed characters left characters exceeded
Jitin Chawla
Dec 29, 2016 at 08:03 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Jitin

Should we log case to SAP Support Center as many users are giving the same feedback in different Hana databases?

0
Kedalene Chong Jan 09, 2017 at 04:17 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Johan Hakkesteegt Jan 09, 2017 at 08:00 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Jan 10, 2017 at 08:34 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Jan 13, 2017 at 04:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded