Has anyone had to resolve the error "You must have...
# suitescripts
Siena
08/15/2019, 2:45 PMHas anyone had to resolve the error "You must have at least one valid line item for this transaction" when attempting to transform a record? (In my case, trying to transform a sales order to an item fulfillment). The transformation never happens, it fails on the record.transform line. I can't find any commonalities between the failing transformations.
a
Aml
08/15/2019, 2:49 PMHave you set the quantity on any of the line items and committed them?
s
Siena
08/15/2019, 2:53 PMI'm not sure what you mean. The line item has a ton of available quantity, and I don't load or edit the sales order in my code at all before trying to transform it
b
battk
08/15/2019, 2:54 PMunless configured otherwise, you can only fulfill committed items
battk
08/15/2019, 2:54 PMif you can't fulfill any items, you get the error you are seeing
s
Siena
08/15/2019, 3:00 PMI mean committed says 0 on this particular sales order for the item, but on another sales order that worked fine with this item, it also said committed 0.
Siena
08/15/2019, 3:00 PMI also don't know what changes that number
b
battk
08/15/2019, 3:04 PMmany things affect commitments
battk
08/15/2019, 3:07 PMvalid locations, quantity available at that location, received special orders, approved drop ship orders, completed work orders, line level commit column values
s
stalbert
08/15/2019, 5:04 PMI hear marriage affects commitment.
😂 2
r
rustyshackles
08/15/2019, 7:25 PMI would also check what happens if I fulfill that record in the UI. Check if the Item fulfillment has items in its sublist.
s
Siena
08/15/2019, 7:40 PMWe actually just fulfilled one in the UI (from the purchase order "mark shipped button; there is no fulfill button on the SO) and it worked perfectly fine
Siena
08/15/2019, 7:41 PMso idk why it can fulfill in the UI but in my script, it thinks none of the lines are valid
b
battk
08/15/2019, 7:44 PMwhats the path in the url used by the button
s
Siena
08/15/2019, 7:50 PM/app/accounting/transactions/itemship.nl?id=376432&e=T&transform=purchord&shipstatus=C&poid=3437392&shipgroup=1&memdoc=0&whence=Siena
08/15/2019, 7:50 PMhowever thats off the purchase order, and obviosuly in the script i need to create it off the sales order
b
battk
08/15/2019, 7:51 PMwhat does your transform look like
s
Siena
08/15/2019, 7:52 PM Copy code
itemFulfill = record.transform({ fromType: record.Type.SALES_ORDER fromId: createdfrom, toType: record.Type.ITEM_FULFILLMENT, isDynamic: true });Siena
08/15/2019, 7:52 PMor, if there is a ship group and a header level location, it also includes those as default values
b
battk
08/15/2019, 7:59 PMyou might not need the location
battk
08/15/2019, 7:59 PMbut that particular transform requires the shipgroup to be set
s
Siena
08/15/2019, 8:22 PMit should be being set anyways
Siena
08/15/2019, 8:22 PMhow can you tell that from the url though?
b
battk
08/15/2019, 8:24 PMnetsuite doesnt add shipgroup to the url for fun
battk
08/15/2019, 8:24 PMif its there, its required
battk
08/15/2019, 8:24 PMmemdoc, poid, shipstatus are not
battk
08/15/2019, 8:25 PMtransform=purchord could be changed to transform=salesord and it should be the same
battk
08/15/2019, 8:26 PMhonestly, i would expect
/app/accounting/transactions/itemship.nl?id=376432&e=T&transform=salesord&shipgroup=1s
Siena
08/15/2019, 8:28 PMok i can start by double checking that the shipgroup is in fact being defaulted in the transform
Siena
08/15/2019, 8:29 PMthanks
Siena
08/15/2019, 8:32 PMof course I also have an order failing with the same error whose url in the UI is much simpler:
/app/accounting/transactions/itemship.nl?id=27128&e=T&transform=salesord&memdoc=0&whence=Siena
08/15/2019, 8:32 PMno shipgroup at all, it lets me transform directly from the sales order, and yet in the script I get the same error, you must have at least one valid line item on this transaction
5 Views