POST AcctReports/GetVolumeStatementReport

Generate a Volume Statement report

Request Information

URI Parameters

Body Parameters

The request object used to create report

VolumeStatementRequestBody
NameDescriptionTypeAdditional Information
CustomerGUID

Agvance Customer GUID

 globally unique identifier

Required
StartDate

Start Date

 date

Required
EndDate

End Date

 date

Required
TotalByDepartmentCategoryName

Total by the department category when true - if false, will total by department sales class

 boolean

Must be 0, 1, True, or False
LocationGuidForSalesTaxOverrideLabel

The location guid to use for determining the sales tax override heading. Used when UseCustomersLocationIdAsSalesTaxOverrideLocationId = false

 globally unique identifier

Only required when UseCustomersLocationIdAsSalesTaxOverrideLocationId = false. Default is null
UseCustomersLocationIdAsSalesTaxOverrideLocationId

Use the customer's location for the location to look up the sales tax override heading from

 boolean

Default value is true

Must be 0, 1, True, or False
IncludeGrainInformation

Include grain settlement in report. Minimum supported version is '6.0.16550'

 boolean

Must be 0, 1, True, or False
IncludeGrainAdvancePayments

Include Grain Advance payments

 boolean

Must be 0, 1, True, or False
IncludeDeferredPaymentAndInstallmentSales

Include Deferred Payments and Installment Sales in calculation

 boolean

Must be 0, 1, True, or False
UseGrossAmountOfDeferredPaymentAndInstallmentSales

Use gross amount of Deferred Payments and Installment Sales

 boolean

Must be 0, 1, True, or False
StatementMessage

Statement message to display on the report

 string

Max length: 200
FooterMessage

Footer message to display on the report

 string

Max length: 40
EligibleSettDedGuids

List of Eligible Settlement Deductions / Additions

 Collection of globally unique identifier
ServiceChargeSettDedGuids

List of Service Charge Settlement Deductions / Additions

 Collection of globally unique identifier

Request Formats

application/json, text/json

Sample: 
{
  "CustomerGUID": "e6c37820-46d1-4eed-8a2f-3e2f66966be2",
  "StartDate": "2025-08-23T07:33:50.048769+00:00",
  "EndDate": "2025-08-23T07:33:50.048769+00:00",
  "TotalByDepartmentCategoryName": true,
  "LocationGuidForSalesTaxOverrideLabel": "0bf16cbb-b90e-4dc8-8b84-93320a4bf3db",
  "UseCustomersLocationIdAsSalesTaxOverrideLocationId": true,
  "IncludeGrainInformation": true,
  "IncludeGrainAdvancePayments": true,
  "IncludeDeferredPaymentAndInstallmentSales": true,
  "UseGrossAmountOfDeferredPaymentAndInstallmentSales": true,
  "StatementMessage": "sample string 9",
  "FooterMessage": "sample string 10",
  "EligibleSettDedGuids": [
    "b1566dd1-c088-4377-a796-bcc6d6513e52",
    "c8d7b1d6-0073-4ec6-ad4c-734313b0c510"
  ],
  "ServiceChargeSettDedGuids": [
    "0d933999-9067-4298-a69c-58973325724a",
    "b2b9f51a-2632-4637-8a07-9d4e5d2c675b"
  ]
}

application/xml, text/xml

Sample: 
<VolumeStatementRequestBody xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/SSI.ApiReports">
  <CustomerGUID>e6c37820-46d1-4eed-8a2f-3e2f66966be2</CustomerGUID>
  <EligibleSettDedGuids xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:guid>b1566dd1-c088-4377-a796-bcc6d6513e52</d2p1:guid>
    <d2p1:guid>c8d7b1d6-0073-4ec6-ad4c-734313b0c510</d2p1:guid>
  </EligibleSettDedGuids>
  <EndDate>2025-08-23T07:33:50.048769+00:00</EndDate>
  <FooterMessage>sample string 10</FooterMessage>
  <IncludeDeferredPaymentAndInstallmentSales>true</IncludeDeferredPaymentAndInstallmentSales>
  <IncludeGrainAdvancePayments>true</IncludeGrainAdvancePayments>
  <IncludeGrainInformation>true</IncludeGrainInformation>
  <LocationGuidForSalesTaxOverrideLabel>0bf16cbb-b90e-4dc8-8b84-93320a4bf3db</LocationGuidForSalesTaxOverrideLabel>
  <ServiceChargeSettDedGuids xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:guid>0d933999-9067-4298-a69c-58973325724a</d2p1:guid>
    <d2p1:guid>b2b9f51a-2632-4637-8a07-9d4e5d2c675b</d2p1:guid>
  </ServiceChargeSettDedGuids>
  <StartDate>2025-08-23T07:33:50.048769+00:00</StartDate>
  <StatementMessage>sample string 9</StatementMessage>
  <TotalByDepartmentCategoryName>true</TotalByDepartmentCategoryName>
  <UseCustomersLocationIdAsSalesTaxOverrideLocationId>true</UseCustomersLocationIdAsSalesTaxOverrideLocationId>
  <UseGrossAmountOfDeferredPaymentAndInstallmentSales>true</UseGrossAmountOfDeferredPaymentAndInstallmentSales>
</VolumeStatementRequestBody>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'VolumeStatementRequestBody'.

Response Information

Resource Description

Generate a Volume Statement report

AgvAccountingReport
NameDescriptionTypeAdditional 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 errors from the API

 Collection of string
WarningList

List of warnings from the API

 Collection of string
S3FileName

The S3 file that was generated for the requested report

 string

Will be "null" when the status is not success.
PreSignedUrl

The presigned url of the file

 string

Will be "null" when the S3FileName is not populated.

Response Formats

application/json, text/json

Sample: 
{
  "Status": "sample string 1",
  "Message": "sample string 2",
  "ErrorList": [
    "sample string 1",
    "sample string 2"
  ],
  "WarningList": [
    "sample string 1",
    "sample string 2"
  ],
  "S3FileName": "sample string 3",
  "PreSignedUrl": "sample string 4"
}

application/xml, text/xml

Sample: 
<AgvAccountingReport xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/AgvWebAPICSharp.Models.AcctReports">
  <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>
  <Message>sample string 2</Message>
  <PreSignedUrl>sample string 4</PreSignedUrl>
  <S3FileName>sample string 3</S3FileName>
  <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>
</AgvAccountingReport>