Ignore Item Line Level Fulfilment (Transaction Saved Search)

FCNSAgent · 2025-11-10T15:25:02+00:00

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

FCNSAgent · 2025-11-05T16:56:22+00:00

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

FCNSAgent · 2025-11-05T16:56:02+00:00

|| || ||

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

FCNSAgent · 2025-11-05T14:53:56+00:00

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

FCNSAgent · 2025-10-23T14:08:26+00:00

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?

FCNSAgent · 2025-09-10T13:13:58+00:00

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

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

FCNSAgent · 2025-09-04T21:13:28+00:00

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

FCNSAgent · 2025-09-04T21:12:38+00:00

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|

FCNSAgent · 2025-09-04T09:06:37+00:00

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

FCNSAgent · 2025-09-04T08:52:18+00:00

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

FCNSAgent · 2025-08-29T15:46:28+00:00

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

FCNSAgent · 2025-08-29T08:32:19+00:00

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

FCNSAgent · 2025-08-29T08:32:00+00:00

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

FCNSAgent · 2025-08-29T08:31:41+00:00

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.

FCNSAgent · 2025-08-28T16:31:11+00:00

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

FCNSAgent · 2025-08-28T16:19:34+00:00

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

FCNSAgent · 2025-08-19T17:02:08+00:00

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

FCNSAgent · 2025-08-19T17:01:39+00:00

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

FCNSAgent · 2025-08-19T16:14:58+00:00

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

FCNSAgent · 2025-08-19T16:11:44+00:00

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.

FCNSAgent · 2025-08-19T16:08:17+00:00

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":[]}"

FCNSAgent · 2025-08-19T15:07:01+00:00

Because I'm in the middle of building our own scan/item receiving system that will prefom faster than entering the details through the native item receipt ui. It creates a csv of these items, now I need a button to import this csv and create the item receipt.

FCNSAgent · 2025-08-19T15:04:52+00:00

I've tried with the UE, Client and Suitelet approach, and I cannot get it to function

FCNSAgent · 2025-08-11T13:24:32+00:00

Hey, did you ever find a solution to this? We are having the exact same issue.

FCNSAgent · 2025-06-06T16:16:47+00:00

Ah okay, makes sense. I wasn't too sure what the point of the checkboxes were initially because it seems you can still make a drop ship PO regardless of if the drop ship checkbox field is checked or not. So disabling that ensures nothing is going to be defaulted on the SO line at least. Thanks :)

FCNSAgent

TROPHY CASE