hello, we have a issue with inbound shipments wher...
# general
a
hello, we have a issue with inbound shipments where we are unable to receive more quantity than whats on the PO. Seems to be a issue with Netsuite but wondering if someone has any suggestions on how to deal with it?
a
It’s an accounting preference. Allow Overage on Item Receipts (or something like that).
a
oh wow
let me try that
@Aries I looked and the setting is already checked.
m
Inbound shipments are pretty limited. I'm 90% sure overages don't work out of the box.
a
@Mark C thats what I gather too, any solutions to overcome this?
a
@Amtoj other than full custom suitelet, You could receive what is on the PO and then edit the receipts to increase for overages. A two step process, not ideal, but it's the best option without scripting.
a
@AK47 thanks a lot. how would you approach this with a script? I can script but unable to figure out a way/
a
@Amtoj I'd probably plan this script the same way it would work manually. So a suitelet that asks what quantity to receive of each line on the Shipment. On submit, I'd create the native receipts for full quantity, and then have an update run at the end that would automatically increase the quantities on the receipt based on what was entered in the suitelet. Nothing glamorous, but I can see this working to prevent the manual entry.
a
@AK47 cheers! Spending this weekend on the solution. Will let you know
a
@Amtoj how'd it come out?
a
@AK47 since we have a 3PL handling item receipts I couldn't go down that route. Plus the Landed Cost Calculation was a issue. Hoping this might work??? Thoughts? https://blog.prolecto.com/2020/07/18/overcome-netsuites-inbound-shipment-over-receipt-challenge/
a
well, I know Marty is very smart...so his approach is usually best. Still sounds like the same idea though since you still need to receive the inbound shipment, have that trigger to create receipts, and then use the custom record to determine what to update. LMK what you come up with. Sounds interesting.
a
@AK47 will do. leaving for a vacation to Costa Rica tonight so once I am back 🙂
a
@Amtoj any luck over-receiving inbound shipments?
a
@AK47 no sir, basically when I revisited the whole process its not possible unless I use Prolecto's suggestion but that fails for us too due to limitations on our 3PL side. I am working with our 3PL to change a process and will have to try it after
a
weak, sorry to hear