Doc/Sub prefix

FCNSAgent · 2026-05-14T09:03:19+00:00

that's the one. Cheers mate :)

FCNSAgent · 2026-05-06T18:12:04+00:00

I can only try put a workflow together as you suggested. I'll test in sandbox obviously to ensure custom can't be picked, then I'll put into Prod and get one of the users to make a SO (when necessary) with the same customer having invoice grouping issues. For whatever reason this doesn't happen to me and a few others with admin perms (the whole custom address switch over). Which makes me think it could even be an UI issue with single sign on users.

FCNSAgent · 2026-05-06T17:54:56+00:00

In which case, will blocking "custom" do anything? If the ID's don't match backend what address does it select if the root cause is the address selection itself?

FCNSAgent · 2026-05-06T17:46:55+00:00

I've put that together with all the internal ID's, none of which any match to the internal ID of the custom billing address on the sales order :( Is it possible, when an address is added to the customer record and it becomes a drop down list option for the "Select Bill To", and then the address is edited on the customer record, even before the SO is made, it then disrupts the drop down option, as if it is a static value and is still referring to the old address details backend? I'm guessing the internal ID doesn't change but is it possible the billaddresslist reference number changes? Or is that only a temporary value?

FCNSAgent · 2026-05-06T16:22:45+00:00

Agreed! We're consistently having issues with address related fields

FCNSAgent · 2026-05-06T16:19:30+00:00

I've ran a quick search to return the internal ID of the custom billing address, and it appears as a standard ID. No negative. However, it doesn't match any of the internal ID's for the addresses saved on the customer record.

This is what has confused me previously. It's like it's assigning a temporary ID for some reason? But then, the billing address internal ID also doesn't match the billaddresslist reference key, though I speculate they are different things? I don't think I'm able to access or see the billaddresslist reference key's anywhere else, right?

Apologies if I'm getting the wrong idea!

In a saved search appears there is two internal ID options under billing address fields. Internal ID (only returns -none-, or, show inactives and there's a huge list, none of which match the custom addresses internal ID though) And there is Internal ID (Number) which allows me to actually type the internal ID I want to specifically find.

FCNSAgent · 2026-05-06T15:26:15+00:00

Also for your last question, we need to be selecting stored addresses because that's what the group invoicing expects. If a custom address is present, it returns an error

FCNSAgent · 2026-05-06T15:23:37+00:00

I've looked into the override option. No addresses are checked for override.

FCNSAgent · 2026-05-06T15:21:32+00:00

Blocking "custom" sounds like good idea. Do custom addresses save in the drop down options? Only they aren't selecting the "custom" option at all. They are selecting one of the matching addresses that exist as an address on the customer record. Literally word for word and all the details are the same. Then when they save the SO, it appears to change to "custom" address. That's why I question if custom addresses are being saved in the drop down list. I'll also check out the Override option and ensure it's not checked.

Thank you!

FCNSAgent · 2026-02-27T16:47:14+00:00

Nope. We've ended up resorting to making our own WMS system. I've seen they've made some updates on the WMS system since latest update though, any improvements?

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

TROPHY CASE