User_7C8GF Red Ribbon

Hi @user_7wd6ot Name or name line is not available for selection on filter using. The entity has it but no entity line. When i added the entity just like the subsidiary, the custom transaction column line field did not display any invoices. Thank you so much.

The custom transaction line did filter out the invoices from the selected subsidiary but can we make it also to filter out by the entity name selected because the entity name may have different invoices from other subsidiaries? This is so close. THank you for the insights.

These are my configuration: Rev Rec Rule - Amount source - events percent amount, revenue start - base on element start date, revenue end - based on element end date. Rev Rec Mapping - Custom field date as source and target is start date as so on with end date till forecast. Item configuration:

Hi Patrick, this is great! Thank you so much. I added the opening balances and it tallies with their legacy reporting. Appreciate the help. Have a great day!

Hi Patrick, GL impact is debit AR and credit opening item ar balance. Legacy system is QB and the way I compare is by section. Income first then cogs then expenses. On the income section, variance is that QB recorded more invoices than netsuite. Netsuite did not take into account the opening invoices. I am wondering how to…

Thank you for the link. But i did go through that steps until step 5. I think step 6 to 7 are on the client side. My question is, is it okay that I integrate first in the SB account to make sure the connection and integration works? Thank all.

Hi Tigran, That is what i am suggesting with the client but client doesnt want to since they already put a lot of work in clearing and reconciling transactions. That is why the request was just to force a balance of the prior period recon balance. Thank you for the response.