Anyone else here using 3rd party POD with Netsuite...
# suitescript
j
Anyone else here using 3rd party POD with Netsuite? On Item Fulfillments, is it possible to update the
quantity
column on a line item based on another column that indicates the qty being returned? The POD software we acquired does not process a return and instead they added a new column on the item fulfillment to show the returned qty but we'd like to update the quantity - returned qty Slack Conversation
b
id say you are doing returns wrong if returning something is represented as an edit to an item fulfillment
j
my client doesn't even process returns. They are completely unfamiliar with that
adopting the POD software came to sort of shake the way they do business
their concept of return is that it should edit the quantity, amount all the way back to the Sales order, item fulfillment and invoice
b
still sounds the same amount of wrong
j
exactly
b
would only be sane if returning the item is the same as never selling it
j
they won't have it any other way
the last attempt they are wanting me to develop is the actual update of the qty
b
at least doing an inventory adjustment has some of the accounting impact correct
j
yeah, that's all they do
Is this concept somewhat possible `On Item Fulfillments, is it possible to update the 
quantity
 column on a line item based on another column that indicates the qty being returned?`
b
if you script it, sure
j
yeah, that's the plan
crap!
b
i wouldnt expect something like negative inventory from decreasing quantity on an item fulfillment
but would not expect their item commitments to behave like standard
if they did this is the ui, they would probably get warning about if they are sure they want to modify a billed item
i would expect this to cause minor mayhem
j
sounds like it would create a mess