...
- QueryString: Find all accounting periods matching specified string in accounting period code or name
- AccountingPeriodIdentity: If specified, the identified accounting period will be returned . And (QueryString will be ignored).
This request also has seven flag filters that decide can further determine which accounting periods to be included. five Five of the flags applies (indicated by asterisks below) apply to operations that are company based and they . They are
- IncludeFullyClosedFlagIncludeOpenForAdjustmentsFlag
- IncludeOpenForApTransactionsFlag *
- IncludeOpenForArTransactionsFlag *
- IncludeOpenForCostFlag *
- IncludeOpenForGlTransactionsFlag *
- IncludeOpenForTimeFlag *
- IncludeFullyClosedFlag
If CompanyIdentity is omitted, these five filters are ignored. And another one IncludeFullyClosedFlag only applies to time/Cost adjustment operation which is not company based. the flags marked with asterisks are ignored.
Request Format
Panel | ||
---|---|---|
| ||
|
...
Element | Data Type | Required? | Default | Description | Sample Data |
---|---|---|---|---|---|
RequestId | Int32 | No | Click here for more information. | ||
SessionTicket | String | Yes | Click here for more information. | ATtU220EvBSE2+GCN9U58g== | |
AccountingPeriodIdentity | No | The unique keys used to identify identity of a single accounting period to be retrieved. If this is specified, all other criteria is ignored. Click here for more information. | |||
IncludeFullyClosedFlag | Boolean | No | false | If a CompanyIdentity is omittedset to 'true', accounting periods closed for all activity will be included in the results, provided they meet any other criteria specified. Note that if no CompanyIdentity is specified, this flag only applies to the time/cost adjustment operation. Otherwise open for adjustments flag and, if set to 'true', will cause all accounting periods that are closed for all operations for the specified company are not open for adjustments to be included in the response. The operations include time entry, cost entry, time/cost adjustment, GL transactions, AP transactions and AR transactions. | false |
IncludeOpenForAdjustmentsFlag | Boolean | No | false | If set to 'true', the accounting period periods that is are open time/cost adjustment is adjustments are included in the response. This filter is not company based. | false |
IncludeOpenForApTransactionsFlag | Boolean | No | false | If a CompanyIdentity is omitted, this flag is ignored. Otherwise if set to 'true', accounting periods that are open for AP transactions is are included in the response. | false |
IncludeOpenForArTransactionsFlag | Boolean | No | false | If a CompanyIdentity is omitted, this flag is ignored. Otherwise if set to 'true', accounting periods that are open for AR transactions is are included in the response. | false |
IncludeOpenForCostFlag | Boolean | No | false | If a CompanyIdentity is omitted, this flag is ignored. Otherwise if set to 'true', accounting periods that are open for cost entry is are included in the response. | false |
IncludeOpenForGlTransactionsFlag | Boolean | No | false | If a CompanyIdentity is omitted, this flag is ignored. Otherwise if set to 'true', accounting periods that are open for GL transactions is are included in the response. | false |
IncludeOpenForTimeFlag | Boolean | No | false | If a CompanyIdentity is omitted, this flag is ignored. Otherwise if set to 'true', accounting periods that are open for time entry is are included in the response. | false |
MaxRowsToReturn | Int32 | No | The maximum number of accounting periods to be retrieved. This flag is disregarded if an accounting period is specified in AccountingPeriodIdentity. | 5 | |
QueryString | String | No | A search string to narrow down the results. An accounting period will be included in the results if the search string matches the accounting period's code or name. This value is disregarded if an accounting period is specified in AccountingPeriodIdentity. | Rev | |
CompanyIdentity | No | The identity of a company for determining whether the company whose accounting periods are being retrieved. Click here for more informationaccounting period is open for time, cost, AP transactions, AR transactions and/or GL transactions for filtering purposes. |
Usage Example(s)
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:pws="http://projectorpsa.com/PwsProjectorServices/" xmlns:req="http://projectorpsa.com/DataContracts/Requests/" xmlns:com="http://projectorpsa.com/DataContracts/Shared/Common/"> <soapenv:Header/> <soapenv:Body> <pws:PwsGetAccountingPeriodList> <pws:serviceRequest> <req:SessionTicket>ATtU220EvBSE2+GCN9U58g==</req:SessionTicket> <req:IncludeFullyClosedFlag>true<IncludeOpenForAdjustmentsFlag>false</req:IncludeFullyClosedFlag>IncludeOpenForAdjustmentsFlag> <req:IncludeOpenForAdjustmentsFlag>true<IncludeOpenForApTransactionsFlag>true</req:IncludeOpenForAdjustmentsFlag>IncludeOpenForApTransactionsFlag> <req:IncludeOpenForApTransactionsFlag>true<IncludeOpenForArTransactionsFlag>false</req:IncludeOpenForApTransactionsFlag>IncludeOpenForArTransactionsFlag> <req:IncludeOpenForArTransactionsFlag>true<IncludeOpenForCostFlag>true</req:IncludeOpenForArTransactionsFlag>IncludeOpenForCostFlag> <req:IncludeOpenForCostFlag>true<IncludeOpenForGlTransactionsFlag>true</req:IncludeOpenForCostFlag>IncludeOpenForGlTransactionsFlag> <req:IncludeOpenForGlTransactionsFlag>true<IncludeOpenForTimeFlag>true</req:IncludeOpenForGlTransactionsFlag>IncludeOpenForTimeFlag> <req:IncludeOpenForTimeFlag>true<MaxRowsToReturn>5</req:IncludeOpenForTimeFlag>MaxRowsToReturn> <req:MaxRowsToReturn>3</req:MaxRowsToReturn>CompanyIdentity> <com:CompanyName>Revolutionary Solutions Corporation CA</com:CompanyName> <req:QueryString><</req:QueryString>CompanyIdentity> </pws:serviceRequest> </pws:PwsGetAccountingPeriodList> </soapenv:Body> </soapenv:Envelope> |
...
Panel | ||
---|---|---|
| ||
|
...
Element | Data Type | Description | Sample Data |
---|---|---|---|
Messages | The web service response status and message. Click here for more information. | ||
ResponseId | Int32 | Click here for more information. | 0 |
Status | RequestStatus | Click here for more information | Ok |
ServerTimestampUtc | DateTime | Click here for more information. | 2018-03-13T19:42:22.6252189Z |
AccountingPeriods | The accounting period summary records that were fetched by the service. Click here for more information. |
Usage Example(s)
...
Fig 1. Accounting periods for Example 01 - Accounting period is not specified.
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> <s:Body> <PwsGetAccountingPeriodListResponse xmlns="http://projectorpsa.com/PwsProjectorServices/"> <PwsGetAccountingPeriodListResult xmlns:a="http://projectorpsa.com/DataContracts/Requests/" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <Messages xmlns="http://projectorpsa.com/CommonServices/" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"/> <ResponseId xmlns="http://projectorpsa.com/CommonServices/">0</ResponseId> <b:PwsMessage> <Status xmlns="http://projectorpsa.com/CommonServices/">Ok</Status> <b:AdditionalErrorText>Warning 104: {oldestSurvivingTimeCardWorkDateString}</b:AdditionalErrorText> <ServerTimestampUtc xmlns="http://projectorpsa.com/CommonServices/">2018-03-15T15:03:37.4306662Z</ServerTimestampUtc> <a:AccountingPeriods <bxmlns:ErrorCode>RowCountExceeded</b:ErrorCode>="http://projectorpsa.com/DataContracts/Shared/Common/"> <b:PwsAccountingPeriodSummary> <b:ErrorNumber>104</b:ErrorNumber> <b:ErrorText>Not all data rows were returned by this request because the specified row count was smaller than the total number of rows available.</b:ErrorText><b:AccountingPeriodCode>01~06-2018</b:AccountingPeriodCode> <b:AccountingPeriodId i:nil="true"/> <b:Type>Warning<AccountingPeriodName>Jan-Jun2018</b:Type>AccountingPeriodName> < <b:AccountingPeriodUid>1152921504606866570</b:PwsMessage>AccountingPeriodUid> </Messages><b:BeginDate>2018-01-01T00:00:00</b:BeginDate> <ResponseId xmlns="http://projectorpsa.com/CommonServices/">0</ResponseId> <b:EndDate>2018-06-30T00:00:00</b:EndDate> <Status xmlns="http://projectorpsa.com/CommonServices/">Ok</Status> <b:OpenForAdjustmentsFlag>true</b:OpenForAdjustmentsFlag> <b:OpenForApTransactionsFlag>true</b:OpenForApTransactionsFlag> <ServerTimestampUtc xmlns="http<b://projectorpsa.com/CommonServices/">2018-03-13T19:42:22.6252189Z</ServerTimestampUtc>OpenForArTransactionsFlag>false</b:OpenForArTransactionsFlag> <b:OpenForCostFlag>false</b:OpenForCostFlag> <b:OpenForGlTransactionsFlag>false</b:OpenForGlTransactionsFlag> <b:OpenForTimeFlag>false</b:OpenForTimeFlag> </b:PwsAccountingPeriodSummary> <b:PwsAccountingPeriodSummary> <b:AccountingPeriodCode>07~12-2017</b:AccountingPeriodCode> <b:AccountingPeriodId i:nil="true"/> <b:AccountingPeriodName>Jul-Dec2017</b:AccountingPeriodName> <b:AccountingPeriodUid>1152921504606866569</b:AccountingPeriodUid> <b:BeginDate>2017-07-01T00:00:00</b:BeginDate> <b:EndDate>2017-12-31T00:00:00</b:EndDate> <b:OpenForAdjustmentsFlag>true</b:OpenForAdjustmentsFlag> <b:OpenForApTransactionsFlag>true</b:OpenForApTransactionsFlag> <b:OpenForArTransactionsFlag>true</b:OpenForArTransactionsFlag> <b:OpenForCostFlag>false</b:OpenForCostFlag> <b:OpenForGlTransactionsFlag>true</b:OpenForGlTransactionsFlag> <b:OpenForTimeFlag>true</b:OpenForTimeFlag> <a:AccountingPeriods xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"> </b:PwsAccountingPeriodSummary> <b:PwsAccountingPeriodSummary> <b:AccountingPeriodCode>future<AccountingPeriodCode>01~06-2017</b:AccountingPeriodCode> <b:AccountingPeriodId i:nil="true"/> <b:AccountingPeriodName>future<AccountingPeriodName>Jan-Jun2017</b:AccountingPeriodName> <b:AccountingPeriodUid>1152921504606866111<AccountingPeriodUid>1152921504606866568</b:AccountingPeriodUid> <b:BeginDate>2018BeginDate>2017-0701-01T00:00:00</b:BeginDate> <b:EndDate i:nil="true"/>:EndDate>2017-06-30T00:00:00</b:EndDate> <b:OpenForAdjustmentsFlag>false</b:OpenForAdjustmentsFlag> <b:OpenForApTransactionsFlag i:nil="true"/>OpenForApTransactionsFlag>true</b:OpenForApTransactionsFlag> <b:OpenForArTransactionsFlag i:nil="true"/>OpenForArTransactionsFlag>true</b:OpenForArTransactionsFlag> <b:OpenForCostFlag i:nil="true"/>OpenForCostFlag>true</b:OpenForCostFlag> <b:OpenForGlTransactionsFlag i:nil="true"/>OpenForGlTransactionsFlag>true</b:OpenForGlTransactionsFlag> <b:OpenForTimeFlag i:nil="true"/>OpenForTimeFlag>true</b:OpenForTimeFlag> </b:PwsAccountingPeriodSummary> <b:PwsAccountingPeriodSummary> <b:AccountingPeriodCode>AccountingPeriodCode>07~12-062018<2016</b:AccountingPeriodCode> <b:AccountingPeriodId i:nil="true"/> <b:AccountingPeriodName>TillAccountingPeriodName>Jul-Jun2018<Dec2016</b:AccountingPeriodName> <b:AccountingPeriodUid>1152921504606863107<AccountingPeriodUid>1152921504606866567</b:AccountingPeriodUid> <b:BeginDate>2015BeginDate>2016-07-01T00:00:00</b:BeginDate> <b:EndDate>2018EndDate>2016-0612-30T0031T00:00:00</b:EndDate> <b:OpenForAdjustmentsFlag>true<OpenForAdjustmentsFlag>false</b:OpenForAdjustmentsFlag> <b:OpenForApTransactionsFlag i:nil="true"/>OpenForApTransactionsFlag>false</b:OpenForApTransactionsFlag> <b:OpenForArTransactionsFlag i:nil="true"/>OpenForArTransactionsFlag>false</b:OpenForArTransactionsFlag> <b:OpenForCostFlag i:nil="true"/>OpenForCostFlag>false</b:OpenForCostFlag> <b:OpenForGlTransactionsFlag i:nil="true"/>OpenForGlTransactionsFlag>true</b:OpenForGlTransactionsFlag> <b:OpenForTimeFlag i:nil="true"/>OpenForTimeFlag>false</b:OpenForTimeFlag> </b:PwsAccountingPeriodSummary> <b:PwsAccountingPeriodSummary> <b:AccountingPeriodCode>04AccountingPeriodCode>01~06-062015<2016</b:AccountingPeriodCode> <b:AccountingPeriodId i:nil="true"/> <b:AccountingPeriodName>AprAccountingPeriodName>Jan-Jun2015<Jun2016</b:AccountingPeriodName> <b:AccountingPeriodUid>1152921504606862364<AccountingPeriodUid>1152921504606866111</b:AccountingPeriodUid> <b:BeginDate>2015BeginDate>2016-0401-01T00:00:00</b:BeginDate> <b:EndDate>2015EndDate>2016-06-30T00:00:00</b:EndDate> <b:OpenForAdjustmentsFlag>true</b:OpenForAdjustmentsFlag> <b:OpenForApTransactionsFlag i:nil="true"/>:OpenForApTransactionsFlag>true</b:OpenForApTransactionsFlag> <b:OpenForArTransactionsFlag i:nil="true"/>OpenForArTransactionsFlag>false</b:OpenForArTransactionsFlag> <b:OpenForCostFlag i:nil="true"/>OpenForCostFlag>true</b:OpenForCostFlag> <b:OpenForGlTransactionsFlag i:nil="true"/>OpenForGlTransactionsFlag>true</b:OpenForGlTransactionsFlag> <b:OpenForTimeFlag i:nil="true"/>OpenForTimeFlag>true</b:OpenForTimeFlag> </b:PwsAccountingPeriodSummary> </a:AccountingPeriods> </PwsGetAccountingPeriodListResult> </PwsGetAccountingPeriodListResponse> </s:Body> </s:Envelope> |
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:pws="http://projectorpsa.com/PwsProjectorServices/" xmlns:req="http://projectorpsa.com/DataContracts/Requests/" xmlns:com="http://projectorpsa.com/DataContracts/Shared/Common/"> <soapenv:Header/> <soapenv:Body> <pws:PwsGetAccountingPeriodList> <pws:serviceRequest> <req:SessionTicket>ATtU220EvBSE2+GCN9U58g==</req:SessionTicket> <req:AccountingPeriodIdentity> <com:AccountingPeriodCode>-062018</com:AccountingPeriodCode> </req:AccountingPeriodIdentity> <req:IncludeFullyClosedFlag>true</req:IncludeFullyClosedFlag> <req:IncludeOpenForAdjustmentsFlag>true</req:IncludeOpenForAdjustmentsFlag> <req:IncludeOpenForApTransactionsFlag>true</req:IncludeOpenForApTransactionsFlag> <req:IncludeOpenForArTransactionsFlag>true</req:IncludeOpenForArTransactionsFlag> <req:IncludeOpenForCostFlag>true</req:IncludeOpenForCostFlag> <req:IncludeOpenForGlTransactionsFlag>true</req:IncludeOpenForGlTransactionsFlag> <req:IncludeOpenForTimeFlag>true</req:IncludeOpenForTimeFlag> <req:MaxRowsToReturn>5</req:MaxRowsToReturn> <req:QueryString></req:QueryString> </pws:serviceRequest> </pws:PwsGetAccountingPeriodList> </soapenv:Body> </soapenv:Envelope> |
PwsGetAccountingPeriodList - Common Errors and Warnings
- For all errors and warnings please refer to the Complete List of Errors and Warnings
ErrorNumber | ErrorCode | Description |
---|---|---|
57335 | AccountingPeriodNotFound | The specified accounting period was not found. |
57339 | CompanyNotFound | The specified company was not found. |