Hi all, Has anyone ever done multi-tender payment ...
# general
k
Hi all, Has anyone ever done multi-tender payment on Netsuite while capturing payment during shipment? I am having trouble on how to split the payment amount to different invoices generated from item fulfillment. I was thinking of a storing payments amount in custom field or even external database, and deduct it until it reaches 0.
k
Oh god, I wouldn't touch this with a ten foot pole!
That said - I suppose you could do something to customize it to allow invoicing immediately at fulfillment, and then you actually have seperate invoices to do payment capture from
But if you have pre-authorizations in play - just know that depending on your merchant this is likely to cause you all kinds of headaches
Plus - wouldn't most folks just want fewer captures on their credit card if it was a choice?
k
Hi kevin, thank you for the feedback. All our orders are prepaid.
We capture customer payment based on sales order. the multi tender problem arise when they redeem gift card
I can do allow invoicing immediately after fulfillment but the trouble I have is, I need to make payment to different invoices.
I don't know what is the best practice to store these multi tender payment while splitting them to possibly 5+ invoices generated from shipment
This is Ecomm order
k
Maybe I'm an idiot. but maybe I've got the wrong direction here
So the customer places an order on your website using a gift card, or buying a gift card?
k
customer can use gift card + credit card in order website.
k
I.e. I have a 100 dollar gift card, and I order 150 dollars in stuff - I have 2 payments to use when completing the order.
k
yes correct
we allow partial shipment as well
k
So then...what transaction type are you using on the recorded payment?
Are you using Customer Deposits?
k
we are using Sales order -> item fulfillment -> Cash sales for single payment Sales order -> item fulfillment -> Inv for multiple payment
k
I'm not sure how NS handles it when there's more than 1 customer deposit on a transaction, but it should auto apply when you invoice the sales order.
Then you just bring in SO+Deposits then Fulfillment -> Invoice and no customization neccessary
My guess is NS will use the first deposit for the application.
Until it's been used in full
You could even do that on your cash sale side as well - because I'm sure your existing process is completely forking you on a cash reconciliation process.
If you are doing captures at time of SO and not PreAuth-> Capture process.
k
Does SO+Desposit work for partial shipment?
Also thank you so much for the feedback, I will test out what you mention on the UI on netsuite
s
We bring gift card payment as payments item on sales order. On cash sale/invoice it used to deduct the amount from and rest of the payment was paid by CC.
k
Hi Sam, we are billing by fulfillments, because we allow partial shipping. will this method work?
s
Not sure because we use sales order for billing. We also used to ship complete for gift card redemption orders because partial shipment cause lots of issue.
k
Gotcha, i did some test case on our end, and it only works if we bill by order, We initially had the same approach when we capture sale after shipment
@KevinJ of Kansas I need assistant, do you know why long term liability does not show up under account for customer deposit, but it shows for payment?
k
why would you want a long term liability account for this process? that sounds like a baaaad idea
Tells me there's some kind of major process disconnect with the underlying accounting
k
I understand, I spoke with them, and planning on using customer payment rather than deposit