Olivier Gagnon NC Red Ribbon

You can change the Account Type so long as nothing has posted to the account. If stuff has posted, then you can edit all posting transactions and redirect them elsewhere (note: journaling on top won't do: you really have to edit all existing transactions). This is likely not feasible if you have stuff in closed periods, or…

It is not necessary to import files. You can mark gl impact line manually as cleared and/or reconciled.

Never heard of them, but you would not see them in SuiteBundle search most likely because they first need to share the bundle with your account. If you want a demo or something, you need to contact them.

No. Sub accounts do not appear in the parent's reconciliation. There are no means to make this happen.

Cleared is like a sort of pre-step. It says you verified the transaction and pretty much know what it is, but it's still just kind of a draft step. The reconciliation is where the buck stops. That's your true, actual record. I guess you can can of consider like a SO and an Invoice. The SO is like a draft and is usually…

For future reference, locking a period has no impact on your ability to perform bank rec. So you don't need to worry about unlocking the period next time. In any case, keep in mind "cleared" is not the same as "reconciled". Registers will show you what has been cleared, but it unable to tell if it has been reconciled. You…

GL impacts to Non-Bank account types cannot be Cleared. It also does not really allow you to net two transactions together per se.

If your Credit Card account is in CAD, then obviously, figures will be in CAD, not USD. This is a standing system limitation - NetSuite does not allow Credit Card accounts in foreign currency. This is a common problem for Canadian accounts wishing to use a USD CC. This is currently Enhancement Request #158027. This is of…

Advance to Apply is a field you manually specify a value in. It subtracts from the total owning value of an Expense Report. Check the Help for more details

Hi Gregg, You need to create the JE to hit A/R and - this is important - in the Name field, set the customer. The offset to A/R can be the write off account of your choice. I gather you've done this so far. So here is the missing next step. Create a Customer Payment transaction. In the "credits" subtab, you will find your…

Agreed. But not, NetSuite does not have this functionality at present, but it's not the first time I hear someone request this.

Hi Drew, If your bank establishement does not provide the right file format for NS import, that is indeed a bit of a problem. The reconcilition cannot be done via scripting or CSV import or any other means than the one provided by Netsuite. What you CAN do, however, is mark record as Cleared. A Cleared record is sort of a…

I agree there are many scenarios where Date and Period mismatches are necessary. That's why NS allows it. My advice is that unless this is a well thought out decision from your accountant, stay away from it. I have had many customers report problems with their financial reports only to discover it was due to date and…

Netsuite can never reconcile anything - the best that can be done is automatation to mark transactions as Cleared. The manual job could be reduced to a user simply Marking All Cleared as Reconciled. The "get online statements from our bank" part largely depends on the availability or Web Service interfaces from your bank.…

Hi, check out my answer in this thread.

Dating differently than the Period is indeed a typical culprit for many accounting problems. I do think it's best if you never date outside of the correct period.

NS should indeed not let you post into a closed period. Mismatching the Date and Period, as you are doing, is possible, and NS will respect the Period you entered. According to what you're saying, you're not posting in a closed period. Why do you say you think you are?

We built an integration like this for a customer. Like most banks, the file is not avaiulable directly for download via automated processes, so they manually download it, stick it on a server, and the file gets automatically fetched from there and the records get created in NS. As far as reconciliation goes, you cannot…

I don't think you can configure this in Netsuite, but a small script would do the job easily.

The list/record type must match the source list type. So, you can't do what you're trying to do.

It is not possible to add buttons to lines. You can add a hyperlink, though.

I advise you to read all the documentation found in the Help under the topic of SuiteCloud (Customization, Scripting, and Web Services) > SuiteBuilder (Customization) > Custom Fields

Standard fields cannot accept additional filtering. So, one way is to create a custom field that lists Classes, and then in the definition of that custom field you add additional filtering as needed. You'll then need to add a script to transfer the value of the custom field into the "real" field.

I'm not sure I fully understand your question, but the ID is unique to every created record and so would not factor at all if you're trying to dedupe.

If I understand correctly, you are using a custom script to perform a duplicate record check. As such, any potential issue with Custom Record ID would be due to an issue in your script. It all depends on how you implemented your deduping logic.

It's just a timing issue. Your SOs were created prior to you creating the field and setting the default, so all existing SOs will generate Invoices where the field is empty. If you created a new SO at this point in time, then invoiced it, you should find that the field properly defaulted. So you could run a mass update to…

Well certain fields are fundamentally required, like say Customer and such. Basically, it is not possible to remove ALL fields.

Hi K_dunc, No, not when I add them. I have multiple companies under one NetSuite roof. Typically, I like ALL fields to be specific to that company. (e.g. Company ABC> abc_customer_first_name, abc_customer_last_name, etc) but it seems that some standard netsuite fields cannot be removed (like Name). When you remove these,…

You need to grant only VIEW permission to the underlying record the list is displaying. So let's say it's a list of customers, then the user must only have VIEW permission on Customers. If it's a custom list, then make sure the user does not have permission to create custom lists, etc.

That basically looks ok to me. The 2 points I would mostly verify are: 1. What do the fields really return? 'Yes' 'No' or something else? NS is notorious for this kind of tricky stuff. 2. Try casting your field into numbers, as in [...] then to_number({custrecord_acsc_aaweb_add_jaws_ver})+1 [...]