Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.

Can't setLineItemValue for item in location

edited Nov 28, 2019 11:50AM in Accounting / ERP 25 comments

Trying to set the line item value for locationquantityonhand which is attached to a location. I found most of this code in a search on Google. They stated that locations is currently working but undocumented.

This code isn't working to do that:

            //load arbitrary item record              var itemRec = nlapiLoadRecord('inventoryitem', itemId)                //set the values on the item              itemRec.setLineItemValue('locations','locationquantityonhand', 2, 300);                            nlapiSubmitRecord(itemRec);
   

I'm able to however pull values just fine by using this:

var itemId = 14344;  var locationId = 2;                var filters = new Array();              filters[0] = new nlobjSearchFilter('internalid', null, 'is', itemId);              filters[1] = new nlobjSearchFilter('location', null, 'is', locationId);                var columns = new Array();              columns[0] = new nlobjSearchColumn('locationquantityonhand');              columns[1] = new nlobjSearchColumn('locationquantityavailable');              columns[2] = new nlobjSearchColumn('locationquantityonorder');              columns[3] = new nlobjSearchColumn('location');                            var searchresults = nlapiSearchRecord('inventoryitem', null, filters, columns);                            for (var i = 0; searchresults != null  && i < searchresults.length; i++)                {                    var searchresult = searchresults[i];                  var qoh = searchresult.getValue('locationquantityonhand');                  var qa = searchresult.getValue('locationquantityavailable');                  var ord = searchresult.getValue('locationquantityonorder');                      var id = searchresult.getValue('location');                  var fen = ord * .50;                         }
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders