Best Of

Hi @User_PVAQ9

Are you referencing to CSV Bank File import,

If yes, navigate to Transactions -> Banks-> Banking Import History ->Upload File and then select Import with Default parser. You will get an option to download sample CSV file

Thanks

Hi,

Please take note that once accounts are deleted, there will be payment to any retrieval of data.

Unfortunately, advising how to mass delete of accounts is out of our scope. What I can advice is for you to contact your AMO.

Thank you for understanding,

Joahnna

Also, what is the best value to set for the "Minimun Period Window Size" accounting setting? - I really can't say on this one. I think this varies depending on your company processes and needs. It is a decision best handled by the CFO/ Financial Controller etc depending on the hierarchy in your finance team.

Hi @Benjamin Paul - USA

Indeed you can see some configuration changes, see SuiteAnswer ID: 92570.

Create a System Note saved search.

Set criteria to: Record Type = Company Preferences

Optionally set criteria: Field = Minimum Period Window Size.

Optionally set fields under Results subtag as you need.

Run the saved search.

Hi @Benjamin Paul - USA

I suspect this is due to the accounting setting Minimun Period Window Size which would have been set by someone.

Can you check this by following: Setup? Accounting> Preferences> Accounting Preferences> General subtab> Minimun Period Window Size.

I would definitely check out the Smartsheet tool from Celigo. Much more than reporting.

https://www.celigo.com/integrations/Smartsheet/

Hi @GLL,

Although I have a One World Account, I am currently using only one subsidiary, so my transactions have been limited to transfers between locations within the same subsidiary. I looked into this further and as you already discovered, there does not seem to be a way to transfer inventory between subsidiary locations via CSV import.

@Mikko De La Fuente-Oracle, can you confirm this?

Thanks,

John

Hi @Sonics,

This is the standard behavior for NetSuite. When you create a transaction, contacts are automatically attached if the customer has multiple contacts associated with it.

An enhancement request is filed under #131030. The only workaround is to manually remove and reassign contacts in the transaction record. Please visit SuiteIdeas and I hope you spare some time to vote for the Enhancement so we can raise the number of votes it has.

I hope this answers your question.

Not sure how I missed this before:

 search.create({
   type: "transaction",
   filters:
   [
      ["trandate","within","9/1/2020","8/31/2022"], 
      "AND", 
      ["file.name","isnotempty",""], 
      "AND", 
      ["mainline","is","T"]
   ],
   columns:
   [
      search.createColumn({
         name: "trandate",
         sort: search.Sort.DESC
      }),
      "transactionnumber",
      "entity",
      "item",
      search.createColumn({
         name: "name",
         join: "file"
      }),
      search.createColumn({
         name: "documentsize",
         join: "file"
      })
   ]
});