https://netsuiteprofessionals.com logo
#suiteanalytics
Title
# suiteanalytics
k

Kevin Weitzner

04/06/2022, 7:57 PM
What is the table to query for accounting periods ? I exposed the field in my query and its all numeric, I need to change the ID to the human readable - I tried AccountingPeriod and Accounting_Period and it doesnt look like either of those exist, I cant find any things in the roles that look like its a permission issue...
t

tdietrich

04/06/2022, 9:59 PM
@Kevin Weitzner There's a query in this post that might help: https://timdietrich.me/blog/netsuite-suiteql-accounting-periods/
m

michoel

04/06/2022, 11:55 PM
You could also try
BUILTIN.DF(postingperiod)
to get text representation of the accounting period
👍 1
k

Kevin Weitzner

04/06/2022, 11:56 PM
Thank you both so much. Will review tomorrow
Thank you @michoel this worked perfectly
2 Views