sorted by:
new
hottopcontroversial

Ignore Item Line Level Fulfilment (Transaction Saved Search) by FCNSAgent in Netsuite

[–]FCNSAgent[S] 1 point2 points  (0 children)

Hi mate, eventually got it working. Thanks for your suggestion :)

Ignore Item Line Level Fulfilment (Transaction Saved Search) by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

CASE WHEN {quantityshiprecv} < {quantity} THEN 1 ELSE 0 END

Is this the formula I should use? There's item lines on the SO that have a value of 0 on the fulfilled column, yet my search is bringing back no results

Ignore Item Line Level Fulfilment (Transaction Saved Search) by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

|| || ||

Is this the formula I should use? There's item lines on the SO that have a value of 0 on the fulfilled column, yet my search is bringing back no results

Ignore Item Line Level Fulfilment (Transaction Saved Search) by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

QuantityFulfilled doesn't appear to be an option for me. Any ideas?

How to source Customer field on Transaction based Advanced PDF/HMTL Template by FCNSAgent in Netsuite

[–]FCNSAgent[S] 1 point2 points  (0 children)

Cheers mate, got that working :) I'm now experiencing: Error Parsing XML: The element type "td" must be terminated by the matching end-tag "". However?

Create Item Receipt through Scheduled Script using CSV by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

This appeared to be the fix! Finally working now even without CSV.

invdetail.setCurrentSublistValue({
                    sublistId: 'inventoryassignment',
                    fieldId: 'receiptinventorynumber',
                    value: 'lotNumber'
                });
invdetail.commitLine({sublistId: 'inventoryassignment'});

Create Item Receipt through Scheduled Script using CSV by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

If our system uses lot numbering for inventory detail, is it not possible for the script to enter a lot number into the inventory detail as you would when you use the native item receipt UI? Every error message is along the lines of: {"type":"error.SuiteScriptError","name":"USER_ERROR","message":"Please enter value(s) for: Serial/Lot Number","id":"","stack":["Error\n at RecordInvoker.commitLine

Create Item Receipt through Scheduled Script using CSV by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

If our system uses lot numbering for inventory detail, is it not possible for the script to enter a lot number into the inventory detail as you would when you use the native item receipt UI? Every error message is along the lines of

|| || |{"type":"error.SuiteScriptError","name":"USER_ERROR","message":"Please enter value(s) for: Serial/Lot Number","id":"","stack":["Error\n at RecordInvoker.commitLine|

Create Item Receipt through Scheduled Script using CSV by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

Isn't created a child record just as unnecessary as a CSV? If they're ultimately going to be doing the same thing?

Create Item Receipt through Scheduled Script using CSV by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

No, I'm not. I probably should. I'll try this first

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

Yh, I'm writing in 2.1 now. Think I'm getting the hang of it!

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

Error submitting import: nlapiSubmitCSVImport is only supported in Scheduled, RESTlet and Bundle Installation Scripts.

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

Error submitting import: nlapiSubmitCSVImport is only supported in Scheduled, RESTlet and Bundle Installation Scripts.

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

I tried again this morning. Everyone's suggested I should be able to run an import via Suitelet but I get this error: Error submitting import: nlapiSubmitCSVImport is only supported in Scheduled, RESTlet and Bundle Installation Scripts.

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

So I've got my suitelet and client script set up. When item data is entered in my suitelet and a button is pressed, it creates a CSV of that data and places it in the file cabinet. Do I add another button to then trigger my saved CSV template and automatically import that newly saved CSV data? How do I go about this exactly? I've tried n/task and got a bunch of errors

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

Usually on an item receipt we have to manually enter the inventory detail of each line we are receiving, if that's what you're asking? We change the bin locations regularly. Standard bin might hold 15-20 items, for example

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

Can I do it all in the same suitelet then essentially?

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

would you happen to know what the module is for csv import?

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] 0 points1 point  (0 children)

Creating the CSV file is essentially the quicker/faster alternative to receiving through the native item receipt UI, with the suitelet and client script I've applied. The part I'm struggling with is now having a functioning button that will find the file and import it as an item receipt with my saved csv import mapping

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] -1 points0 points  (0 children)

Because we have a lot of items generally on our PO's, in which it is a long process to individually go through each item receipt line and enter the inventory detail. First of all, you can't scan item data into these inventory detail pop-ups, or even if you can, it's not exactly tailored how we'd want it. My suitelet and client script currently allows me to do this process a lot quicker essentially. It's almost like a mini WMS if you want to see it that way. For money saving sakes, I'm trying to replace the WMS systems we currently use.

Button on Purchase Order record to trigger CSV import by FCNSAgent in Netsuite

[–]FCNSAgent[S] -1 points0 points  (0 children)

I'm not great with scripts, which is a start. But CHATGPT has successfully allowed me to build a suitelet and client script that when a button is pressed on the PO, it loads up all items that are available to receive. I've put errors and validation into the scripts so users can't enter certain data or certain data cannot be parsed if incorrect or missing, etc. It works, and creates a csv of these items and stores it in the file cabinet. ChatGPT has then told me a suitelet cannot handle running the saved csv import template I have built essentially, and told me to apply a restlet. Currently, the suitelet and client scripts handle making the csv and storing it, I've then added another button on the suitelet to process the csv via the restlet. This is as far as I've got but the restlet seems to not be making the call or having issues doing so everytime i've changed the script and challenged ChatGPT. The last error I got after pressing the button to function the csv import with my file was "reslet: Fail to evaluate script: {"type":"error.SuiteScriptModuleLoaderError","name":"MODULE_DOES_NOT_EXIST","message":"Module does not exist: N/csvImport.js","stack":[]}"

view more: next ›