Olivier Gagnon NC Red Ribbon

I've been trying to add lines to an Invoice and no matter what I do I am getting Unexpected Errors. If it was the totals (which I am setting) I would expect a "transaction out of balance" error. So like, wth? Has anyone been able to add lines to a transaction recently? I created a case, #703055

I don't understand what Join is for. Name is the name of the field you are searching on, operator is the search operator and then value is pretty simple. What is Join for? Edit: Oh, another question: If I put many nlobSearchFilters, does the search treat them as an "And"? Like say I want to run a nlobjSearchRecord that…

Try putting your script in Released mode (it is currently in Testing).

It is not directly possible. To achieve the end goal, you would need to add the preventive measures to Journal entry (which truly are the only other means that A/R could be posted to, aside from various A/R transactions). It can be handled in several different ways. The easiest would be "soft" measures such as forcing…

Do you mean you want to create parent accounts and not post to them, like say something like: - 1200 Accounts Receivable --1201 Accounts Receivable: Trade AR Where 1200 is a parent of 1201, and only 1201 should be posted to? If so, you can flag 1200 as a Summary account. This will do as desired.

Terms can be configured under Setup-Accounting-Accounting Lists

I believe when you make the parent inactive, it then "helpfully" makes all the children inactive. But you can reactive all the children in order to just keep the parent as inactive. I may be forgetting something, but am under the impression this works well.

You can make all Parent Departments inactive if you purely use them for hierarchy and nothing should ever post to them. That would do the trick. Otherwise, a script can do it, yes.

Yes, it is. Your Journal must have the same Customer as on the Credit Memo, and must of course be using the same A/R account. So long as those two factors are true, you can tie the two together without issue. The Journal will appear on the CM's list of possible "Apply To" transactions.

Err, no.. I don't understand your problem then. If 1201 is the account defaulting and posting to, what is the issue?

NS cannot accept a foreign currency payment (DKK) into a foreign currency Bank (Euro). You will need to use Journals to translate the transaction by hand: 1. Accept payment of DKK into an intermediary account in DKK, just to close the transaction off 2. Create a Journal to transfer DKK into GBP 3. Create a Journal to…

Hi Kathy, glad to see you are still on NetSuite! The deposit/payment has no impact on recognized revenue. Invoices generate revenue, not payments. It also does not seem GAAP to me to recognize the revenue in your situation as the service has not occured (the student did not attend the seminar). I'm trying to think of how…

There is no collections tab, but given that you can create custom menus, you may be able to create your own. What do you envision a "collections module" would contain in terms of functionality?

Only accounts of type "Accounts Payable" show in the Aging and can actually be used for A/P purposes. Specifically, if you create a "other current expense" type account, that will not work. Functionality is specifically tied to "Accounts Payable" Assuming you have that, if you import a Journal that hits A/P and his given a…

You are basically looking to cSV Import the Make Deposit transaction. This is not yet supported by NetSuite. However, SuiteAnswer article 72421 provides a customization description to allow you to do this.

Yes, you need to go into Accounting Preferences and set INTERCOMPANY EXPENSES to "Allow and Auto-Adjust". You can read the Help documentation on this setting to understand how NS will handle the accounting.

Did the import not work? I would have thought that would have done it.

To adjust an invoice, you can edit it. There are no other means of adjusting an invoice. Anything else is a separate transaction, whether you do another Invoice or a Journal.

Well sounds like at the very minimum, you would need to create a customization. But based on what I'm understanding - that it MUST be a modification to an Invoice, without actually truly modifying the invoice - then the answer sounds like it would be "buy another accounting system". I can't really see any way of…

A transaction's status is set to closed if all of its lines are closed. There is no body-level "closed" option. Actually, come to think of it, that may just be the issue. The import may have succeeded and closed the lines you told it to, but you may be expecting the PO status to change. The status won't change if you don't…

You are talking about opening (un-closing) financial periods. Please check the Help under Accounting >General Accounting >Working with Accounting Periods >Closing Accounting Periods >Reopening a Closed Period for instructions and risks in regards to reopening a period.

There are no settings in NS to allow this, but a custom field populated by a script or possibly a workflow would definitely be possible.

From memory I do not believe Vendor Payments can be memorized. Depending on your settings, it may be possible for you to place Payments in future periods - that may indeed be an option. Otherwise, a custom suitescript-based solution would be able to create payments according to a schedule.

Well, why WOULDN'T you invoice a SO? What is your trigger point?

Typically we'll import these via a 2 line transaction, like a Bill or whatever. Line 1 has the expense amount being amortized, with the amortization schedule on it. Line two has the same amount as line 1, but negative. End result: you have a null value Bill, but the amortization will still occur and post properly.

Which country is this for?

Ok so your base problem is that your way of doing SOs is not scalable. So your problem isn't really how to invoice from here, but the fact that you need to backtrack and re-design the way you handle SOs. Sounds like you need a contract management/recurring billing solution. At the very least it could be Billing Schedules…

Yes, you need to enable the body-level Location field by customizing the form. This will allow you to set location for the AP impact.

ARM would not affect your ability to copy, but am pretty sure Contracts Renewal does. I don't believe there are any options so long as you use that module.

Looks like you're right, A/P Account is only selectable on creation. I would say that if you need to make a change, void or delete the Payment and create a new one.