by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Othmane HALHOULI
    @OthmaneHalhouli_gitlab
    Thanks a lot JOE
    Joe Bordes
    @joebordes
    yes, we added the possiblity to create manual changesets now
    and added an additional check to detect system changesets
    I'm glad it worked :-)
    Othmane HALHOULI
    @OthmaneHalhouli_gitlab
    Yes. Me toot :)
    too
    Ranieri
    @slemernet
    Hi @joebordes how are you?
    let me ask something, you add the possibility choose in filters some fileds from user, like a name, dept, etc
    works fine
    But now I need created a account report, but listed only users is active in system
    there any way I specify this condition in report too?
    I can put one by one name for each user, but is hard worked and each change in users I need manually change in report too
    Ranieri
    @slemernet
    not "hard coded" there any way to do that? You can think in another solution?
    Joe Bordes
    @joebordes
    Hi
    All good, and you?
    Ranieri
    @slemernet
    I am fine too
    Joe Bordes
    @joebordes
    can you give me an example
    or create a similar report in the demo?
    Joe Bordes
    @joebordes
    @Luke1982
    mysql strict varchar size validations
    give it a try when you can
    Account and contacts group by assigned to
    Joe Bordes
    @joebordes
    what am I supposed to see there?
    Ranieri
    @slemernet

    In fact, I need to count how many accounts and contacts each user has assigned to him.

    I generate an excel spreadsheet and put the subtotal function for that

    Problem is I need know if user is marked as active or not too
    Joe Bordes
    @joebordes
    use a custom SQL with a group by
    Ranieri
    @slemernet
    good idea, i will try do that, thanks!
    Joe Bordes
    @joebordes
    Let me know how it goes
    Luke1982
    @Luke1982
    @joebordes Very nice, so we validate the length of the input in the field?
    Joe Bordes
    @joebordes
    yes, correct
    Gerald Bigot
    @geraldbigot
    @Luke1982 Hello. Excuse me for the delay. I just finished to test Inventory Mutations module : it's perfect !
    @Luke1982 With your module I can offer multi "virtual Stock" possibilities to my clients.
    @Luke1982 I just have to find how to manage the assets links
    Luke1982
    @Luke1982
    Thanks, like I said the module is very powerful. What do you mean with 'asset links'?
    Joe Bordes
    @joebordes
    that is wonderful. Very happy. :clap:
    Gerald Bigot
    @geraldbigot
    I mean to manage serial numbers for each product
    Possible with assets ? No ?
    Luke1982
    @Luke1982
    That is exactly what asset does, the problem is it has no link to inventory lines on invoices, salesorders and such
    Gerald Bigot
    @geraldbigot
    I'm trying to find a manner to link all these records
    Luke1982
    @Luke1982
    What you want is a M:M relation between inventorydetails records and assets and a frontend that lets you handle that. I have an overhaul of the inventoryblock on the roadmap but that'll take some time
    Joe Bordes
    @joebordes
    in fact, you can relate assets to invoice
    even on the product lines
    Luke1982
    @Luke1982
    No, that's just a link that will let you create an asset, or it has changed since I checked last?
    Joe Bordes
    @joebordes
    you can select the asset also
    but, yes, it is just setting the uitype 10 in the asset module
    the standard relation between invoice and assets
    Luke1982
    @Luke1982
    Yeah I would like to expand that, sometime this year
    Gerald Bigot
    @geraldbigot
    Nevermind, it's already a very nice tool !