There are several preferences available for the Nerdly Multi-company Automation (NMCA) in Settings > Company > General Preferences > Custom Preferences. The purpose of this article is to explain these preferences in as boring a manner as possible. We'll try and keep things light, though.

Preference Settings

Please note that the settings pictured here may or may not be the ones that are appropriate for your business. If you aren't sure, feel free to ask. That's what the paid support plan is for! We love your questions!

Leave Transfer Fields on Copy/Create?

Some NetSuite users make lots of copies of transactions, or create payable bills from purchase orders. The standard behavior for NMCA is to clear out all the "Transfer to Subsidiary" and "Transfer to Department, Class, Location" fields when the original transaction is copied or created from a purchase order. Checking this box will not clear out the "Transfer to..." fields, so that you can quickly and easily copy existing bills, use memorized transactions, or fill out your transfer to information on the purchase order.

Use Empty Values on Transfer to Segments

When the NMCA generates an intercompany journal entry to allocate costs from one subsidiary to another, the default behavior is to use the same values for class, department, and location on the destination subsidiary transaction line as were used in the source transaction, unless you populate the "Transfer to..." fields on the lines of the transactions. If you check the "Use Empty Values..." preference, then the intercompany journal entry will use the values in the "Transfer to..." fields no matter what those values are.  If they are null/empty values, then the NMCA will post them as null/empty. That's all it does.

JE Field to Mark True (NMCA 2.0)

This setting makes it possible for you to automatically approve Journal Entries, either with the "Journal Is Approved" checkbox or some other checkbox that you implement in your Advanced Journal Entry Approval workflow. 

To use this field, simply enter the script ID of the field that you would like the NMCA to mark as true when it generates a journal entry, and then set your workflow to auto-approve if that field is checked. 

For example, if I had a custom field called "System JE" with a script ID of "custbody_system_je", I would enter custbody_system_je in the "JE Field to Mark True" field. Then I can use the workflow to automatically approve any JE that is generated by the NMCA.

Ignore Classifications on Balancing Lines

Some people don't want classifications (Class, Department, Location...) on their balance sheet. By checking this preference, the NMCA will not populate any sort of Class, Department, or Location (or whatever you might have renamed those to be) on the intercompany AR or intercompany AP lines of the generated journal entry.

Journal Memo Separator

When the NMCA generates a journal entry from the vendor bill, it populates certain information from the bill into the memo field of the journal entry. By default, the NMCA uses a new-line character (It's "\n" in JavaScript for those who care). If you enter something else in this field, then NMCA will use that as a delimiter between the different data points added to the Journal Memo. So, instead of a new-line character, you might choose " | " (that's space, pipe, space) or ", " (that's comma, space) or whatever your happy accountant heart desires.

If you are going to be exporting to Excel, and want to be able to run something like Text to Columns, I'd recommend that you use something like a "|" or "~" or something that you wouldn't normally expect to find in text (like "." or "," or "!"). That will make it easier on you.

Journal Currency Source

When the automated intercompany journals are created, you can choose to have the journal currency be sourced from the base currency of the subsidiary, or from the currency on the transaction record. In the old days (before Advanced Intercompany Journal Entries) the only available currency for intercompany transactions was the subsidiary base currency, so that's the default behavior, but you can choose how you want it to appear now.