# Accounting Period

**URL:** <https://connective.celigo.com/t/accounting-period/630>\
**Category:** Integrator.io\
**Tags:** error-handling, json, lookup, javascript, netsuite\
**Created:** [October 8, 2022, 1:50pm UTC](https://connective.celigo.com/t/accounting-period/630 "2022-10-08T13:50:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nuriensing](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/nuriensing/32/6918_2.png) [@nuriensing](https://connective.celigo.com/u/nuriensing)\
**Post date:** [October 8, 2022, 1:50pm UTC](https://connective.celigo.com/t/accounting-period/630/1 "2022-10-08T13:50:59Z")

</div>

I am trying to set the accounting period (posting period) on a invoice and bill.

Example:

![5301043caa20740200000001-43f9ab273ca044818d92210078945066.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/bd5e6f4f7a59b16a97abcba7981a45d3a120caf3.png)

Because the account/posting period is expanding every month (for example next month we will have Dec 2022). Its impossible to know before hand the internal ids:

 ![5301043caa20740200000001-e39b57bb1afb4c87b045fc4f8378695e.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/48153004c8ec5ff98d99849106123bbe6430495c.png)

However in the incoming JSON there is a month and year:

"year":2022,

"month":10,  
  
I created a javascript to eventually create a new key called postingPeriod where i for example put: "Oct 2022".  
  
When I try the following via mapping I will get an error:  

![5301043caa20740200000001-899d2f572f7e4da4ac865a8b05241427.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/optimized/2X/d/d133c370aeed95686133fd1dbc84824b500df501_2_690x27.png)

 

 ![5301043caa20740200000001-79aa33348623471fb3940ce6451c410a.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3a3e38a4c7f470ec74acecbe6c98f69f19f0e1c2.png)

  

![5301043caa20740200000001-89c7b5620fe44a9a9e5e6dd7a0cf8d78.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3fcf62289e50d02ba9eebd5ed3b1576fbb3ef9ca.png)

so this does not work.  
  
I also created an Account Period Lookup in Netsuite. However it seems in Celigo I cannot find the account period record type:

 

 ![5301043caa20740200000001-97c3e2c783f74803ae2e16fd4d8c0a20.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/8/889da24b1cbc02d8fca53473134ef7e15fdf7f2c.png)

Any idea how to fix this?

---

<div class="post-metadata">

**Author:** ![nuriensing](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/nuriensing/32/6918_2.png) [@nuriensing](https://connective.celigo.com/u/nuriensing)\
**Post date:** [October 8, 2022, 8:34pm UTC](https://connective.celigo.com/t/accounting-period/630/2 "2022-10-08T20:34:01Z")

</div>

I fixed it already.  
Added "Manage Accounting Period" to the Role \> Permissions \> Setup.