how to book this?

2fast4wireless

We are users of Navision, and we're facing a challenge.

We run a webshop on top of Navision.
But the payment goes through a 3rd party vendor.
At this stage this vendors is being inserted the only challenge is, we always money from this vendor.

We would like to track payments from clients, which at this stage we can't.
I'm trying to make it more client.
c = customer
v = vendor

Customer (c) places order for example 100 euro.
we get a payment from (v) of 100 euro (- 0.99 euro ct commission)

but in Navision the payment of the clients is still standing open and the payment received from the vendor is also standing open.

Unfortunately we can't create an incoming invoice on v with on this a payment on c.
This way would be ideal, then we can track the payments per clients and also track the amount of commision on v.

Please advise on how to do this.

Best regards,

Mike Hydra
Mega Shop Plaza

bstoyano

Hi,

What occurs to me is:
1. You get an order from a Client and you create a Sales order for the full amount AND a purchase order (or purchase protocol) for the commission of the vendor.\
2. You ship the goods and you post the Sales order.
3. You get a payment from a Client through a Vendor, which you record as payment from the client (including the commissions, e.g. EUR 100 = EUR 99 cash + EUR 1 commission). This payment you can apply to the posted sales invoice.
4. You post the purchase protocol and a payment to the vendor.

OR if you record your sales by the value of the cashflow that comes from the vendor, then register your e-vendor as your client and post the sales to him. The disadvantage here is that you will not know who your end-clients are.

kitik

I guess you could use a bank account.

You can create a new bank card and configure the Payment Method of the customer to automatically post the payment to that Bank. The cust. entry is no longer open.

The Balance for the Bank account is the amount the vendor has to pay (except for the comission)

You post a purch. invoice for the vendor comission. When you get the money you can post something like this:

-X (Temp Bank)
X-Comission (Real Bank)
Comission (Vendor)

Salut!

peperl

bstoyano wrote:

OR if you record your sales by the value of the cashflow that comes from the vendor, then register your e-vendor as your client and post the sales to him. The disadvantage here is that you will not know who your end-clients are.

You can use the real customer as the Sell-to customer and the vendor (created as customer) as the Bill-to customer.
That way, you can still keep track of end-clients.

bstoyano

peperl wrote:

bstoyano wrote:

OR if you record your sales by the value of the cashflow that comes from the vendor, then register your e-vendor as your client and post the sales to him. The disadvantage here is that you will not know who your end-clients are.

You can use the real customer as the Sell-to customer and the vendor (created as customer) as the Bill-to customer.
That way, you can still keep track of end-clients.

Yes, this works You even have a "Sell-to Customer" field in the Customer Ledger.