You’re offline. This is a read only version of the page.
1,440
Is there a way to automate running the Inventory Reconciliation process? It would be nice to automatically have that run every night at midnight.
Any ideas would be appreciated!
Thanks,
Ryan
*This post is locked for comments
I have not tested the AX function against GP as I am not sure that would work.
Thanks for the tip on the macro.
Have you tested the AX function against GP? Not sure if it is compatable.
One thing that can be done is to record a macro that can be run when GP is launched that will start the inventory reconciliation. Use the workstation functions to launch GP with the macro. It will run the reconciliation but leave the workstation logged in.
There is a new report released for AX2009 Sp1 that will allow you to do this per day to day. The report will display an Inventory balance and GL balance for the selected date range and also list the transactions that has coursed any imbalance.
The report can be run in batch meaning that you can use the recurrent batch. The report also allow to use Date interval codes so you can create a Date interval code equal current date. The problem is though that you want to run this during night and Date interval codes uses current system date to figure out the date interval. The issue that you can not control when the batch job is executed before or after midnight.
In your case you will have to enter the From and To date manual and then execute the report in batch
Here is a link to the Whitepaper: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=001e98e3-a83e-43be-b3a9-a38b26912f46
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (