Vernita Gold Medal

Hi @Red Velasco-Oracle The bank record does not appear to be available on a workflow. I assumed it should be the same for an employee bank details as it is for vendor bank details. These are screenshots of trying to set the Entity Bank (Employee) field on an expense report:

Option C

Hi @Richard James Uri-Oracle No. There aren't any scripts running on the portlets or the underlying records. Thanks

Thanks @SouthernSun It can be edited on the UI to select a bank account. However, the requirement here is to populate the field automatically with the primary bank account record when creating a vendor bill so the user does not need to manually populate it.

Hi @Shiela Marie Villaluz-Oracle All users are facing the same issue

Consolidated Payment

Option C

Hi @Patrick Fresnosa-Oracle Thanks for this. Is there a way to split the account number and account name into two separate columns? Thanks

The fulfilment would always have to be done in NetSuite to ensure the inventory levels are correct in NetSuite. Starshipit is more of a courier coordination/booking tool

Hi @Claire Arkell Shopify and Starshipit have different functions when integrated into NetSuite. For example, in the integration I have set up, Shopify integrates into NetSuite to allow the creation of sales orders in NetSuite based on customer orders from Shopify. There is then an integration from NetSuite into Starshipit…

True

@Amanda Edwards , @Trixie Amora-Oracle I was after the header level memo field from the work order completion record

True

Hi @Trixie Amora-Oracle The memo field from a work order completion. I think my query is mainly: is there a join that can be used to source from the header level of a work order completion record on to a search for type: item?

Hi Yes, it created two journals for CTA-E. The original entry lines were: Subsidiary A: Dr Investment in subsidiary B Subsidiary A: Cr Intercompany clearing account Subsidiary B; Dr intercompany Clearing Account Subsidiary B: Cr Loan from subsidiary A

Hi This account only uses Australian Dollars. That is the base currency for every subsidiary. The account types are: Equity, Other Assets and Loan accounts

Hi There The transaction lines. I had looked at the source linked transaction.4 It points to an advanced intercompany journal. That doesn't tell me which lines it is generating the value for though (the journal is more than 10 lines). All of the lines appear balance between subsidiaries. Everything in this account is a…

Option C

Hi @Chelsea Jacobs Thanks for the suggestions. Toggling the edit button didn't work. The issue is related to the criteria in the brackets. I was hoping to understand why that is the case. Whether it is all bracketed criteria that cause the problem or the specific fields used in this example.

Option D

Deferral Account

Answer D

Answer C

This is for opening balances so I needed it to be against the customer deposit liability account. There are over a 100 deposits. I ended up using integrator.io (Celigo free tool) to import them. I will have to find the enhancement request and vote for including it as a standard function

Thanks @Patrick Fresnosa-Oracle In that case, what would be the use case for where the regular journal, with the 'To Subsidiary' field being exposed? Since that will always result in the journal posting to the CTA-E account, given the regular journal doesn't allow posting to more than one subsidiary's account, I can't see…

Hi Patrick The CTA-E account is used by NetSuite by default when running eliminations in the example you mentioned. How would I nominate which account to use, as per your example, when using a regular journal and not an advanced intercompany journal? In my use case, the currency is the same (AUD) for all transactions so it…

Hi @Patrick Fresnosa-Oracle Thanks for the detailed steps :). In your example, the equity amount is being posted to the cumulative translation adjustment-elimination account instead of the correct account in the parent subsidiary. doesn't that mean this hasn't eliminated correctly? Thanks

Hi @Trixie Amora-Oracle My question was more around trying to understand the implications of altering an inventory adjustment, to add in the correct date and $ value of the item.

Hi @Trixie Amora-Oracle It is this field: The saved search is a transaction search with criteria: type: Sales Order This is so that I can source fields from the sales order such as quantity picked; packed and shipped; sales order line memo, rate, etc which I can't do if the saved search is for transaction type: work order.…

Forward Scheduling