Olivier Gagnon NC Red Ribbon

A couple of thoughts, if any help - 1. Only old versions of Excel have 65k line limits. Upgrade your Excel and this will no longer be a problem 2. If your external list has some sort of key, you can use this as an External ID in Netsuite. Now I suspect this probably won't work in most cases, as there probably isn't a key…

Use Address Book 1. The Assistant will attempt to match addresses by label. -John Is this new? Last time I talked to NS Support about this I was told there was no way to update addresses, you could only add new ones.

I know this one- for some unknown reason (probably to make us all a bit nuts), when importing item fields involving advanced inventory (once it has been turnedon or off- doesn't mtter) the prefferred stock level and reorder point filds are changed to boolean. You can't bring in a number in a boolean field, it is only a…

Try setting it at Location-level. I think it'll solve your problem.

You could swap out the Serialized Item with a non-inventory item (call it "misc refund"). That will sidestep the issue.

I have never attempted to do this, but it appears that as of a recent-ish update, NS has exposed the Consolidate Rate table to scripting. So, in theory, you could have a completely custom calculation engine running and setting the rates per your desired logic. In theory.

Hi Joe, That is a good topic. It is absolutely a violation of PCI compliance to use CSV files. The best process we have found it to use Dell Boomi to plug into both systems and transfer the card number that way. Dell Boomi is certified as a PCI Compliant platform, so this creates a secure end-to-end process. However, the…

NetSuite always uses the same system-determined account to post to it, as it does with a few other functionalities.

The items post to their Asset account. The contra to that is typically Inventory Received Not Billed. While the Asset account is configurable per item, the contra account is not configurable.

I have certainly worked with companies that didn't like NS's auto calc and set the figures by hand. Accountants tend to be pretty happy when Excel is involved, so nobody has requested yet to build an automation like I suggest may be possible.

Average Cost can only ever be affected by inventory transactions. So, doing an Inventory Adjustment would be the correct way. Items with 0 quantity on hand cannot have their average cost updated. This is all by-design NetSuite behavior.

Yes. Avg Cost remains for items with qty 0. As I said, you can't UPDATE the cost, but it remains to the last value before it dropped to 0. This is standard system behavior and cannot be changed.

One can speculate that 1099 forms are subject to changing laws, and NS no longer wanted to be in the business of being tied to the liability to having the correct forms all the time.

Hi Paul, The key point is that the Item Fulfillment is what logs the COGS, not the Invoice. So the Invoice's date is irrelevant one way or another. Perhaps the issue is just that you raise the invoice before the Item Fulfillment, thus the Invoice's revenue hits, but there is no source for the COGS yet? If that is all it…

Tax Accounts are system controlled are cannot be modified in this way. You can see your system tax accounts under Setup->Accounting->Tax Control Accounts. Of the accounts presented there, you can then select which one your Tax Codes should write to. There is no option for any other behavior.

COGS is normally generated by Item Fulfillments and is posted to the date of the Item Fulfillment. COGS is generated directly on Invoices only if that Invoice is created standalone (not from a Sales Order). COGS on Invoices is usually a sign of a bad process and action should be taken to correct the process. So based on…

Yes you would

Yes you can set up multiple FY in one calendar year, so long as the FY and periods do not overlap.

Hello Christina, No, native NS has no batch functionality to mass email invoices. You would need to hire a developer to build the customization.

All all subsidiaries in the same currency?

Hmm, unfortunately not. So there are a few processes in NetSuite that kind of auto-log interco accounting. Time Entry comes to mind, but there is also interco transfer orders and other things like that. Then there is the actual interco framework to go through PO-SO on either side. These do not use any preset accounting…

Mmm. Sorry, can't say without actually getting in there an investigating. I'm sure there is something, but don't know what

Which intercomany clearing account? For what interco functionality?

Natively, there is no way to do so: a Journal is either pending approval or approved. I believe there is a NetSuite bundle out there that adds the capability to actually reject a Journal.

There is a setting under Accounting Preferences to allow cross-subsidary expense reports. You can also select how to handle the interco aspect of it in there.

Hmm. That's unusual then. Are either the local Trial Balances, or the Consolidated reports customized?

Create a Customer Deposit manually, so that the Customer Deposit is not tagged to the Sales Order. There is otherwise no possibility of stopping it from auto-applying - this is basically the main feature of creating a Customer Deposit from a Sales Order.

My first thought is that in scenario 2, you removed the shipping charge from the SO but invoiced from the fulfillment, which still had the charge.

NS automatically calculates Retained Earnings. For more information please refer to the Help under: Accounting General Accounting Working with Accounting Periods Year-End Closing

Not via native functionality, but with customization it is possible.