https://netsuiteprofessionals.com logo
Join Slack
Powered by
Kind of a strange question, but is it normal to ha...
# general
j
Kind of a strange question, but is it normal to have over 100 item fulfillments for one SO (in this case drop ship). Was curious if NetSuite might experience any issues with that many related records over the course of a year.
k
I can't imagine that causing issues, but the simplest way to find out would be to do it.
j
We're having problems with billed shipping costs carrying over and wondered if that might cause an issue.
On smaller transactions, it doesn't seem to be happening, so didn't know if it's this particular transaction or if it was any large transaction.
k
Billled shipping costs won't occur after the first fulfillment.
has to be manually added to Invoices at that point.
or scripted onto it (I helped a client with some massively terrible spaghetti code to update the SO once the fulfillment was created)
j
That's interesting, because we have another PO where it does carry over.
Actually, I need to check something on that one.
s
I think that is the issue, it gets carried over from the sales order and sales order gets updated from last item fulfillment, but each item fulfillment can have different shipping cost, so either you need to put it manually on the IF or the invoice or like Kevin said, it needs to be scripted to ensure you get correct shipping cost.
j
I think scripting it is going to be the ultimate solution , since we do bulk invoicing.
I keep meeting resistance from all sides when I try to explain this, so I'm at a loss.
k
the basis of the calculation I used was "total shipping on item fulfilments - total shipping on invoices = amount to put on Sales Order"
j
Thanks.
k
and then when it invoiced - it invoiced for correct amount - and the next fulfilment would update with the correct amount to be invoiced.
I think I wound up having to get more creative with it - because of some agreements that customer had with their customers.
but the core logic was mostly the same.
oh i remember what caused the heartache
I had to do a "total shipping amount of item fulfillments except this one plus the shipping amount from this item fulfillment - because doing a straight search didn't work until after the record had saved and there was a stupid order of operations issue.
s
did you script that thing into this field? or did you had to create line level logic
k
I scripted it into the shipping cost field on the shipping tab.
s
aha which will bring the value in this box
Open in Slack
PreviousNext
Powered by