Vendor Period Trial Balance

(0) Share

Report

Posted on by Deb Lashua

2,165

We have multiple companies and in one company the vendor period trial balance hangs and will not complete printing. I have run the following statement and it allowed access once. But then reverted back to the report hanging up.

grant

select on vs_company to

public

grant

select on vs_company to E7F575915A2E4897A517779C0DD7CE

The report continues to hang up. If we end task it, we receive system message 7011 - ROI Get RIPARAM failed for CRPERC and for CRPEMSGCNT. I have reviewed article 905595 on this error message to see if there was something that might resolve the issue.

Does anyone have any suggestions on how we can correct this?

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor Period Trial Balance

Worked for me!

Thanks!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor Period Trial Balance

This script worked for me. Thanks!
Verified answer

Deb Lashua 2,165 on at

Like (0)

Report

RE: Vendor Period Trial Balance

We were able to resolve this by reindexing. Thank you.
Carolyn Kolpien on at

Like (1)

Report

RE: Vendor Period Trial Balance

Hi Deb,

Most likely you are running into bug 14887. Just run the statement below to create an additional index and let me know if it resolves the problem.

CREATE INDEX [APDocX1] ON

[dbo].[APDoc]

(MasterDocNbr,S4Future11)

Thanks,