You’re offline. This is a read only version of the page.
443
Hello Team,
I use the following method to receive the GL Transactions: GLTransactionList
Microsoft Dynamics GP returns the Transaction list.
For example:
Share
Report
All responses (
Answers (
GLTransactionKey key = new GLTransactionKey();
key.JournalId = journalId;
key.Date = transactionDate; GLTransactionPostedKey postedKey = new GLTransactionPostedKey();
postedKey.JournalId = journalId;
postedKey.RecurringTransactionSequence = 0;
postedKey.FiscalYear = transactionDate.Year;
postedKey.Date = transactionDate;
My GetGLTransactionList, by default, returns a list of about 13 journal entries, all with a reference of 'Computer Checks', such as journal ID 3327 through 3339.
Using the GetGLTransactionByKey method, it returns "Source Document: PMCHK" which is the source document value in the Financial > Transaction Entry window for this journal entry.
Then, after I posted 3327, using the GetGLPostedTransactionByKey, I was able to get the return of "Reference: Computer Checks, posted by: sa.
**NOTE: In this last method, I had to set the transactionPostedKey.RecurringTransactionSequence = value to 0, because this wasn't a recurring journal entry, otherwise I get the Business Object Not Found message.
What you need to look at with these Web Services methods, is start with the sample code......in the case of the GetGLPostedTransactionByKey method, the sample code is only returning this:
MessageBox.Show("Reference: " + transaction.Reference + " Posted by: " + transaction.PostedBy);
When you pull up the method, you'll see something like this under 'Return Value':
Value Type Description
GetGLPostedTransactionByKeyResult GLTransaction A GL transaction object.
If you click on GLTransaction, you'll see a list of all the properties that can be returned by this method, to include the 'Referenced' and 'PostedBy' values that it shows by default.
This is all that the method is able to return/display. There isn't any way to change that or modify it.
You would have to create your own customization or call the SQL data directly through your code to get information other than what the Web Services methods are able to return. This seems to be true for a majority of the questions you're asking in regards to the Web Services methods.
Thanks
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...
290,902
Super User 2024 Season 2
#2
Martin Dráb
229,316
Most Valuable Professional
#3
nmaenpaa
101,156