15
New to an SL client running 2015CU3. The ARHist table does not seem to be updating the Sales columns for the past 2 years and, as a result, the A/R Integrity report is always filled with errors.
Two questions:
1. Is there a way to get it to start updating again?
2. Is there a way to get it to recalculate and repopulate the previous columns in the table
This didn't change anything. The AR Integrity check does NOT recalc the AR Hist from AR Doc. What might be stopping that? Maybe the two are related.
When they post invoices, they do it through Flexible Billings if that matters to the update procedure that runs.
I ran into a similar issue years ago and resolved it by running the Sync Ownership and Security process. It may be a permission issue on a stored procedure.
Hello,
It should update Sales in ARhist as you release an invoice batch in AR Invoice. You don't get any error?
Do you manually enter transactions or is there some other program that imports them in?
The AR integrity check should fix the table. If you are getting errors you might consider opening up a case with Microsoft support for the issue.
I do see my arhist table is updated in cu3 with sales for the current fiscal year/period. So i don't see there is any bug reported related to the issue. Are you selecting for all companies or in a single company?
Best Regards,
Jana MacDonald
#1
Abhilash Warrier
565
#2
Martin Dráb
536
Most Valuable Professional
#3
André Arnaud de Cal...
402
Super User 2025 Season 1
Share
Report
All responses (
Answers (
