Hey Everyone :saluting_face:
When i tried to upda...
# suitescriptd
Driss Talainte
10/29/2022, 1:13 PMHey Everyone 🫡
When i tried to update the existing Invoice i got this error : Please configure inventory details
How i update the existing invoice
1. Look for the invoice using : Etail order id
2. search for line item inside items using SKU
3. inside that item i want to update Etail order line ID
SCRIPT
Copy code
function updateme() {
r = nlapiLoadRecord("invoice", 246059, {"recordmode":"dynamic"});
r.selectLineItem("item", 1);
r.setCurrentLineItemValue("item", "item", 26492);
r.setCurrentLineItemValue("item", "custcol_celigo_etail_order_line_id", "45019547993346");
r.setCurrentLineItemValue("item", "line", "1");
r.setCurrentLineItemValue("item", "id", "246059_1");
r.commitLineItem("item");
}b
battk
10/29/2022, 5:37 PMdont change the item, that will reset all sourced fields
battk
10/29/2022, 5:37 PMquit trying to mess with the internal line and id fields
d
Driss Talainte
10/29/2022, 9:29 PM@battk yes but i don't know how to stop it from trying to add the same item when it's trying to update it
Driss Talainte
10/29/2022, 9:30 PMthis script is created by celigo
Driss Talainte
10/29/2022, 9:31 PM@battk
function updateme() {
r = nlapiLoadRecord("invoice", 246059, {"recordmode":"dynamic"});
r.selectLineItem("item", 1);
r.setCurrentLineItemValue("item", "item", 26492); ======> This part
r.setCurrentLineItemValue("item", "custcol_celigo_etail_order_line_id", "45019547993346");
r.setCurrentLineItemValue("item", "line", "1");
r.setCurrentLineItemValue("item", "id", "246059_1");
r.commitLineItem("item");
}
b
battk
10/29/2022, 9:36 PMremove lines from the code that doesnt do what you want it to do
battk
10/29/2022, 9:37 PMif you dont know which ones those are, then dont touch it and get celigo to fix the problem
d
Driss Talainte
10/29/2022, 10:12 PM@battk i see thank you so much
2 Views