cancel
Showing results for 
Search instead for 
Did you mean: 

Missing transaction in document journal report with Transaction Code

Former Member
0 Kudos
453

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.

Accepted Solutions (1)

Accepted Solutions (1)

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
0 Kudos

Hi Jitin,

Attached are screen shots of selection I used.

in option 2 I selected All trans code

Thanks Deepak

Former Member
0 Kudos

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
0 Kudos

Hi Beni,

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

Thanks Deepak

Former Member
0 Kudos

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
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
0 Kudos

Hi Jitin,

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

Thanks Deepak

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

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
0 Kudos

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