Vernita Bronze Trophy

Thanks @Red Velasco-Oracle The problem with scripts or workflows is, that assumes the transactions enter NetSuite. If the transactions fail at the connector stage, they never end up in NetSuite so no alternative routing is possible. The Farapp/NetSuite connector is a locked NetSuite bundle. It isn't possible to change how…

Hi @Red Velasco-Oracle The suggestions for workarounds that you have suggested will not work as: It is not possible to create a sales order from a POS farapp connector. The order is already fulfilled so the connector throws an error. The only available transaction types are sales orders and cash sales for the connector. So…

Thanks @Chelsea Jacobs The accounts are already inactove but good idea on filing a aupport ticket

@Jam Amper-Oracle do i need to create a new thread?

@Red Velasco-Oracle Just wanted to chekc this point too: Some middleware/integrators (like FarApp or Celigo) have an option to “force create” a transaction regardless of stock availability. I don't believe that setting exists in the NetSuite Connector (aka Farapp).

@Red Velasco-Oracle : Bumping this up again. did you see my last few posts?

Thanks @Chelsea Jacobs I have other credit card accounts. Those are linked to employees ('corporate card by default'). These ones aren't

Hi @Ayitah Tallada-Oracle I have done that. That only filters individual prepayment transactions and not net amounts or anything fully applied

B.

Hi Chelsea This is a new Netsuite account with very few transactions. The account in question is a credit card account. It hasn't been listed anywhere as a default. Thanks

@Red Velasco-Oracle Any updates on this?

option c

I found the answer: I was creating a generic group (Lists>Relationships>Groups) when I needed to create a resource group(Lists>Employees>Relationship Groups)

A.

I have worked out the reason myself. The loan and investment accounts did not have the elimination subsidiaries included on the account set up. They only had subsidiary A and sibsidiary B The entries from the system generated elimination journal would post to the accounts i.e. Dr Loan Cr Investment Asset in the elimination…

@Cherry Eunice B Licyayo-Oracle The issue here is the journal wasn't generated.

Yes @Pratik Teredesai-Oracle THe question is still unanswered The steps provided to create a primary contact did not resolve the issue as i had already done that

Hi @Cherry Eunice B Licyayo-Oracle Create 2 accounts: 1 current asset and 1 current liability Mark both for elimination Create am advanced Intercompany journal Ensure that the lines with the current asset snd current liability account have "eliminate" checked and the name of the other subsidiary. Run the month end close…

Hi @Red Velasco-Oracle Thanks for your response. I can't see the 'Allow Negative inventory' preference in Global Preferences; Enable Features; or Accounting Preferences. Where would this preference be? All references to this setting, in the NetSuite Help topics and Suiteanswers, is in relation to the Enhanced Validation…

@Pratik Teredesai-Oracle I had already done that before testing

Hi @Pratik Teredesai-Oracle and @Angela Bayliss I am using a sales order transaction

Hi @Niks Blando-Oracle The work around is not relevant for xlsx which is the format I'm trying to export to Exporting the report as xlsx (with incorrect currency symbols) ; saving it as csv (to get rid of formatting) and then saving it again as xlsx seems like a really long winded way to resolve this

HHi @Angela Bayliss Yes. The contact is assigned the primary contact role Unassigning the primary contact should just be editing the contact via the customer card (without opening the subrecord), I would have thought? At least that's how i assigned it

FAlse

I found this suiteanswer, though it is talking about CSV exports being "jumbled". In this case, the export is xlsx

Thanks @Divya Unnikrishnan I was wanting to keep AR and AP unlocked in September though lock the GL in September. And keep AR and AP locked in August, though unlock the GL in August.

Hi @MTL_MIA and @Red Velasco-Oracle I have tried the approach mentioned in Suiteanswers and that does not work. The value from the custom field without the 'Store Value' checked, results in a null value when sourced. It looks like this is not possible with a workflow EDIT: Found the issue. The original search was summing…

Hi @Red Velasco-Oracle Quantity is not an available field on the sales order transaction record

A.

@Ayitah Tallada-Oracle Please see screenshot below