SAP B1 User Account Related Error

[Former Member]

Hi all,

We just want to share if anyone experience a user account cause of error when Filtering Reports for General Ledger?

We want to know what might cause this so that we can prevent this concern in the future.

Our solution for the mean time was to create a new user and copied the same Authorization details from the old user account and this works fine.

Thanks in advance!

Teng Pereras

[Johan_H]

Hi Teng,

Please also tell us what the error was.

Regards,

Johan

[Former Member]

John,

This is the scenario.

Run the General Ledger report with a filtered list of accounts. The General Ledger ignores the account selection and runs over all accounts. This happens only for two users. The filtering of GL accounts for other users working correctly.

Reproducing the issue

Scenario:
1. From the SAP Business One Main Menu choose Financials ->Financial Reports-> Accounting-> General Ledger.
2. Set the Selection Criteria (Select Document Date from - to for example).
3. In the Selection Criteria window choose a sub-range of accounts.
4. Run the report.
5. After running the report, go back to the Selection Criteria window and clear the account range. Then, select accounts using the Find Account window and make sure all other criteria is updated.
6. Run the report again.

Actual Behavior:

The report runs over all accounts instead of the specific selected accounts.

Expected Behavior:

The report runs only over the selected accounts.

Thanks!

Teng Pereras

[Former Member]

Hi Teng,

In this case you always need to Cancel the general ledger Selection Criteria window and again open the selection criteria window and then try.

Thanks,

Harshal

[Johan_H]

Hi Teng,

I cannot reproduce this, but you did say that it only happens for two users. To determine whether this is about the users or their machines, please test the following:

• with one of the affected users, log into B1 on a machine of a user that does not have this issue. Now try to reproduce the issue.
• If you can reproduce the issue, please log into B1 on the machine that the user usually uses (the machine that the issue was originally discovered on), but with a user that does not have the issue. Now try to reproduce the issue.

Please let us know how it goes.

Regards,

Johan

[Former Member]

Johan,

When the user account is used on other workstation, same issue arises.

And when other user account was used on the workstation owned by the user with issue, there is no problem doing the said transaction.

We think that something happened to the user account, we just want to know what might that be so that we can prevent it form happening again.

Thanks!

Teng Pereras

[Johan_H]

Hi Teng,

In this case, there is nothing you can do yourself to find out what the problem is. I would recommend the following approach:

1. If you do not have the Remote Support Platform installed, install it on the server.
2. Check all tasks in the RSP, to see if there is one that addresses this issue specifically, or that addresses any other user related issues.
3. Run all such tasks that you may find.
4. If there are no such tasks, or running them does not solve the issue, log a support message with SAP.

It sounds like a database corruption of user settings. This happens sometimes, and it can only be solved by SAP.

Regards,

Johan