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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (