Hi Chantilly -Right. Our reports infra is in need of some revisions.
Are you looking at a data dictionary or mapping tool of the database structure? Pentaho is over at Mifos rather than Fineract for licensing reasons. On Thu, Sep 1, 2022 at 12:04 PM Chantilly Muyaya <[email protected]> wrote: > Hello James, > > Thanks for your reply. > I'm Chantilly Muyaya From Democratic Republic of Congo. > > I learned about Fineract since 2017 and is at 2022 that I decided to > integrated it in the product portfolio of my fintech. Is since March that > I'm on the devlist > > My question about the cashier Transactions, is because I would like to > create a penthao report where staff could request the database to got the > balance and transactions (cash in, cash out, allocation and settlement) for > each cashier/teller for control. > > To resolve the problem I'm trying to create a procedure for that. > > Regards > > > > Le jeu. 1 sept. 2022 à 17:32, James Dailey <[email protected]> a > écrit : > >> Hi Chantilly >> >> Good to have you join the listserv. I see you first posted in August >> this year, correct? >> >> What is your interest in the project? Can you introduce yourself a bit? >> >> Specifically, why do you want access to a single table? Fineract is a >> complex banking application, where transactions are handled through various >> relational database tables. >> You wouldn't go to the database tables unless you are developing entirely >> new structures of database calls. >> >> If you have a user requirement, the practice is to discuss on list and >> see if there is already support. >> >> Thanks, >> >> - James >> >> >> >> On Thu, Sep 1, 2022 at 1:13 AM Chantilly Muyaya <[email protected]> >> wrote: >> >>> Hi, Bharath, >>> >>> Thanks for your answer. >>> In 'm_cashier_transactions' I can Found only a settle transactions and >>> not cash-in or cash-out. >>> 'm_tellers' store just tellers list >>> >>> Regards >>> >>> Le jeu. 1 sept. 2022 à 09:02, Bharath Gowda <[email protected]> a écrit : >>> >>>> Hi Chantilly, >>>> >>>> Did you check the `m_cashiers`, `m_cashier_transactions`, and >>>> `m_tellers` tables? >>>> If I am not mistaken the teller and cashier module data are stored in >>>> these 3 tables >>>> >>>> >>>> Regards, >>>> Bharath >>>> Lead Implementation Analyst | Mifos Initiative >>>> Skype: live:cbharath4| Mobile: +91.7019635592 >>>> http://mifos.org <http://facebook.com/mifos> >>>> <http://www.twitter.com/mifos> >>>> >>>> >>>> On Thu, Sep 1, 2022 at 1:26 PM Chantilly Muyaya <[email protected]> >>>> wrote: >>>> >>>>> Hello Dear All, >>>>> >>>>> After many research I can't found the Mysql table where the cashier >>>>> Transactions are store. >>>>> >>>>> Anybody as idea? >>>>> >>>>> Regards >>>>> >>>> -- Sent from Gmail Mobile
