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

True

Hi @Alex Joves -Oracle To confirm,.the formula fields are redundant in the case of creating a task record as part of a workflow's 'create record' action. Is that correct? thanks

Answer C

Thanks @Clarisa De Torres-Oracle I wasn't able to import these though was able to enter it in the UI. I still get the prompt saying: "The journal entry does not balance between subsidiaries. Do you want to continue?" and once I click 'yes', "The elimination amount is not balanced in the intercompany transaction. Do you…

I think I found the cause of the issue: The 'Custom Record Entry' permission was missing. I still needed that permission even though the permission for the specific custom record type (i.e custom record B) was set to 'view' only.

Thanks @PaulFleetwood That's definitely an interesting suggestion. Unfortunately, it won't work in this use case. The use case is : There is a button on a record (which itself is a custom record), which opens a suitelet form The user fills in the fields on the pop up suitelet form and presses submit A custom record B…

Thanks @Clarisa De Torres-Oracle Am I right in thinking I need another 2 lines posted to subsidiary B, in order for this to stop throwing errors? Would one line be to an account which eliminates, where the due/to from subsidiary is Subsidiary A? The second line would be a regular line which does not eliminate. Is that…

Hi @Clarisa De Torres-Oracle What is the underlying cause of that error? Do the non eliminating lines need to balance in each subsidiary? For example: Lines 11 is necessary to make subsidiary B balance. is an additional line needed in subsidiary A (another debit) to make that balance? Would it need to eliminate?