PhilSpender's Profile
Rookie
11
Points

Questions
2

Answers
3

  • RE: How can I search REST API Accountingperiod entries?
    Rookie Asked on September 8, 2020 in Accounting.

    Thanks Chris. That’s very helpful. It works fine now.

    Regards,

    Phil.

    • 920 views
    • 6 answers
    • 0 votes
  • RE: How can I search REST API Accountingperiod entries?
    Rookie Asked on September 8, 2020 in Accounting.

    Hi Chris,

    /services/rest/record/v1/accountingperiod?q=STARTDATE%20ON%20%E2%80%9C1/1/2020%E2%80%9D%20AND%20ISQUARTER%20IS%20FALSE%20AND%20ISYEAR%20IS%20FALSE

    produces:

    {“type”:”https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1″,”title”:”Invalid search query .”,”status”:400,”o:errorCode”:”INVALID_PARAMETER”}

    Phil.

    • 920 views
    • 6 answers
    • 0 votes
  • RE: How can I search REST API Accountingperiod entries?
    Rookie Asked on September 8, 2020 in Accounting.

    Hi Chris,

    The problem is you cannot use the RefName field or Start date/End date fields to select the accounting period and therefore cannot get the id to add to (say) a journal posting.

    IOW the …/accountingperiod?q=  doesn’t include those fields so field selection isn’t possible, it seems…

    I have since built a dictionary of active NS accounting periods and am using that as my validation/translation mechanism.

    Regards,

    Phil.

    • 920 views
    • 6 answers
    • 0 votes