3961035 Newbie

It's not optimal, but you can create a SubList derived from a Saved Search containing 'Member Item' and 'Member Item...' fields to duplicate the content created within the Components (Members) table, then sort by either the Saved Search results, or from clicking the headers within the custom SubList.

For those who stumble upon this thread, here's some sample code to create a batched bin transfer via js/scheduled script: //Trxn Header var obj = nlapiCreateRecord('bintransfer'); //Rec type obj.setFieldValue('location', 1); //Loc ID obj.setFieldValue('memo', 'Memo text goes here'); //Line-data…

tgrimm, I think I've found the issue while putting together content for our PM. The subsidiary in use for the transaction/customer uses currency USD, though my user & the account is of another currency. Looking at the historic exchange rate; that would explain the reporting - as it appears reporting is consistently in my…

Search Type = Transaction Criteria: Type = Invoice Main Line = False (Tried w/ main line & without, the amount still does not reflect the actual amount displayed when viewing the transaction) Date Created = Within 01/01/2016 - 07/06/2016 Results: Internal ID Date Created Currency (each line shows USD) Exchange Rate (each…

In the top section of code, might this be a typo: 'custboy' rather than 'custbody'? },{'custboy_added_to_magpy':'YUP!'}

Hi 3ksys, We've worked through a similar issue with a similar need and resolved by using a scheduled script to trigger our Suitelet which then handed off a series of results to multiple User Event deployments.

Thanks michoel, this worked perfectly! I'd originally tried using 'name' but included (results, name) in my function rather than (type, name).

Do you have the barcodes feature enabled in your NetSuite account? Are you using the native UPC Code field on the item record to house the lookup value?

I've been working through issues around confusion with our purchase prices and have gathered: 1. In the simplest form, purchase price is the price to be pushed to the purchase order 2. Purchase price on the item record defaults to the 'Preferred Vendors' currency (USD, CAD, etc.) 3. Purchase price's conversion factor on…

For anyone who stumbles upon this; my original request was unable to reach resolution. The solution we've implemented was to create a Suitelet to pull the data from the external resource which then passes the data to the Restlet. Thanks again, Olivier!

Thanks Olivier! What value should be included to define a post within the URL?

I'm running into this same issue... have you been able to resolve? EDIT: We had a script running to populate a custom column field with the inventory detail data; this was causing our WebServices request to fail.

Are you able to identify whether or not the serialized items in question are allocated to any other order(s)? Try checking out the Reallocate Items screen. Transactions -> Inventory -> Reallocate Items Are your On Hand and Available quantities matching values on each item record? If not, there is potential for an Item…

Issue has reoccurred in our sandbox immediately after a refresh. Actions taken to trigger the unexpected error (for what seems it will be until the next refresh) - created a workflow for a custom record. Workflow has 1 state titled 'Active' and is set to 'Do not exit workflow'. The state solely performed Before Record…

Does this impact end users in SCA webstores?

Hi fishstickjesus, Might be incorrect, but I think Suitelet's can only be triggered through client/scheduled scripts. Had a similar issue a while back.

I'm not sure what the expected behavior with Cost Estimate Type: Preferred Vendor Rate vs. Purchase Price is, but the same thing happens regardless of my Cost Estimate Type... I've even set it to 'Item Defined Cost' with my 'Item Defined Cost' specified. The Purchase Price recalculates every time I selected 'Preferred' on…

For anyone who stumbles upon this post; this has been flagged as an S3 Defect (#367077).

We're facing the exact same scenario and reached the same conclusion as detailed by Dew. There's no 'good' way to modify mass amounts of existing records, since the need for adjustments in/out & product history may be an absolute nightmare. The solution that makes the most sense for us is to define the process going…

The 'big' benefit to matrix items is the ease of mass-producing item records based on list selections (4g - AT&T - 16GB - etc.) tied to the parent item. Matrix items also allow NetSuite's SCA to handle filtration & item pages extremely well. If you're not concerned about an SCA web-presence and are not interested in…

Hi bt, This could likely be handled through either a Saved Search & Workflow combination, or a client script on validate field. If a scripting isn't an option, one of the easier ways of handling the SS/WF solution: <Criteria> <Results> Int Id Warranty End Date New Warranty Start Date (Formula(Date) {warrantyenddate}+1)…

I believe \r should work. I'm able to emulate it in the console with: nlapiSetFieldValue('custitem_mbrewer_test_field','Line 1\rLine 2\rLine 3') Please let us know whether this works in your workflow context or not.