Book supplier liability on sale

[Khurram Shahzad]

Dear All,

We have outsourced food services at our hospital. An order is placed from Ward to the service provider who delivers food.

Different food services have been configured in Products by giving:

List Price

Cost Price

Revenue Account

Expense Account

Suppose an order is placed for services whose list price is $8.0 and cost price is $6.0. I recorded the sale entry but at the same time I want to record that $6.0 is payable to the food service provider. Is there any way that we can configure it with the Product and this liability is auto-recorded with sale? If it is not possible, then what accounts should be affected while recording this entry?

--

 

Regards,

Khurram.

[Sergi Almacellas Abellana]

El 21/02/17 a les 11:44, Khurram Shahzad ha escrit:

I'm not sure to fully understand your requirements, but your
explaination remains me the sale_supply_drop_shipment module where the
goods are sended directly from the supplier to the customer. In this
scenario, a purchase request is created automatically when creating the
sale, and when this purchase request is processed the sale is processed.

Hope it helps.


[1]
http://doc.tryton.org/4.2/modules/sale_supply_drop_shipment/doc/index.html



--
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

[Cédric Krier]

On 2017-02-22 09:25, Sergi Almacellas Abellana wrote:
> El 21/02/17 a les 11:44, Khurram Shahzad ha escrit:

> > Suppose an order is placed for services whose list price is $8.0 and
> > cost price is $6.0. I recorded the sale entry but at the same time I
> > want to record that $6.0 is payable to the food service provider. Is
> > there any way that we can configure it with the Product and this
> > liability is auto-recorded with sale? If it is not possible, then what
> > accounts should be affected while recording this entry?
>
> I'm not sure to fully understand your requirements, but your explaination
> remains me the sale_supply_drop_shipment module where the goods are sended
> directly from the supplier to the customer. In this scenario, a purchase
> request is created automatically when creating the sale, and when this
> purchase request is processed the sale is processed.

Maybe they do not want to manage the shipments so using sale_supply with
service will be enough.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[Khurram Shahzad]

Dear Sergi and Cedric,

On Wed, Feb 22, 2017 at 2:19 PM, Cédric Krier <cedric...@b2ck.com> wrote:

On 2017-02-22 09:25, Sergi Almacellas Abellana wrote:
> El 21/02/17 a les 11:44, Khurram Shahzad ha escrit:
> > Suppose an order is placed for services whose list price is $8.0 and
> > cost price is $6.0. I recorded the sale entry but at the same time I
> > want to record that $6.0 is payable to the food service provider. Is
> > there any way that we can configure it with the Product and this
> > liability is auto-recorded with sale? If it is not possible, then what
> > accounts should be affected while recording this entry?
>
> I'm not sure to fully understand your requirements, but your explaination
> remains me the sale_supply_drop_shipment module where the goods are sended
> directly from the supplier to the customer. In this scenario, a purchase
> request is created automatically when creating the sale, and when this
> purchase request is processed the sale is processed.

Maybe they do not want to manage the shipments so using sale_supply with
service will be enough.

 

Thanks for the valuable response!

I have installed sale_supply module but I could not find any entry in any Menu for it. How and from where I can use it? Is there any documentation for it available?

The scenario is simple; we get service/goods from a service/goods-providers and sell them to our customer after keeping some profit. At the end of every moth, we want to get the bill payable to our services/goods provider from the system.

--

 

Regards,

Khurram.

[Cédric Krier]

On 2017-02-24 22:38, Khurram Shahzad wrote:
> Dear Sergi and Cedric,
>
> On Wed, Feb 22, 2017 at 2:19 PM, Cédric Krier <cedric...@b2ck.com> wrote:
>
> > On 2017-02-22 09:25, Sergi Almacellas Abellana wrote:
> > > El 21/02/17 a les 11:44, Khurram Shahzad ha escrit:
> > > > Suppose an order is placed for services whose list price is $8.0 and
> > > > cost price is $6.0. I recorded the sale entry but at the same time I
> > > > want to record that $6.0 is payable to the food service provider. Is
> > > > there any way that we can configure it with the Product and this
> > > > liability is auto-recorded with sale? If it is not possible, then what
> > > > accounts should be affected while recording this entry?
> > >
> > > I'm not sure to fully understand your requirements, but your explaination
> > > remains me the sale_supply_drop_shipment module where the goods are
> > sended
> > > directly from the supplier to the customer. In this scenario, a purchase
> > > request is created automatically when creating the sale, and when this
> > > purchase request is processed the sale is processed.
> >
> > Maybe they do not want to manage the shipments so using sale_supply with
> > service will be enough.
> >
>
> Thanks for the valuable response!
>
> I have installed sale_supply module but I could not find any entry in any
> Menu for it. How and from where I can use it? Is there any documentation
> for it available?

The documentation is here:
http://doc.tryton.org/4.2/modules/sale_supply/doc/index.html

> The scenario is simple; we get service/goods from a service/goods-providers
> and sell them to our customer after keeping some profit. At the end of
> every moth, we want to get the bill payable to our services/goods provider
> from the system.

I do not think the sale_supply will be exactly what you need because as
far as I understand you do not want to manage the purchase order of the
service to the supplier.

But I have a question, why do you want to generate the supplier invoice
instead of encoding the one you will receive?
Also how are the services sold/managed? Are you encoding a sale order
every day for every patient? This seems a very hard work to do.

[Khurram Shahzad]

Yes. You are right. We don't want to manage the purchase order of the service provider.
 

But I have a question, why do you want to generate the supplier invoice
instead of encoding the one you will receive?

The idea is good. But, in this case system will not be showing the correct account payable as the payable to supplier is not posted. Moreover, how will we validate or confirm that every line in the invoice sent by supplier is corresponding to a patient sale line.
 

Also how are the services sold/managed? Are you encoding a sale order
every day for every patient? This seems a very hard work to do.

We have one sale order for exactly one hospitalized patient. Every food item consumed by the patient appears in his sale order as sale lines.

[Cédric Krier]

On 2017-02-25 09:01, Khurram Shahzad wrote:
> > But I have a question, why do you want to generate the supplier invoice
> > instead of encoding the one you will receive?
> >
>
> The idea is good. But, in this case system will not be showing the correct
> account payable as the payable to supplier is not posted.

It will once you post the supplier invoice which will always be the case
no matter the workflow. You can not post in your accounting without
having the actual supplier invoice.

> Moreover, how
> will we validate or confirm that every line in the invoice sent by supplier
> is corresponding to a patient sale line.

You do not trust your supplier? The hard way is to generate purchase for
each order and re-construct the supplier invoice with the invoice line
generated by the purchase. But this will be long process.

The other way could be that you just matter about the quantities and so
you create a simple report base on the sale orders which gives you the
quantity orders over the invoiced period and check it against the
supplier invoice.

> > Also how are the services sold/managed? Are you encoding a sale order
> > every day for every patient? This seems a very hard work to do.
> >
> > We have one sale order for exactly one hospitalized patient. Every food
> item consumed by the patient appears in his sale order as sale lines.

So I guess this sale order is generated at the end of the
hospitalization otherwise how will you manage when the stay last longer
or shorted or when they are changes about the order etc.

[Khurram Shahzad]

Thank you so much for such a brief response. I think, we should go with invoices from suppliers and will validate it using some report from patient sales.