[dansteg]

We’re slowly switching all of our forms to Advanced PDF and it looks like I’m having an issue with this one. On the old PDFs, there was a print column for “Bin Numbers”, which printed the preferred bin, along with the quantity in that bin:

001.01A (400)

On the Advanced PDFs, I am not seeing the ability to pull in this field. From my understanding you’re pretty much limited to the fields that show up on the record. In this case the sales order. ${record.item.description}. I’ve actually even been able to go one level deeper in some cases ${record.item.salesrep.location} to pull in the location associated with the customer’s sales rep. However, I’m not able to do something like ${record.item.location.preferredbin}

Has anyone run into similar issues or do you have any idea on how to pull this information? I’ve guessed and guessed, looked at XML output for field names, with no luck:

${record.item.preferredbin} NOPE

${record.item.binnumber} NOPE

${record.item.binnumbers} NOPE

I can’t imagine that this is something NetSuite would miss. When a pick ticket is printed, it’s a huge help to see the bin location that the picker needs to go to.

Thanks in advance!
This is a cached copy. Click here to see the original post.

[cdelacruz]

Hello,

Have you tried using: ${item.inventorydetail}?

Note: Bin Management = T and Advanced Bin/Numbered Inventory Management = T in Enable Features page.

---

dansteg replied on 02/05/2016, 03:25 PM: Unfortunately, that did not work. We are not configured for Advanced Bin Management. Regradless, ${item.inventorydetail} returns no value. :-

[EnablingSolutions]

Within the Items List, have you tried something like ${item.item.preferredbin} ?

---

dansteg replied on 04/14/2016, 07:13 AM: I get an error for that ….’item.preferredbin’ Not Found…. I was able to get it to pull in a bin at one point, but it looks like it was just pulling in the first bin on the bin sublist. Since we have multiple locations, this won’t work and some crazy logic would be needed to check that the bin matches the line level’s location…and the bin is also preferred.

I opened a case with NetSuite and it basically came down to telling me this isn’t doable…and the solution would be to create a custom column field on the Sales Order/Transfer Order that would pull the preferred bin for the location that was entered on the line…..not going to do that, so I guess it’s standard PDF until they realize this is a problem.

[EnablingSolutions]

Ah yes, of course…My next suggestion was for a Custom TX Column Field which is populated by a post sourcing script, checking the Item and Location…

[tgrimm]

I just recently had to write this script on sales orders and work orders to pull in preferred bin. It is quite simple and fortunately the user doesnt have to be bothered with seeing the ‘Preferred Bin’ field on the sales orders lines section. After adding the custom column field, and after testing that your UE script is working to set the preferred bin, just remove the ‘Label’ from the column field on the custom transaction form you are working with and the data will remain in the background without being displayed in the UI. The problem here is that the data you are trying to get at is in another sublist. So you are accessing the sublist from the sales order, then saying go to this item record, then access the location sublist and provide me the preferred bin for the item.

[dansteg]

I just revisited this and although it does work under a client script (line validate), it adds an additional 1/2 second to run the search. I’d rather not burden our sales department with more overhead/wait times at the line level. I thought I could get away with it as an afterSubmit event, but if we have large orders (50+ lines), the script might hit the execution limit. I think I’ll just wait for NetSuite to realize that we still need preferred bins showing natively on Advanced PDF forms.

Code:
var binFilters = new Array();
var binColumns = new Array();

binFilters.push(new nlobjSearchFilter(‘preferredbin’, null, ‘is’, ‘T’));
binFilters.push(new nlobjSearchFilter(‘internalidnumber’, null, ‘equalto’, currentLineItem));
binFilters.push(new nlobjSearchFilter(‘location’, ‘binnumber’, ‘is’, currentLineLocation));

binColumns.push(new nlobjSearchColumn(‘internalid’, ‘binNumber’));

var binResults = nlapiSearchRecord(‘item’, null, binFilters, binColumns);

if (IsNotNull(binResults))
{
nlapiSetCurrentLineItemValue(‘item’, ‘custcol_so_pref_bin’, binResults[0].getValue(‘internalid’, ‘binNumber’));
}

[al3xicon]

I am also trying to do this. tgrimm I wound up taking your approach, but we also use Kit Items and have the Accounting Preference set to “Display Kit Items on Transactions”, so all the components show, and we need our warehouse to see which bins the components are in (something that the basic PDF handled no problem). Unfortunately, even my script doesn’t work with the Kit Items (because on Sales Orders, they aren’t listed).

I have a case open with NS now because, like dansteg, I have no work-around other than to use Basic Templates.

Has anyone been able to solve this while still making it work for Kit Items?

---

dansteg replied on 09/04/2016, 09:41 PM: Good (but bad) to see that others are having the same issue. Hoping that this can be resolved shortly, so that we can take advatage of the dynamic forms for pick tickets. Lots of ideas in store, but we definitely need the preferred bin for non-wireless warehouses. They are reliant on the pick tickets to find their bins, unlike using a wireless gun, which guides them. Thanks for opening up a ticket…if there is an enhancement number, please let me know and I’ll vote on it.

[Author]

Posts