Tryton - various questions

162 views
Skip to first unread message

Axel Braun

unread,
Apr 18, 2013, 10:46:56 AM4/18/13
to try...@googlegroups.com
Hello,

I'm currently testing a business scenario for use of tryton in a trading
company. Some question where I appreciate your help:

- tryton can maintain different companies to work with. How can I quickly
change the company (e.g. doing a sales as company A, then a Purchase as
Company B, and next a sale as company C)?

- When I enter a new party, e.g. employee, the party number is assigned
internally (means the systems creates the number). Can I switch this to
external number assignment (I create the number/alphanumeric)? Is this coding
or configuration work?
- Same question applies for offers (to customer) and quotation from purchasing

- when adding a party associated with sales, how can I add a contact person?

- where are bank data for companies / parties maintained

- tryton offers the possibility to send a .odt document by mail to a party.
How can i send a PDF?
Is there a way to fax the document out of tryton (e.g. via sendfax, or PDF-
email to the fax server)?

- Is there any integration with a telephone system possible (e.g. click on a
contact's phone number to call him)? e.g. via skype or an external telephone
system? Has someone already build this?

- when creating a material, I have to enter sales and purchase price. In many
cases we will not know this at that point in time. How can I swich off that
these fields are mandatory?

- Similar problem on the quotation for sales - is it possible to create a
quotation for sales with just a reference, means without customer in it? (This
will be added of course before it is sent out!)

- How can I create an inquiry to a supplier based on the just created
quotation for sales? Can I copy one inquiry from another (to ask same product
with a different supplier)?

- how can I see sales / purchases to a material ('open related records' on a
material does not show this)

- sometimes there are variable components in sales, e.g to cover changing
copper price. so the material price consists of
material 20EUR
copper component 5,33 EUR
Can this be handled in tryton in one sales line?
Adding a second sales line for the copper price is a potential solution, but
might cause problems in case of multiple sales lines with copper component....

- how can I see the document flow (quotation 2411 resulted in sales order 333,
invoice 231, with associated account records (postings) 33344455). Plus link
to associated supplier inquiry, if possible

- how can I create customer hierarchies (e.g. customer A belongs to group C,
customer D is a subdivision of A)? Is there a reporting possibility on this
(see sales on group and company level, for example).

- in general I miss the incoterms in sales and purchase, plus information on
customs tariff code - is this planned to add?

- is there a kind of 'customer/vendor info record' that combines a material
with a customer, e.g. to store special customer information for that material
(e.g. material is called 'Jim' , but in customer / vendor terms it is 'John')

- in order to avoid misunderstanding in dates in international communication,
can the month in tryton always be displayed as JAN, FEB, MAR, etc? (european
notation is usually 01.02.2013, 01 FEB 2013, while 01.02.2013 is for a US-
customer JAN 02, 2013)

- how is the lock mechanism work (to prevent that one record is changed from
User B while user A is working on it). Can user B at least open a record in
view mode then?

- has anyone already combined tryton with a reporting tool like Pentaho,
Jasper or Qliktech?

..a lot of stuff. Any help is appreciated.

Thanks in advance
Axel


Cédric Krier

unread,
Apr 18, 2013, 6:24:21 PM4/18/13
to try...@googlegroups.com
On 18/04/13 16:46 +0200, Axel Braun wrote:
> Hello,
>
> I'm currently testing a business scenario for use of tryton in a trading
> company. Some question where I appreciate your help:
>
> - tryton can maintain different companies to work with. How can I quickly
> change the company (e.g. doing a sales as company A, then a Purchase as
> Company B, and next a sale as company C)?

You can change current company via the User Preferences.

> - When I enter a new party, e.g. employee, the party number is assigned
> internally (means the systems creates the number). Can I switch this to
> external number assignment (I create the number/alphanumeric)? Is this coding
> or configuration work?

Yes if you remove the sequence on Party>Configuration

> - Same question applies for offers (to customer) and quotation from purchasing

It does not.

> - when adding a party associated with sales, how can I add a contact person?

For now, the module party_relationship was not yet writen.

> - where are bank data for companies / parties maintained

None.

> - tryton offers the possibility to send a .odt document by mail to a party.
> How can i send a PDF?

If you setup unoconv, trytond will be able to convert odt into pdf.

> Is there a way to fax the document out of tryton (e.g. via sendfax, or PDF-
> email to the fax server)?

Not by default.

> - Is there any integration with a telephone system possible (e.g. click on a
> contact's phone number to call him)? e.g. via skype or an external telephone
> system? Has someone already build this?

Yes if you configure the OS to manage "callto:" or "sip:" URI schema.

> - when creating a material, I have to enter sales and purchase price. In many
> cases we will not know this at that point in time. How can I swich off that
> these fields are mandatory?

It is not possible.

> - Similar problem on the quotation for sales - is it possible to create a
> quotation for sales with just a reference, means without customer in it? (This
> will be added of course before it is sent out!)

Not in the base.

> - How can I create an inquiry to a supplier based on the just created
> quotation for sales?

Manually

> Can I copy one inquiry from another (to ask same product
> with a different supplier)?

Duplicate purchase.

> - how can I see sales / purchases to a material ('open related records' on a
> material does not show this)

It depends what information you are looking for.

> - sometimes there are variable components in sales, e.g to cover changing
> copper price. so the material price consists of
> material 20EUR
> copper component 5,33 EUR
> Can this be handled in tryton in one sales line?

No.

> Adding a second sales line for the copper price is a potential solution, but
> might cause problems in case of multiple sales lines with copper component....
>
> - how can I see the document flow (quotation 2411 resulted in sales order 333,
> invoice 231, with associated account records (postings) 33344455). Plus link
> to associated supplier inquiry, if possible

Follow relate on sale.

> - how can I create customer hierarchies (e.g. customer A belongs to group C,
> customer D is a subdivision of A)? Is there a reporting possibility on this
> (see sales on group and company level, for example).

Idem about party relationship.

> - in general I miss the incoterms in sales and purchase, plus information on
> customs tariff code - is this planned to add?

It is up to you.

> - is there a kind of 'customer/vendor info record' that combines a material
> with a customer, e.g. to store special customer information for that material
> (e.g. material is called 'Jim' , but in customer / vendor terms it is 'John')

No only for supplier.

> - in order to avoid misunderstanding in dates in international communication,
> can the month in tryton always be displayed as JAN, FEB, MAR, etc? (european
> notation is usually 01.02.2013, 01 FEB 2013, while 01.02.2013 is for a US-
> customer JAN 02, 2013)

Perhaps by changing the date format but it needs to be tested.

> - how is the lock mechanism work (to prevent that one record is changed from
> User B while user A is working on it). Can user B at least open a record in
> view mode then?

https://en.wikipedia.org/wiki/Optimistic_concurrency_control

--
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: cedric...@b2ck.com
Website: http://www.b2ck.com/

Axel Braun

unread,
Apr 19, 2013, 3:52:58 AM4/19/13
to try...@googlegroups.com
Hello Cedric,

thanks for this fast and comprehensive answer. It leads to some more question:
 
>> - tryton can maintain different companies to work with. How can I quickly
>> change the company (e.g. doing a sales as company A, then a Purchase as
>> Company B, and next a sale as company C)?

> You can change current company via the User Preferences.

..but that means the user has to log on and off again? Then it is probably better to have a second session open

>> - When I enter a new party, e.g. employee, the party number is assigned
>> internally (means the systems creates the number). Can I switch this to
>> external number assignment (I create the number/alphanumeric)? Is this coding
>> or configuration work?

>Yes if you remove the sequence on Party>Configuration

>> - Same question applies for offers (to customer) and quotation from purchasing

>It does not.

What is the effort to change this? (Assuming it can be changed)

>> - when adding a party associated with sales, how can I add a contact person?

>For now, the module party_relationship was not yet writen.

Is there a due date for this?

>> - where are bank data for companies / parties maintained

>None.

Is there a plan to add this?

>> - tryton offers the possibility to send a .odt document by mail to a party.
>> How can i send a PDF?

>If you setup unoconv, trytond will be able to convert odt into pdf.

OK

>> Is there a way to fax the document out of tryton (e.g. via sendfax, or PDF-
>> email to the fax server)?

>Not by default.

I assume that it is similar to the sending of an EMail. One should be able to clone the method.
Maybe something for the wishlist?

>> - Is there any integration with a telephone system possible (e.g. click on a
>> contact's phone number to call him)? e.g. via skype or an external telephone
>> system? Has someone already build this?

>Yes if you configure the OS to manage "callto:" or "sip:" URI schema.

Great. That should be feasible on a Linux-Server.

>> - when creating a material, I have to enter sales and purchase price. In many
>> cases we will not know this at that point in time. How can I swich off that
>> these fields are mandatory?

>It is not possible.

...except we change the coding?

>> - Similar problem on the quotation for sales - is it possible to create a
>> quotation for sales with just a reference, means without customer in it? (This
>> will be added of course before it is sent out!)

>Not in the base.

OK

>> - How can I create an inquiry to a supplier based on the just created
>> quotation for sales?

>Manually

OK

>> Can I copy one inquiry from another (to ask same product
>> with a different supplier)?

>Duplicate purchase.

OK

>> - how can I see sales / purchases to a material ('open related records' on a
>> material does not show this)

>It depends what information you are looking for.

When I'm in the material view, I want to see from whom we have purchased a material, and to whom we have sold it. The purchase case in this context is more important.

>> - sometimes there are variable components in sales, e.g to cover changing
>> copper price. so the material price consists of
>> material 20EUR
>> copper component 5,33 EUR
>> Can this be handled in tryton in one sales line?

>No.

OK. How would you solve this requirement? Second sales line?

>> Adding a second sales line for the copper price is a potential solution, but
>> might cause problems in case of multiple sales lines with copper component....
>>
>> - how can I see the document flow (quotation 2411 resulted in sales order 333,
>> invoice 231, with associated account records (postings) 33344455). Plus link
>> to associated supplier inquiry, if possible

>Follow relate on sale.

OK, will check this

>> - how can I create customer hierarchies (e.g. customer A belongs to group C,
>> customer D is a subdivision of A)? Is there a reporting possibility on this
>> (see sales on group and company level, for example).

>Idem about party relationship.

OK

>> - in general I miss the incoterms in sales and purchase, plus information on
>> customs tariff code - is this planned to add?

>It is up to you.

You mean adding this as custom field?

>> - is there a kind of 'customer/vendor info record' that combines a material
>> with a customer, e.g. to store special customer information for that material
>> (e.g. material is called 'Jim' , but in customer / vendor terms it is 'John')

>No only for supplier.

Is it planned to have this for a customer as well? It is required to have it to store customer material specific information. Material text can slightly differ frm customer to customer, but if we do not put it the exact way on the bill of lading for example, customs will not let it pass through. So this is really a business requirement.

>> - in order to avoid misunderstanding in dates in international communication,
>> can the month in tryton always be displayed as JAN, FEB, MAR, etc? (european
>> notation is usually 01.02.2013, 01 FEB 2013, while 01.02.2013 is for a US-
>> customer JAN 02, 2013)

>Perhaps by changing the date format but it needs to be tested.

OK

Thanks again for your help,
Axel

Guillem Barba Domingo

unread,
Apr 19, 2013, 3:42:25 AM4/19/13
to try...@googlegroups.com
2013/4/19 Cédric Krier <cedric...@b2ck.com>
On 18/04/13 16:46 +0200, Axel Braun wrote:
> Hello,
>
> I'm currently testing a business scenario for use of tryton in a trading
> company. Some question where I appreciate your help:
>
> - where are bank data for companies / parties maintained

None.

 
> - Is there any integration with a telephone system possible (e.g. click on a
> contact's phone number to call him)? e.g. via skype or an external telephone
> system? Has someone already build this?

Yes if you configure the OS to manage "callto:" or "sip:" URI schema.

 
> - when creating a material, I have to enter sales and purchase price. In many
> cases we will not know this at that point in time. How can I swich off that
> these fields are mandatory?

It is not possible.

but you can't put 0.0
 
> - sometimes there are variable components in sales, e.g to cover changing
> copper price. so the material price consists of
> material                      20EUR
> copper component      5,33 EUR
> Can this be handled in tryton in one sales line?

No.

 
> Adding a second sales line for the copper price is a potential solution, but
> might cause problems in case of multiple sales lines with copper component....


--
Guillem Barba
http://www.nan-tic.com/

Raimon Esteve

unread,
Apr 19, 2013, 4:09:09 AM4/19/13
to try...@googlegroups.com
>> Yes if you configure the OS to manage "callto:" or "sip:" URI schema.
>
> another posibility is these module (I don't know it's maturity state):
> https://bitbucket.org/zikzakmedia/trytond-asterisk
> https://bitbucket.org/zikzakmedia/trytond-party_asterisk
> https://bitbucket.org/zikzakmedia/trytond-party_asterisk_event
> https://bitbucket.org/zikzakmedia/trytond-sale_asterisk

I'm waiting a asterisk tester from Nan-TIC and create tests ;)

Cédric Krier

unread,
Apr 19, 2013, 4:22:32 AM4/19/13
to try...@googlegroups.com
On 19/04/13 09:52 +0200, Axel Braun wrote:
> Hello Cedric,
>
> thanks for this fast and comprehensive answer. It leads to some more question:
>  
> >> - tryton can maintain different companies to work with. How can I quickly
> >> change the company (e.g. doing a sales as company A, then a Purchase as
> >> Company B, and next a sale as company C)?
>
> > You can change current company via the User Preferences.
>
> ..but that means the user has to log on and off again? Then it is probably better to have a second session open

Yes since 2.2 you can start 2 clients, login with the same user and set
2 different companies.

> >> - When I enter a new party, e.g. employee, the party number is assigned
> >> internally (means the systems creates the number). Can I switch this to
> >> external number assignment (I create the number/alphanumeric)? Is this coding
> >> or configuration work?
>
> >Yes if you remove the sequence on Party>Configuration
>
> >> - Same question applies for offers (to customer) and quotation from purchasing
>
> >It does not.
>
> What is the effort to change this? (Assuming it can be changed)

I don't think it is the same as Party Code is forever when Sale/Purchase
Reference is for a small time.
I think what you are looking for is a extra field to put an extra
reference.

> >> - when adding a party associated with sales, how can I add a contact person?
>
> >For now, the module party_relationship was not yet writen.
>
> Is there a due date for this?

Not that I know.

> >> - where are bank data for companies / parties maintained
>
> >None.
>
> Is there a plan to add this?

Why not it should not be difficult but as usual we prefer to have real
usage for it before just storing data.

> >> Is there a way to fax the document out of tryton (e.g. via sendfax, or PDF-
> >> email to the fax server)?
>
> >Not by default.
>
> I assume that it is similar to the sending of an EMail. One should be able to clone the method.
> Maybe something for the wishlist?

If you use send email to a fax server, you have nothing to do.
There is also the possibility to use a specific extension and link it
(at the OS level) to the sendfax program.

> >> - when creating a material, I have to enter sales and purchase price. In many
> >> cases we will not know this at that point in time. How can I swich off that
> >> these fields are mandatory?
>
> >It is not possible.
>
> ...except we change the coding?

Yes. But I think cost price could be set to 0 without issue.
list price could perhaps be required only if the product is salable (to
be checked).

> >> - how can I see sales / purchases to a material ('open related records' on a
> >> material does not show this)
>
> >It depends what information you are looking for.
>
> When I'm in the material view, I want to see from whom we have purchased a material, and to whom we have sold it. The purchase case in this context is more important.

For purchase, you have the supplier configuration.
Otherwise it should be possible to create a view that will aggregate the
party linked to sale/purchase lines by product.

> >> - sometimes there are variable components in sales, e.g to cover changing
> >> copper price. so the material price consists of
> >> material 20EUR
> >> copper component 5,33 EUR
> >> Can this be handled in tryton in one sales line?
>
> >No.
>
> OK. How would you solve this requirement? Second sales line?

Yes why not. But I think a clear use case should help to define the
requirements.

> >> - in general I miss the incoterms in sales and purchase, plus information on
> >> customs tariff code - is this planned to add?
>
> >It is up to you.
>
> You mean adding this as custom field?

I guess but probably it should be also linked to the configuration. For
example with the module sale_shipment_cost.

> >> - is there a kind of 'customer/vendor info record' that combines a material
> >> with a customer, e.g. to store special customer information for that material
> >> (e.g. material is called 'Jim' , but in customer / vendor terms it is 'John')
>
> >No only for supplier.
>
> Is it planned to have this for a customer as well? It is required to have it to store customer material specific information. Material text can slightly differ frm customer to customer, but if we do not put it the exact way on the bill of lading for example, customs will not let it pass through. So this is really a business requirement.

I think it is more an exception than a common practice, most business
trades with a lot of customer and they can not manage such things
customer by customer.

But any way, I don't see any difficulty to implement it as the
description is copied from the product to the sale line, this text could
be override.

Cédric Krier

unread,
Apr 19, 2013, 4:25:24 AM4/19/13
to try...@googlegroups.com
Those modules seem empty.

Raimon Esteve

unread,
Apr 19, 2013, 4:29:53 AM4/19/13
to try...@googlegroups.com
>> > another posibility is these module (I don't know it's maturity state):
>> > https://bitbucket.org/zikzakmedia/trytond-asterisk
>> > https://bitbucket.org/zikzakmedia/trytond-party_asterisk
>> > https://bitbucket.org/zikzakmedia/trytond-party_asterisk_event
>> > https://bitbucket.org/zikzakmedia/trytond-sale_asterisk
>>
>> I'm waiting a asterisk tester from Nan-TIC and create tests ;)
>
> Those modules seem empty.

I need to push when @bernat test asterisk communication ;)

Raimon Esteve

unread,
May 13, 2013, 4:46:19 AM5/13/13
to try...@googlegroups.com
2013/4/19 Cédric Krier <cedric...@b2ck.com>:
> On 19/04/13 10:09 +0200, Raimon Esteve wrote:
>> >> Yes if you configure the OS to manage "callto:" or "sip:" URI schema.
>> >
>> > another posibility is these module (I don't know it's maturity state):
>> > https://bitbucket.org/zikzakmedia/trytond-asterisk
>> > https://bitbucket.org/zikzakmedia/trytond-party_asterisk
>> > https://bitbucket.org/zikzakmedia/trytond-party_asterisk_event
>> > https://bitbucket.org/zikzakmedia/trytond-sale_asterisk
>>
>> I'm waiting a asterisk tester from Nan-TIC and create tests ;)
>
> Those modules seem empty.

I'ts a skeleton to new release.

Codereview available in:

http://codereview.tryton-erp.es/15/
http://codereview.tryton-erp.es/16/
http://codereview.tryton-erp.es/17/


--
Si us plau, NO adjunti arxius a les seves respostes. Li preguem que
integri el text al cos del missatge. Pot respondre usant NetEtiquete
que li ajudarà a seguir la conversa.
http://es.wikipedia.org/wiki/Netiquette

Por favor, NO adjunte archivos a sus respuestas. Le rogamos que
integre el texto en el cuerpo del mensaje. Puede responder usando
NetEtiquete que le ayudará a seguir la
conversación.http://es.wikipedia.org/wiki/Netiquette

Please, DO NOT send attachment files with your answers, just copy and
paste only the text you need to send into the body of your mails.
Repply using NetEtiquete. http://en.wikipedia.org/wiki/Netiquette
Reply all
Reply to author
Forward
0 new messages