Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamics SQL Tables/Fields for adding an unposted G/L...

Status
Not open for further replies.

colttaylor

Programmer
Aug 20, 2002
117
0
0
US
I am looking for a list of the sql tables and fields which are involved in adding an unposted batch of G/L journal entries to the Dynamics Accounting System.
I have tried to get this information from Microsoft, but they only share such details with "Partners" and the process of becoming a partner would involve more time (and possibly money) than I have available.
A quick recipe for adding an unposted journal batch would be a god-send. Any help would be appreciated!
Peace,
Colt. If it's stupid but it works, it isn't stupid
 
The tables are GL10000 and GL10001 and SY00500. SY00500 is the batch table so you can just run batch reconcile and this will populate the table.
 
Thanks!
I got sidetracked from the project but it will be coming back soon and your information should be very helpful!

If it's stupid but it works, it isn't stupid
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top