Is there any solution to retrieve the sales order ...
# suitescriptx
Xiaoxin Li
07/31/2024, 1:37 AMIs there any solution to retrieve the sales order line item's inventory detail information (serial/lot number and quantity) using Suitelet? (1st screenshot result is target)
For now, I have created a saved search related to the specific sales order, but it shows each line item record's whole inventory detail information (saved search results attached)
b
battk
07/31/2024, 2:16 PMyou are duplicating rows by including multiple unrelated joins
battk
07/31/2024, 2:16 PMremove the item's serial / lot number
x
Xiaoxin Li
07/31/2024, 2:52 PMthanks, @battk
Xiaoxin Li
08/04/2024, 4:21 AM@battk could you help me how to get the possible lot number and quantity when creating a partial item fulfillment?
for a sales order, there's already an item fulfillment created with item qty 1 (i.e. inventory detail is "SH11621" lot number and "1" quantity)
next time, trying to create another item fulfillment with qty -"2", it only allows to use lot number ("SH11842") with qty - "2"
could you tell me how to extract such available lotnumber and qty info for new item fulfillment?
b
battk
08/04/2024, 2:43 PMlearn how to do an inventory balance or inventory numbers saved search
battk
08/04/2024, 2:44 PMyou can do the same with a query
x
Xiaoxin Li
08/06/2024, 7:45 AMthanks a lot
3 Views