Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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

  • IncludeOpenForAdjustmentsFlag
  • 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
titlePwsGetAccountingPeriodList Request
  • PwsGetAccountingPeriodList
    • serviceRequest: PwsGetAccountingPeriodListRq
      • RequestId: Int32
      • SessionTicket: String
      • AccountingPeriodIdentity: PwsAccountingPeriodRef
      • IncludeFullyClosedFlag: Boolean
      • IncludeOpenForAdjustmentsFlag: Boolean
      • IncludeOpenForApTransactionsFlag: Boolean
      • IncludeOpenForArTransactionsFlag: Boolean
      • IncludeOpenForCostFlag: Boolean
      • IncludeOpenForGlTransactionsFlag: Boolean
      • IncludeOpenForTimeFlag: Boolean
      • MaxRowsToReturn: Int32
      • QueryString: String
      • CompanyIdentity: PwsCompanyRef

...

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

PwsAccountingPeriodRef

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

PwsCompanyRef

No


The identity of the company whose accounting periods are being retrieved. Click here for more informationa company for determining whether the accounting period is open for time, cost, AP transactions, AR transactions and/or GL transactions for filtering purposes.


Usage Example(s)


Code Block
languagexml
titleExample 01 - Accounting period is not specified
collapsetrue
<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:IncludeOpenForAdjustmentsFlag>false</req:IncludeOpenForAdjustmentsFlag>
            <req:IncludeOpenForApTransactionsFlag>true</req:IncludeOpenForApTransactionsFlag>
            <req:IncludeOpenForArTransactionsFlag>false</req:IncludeOpenForArTransactionsFlag>
            <req:IncludeOpenForCostFlag>true</req:IncludeOpenForCostFlag>
            <req:IncludeOpenForGlTransactionsFlag>true</req:IncludeOpenForGlTransactionsFlag>
            <req:IncludeOpenForTimeFlag>true</req:IncludeOpenForTimeFlag>
            <req:MaxRowsToReturn>5</req:MaxRowsToReturn>
            <req:CompanyIdentity>
               <com:CompanyName>Revolutionary Solutions Corporation CA</com:CompanyName>
            </req:CompanyIdentity>
         </pws:serviceRequest>
      </pws:PwsGetAccountingPeriodList>
   </soapenv:Body>
</soapenv:Envelope>

...

Panel
titlePwsGetAccountingPeriodList Response

...

Element

Data Type

Description

Sample Data

Messages

PwsMessage[]

The web service response status and message. Click here for more information.


ResponseId

Int32

Click here for more information.

0

StatusRequestStatusClick here for more informationOk

ServerTimestampUtc

DateTime

Click here for more information.

2018-03-13T19:42:22.6252189Z

AccountingPeriods

PwsAccountingPeriodSummary

The accounting period summary records that were fetched by the service. Click here for more information.


...

Code Block
languagexml
titleExample 01 - Accounting period is not specified
collapsetrue
<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/">
               <b:PwsMessage>
                  <b:AdditionalErrorText>Warning 104: {oldestSurvivingTimeCardWorkDateString}</b:AdditionalErrorText>
                  <b:ErrorCode>RowCountExceeded</b:ErrorCode>
                  <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:Type>Warning</b:Type>/2001/XMLSchema-instance">
            <Messages   </b:PwsMessage>
            </Messages>xmlns="http://projectorpsa.com/CommonServices/" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"/>
            <ResponseId xmlns="http://projectorpsa.com/CommonServices/">0</ResponseId>
            <Status xmlns="http://projectorpsa.com/CommonServices/">Ok</Status>
            <ServerTimestampUtc xmlns="http://projectorpsa.com/CommonServices/">2018-03-15T15:03:37.4306662Z</ServerTimestampUtc>
            <a:AccountingPeriods xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
               <b:PwsAccountingPeriodSummary>
                  <b:AccountingPeriodCode>01~06-2018</b:AccountingPeriodCode>
                  <b:AccountingPeriodId i:nil="true"/>
                  <b:AccountingPeriodName>Jan-Jun2018</b:AccountingPeriodName>
                  <b:AccountingPeriodUid>1152921504606866570</b:AccountingPeriodUid>
                  <b:BeginDate>2018-01-01T00:00:00</b:BeginDate>
                  <b:EndDate>2018-06-30T00:00:00</b:EndDate>
                  <b:OpenForAdjustmentsFlag>true</b:OpenForAdjustmentsFlag>
                  <b:OpenForApTransactionsFlag>true</b:OpenForApTransactionsFlag>
                  <b: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>
               </b:PwsAccountingPeriodSummary>
               <b:PwsAccountingPeriodSummary>
                  <b:AccountingPeriodCode>01~06-2017</b:AccountingPeriodCode>
                  <b:AccountingPeriodId i:nil="true"/>
                  <b:AccountingPeriodName>Jan-Jun2017</b:AccountingPeriodName>
                  <b:AccountingPeriodUid>1152921504606866568</b:AccountingPeriodUid>
                  <b:BeginDate>2017-01-01T00:00:00</b:BeginDate>
                  <b:EndDate>2017-06-30T00:00:00</b:EndDate>
                  <b:OpenForAdjustmentsFlag>false</b:OpenForAdjustmentsFlag>
                  <b:OpenForApTransactionsFlag>true</b:OpenForApTransactionsFlag>
                  <b:OpenForArTransactionsFlag>true</b:OpenForArTransactionsFlag>
                  <b:OpenForCostFlag>true</b:OpenForCostFlag>
                  <b:OpenForGlTransactionsFlag>true</b:OpenForGlTransactionsFlag>
                  <b:OpenForTimeFlag>true</b:OpenForTimeFlag>
               </b:PwsAccountingPeriodSummary>
               <b:PwsAccountingPeriodSummary>
                  <b:AccountingPeriodCode>07~12-2016</b:AccountingPeriodCode>
                  <b:AccountingPeriodId i:nil="true"/>
                  <b:AccountingPeriodName>Jul-Dec2016</b:AccountingPeriodName>
                  <b:AccountingPeriodUid>1152921504606866567</b:AccountingPeriodUid>
                  <b:BeginDate>2016-07-01T00:00:00</b:BeginDate>
                  <b:EndDate>2016-12-31T00:00:00</b:EndDate>
                  <b:OpenForAdjustmentsFlag>false</b:OpenForAdjustmentsFlag>
                  <b:OpenForApTransactionsFlag>false</b:OpenForApTransactionsFlag>
                  <b:OpenForArTransactionsFlag>false</b:OpenForArTransactionsFlag>
                  <b:OpenForCostFlag>false</b:OpenForCostFlag>
                  <b:OpenForGlTransactionsFlag>true</b:OpenForGlTransactionsFlag>
                  <b:OpenForTimeFlag>false</b:OpenForTimeFlag>
               </b:PwsAccountingPeriodSummary>
               <b:PwsAccountingPeriodSummary>
                  <b:AccountingPeriodCode>01~06-2016</b:AccountingPeriodCode>
                  <b:AccountingPeriodId i:nil="true"/>
                  <b:AccountingPeriodName>Jan-Jun2016</b:AccountingPeriodName>
                  <b:AccountingPeriodUid>1152921504606866111</b:AccountingPeriodUid>
                  <b:BeginDate>2016-01-01T00:00:00</b:BeginDate>
                  <b:EndDate>2016-06-30T00:00:00</b:EndDate>
                  <b:OpenForAdjustmentsFlag>true</b:OpenForAdjustmentsFlag>
                  <b:OpenForApTransactionsFlag>true</b:OpenForApTransactionsFlag>
                  <b:OpenForArTransactionsFlag>false</b:OpenForArTransactionsFlag>
                  <b:OpenForCostFlag>true</b:OpenForCostFlag>
                  <b:OpenForGlTransactionsFlag>true</b:OpenForGlTransactionsFlag>
                  <b:OpenForTimeFlag>true</b:OpenForTimeFlag>
               </b:PwsAccountingPeriodSummary>
            </a:AccountingPeriods>
         </PwsGetAccountingPeriodListResult>
      </PwsGetAccountingPeriodListResponse>
   </s:Body>
</s:Envelope>

...

Code Block
languagexml
titleExample 02 - Accounting period is specified
collapsetrue
<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

ErrorNumber

ErrorCode

Description

57335AccountingPeriodNotFoundThe specified accounting period was not found.
57339CompanyNotFoundThe specified company was not found.