GET JournalEntry/GetJournalEntry?createdOnOrAfterUtc={createdOnOrAfterUtc}&includeAccountAttributesList={includeAccountAttributesList}
Returns a list of Journal Entries filtered by the date and time created in UTC format. The request and response require the use of "Paged" records using Header Keys.
Request Information
URI Parameters
Name | Description | Type | Additional Information |
---|---|---|---|
createdOnOrAfterUtc |
Filter to include only Journal Entries created on or after the supplied UTC date and time. Format = yyyy-MM-ddTHH:mm:ss |
string |
Required |
includeAccountAttributesList |
Optionally include the GL Account Attributes in the response for each line item. The default is "false". |
boolean |
Default value is False |
Body Parameters
Response Information
Resource Description
Returns a list of Journal Entries filtered by the date and time created in UTC format. The request and response require the use of "Paged" records using Header Keys.
AgvJournalEntryName | Description | Type | Additional Information |
---|---|---|---|
Status |
0 = Success. 1 = An error occurred. 2 = An error occurred. 3 = Descriptive message, process was successful. |
string | |
Message |
Informational message that corresponds to the Status returned. 0 - Message will be "OK". 1 - Detailed message returned to give user an indication of what went wrong. 2 - Less Detailed message returned that may not mean anything to the user but that the application might use to take a corrective action. 3 - Not an error but something the user might need to know. |
string | |
ErrorList |
List of error messages of the API call. |
Collection of string | |
WarningList |
List of warning messages of the API call. |
Collection of string | |
Count |
Number of results returned. |
string | |
JournalEntries |
List of Properties and Values returned for each journal entry that matches the request. |
Collection of JEntryMultiYear |
Response Formats
application/json, text/json
{ "Status": "sample string 1", "Message": "sample string 2", "ErrorList": [ "sample string 1", "sample string 2" ], "WarningList": [ "sample string 1", "sample string 2" ], "Count": "2", "JournalEntries": [ { "JournalEntryGUID": "f05ef08b-85c3-4ab1-9c85-77839e6b4076", "PreviousYearGUID": "7228b65c-018d-4a2f-b58c-fa0636117669", "PreviousYearDescription": "sample string 2", "PreviousYearCreatedDateTimeUTC": "2024-11-21T09:30:10.0900046+00:00", "JournalEntryNumber": 3, "Date": "2024-11-21T09:30:10.0900046+00:00", "TypeOfEntry": "sample string 5", "Reference": "sample string 6", "GrowerGUID": "20c18a89-b59a-4cc5-aca5-e8734cad6591", "GrowerID": "sample string 7", "GrowerName": "sample string 8", "VendorGUID": "14b86733-34da-4fdf-aed8-c9c8714f2b5a", "VendorID": "sample string 9", "VendorName": "sample string 10", "Source": "sample string 11", "CreatedByUser": "sample string 12", "Description": "sample string 13", "TotalAmount": 14.1, "NumberOfDebits": 15, "NumberOfCredits": 16, "FiscalMonth": 17, "AmountPaidFor1099": 18.1, "TransactionDateTimeUTC": "2024-11-21T09:30:10.0900046+00:00", "ReversedByJEGUID": "ab949c14-edcb-49d0-9e18-f2185d690cb2", "ReversedByJENumber": 1, "ReversalOfJEGUID": "4c948ffa-3080-43cc-aa9e-c20a4350c27e", "ReversalOfJENumber": 1, "PostCurrent": true, "ACHPayment": true, "Status": "sample string 22", "SourceTransactionGUID": "8c8a4cab-2e50-4fb8-bab5-6b2f90f4af6e", "LastModifiedUTC": "2024-11-21T09:30:10.091005+00:00", "LineItems": [ { "JournalEntryDTGUID": "3bb11008-4d86-4f45-a542-7956d1ce266e", "LineItem": 2, "DebitOrCredit": "sample string 3", "AcctProfGUID": "dd636d4d-53a2-4a83-985a-98f6fef39c73", "AccountID": "sample string 4", "AccountDescription": "sample string 5", "Amount": 6.1, "Reconciled": true, "Quantity": 8.1, "Comment": "sample string 9", "Deposited": true, "GrainCode": "sample string 11", "PositivePayExported": true, "GLAccountAttributeValues": [ { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" }, { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" } ] }, { "JournalEntryDTGUID": "3bb11008-4d86-4f45-a542-7956d1ce266e", "LineItem": 2, "DebitOrCredit": "sample string 3", "AcctProfGUID": "dd636d4d-53a2-4a83-985a-98f6fef39c73", "AccountID": "sample string 4", "AccountDescription": "sample string 5", "Amount": 6.1, "Reconciled": true, "Quantity": 8.1, "Comment": "sample string 9", "Deposited": true, "GrainCode": "sample string 11", "PositivePayExported": true, "GLAccountAttributeValues": [ { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" }, { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" } ] } ] }, { "JournalEntryGUID": "f05ef08b-85c3-4ab1-9c85-77839e6b4076", "PreviousYearGUID": "7228b65c-018d-4a2f-b58c-fa0636117669", "PreviousYearDescription": "sample string 2", "PreviousYearCreatedDateTimeUTC": "2024-11-21T09:30:10.0900046+00:00", "JournalEntryNumber": 3, "Date": "2024-11-21T09:30:10.0900046+00:00", "TypeOfEntry": "sample string 5", "Reference": "sample string 6", "GrowerGUID": "20c18a89-b59a-4cc5-aca5-e8734cad6591", "GrowerID": "sample string 7", "GrowerName": "sample string 8", "VendorGUID": "14b86733-34da-4fdf-aed8-c9c8714f2b5a", "VendorID": "sample string 9", "VendorName": "sample string 10", "Source": "sample string 11", "CreatedByUser": "sample string 12", "Description": "sample string 13", "TotalAmount": 14.1, "NumberOfDebits": 15, "NumberOfCredits": 16, "FiscalMonth": 17, "AmountPaidFor1099": 18.1, "TransactionDateTimeUTC": "2024-11-21T09:30:10.0900046+00:00", "ReversedByJEGUID": "ab949c14-edcb-49d0-9e18-f2185d690cb2", "ReversedByJENumber": 1, "ReversalOfJEGUID": "4c948ffa-3080-43cc-aa9e-c20a4350c27e", "ReversalOfJENumber": 1, "PostCurrent": true, "ACHPayment": true, "Status": "sample string 22", "SourceTransactionGUID": "8c8a4cab-2e50-4fb8-bab5-6b2f90f4af6e", "LastModifiedUTC": "2024-11-21T09:30:10.091005+00:00", "LineItems": [ { "JournalEntryDTGUID": "3bb11008-4d86-4f45-a542-7956d1ce266e", "LineItem": 2, "DebitOrCredit": "sample string 3", "AcctProfGUID": "dd636d4d-53a2-4a83-985a-98f6fef39c73", "AccountID": "sample string 4", "AccountDescription": "sample string 5", "Amount": 6.1, "Reconciled": true, "Quantity": 8.1, "Comment": "sample string 9", "Deposited": true, "GrainCode": "sample string 11", "PositivePayExported": true, "GLAccountAttributeValues": [ { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" }, { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" } ] }, { "JournalEntryDTGUID": "3bb11008-4d86-4f45-a542-7956d1ce266e", "LineItem": 2, "DebitOrCredit": "sample string 3", "AcctProfGUID": "dd636d4d-53a2-4a83-985a-98f6fef39c73", "AccountID": "sample string 4", "AccountDescription": "sample string 5", "Amount": 6.1, "Reconciled": true, "Quantity": 8.1, "Comment": "sample string 9", "Deposited": true, "GrainCode": "sample string 11", "PositivePayExported": true, "GLAccountAttributeValues": [ { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" }, { "MasterCrossRefNamesKey": 3, "CrossRefName": "sample string 4", "CrossRefValue": "sample string 5" } ] } ] } ] }
application/xml, text/xml
<AgvJournalEntry xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/AgvWebAPICSharp.Models.JournalEntry"> <ErrorList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d2p1:string>sample string 1</d2p1:string> <d2p1:string>sample string 2</d2p1:string> </ErrorList> <JournalEntries xmlns:d2p1="http://schemas.datacontract.org/2004/07/SKY.Core.JournalEntry"> <d2p1:JournalEntry> <d2p1:ACHPayment>true</d2p1:ACHPayment> <d2p1:AmountPaidFor1099>18.1</d2p1:AmountPaidFor1099> <d2p1:CreatedByUser>sample string 12</d2p1:CreatedByUser> <d2p1:Date>2024-11-21T09:30:10.0900046+00:00</d2p1:Date> <d2p1:Description>sample string 13</d2p1:Description> <d2p1:FiscalMonth>17</d2p1:FiscalMonth> <d2p1:GrowerGUID>20c18a89-b59a-4cc5-aca5-e8734cad6591</d2p1:GrowerGUID> <d2p1:GrowerID>sample string 7</d2p1:GrowerID> <d2p1:GrowerName>sample string 8</d2p1:GrowerName> <d2p1:JournalEntryGUID>f05ef08b-85c3-4ab1-9c85-77839e6b4076</d2p1:JournalEntryGUID> <d2p1:JournalEntryNumber>3</d2p1:JournalEntryNumber> <d2p1:LastModifiedUTC>2024-11-21T09:30:10.091005+00:00</d2p1:LastModifiedUTC> <d2p1:LineItems> <d2p1:JournalEntryDT> <d2p1:AccountDescription>sample string 5</d2p1:AccountDescription> <d2p1:AccountID>sample string 4</d2p1:AccountID> <d2p1:AcctProfGUID>dd636d4d-53a2-4a83-985a-98f6fef39c73</d2p1:AcctProfGUID> <d2p1:Amount>6.1</d2p1:Amount> <d2p1:Comment>sample string 9</d2p1:Comment> <d2p1:DebitOrCredit>sample string 3</d2p1:DebitOrCredit> <d2p1:Deposited>true</d2p1:Deposited> <d2p1:GLAccountAttributeValues xmlns:d6p1="http://schemas.datacontract.org/2004/07/SKY.Core.GL"> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> </d2p1:GLAccountAttributeValues> <d2p1:GrainCode>sample string 11</d2p1:GrainCode> <d2p1:JournalEntryDTGUID>3bb11008-4d86-4f45-a542-7956d1ce266e</d2p1:JournalEntryDTGUID> <d2p1:LineItem>2</d2p1:LineItem> <d2p1:PositivePayExported>true</d2p1:PositivePayExported> <d2p1:Quantity>8.1</d2p1:Quantity> <d2p1:Reconciled>true</d2p1:Reconciled> </d2p1:JournalEntryDT> <d2p1:JournalEntryDT> <d2p1:AccountDescription>sample string 5</d2p1:AccountDescription> <d2p1:AccountID>sample string 4</d2p1:AccountID> <d2p1:AcctProfGUID>dd636d4d-53a2-4a83-985a-98f6fef39c73</d2p1:AcctProfGUID> <d2p1:Amount>6.1</d2p1:Amount> <d2p1:Comment>sample string 9</d2p1:Comment> <d2p1:DebitOrCredit>sample string 3</d2p1:DebitOrCredit> <d2p1:Deposited>true</d2p1:Deposited> <d2p1:GLAccountAttributeValues xmlns:d6p1="http://schemas.datacontract.org/2004/07/SKY.Core.GL"> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> </d2p1:GLAccountAttributeValues> <d2p1:GrainCode>sample string 11</d2p1:GrainCode> <d2p1:JournalEntryDTGUID>3bb11008-4d86-4f45-a542-7956d1ce266e</d2p1:JournalEntryDTGUID> <d2p1:LineItem>2</d2p1:LineItem> <d2p1:PositivePayExported>true</d2p1:PositivePayExported> <d2p1:Quantity>8.1</d2p1:Quantity> <d2p1:Reconciled>true</d2p1:Reconciled> </d2p1:JournalEntryDT> </d2p1:LineItems> <d2p1:NumberOfCredits>16</d2p1:NumberOfCredits> <d2p1:NumberOfDebits>15</d2p1:NumberOfDebits> <d2p1:PostCurrent>true</d2p1:PostCurrent> <d2p1:PreviousYearCreatedDateTimeUTC>2024-11-21T09:30:10.0900046+00:00</d2p1:PreviousYearCreatedDateTimeUTC> <d2p1:PreviousYearDescription>sample string 2</d2p1:PreviousYearDescription> <d2p1:PreviousYearGUID>7228b65c-018d-4a2f-b58c-fa0636117669</d2p1:PreviousYearGUID> <d2p1:Reference>sample string 6</d2p1:Reference> <d2p1:ReversalOfJEGUID>4c948ffa-3080-43cc-aa9e-c20a4350c27e</d2p1:ReversalOfJEGUID> <d2p1:ReversalOfJENumber>1</d2p1:ReversalOfJENumber> <d2p1:ReversedByJEGUID>ab949c14-edcb-49d0-9e18-f2185d690cb2</d2p1:ReversedByJEGUID> <d2p1:ReversedByJENumber>1</d2p1:ReversedByJENumber> <d2p1:Source>sample string 11</d2p1:Source> <d2p1:SourceTransactionGUID>8c8a4cab-2e50-4fb8-bab5-6b2f90f4af6e</d2p1:SourceTransactionGUID> <d2p1:Status>sample string 22</d2p1:Status> <d2p1:TotalAmount>14.1</d2p1:TotalAmount> <d2p1:TransactionDateTimeUTC>2024-11-21T09:30:10.0900046+00:00</d2p1:TransactionDateTimeUTC> <d2p1:TypeOfEntry>sample string 5</d2p1:TypeOfEntry> <d2p1:VendorGUID>14b86733-34da-4fdf-aed8-c9c8714f2b5a</d2p1:VendorGUID> <d2p1:VendorID>sample string 9</d2p1:VendorID> <d2p1:VendorName>sample string 10</d2p1:VendorName> </d2p1:JournalEntry> <d2p1:JournalEntry> <d2p1:ACHPayment>true</d2p1:ACHPayment> <d2p1:AmountPaidFor1099>18.1</d2p1:AmountPaidFor1099> <d2p1:CreatedByUser>sample string 12</d2p1:CreatedByUser> <d2p1:Date>2024-11-21T09:30:10.0900046+00:00</d2p1:Date> <d2p1:Description>sample string 13</d2p1:Description> <d2p1:FiscalMonth>17</d2p1:FiscalMonth> <d2p1:GrowerGUID>20c18a89-b59a-4cc5-aca5-e8734cad6591</d2p1:GrowerGUID> <d2p1:GrowerID>sample string 7</d2p1:GrowerID> <d2p1:GrowerName>sample string 8</d2p1:GrowerName> <d2p1:JournalEntryGUID>f05ef08b-85c3-4ab1-9c85-77839e6b4076</d2p1:JournalEntryGUID> <d2p1:JournalEntryNumber>3</d2p1:JournalEntryNumber> <d2p1:LastModifiedUTC>2024-11-21T09:30:10.091005+00:00</d2p1:LastModifiedUTC> <d2p1:LineItems> <d2p1:JournalEntryDT> <d2p1:AccountDescription>sample string 5</d2p1:AccountDescription> <d2p1:AccountID>sample string 4</d2p1:AccountID> <d2p1:AcctProfGUID>dd636d4d-53a2-4a83-985a-98f6fef39c73</d2p1:AcctProfGUID> <d2p1:Amount>6.1</d2p1:Amount> <d2p1:Comment>sample string 9</d2p1:Comment> <d2p1:DebitOrCredit>sample string 3</d2p1:DebitOrCredit> <d2p1:Deposited>true</d2p1:Deposited> <d2p1:GLAccountAttributeValues xmlns:d6p1="http://schemas.datacontract.org/2004/07/SKY.Core.GL"> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> </d2p1:GLAccountAttributeValues> <d2p1:GrainCode>sample string 11</d2p1:GrainCode> <d2p1:JournalEntryDTGUID>3bb11008-4d86-4f45-a542-7956d1ce266e</d2p1:JournalEntryDTGUID> <d2p1:LineItem>2</d2p1:LineItem> <d2p1:PositivePayExported>true</d2p1:PositivePayExported> <d2p1:Quantity>8.1</d2p1:Quantity> <d2p1:Reconciled>true</d2p1:Reconciled> </d2p1:JournalEntryDT> <d2p1:JournalEntryDT> <d2p1:AccountDescription>sample string 5</d2p1:AccountDescription> <d2p1:AccountID>sample string 4</d2p1:AccountID> <d2p1:AcctProfGUID>dd636d4d-53a2-4a83-985a-98f6fef39c73</d2p1:AcctProfGUID> <d2p1:Amount>6.1</d2p1:Amount> <d2p1:Comment>sample string 9</d2p1:Comment> <d2p1:DebitOrCredit>sample string 3</d2p1:DebitOrCredit> <d2p1:Deposited>true</d2p1:Deposited> <d2p1:GLAccountAttributeValues xmlns:d6p1="http://schemas.datacontract.org/2004/07/SKY.Core.GL"> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> <d6p1:GLAccountAttributes> <d6p1:CrossRefName>sample string 4</d6p1:CrossRefName> <d6p1:CrossRefValue>sample string 5</d6p1:CrossRefValue> <d6p1:MasterCrossRefNamesKey>3</d6p1:MasterCrossRefNamesKey> </d6p1:GLAccountAttributes> </d2p1:GLAccountAttributeValues> <d2p1:GrainCode>sample string 11</d2p1:GrainCode> <d2p1:JournalEntryDTGUID>3bb11008-4d86-4f45-a542-7956d1ce266e</d2p1:JournalEntryDTGUID> <d2p1:LineItem>2</d2p1:LineItem> <d2p1:PositivePayExported>true</d2p1:PositivePayExported> <d2p1:Quantity>8.1</d2p1:Quantity> <d2p1:Reconciled>true</d2p1:Reconciled> </d2p1:JournalEntryDT> </d2p1:LineItems> <d2p1:NumberOfCredits>16</d2p1:NumberOfCredits> <d2p1:NumberOfDebits>15</d2p1:NumberOfDebits> <d2p1:PostCurrent>true</d2p1:PostCurrent> <d2p1:PreviousYearCreatedDateTimeUTC>2024-11-21T09:30:10.0900046+00:00</d2p1:PreviousYearCreatedDateTimeUTC> <d2p1:PreviousYearDescription>sample string 2</d2p1:PreviousYearDescription> <d2p1:PreviousYearGUID>7228b65c-018d-4a2f-b58c-fa0636117669</d2p1:PreviousYearGUID> <d2p1:Reference>sample string 6</d2p1:Reference> <d2p1:ReversalOfJEGUID>4c948ffa-3080-43cc-aa9e-c20a4350c27e</d2p1:ReversalOfJEGUID> <d2p1:ReversalOfJENumber>1</d2p1:ReversalOfJENumber> <d2p1:ReversedByJEGUID>ab949c14-edcb-49d0-9e18-f2185d690cb2</d2p1:ReversedByJEGUID> <d2p1:ReversedByJENumber>1</d2p1:ReversedByJENumber> <d2p1:Source>sample string 11</d2p1:Source> <d2p1:SourceTransactionGUID>8c8a4cab-2e50-4fb8-bab5-6b2f90f4af6e</d2p1:SourceTransactionGUID> <d2p1:Status>sample string 22</d2p1:Status> <d2p1:TotalAmount>14.1</d2p1:TotalAmount> <d2p1:TransactionDateTimeUTC>2024-11-21T09:30:10.0900046+00:00</d2p1:TransactionDateTimeUTC> <d2p1:TypeOfEntry>sample string 5</d2p1:TypeOfEntry> <d2p1:VendorGUID>14b86733-34da-4fdf-aed8-c9c8714f2b5a</d2p1:VendorGUID> <d2p1:VendorID>sample string 9</d2p1:VendorID> <d2p1:VendorName>sample string 10</d2p1:VendorName> </d2p1:JournalEntry> </JournalEntries> <Message>sample string 2</Message> <Status>sample string 1</Status> <WarningList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d2p1:string>sample string 1</d2p1:string> <d2p1:string>sample string 2</d2p1:string> </WarningList> </AgvJournalEntry>