I have a customer who is currently using Dynamics GP for Sales Orders and here is the process.
They sell and item for $15.00, but they need $5.00 to go to an Amazon liability and $2.00 to go to Shipping liability with the rest to be paid by the amount that is on the invoice. The sale invoice needs to remain at the $15.00, but we need some sort of clearing type account or something for the other amounts. The order is fully paid when it is entered we just need those amounts to hit another account. I could use a payment method to post to one liability, but I can't use two payment methods.
What they do today in Dynamics GP is they enter two credit card payments to different credit cards which have different clearing accounts attached. So essentially they enter 3 payments for each order/invoice one to credit card A for Amazon clearing, one for credit card B for shipping clearing and then credit card C for the rest of the amount which hits the cash account when posted.
The other two entries are not paid until 2 weeks later when Amazon sends a payment which they just enter a G/L entry to clear the clearing account.
Any idea to replicate this in BC? I thought of prepayments, but I am not sure that would work.
Any help is greatly appreciated.
Tanya