RE: Duplicate records for Balance Sheet Extract by Account
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 ?
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.