Olivier Gagnon NC Red Ribbon

I'm not sure I understand you need - rate is a standard column available for items in Item Groups

Return Authorizations are line-based transactions like Sales Orders or Invoices. Their amount is set by the line items added to them. If you require different amounts under different circumstances, you can either use different items under different circumstance, or use the same item but modify the rate. Note that if the…

I would probably submit this as a question to NetSuite rather then here...

Let me switch tables on you - can you describe your taxation needs are, and I'll let you know what the best solution is

Return Authorization is a transaction type you can give access to in Roles. NetSuite does not ship with any logic pertaining amount-based (or anything-based, for that matter) restrictions for approval - you can either approve or you can't. This would thus need to be handled as a customization.

There is no standard mass delete functionality in NetSuite. First of all, do you really need to scrap everything? Nothing is salvageable? You can'y just run updates on top of it to fix it? If you really do need to delete, here are a couple of options: 1. Once upon a time, I remember that you could contact NS Support and…

Correct - do not delete your accounts. Expose Internal ID and run an update based on this. As I gather you are implementing, for the rest of your imports, SET THE EXTERNAL ID. This will save you a massive amount of headaches later on.

1. Take out the CAD amount from your monthly USD Journal. Offset the missing amount to a junk account like 3200 Opening Balance. Import. 2. Create a second Journal, in CAD. Set the value of that one account, and then also offset to 3200 Opening Balance. Import. Result: If you did this well, 3200 is at 0 (or worse case like…

The field is most likely hidden then. You should customize it and make that field visible again.

If you set Terms, it will make an Invoice. If you set Payment Method, it will be a Cash Sale.

You must manually update them

This would be possible via scripting, I have done this multiple times for many clients. I've done versions where multiple fulfillments end up on the same Invoice, but 1 fulfillment = 1 invoice is actually easier. The ROI on that is pretty clear: the script is a one time cost and it's far, far less than a person's salary.…

One option would be to go to your Accounting Preference and turn on "Void using reversing Journal". This will allow you to void checks in closed periods by creating a reversing entry dated on the day you press the void button. However, note that using this ability restricts your ability to void transactions to just a…

Correct. You may wish to explore a product like Avatax if you want automatic updates, though this is a 3rd party add-on and will thus require a separate investment.

Well customer refunds is a system account you cannot change, so it does not appear anywhere (this is not the only such account) The bank thing... I hope this isn't a case of someone having renamed the Undeposited Funds accounts to a Bank Account... That would be bad. Otherwise, I believe NS just defaults to the first…

Ideally, instead of cresting SOs, your integration should have been set up to create Cash Sales right away. Cash Sales are what you want, as these will post to Undep Funds. If your integration had been optimally set up to skip the SO, you wouldn't need an Fulfillment not an additional Cash Sales step. I would actually…

How does your script work? Does it call a Search or something? Script execution speed is more or less a constant, but if your script does search operations, especially if they aren't properly filtered, you might notice a slowdown. Time of day may be a factor as well. I think scripts might run a little faster off peek hours.

How were you fulfilling them, using the normal bulk fulfilment? Do you mean you ticked in all 30 000 of them in one go and let NS process them?

I don't have any tested and confirmed code handy, no. My instinct would be to try placing nlapiSetCurrentLineItemValue('expense','currency',DEFAULT_CURRENCY); on the pageInit trigger. DEFAULT_CURRENCY would be defined to the internal id of whatever currency you want as a default.

My experience was with Invoices as well as Assembly Builds. In both cases, I was never able to reset the numbering by following steps similar as those listed here. Maybe because the SO isn't posting? Robert, can you try your sequence with posting transactions, just to see?

Last I tested, this did not in fact work. Please post back and let me know if this is now viable, I would be very interested in knowing

Yeah you can script that

Yeah, you are basically up a certain creek without a paddle. You CANNOT go back to a smaller number, even if you deleted that large transaction number, it's irrevocably set. The ONLY option you have is to try switching to Location-based numbering if you weren't doing it already, as this allows you a new track. Also, you…

If possible the simplest thing would be to just edit the Transaction and make the change. If this is not possible (ex: it's sitting in a closed Period), you can Void the transaction and re-issue it (though the Impact will now be in the current period). Issuing a corrective Journal is also a possiblity, though you have to…

Easiest way: create a Cash Refund for her original card but take out the Inventory Item, and replace it with a generic Non-Inventory item called "Misc Charge". Make sure amount is correct. Then create a Cash Sale, using the same "Misc Charge" non-inventory item and charge her corp card. The reason you need to use a…

By default there aren't any indication a record came from a memorization. However, you could add a custom checkbox called "From Memorization" and tick that on all memorization template records. You can then easily use that as a criteria in any search.

The proper method is to create a Vendor Return Authorization first and transform that as a Bill. The second option is to put non-inventory item placeholders on your Bill rather than the actual Items from the PO.

It is not possible to assign multiple department, though clever set up of a department hierarchy might see you through.

I designed such a script about 2 years ago. I remember it being extremely complex but I believe that was because of complexities in that particular customer's side. I could look at this with you, please drop me a line at ogagnon@ncompasssolutions.com

Hmm. I have seen this before yes. Take a simple case: I put in 100$ as exchange rate 1.5, and then take 100$ out at exchange rate 1.3. My COA would say 0$, but if I looked at it with foreign currency, I would see like 20$ left.