I am wondering is there is any way to schedule recon (SO, PO and Inventory) runs. I.e. if GP reconciliation can be somehow invoked not from GP client but rather from command line, in order to be able to schedule automated runs of recon.
We are on GP 2016.
Thank you
*This post is locked for comments
Excellent! Thank you very much Leslie!
What you can do is record a macro that logs in to Dynamics GP, runs the Utility and then logs out. You would then create a batch file that would fire off the launch of GP an automatically run the macro. The command line to launch GP and run the macro would look like this:
"C:\Program Files (x86)\Microsoft Dynamics\GP2013\Dynamics.exe" Dynamics.set Login.mac
In the above example, the 'Login.mac' file is in the root directory of Dynamics. The macro would require the user ID and password to be hard-coded into the file. The macro itself would look something like this:
# DEXVERSION=12.00.0270.000 2 2
CheckActiveWin dictionary 'default' form Login window Login
MoveTo field 'User ID'
TypeTo field 'User ID' , 'userID_here'
MoveTo field Password
TypeTo field Password , 'password_here'
MoveTo field 'OK Button'
ClickHit field 'OK Button'
NewActiveWin dictionary 'default' form sheLL window sheLL
ShellCommand 'Navigate to \cmdNavigationPane\SalesButton\SalesAreaPage' # Sales
ClickHitIE , 'dexterity/.../args=0,1567,47' # http://dexterity will be pre-pended
NewActiveWin dictionary 'default' form 'RM_Reconcile' window 'RM_Reconcile'
ClickHit field '(L) Process GB' item 1 # 'Outstanding Document Amounts'
MoveTo field 'Process Button P'
ClickHit field 'Process Button P'
NewActiveWin dictionary 'DEX.DIC' form 'Report Destination' window 'Report Type'
MoveTo field '(L) Screen' # 'FALSE'
ClickHit field '(L) Screen' # 'TRUE'
MoveTo field '(L) OK'
ClickHit field '(L) OK'
NewActiveWin dictionary 'default' form 'RM_Reconcile' window 'RM_Reconcile'
NewActiveWin dictionary 'default' form 'RM_Reconcile' window 'RM_Reconcile'
# Print To Screen: 'RM Outstanding Reconciliation'
NewActiveWin dictionary 'default' form sheLL window sheLL
WindowSize dictionary 'DEX.DIC' form 'Reports Screen' window 'Screen Output' pointh 360 pointv 24
CloseWindow dictionary 'DEX.DIC' form 'Reports Screen' window 'Screen Output'
NewActiveWin dictionary 'default' form sheLL window sheLL
CommandExec form BuiLtin command cmdQuitApplication
You could use Windows scheduler to run the batch file.
Kind regards,
Leslie
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (