Accounting Period

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

Example:

5301043caa20740200000001-43f9ab273ca044818d92210078945066.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:



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


5301043caa20740200000001-89c7b5620fe44a9a9e5e6dd7a0cf8d78.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:

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