Best Of

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"
      })
   ]
});

Hi @Dwight Schrute,

Is this something close to what you are looking for?

John

For the item not to show up on the inventory detail I would expect that it does not have a BIN and also does not have Inventory Number(s). If that is the case, I am not sure how it is being included in the search results since the criteria is Bin On Hand : On Hand is not 0, but it may be because the results are using the Location On Hand field.

Using search for this inventory snapshot report, it may be difficult to achieve with a single search. I know we can create 3 separate searches depending on the level of detail needed; Location Total, Location/Bin Total, and Bin/Inventory Number Detail. I do not see a quick way, using search, to accomplish a single search solution that yields concise data. Hopefully, someone else has conquered this already and will share their solution.

John

Hello @KNason76 ,

Yes, It's possible to add a customer ID/number in a custom AR Statement.

Goto Customization - Forms - Advanced PDF/HTML Template

Select customer statement and do the required changes using the customization

Hello @User_XQ321

One of the reasons is the Depreciation Journal Entry posted also includes depreciation for a different period (most of the time past period). To further check it, try running the Depreciation Monthly Report on a much broader period scope and try to reconcile the report against the Journal Entry.

Hello @User_XQ321

all related records should be unlinked first. This is done by editing the related records and unapply the Customer Refund under Items tab> Apply subtab then try to delete the record again.

If a Customer refund is created from a credit memo, Pls check the SuiteAnswer Id 24570

Hello @User_HPB3I

Currently adding a specific date range on Trend Graphs is under enhancement vide # 72177.

Alternative solution: Create a custom KPI and set the date range based on your requirement.