This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone know if the Period Close Checklist/tasks are available through SuiteAnalytics connect (JDBC)? We use Per Subsidiary Accounting Period Locking (SA 19058)

I can join transactions to the `accountingperiod` but it doesn't do me much good. The accountingPeriod table only show's if the entire period (for all subsidiaries) is locked/closed. We might have some subsidiaries still closing the books but other subsidiaries have completed their tasks and locked their period

&gt; *How is Per Subsidiary Accounting Period Locking apply to transactions?*
&gt; Posting Period will default to null/blank when we enter a new transaction (i.e. Vendor Bill, Invoice, etc.) dated Today. Users with no Overrride Period Restrictions permission will have to enter the entity (Customer/Vendor) in the transaction first before the Period field is filled up. *NetSuite will check which period is open for that subsidiary for the transaction date indicated in the transaction.*

That is exactly what I'm trying to do with either connect, or SuiteScript ^

you can access it via not documented TaskItemStatus search via SuiteScript :slightly_smiling_face:
code below should give what you’re looking for

```let taskItemStatusSearch = search.create({
                    type: 'taskitemstatus',
                    filters: [
                        ['period', 'abs', o], 'AND',
                        ['itemtype', 'anyof', ['PCP_LOCK_AR', 'PCP_LOCK_AP', 'PCP_LOCK_ALL']], 'AND',
                        ['complete', 'is', true]
                    ],
                    columns: ['period', 'subsidiary', 'itemtype']
                });```