I heard that there is a project to implement ERP Next at above mentioned company.
If I am right Navaisha has been occupied with this.
If needed you can ask me.
I heard that there is a project to implement ERP Next at above mentioned company.
If I am right Navaisha has been occupied with this.
If needed you can ask me.
Hi UbuntuFrans,
Well not really a water distribution company but a (government) Water Management Authority (WRMA).
However, since also raw water is to be paid in Kenya, the financial transactions are similar to a water utility.
Further, for specific reasons, the realy implementation is still a waiting final approval
rgds robert becht
Hi Ubuntu Frans,
I am interested on how to come up with the above. Please guide me.
Thanks
What you want to know? Who are the customers and who are the suppliers?
First let me know whether customers are selling water through a water meter?
Yes they are selling through a water meter. I want to know how to customize the erpnext sales invoice inorder to get the meter readings field and the start and end date of accounting fields. Thanks
First of all it is important to know whether the individual meters are read
every month, two months or three months (or maybe more)?
The product name will be the number of the meter.
Then you can add four columns in database 1. date previous read 2. previous
read usage 3. date recent read 4. recent read usage 4. minus 2 is quantity
(this column is in table
Unit of measurement should be changed into M3. The tables should be chaned
in MariaDB.
I would do this:
Thanks I will try this
Many thanks, I will try out and find if it works out
@RWEMA_Aimable 1.When the sales invoice is to be raised after you have submitted the new Meter reading will the consumed quantity be automatically populated in the sales invoice.
2.Are you going to make Sales invoice as one of the action performable(Action-drop down) from the submitted Meter reading.
Kindly advice
Yes, it will be done automatically, when a new Meter Reading is created. The quantity would be then fed into the invoice. I guess you have thousands of subscribers, so most of the actions need to be automated. I would also suggest to make the Meter Reading submittable so that the invoice would be generated on_submit. In case of the unavoidable adjustments, the reading and its invoice would be amended manually.
Yes, you can add it there, in addition to automated actions.
The company in Kenya working on this is Upande a Kenya based IT company owned @Mark_de_Blois… Dutch like @Ubuntu_Frans …and myself
The experience I shared is how it is done in Rwanda. Though the backend is not ERPNext, the logic is the same
Dear All,
Great you share your knowledge and expertise.
I think depending on the number of (increasing) data that later db should
be migrated to Postgresql, as Mariadb is relatively quite small in
comparison to Postgres.
Is water in Kenya prepaid or postpaid?
Mostly postpaid