RGrier Red Ribbon

I finally have the answer. You must include the item fulfillment in the initialize object, as I thought. The key is "itemfulfillment" instead of "auxReference" var itemReceipt = nlapiTransformRecord('transferorder', id, ' itemreceipt', { 'itemfulfillment' : 2219}); Robert, if you'd like to document this, which I strongly…

I found the issue. For some costing reason, receiving a transfer order that was partially fulfilled must match one of the fulfillments. So far so good. But there is no way from a RESTlet to specify which fulfillment and it will fail if you guess wrong. I found a SuiteAnswers page for how to do this using SOAP, "Initialize…

Invoice: Open is status A Invoice: Paid is status B

Yes, exactly. Whoever did this in 2009 closed the order after the item fulfillment was picked.

Found the problem. The client didn't have Bar Coding & Labeling enabled; so the upccode field was missing on the item record.

Did you ever find the answer to this question? I'm dealing with a client account where upcCode is missing. 

sorry, posted twice

I'm having this same difficulty and I think the work orders is to blame. I have assemblies that have work orders that were generated from sales orders. The work orders have either a completion or an assembly build depending if WIP was used or not. In both cases, the WO has the Built status but the newly manufactured items…

@qpongrass You should check for existing subrecords. use viewCurrentLintItemSubrecord and test it for null. If it's not null, you will have to edit the subrecord instead of creating it. var subrecordView = fulfillment_record.<strong>view</strong>CurrentLineItemSubrecord('item', 'inventorydetail'); if(subrecordView){…

@gerson.rodriguez I've been directed to move to SS 2.0 by management. Because 2 is a higher number than 1 so it must be better/sexier/cooler.

I've traced the problem to the preselected inventory detail subrecord that comes across with the transform. SuiteScript will not let me edit the existing subrecord; not even quantity. The same thing is happening when an item has a preferred bin. A subrecord is created with the preferred bin in it and I can't change the bin…

Our solution is all suitescript in suitelets. Because of this, we had to use Custom Records to create our own Inventory Count; and that's been a never ending headache. If NetSuite ever gets around to allowing script to change the status, we will switch back to their version of Inventory Count.

I'd love to hear from a NetSuite person on this. It seems that exposing the status to script would be a simple change. I am soon to be tasked with writing a new version of the count app, and I'd love to use NetSuite's inventory count record. Hello NetSuite?

Thanks, that at least gets me limited functionality.

I've again been tasked with committing inventory from script when "PERFORM ITEM COMMITMENT AFTER TRANSACTION ENTRY" is disabled. Can this be done? Is there and enhancement request for this?

While learning it was all they ways things could return null. My current struggles are: 1. Manipulating the inverntorydetails subrecord: it doesn't work the way the help pages say it should in all the places where the subrecord is used; and the example code doesn't work at all. 2. Some NetSuite tasks seem to be…

I has this problem because NetSuite requires the REALM in the Oauth 1.0 header. Once we added REALM to our web connector, it worked fine.

I've got a similar problem with item details on the Inventory Adjustment. The following code works just fine when I'm adjusting a serial/lot numbered item with a negative adjust-by quantity. But returns "USER_ERROR Please enter value(s) for: Serial/Lot Number" when I try to adjust a positive adjust-by quantity. How can I…

I found the solution. It's the setting, "Check Completed In Prior Operations During Operation Completion", under Set-Up->Accounting Preferences->Order Management->Work Orders, must be "No Validation." Apparently, the components sublist is static until the back-end process validates the quantity against the work order's…

To close a work order you have to use nlapiTransformRecord('workorder',ID, 'workorderclose'). That will create a new work order close record and cause the work order to change to closed.

I'm doing something similar on the validate line event. I need to step through the items list and insert a line in the proper place based on some input on the just-edited line. I'm finding that calls to nlapiSelectLineItem, nlapiInsertLineItem, nlapiCommitLineItem and nlapiSelectNewLineItem all fire the field changed event…

I'm trying to do this from a client script. I see the alerts, but it doesn't perform a redirect. function onFieldChanged(type, name, linenum) { nlapiLogExecution('AUDIT', 'onFieldChanged', name); if ( name == 'custentity38' ) // print financial history { nlapiLogExecution('DEBUG', 'onFieldChanged', 'custentity38'); var…

Try setting Customer Credit Limit Handling = Enforce Credit Hold on Setup -> Accounting -> Accounting Preferences -> General

Thanks, that worked once the 2018.1 rollout was complete.

I'm having the same message when creating an emailtemplate using a restlet. It works fine from the UI.

Bundles are back up

Now bundles will not update or install in sandbox environments.It throws "An unexpected error has occurred."

I have a portlet that holds a suitelet and when the user clicks submit, I include javascript to schedule a opener.reload() event.

Does this method cause the items to be added in the same order as they appear in multi? Order is critical for our configurator code. Right now the form calls another suitelet that loops through multi and calls additemtocart.nl seperately for each one. Each call is taking about 3 seconds, so a large configuration takes a…

It sounds like you need to set the units of measure fields on the item record. NetSuite allows you to have separate purchasing, inventory/warehouse, and selling units. If should be possible to set your inventory unit to case and your sales unit to each. You can then set the units column on your Inventory Adjustment to each…