Duplicate records for Balance Sheet Extract by Account

Hello experts,

I have created a saved search for extracting Balances for a given month for all Balance Sheet accounts in NetSuite. The issue is the safe search returns duplicate rows for each GL account. Can you please help ? My saved search criteria is : –

Account Type : Various Balance Sheet Items – Bank , Current Assets etc etc..

Posting = True

Period = Last 18 months

In the results I only have – Account Number , Account Name , Period and Amount .

Any way to only have a single row for an account by period ?

Rookie Asked on January 26, 2022 in Saved Searches.
Add Comment
1 Answer(s)

Hello Experts,

Can someone help with created a Saved Search for Balance Sheet monthly Balance . I need this so that we can move Balance sheet monthly data to our planning system.

regards,

Vik

Rookie Answered on February 1, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor