Missing transaction in document journal report with Transaction Code

[Former Member]

Dear Experts,

I am facing below issue when generating Document Journal Report from Financial --> Financial Reports --> Document Journal

1. When I run for 1 month report without selecting any transaction code the result is 1466 pages.

2. When I run for same period i.e. 1 month and click on expanded option to select all transaction code i.e start from blank to the last one under the result is of 45 pages only.

Please advise why selecting transaction codes removes so many entries.

Thanks Deepak.

[srinivas16]

I had found lot of missing Serial numbers when I Run  Transactions journals Report  for all transactions for the year 2024. The feedback i got from Support was when the automatic roll back happens it will be missed out, second reason was when we preview before posting it will skip the entry. Either of the cases, the DB should should consider the last posted Trans ID and update the next, but if it is missing the Auditors says either it is deleted by users or Bug.

[jitin_chawla · Accepted solution]

Hi,

May be if you post the screenshots, it would be better for understanding and checking the setting, if it may be because of the settings issue.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

Attached are screen shots of selection I used.

in option 2 I selected All trans code

Thanks Deepak

[Former Member · Accepted solution]

Hi,

The "Salary" is indeed the last one in the list, but it's not necessarily the last code in the system.

"Salary" is TransCode Description, but the report is run according to TranCode Code.

Change your filter settings to include the last correct TranCode.

Beni.

[Former Member · Accepted solution]

Hi Beni,

Salary is the last code as shown in screen shot above and also I checked on the JE

Thanks Deepak

[Former Member · Accepted solution]

Hi Deepak,

You must select the first code instead of leave it empty. Try to see what is the result. If you need include empty code JE, the only option will be deselect this expanded section.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

Thanks for your reply, we want to have blank and other code as well in the report i.e. from blank to Salaries.

If I deselect expanded section the report becomes very big in our case 1400 pages and if i select expanded its reduced to 45 page which I could not understand.

Please advise.

Thanks Deepak

[jitin_chawla · Accepted solution]

Hi,

Please check one transaction which is missing from the report upon different selection criteria and let us know the transaction code which is not included.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

I compared and found that Incoming payment, outgoing payment, reversal JE, AP invoice are missing when expanded is selected.

Thanks Deepak

[jitin_chawla · Accepted solution]

Hi,

Run the following query and see what all different transaction Code appears :

select distinct transcode from JDT1

It may seem that the problem can be with the journal entries which have with blank or NULL in the TransCode.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

I ran query in SQL and found NULL value as shown below

Thanks Deepak

[jitin_chawla · Accepted solution]

Hi,

Check one of the non-appearing transaction from Incoming payment, outgoing payment, reversal JE, AP Invoice and see what transcode is displayed.

Also, check the report by marking the Tans Code in the Expanded button and not selecting any of the values in the from and to fields. Compare the result with the trans Code not selected and see if it still differs.

Kind Regards,

Jitin

SAP Business One Forum Team

[kothandaraman_nagarajan]

Hi,

If you select transaction code ,the system generate the report as per selected transaction code. If not selected, the system will show all the transaction code as per date that you defined.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Rajan,

I have selected blank transaction code as well to cover transactions without code, I understand that should show all transactions, basically we want to exclude only one transaction type and include all rest in the Journal Report thats why using expanded option. However it drops lot of transactions.

Thanks Deepak