Future of webzash

[Prashant Shah]

Hi,

I will be working on webzash from next month onwards and try to
maintain a regular release cycle. Things that are planned in next
version (3 months from now) :

- Keep the basic functionality intact and move webzash from
codeigniter to cakephp due to licensing issues with codeigniter
- Move to MIT license
- Support date ranges for all statements
- Charts
- Add support for sqlite, oracle, postgres apart from mysql
- Cleanup and refactor the code

Feel free to suggest any other improvements. Also, if anyone is
interested in contributing let me know.

Regards.

[omol...@gmail.com]

Support for Oracle should meet my request in my earlier post (see my post of July 30 titled "Webzash/Oracle) ... in any case, I shall appreciate it if you would still respond to my request.

I'll suggest that there should be provision for Account Codes in the Chart of Accounts creation, instead of just Account Name. Or, is there a way to do this in the current version ? If Yes, please let me know because I want to implement it right now.

Lolu

[Prashant Shah]

Hi,

On Saturday, August 10, 2013 6:42:19 PM UTC+5:30, omol...@gmail.com wrote:

Support for Oracle should meet my request in my earlier post (see my post of July 30 titled "Webzash/Oracle) ... in any case, I shall appreciate it if you would still respond to my request.

That is why I have included that in feature list. Code Igniter supports oracle but you need to search the code and locate where to replace the connection string. I am not implementing it in current version since anyway I am going to move to cakephp.

I'll suggest that there should be provision for Account Codes in the Chart of Accounts creation, instead of just Account Name. Or, is there a way to do this in the current version ? If Yes, please let me know because I want to implement it right now.

You can use the account code in the name itself if that serves your purpose : (001) Salary A/C

Where do you intend to use it ? Its simple to do, just add a column in the database and a form field in account create/edit page.

PS : I was working at a full time job so didnt get time to work on webzash. I am leaving the job this month end so that I can work on webzash and other open source projects :) I am in middle to leaving the job so I wont be able to do anything this month.

Regards.

[omol...@gmail.com]

Thanks, once again.

Yes, I know that I can implement the Account Code as you suggested ((001) Salary A/C), but I prefer to have Account Code as a separate field. I have explored the option of adding a column in the database, but I can't locate the form field and the account create/edit page ... could you please post a screenshot of this page ?

Also, I want to add a new menu item in the main Menu list, just before the "Help" menu item. Is this feasible ? If Yes, could you please post a screenshot of the process/page that shows how/where to do it ?

Regards.

Lolu 

[sharad singh]

lolu,

I have implemented account code and budget functionality in webzash.

if you need i can provide the full code.

Regards

Sharad

mob:+91-7275002789

--
You received this message because you are subscribed to the Google Groups "webzash-help" group.
To unsubscribe from this group and stop receiving emails from it, send an email to webzash-help...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Sharad Singh
9450328117
http://202.141.40.216:8080/brihaspati/servlet/brihaspati

[Prashant Shah]

Hi,

On Sunday, August 11, 2013 8:58:47 PM UTC+5:30, omol...@gmail.com wrote:

Yes, I know that I can implement the Account Code as you suggested ((001) Salary A/C), but I prefer to have Account Code as a separate field. I have explored the option of adding a column in the database, but I can't locate the form field and the account create/edit page ... could you please post a screenshot of this page ?

Also, I want to add a new menu item in the main Menu list, just before the "Help" menu item. Is this feasible ? If Yes, could you please post a screenshot of the process/page that shows how/where to do it ?

You will have to check code igniter for this. Go through the user_guide folder.

https://github.com/prashants/webzash/blob/v1.x/system/application/controllers/ledger.php

https://github.com/prashants/webzash/blob/v1.x/system/application/views/template.php#L107

[Prashant Shah]

Hi,

Other things that are planned :

- Use sqlite to store user and account config rather than text files
- URL based account selection so that user can access more than one
account at a time
http://localhost/webzash/account1/...
http://localhost/webzash/account2/...

@omololuwa
Whats the use case for adding account code. If possible I can
integrate it in next version.

Regards.

[omol...@gmail.com]

Sharad,

Please, provide the full code(s) and send it to my Email address.

Regards.

Lolu

[omol...@gmail.com]

Account code would ensure more accurate search for the Accounts in the Chart of Account in a search implementation scenario. If Account Name is used, a miss-spelt name would definitely return NO RESULT. I also want to integrate Webzash with an External software, and Account Code setup seems to be more plausible and compatible with this implementation.

Let me ask a Question: Is it feasible to have one or two PHP codes within Webzash to connect to an Oracle DB on a different computer in order to fetch some data from the Oracle DB.

Regards.

Lolu

[Prashant Shah]

Hi,

On Monday, August 12, 2013 7:39:46 PM UTC+5:30, omol...@gmail.com wrote:

Account code would ensure more accurate search for the Accounts in the Chart of Account in a search implementation scenario. If Account Name is used, a miss-spelt name would definitely return NO RESULT. I also want to integrate Webzash with an External software, and Account Code setup seems to be more plausible and compatible with this implementation.

Let me ask a Question: Is it feasible to have one or two PHP codes within Webzash to connect to an Oracle DB on a different computer in order to fetch some data from the Oracle DB.

Regards.

Lolu

Its just php you can do whatever you want :)

 

[omol...@gmail.com]

Thanks.

Lolu

[Prashant Shah]

I have started working on the updated version of webzash using cakephp
and it will be under MIT License

https://github.com/prashants/webzash-next

[Adekeye Omololu]

Great ! Great !! Great !!!

Thanks.

Lolu

[Thiago Dell Agnese]

Você pode adicionar um cliente de registro.

Eu estou tentando implementar isso, mas a estrutura de seu programa ainda é difícil para mim.

Após registrar o cliente pode gerar faturas, um por um ou automatizados para todos os clientes ao mesmo tempo.

poderia deixar a obra para nos colocar para fora as faturas porque os encargos bancários exigem um layout para cada banco.

Se você executá-lo usando seu programa aqui no Brasil seria generalizada, anexo segue os três arquivos que você precisa para criar faturas banco aqui no Brasil.!

obrigado,

Thiago

Em Sábado, 10 de agosto de 2013 05h27min26s UTC-3, Prashant Shah escreveu:

Oi, eu vou estar trabalhando em webzash a partir do próximo mês em diante e tentar manter um ciclo de lançamento regular. Coisas que são planejadas em próxima versão (três meses a partir de agora): - Manter a funcionalidade básica intacta e mover webzash do codeigniter para cakephp devido a questões de licenciamento com codeigniter - Move a licença MIT - intervalos de datas Suporte para todas as declarações - gráficos - Adicionar suporte para o SQLite, Oracle, PostgreSQL além de mysql - Limpeza e refatorar o código Sinta-se livre para sugerir quaisquer outras melhorias. Além disso, se alguém estiver interessado em contribuir, me avise. Atenciosamente.

[Thiago Dell Agnese]

I have created a new menu for customer base and have created a table in the database for this.

Could you tell me what are the structures to open the database, insert, update and delete records?

This is my first step, after missing only create invoices with the layout of my bank, which are 3 PHP files they send.

If you can help me I would be grateful.

--
You received this message because you are subscribed to a topic in the Google Groups "webzash-help" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/webzash-help/kcDW8OA8u1w/unsubscribe.
To unsubscribe from this group and all its topics, send an email to webzash-help...@googlegroups.com.

[Wira m.s]

Dear Prashant and all

My name Wira, I am one of the users of the software that you create, and have been using it since 6 months ago.

I think by joining this group and contribute as I could is a form of gratitude to those of you who have made this software useful for many people.

I would like to convey an idea, what if the interfaces of these applications can use extjs 4? I thought it will more clean and modern for a web application. :)

one simple question, What is your reason to choose cakephp as the replacement of codeigniter? why not phalconphp ?

sorry for my english, I use google translate :( 

[Tauqeer Ahmed]

Hi
Webzash is very good application, i like it & thumbs up for your efforts.
i want to know when will you release cakephp version of webzash, and what about current progress of development on cake php version


regards
Tauqeer Ahmed

[Prashant Shah]

Hi,

Just for the updates I have finally started to work on next version of webzash. Its still too early.

Here are some screenshots :

http://imgur.com/PyG4S6z,anR8JJL,n64ZD7q#0
http://imgur.com/PyG4S6z,anR8JJL,n64ZD7q#1
http://imgur.com/PyG4S6z,anR8JJL,n64ZD7q#2

Its based on CakePHP, due to licensing issues with CI. Most of the features will remain the same except for small improvements. Its just a total rewrite in CakePHP.

Regards.

[Tauqeer Ahmed]

Hi,

I want to know that data from my existing installation of webzash will be migrate to cakephp version of webzash


Regards


Tauqeer Ahmed

[Prashant Shah]

Hi,

> I want to know that data from my existing installation of webzash will be
> migrate to cakephp version of webzash

Yes. We will provide a script to do that.

Regards.

[Adam Oliver]

Would you kindly explain/send modified code where you have implemented account code and budget. Many thanks. aoli...@gmail.com

[Ishtiaque Sarwar]

Prashant

is there any user manual or general guideline of the feature and documentation of webzash. we are deploying this app for our clients but we are facing some issues with user manual, guideline how to use the system, appreciate if any help comes from you

thanks

[Prashant Shah]

Hi,

On Mon, Jan 19, 2015 at 11:03 PM, Ishtiaque Sarwar
<ishtiaqu...@gmail.com> wrote:
> Prashant
>
> is there any user manual or general guideline of the feature and
> documentation of webzash. we are deploying this app for our clients but we
> are facing some issues with user manual, guideline how to use the system,
> appreciate if any help comes from you

Will record a screen-cast on how to use it within 2-3 days.

Regards

[A.M.Ishtiaque Sarwar]

Thank you with some real life inputs would help completely.

thanks

A.M.Ishtiaque Sarwar
================
Managing Director
~~~~~~~~~~~~~~~~
Soft Tech Innovation Ltd

~~~~~~~~~~~~~~~~~

Consultant:

NARRI Consortium (8 International NGO's)

Islamic Relief Worldwide,

Azadi Technologies, Chittagong.

Sagarika Samaj Unnayan Sangstha,

Coordinator: 

Partnership Coordinator: Bangladesh Open Source Network

Service Wings: MUTHOFUN |  aamarPay | eBiponon |

C: 880-1711-272324 | 880-1611-272324

E: c...@softbd.com | in...@softbd.com
W: www.softbd.com | www.softbd.net | www.softbd.info

Skype: softbd | GTalk: ishtiaque.sarwar | Yahoo: ishti_kristi

DISCLAIMER: This email (including any attachments) is intended only for use by the named addressee(s) and may contain private, confidential and/or privileged material. Any reliance, dissemination, distribution, review, copy or other use of this email by person(s) who are not the intended recipient is prohibited. If you have received this email in error, please notify the sender immediately by email and permanently delete the email and any copies (including print-outs). E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.

[A.M.Ishtiaque Sarwar]

Please do record screencast in such a way that we can use any where without hesitation, and we can use that at our website for helping our clients without worrying about labels and names you will use at screencast

A.M.Ishtiaque Sarwar
================
Managing Director
~~~~~~~~~~~~~~~~
Soft Tech Innovation Ltd

~~~~~~~~~~~~~~~~~

Consultant:

NARRI Consortium (8 International NGO's)

Islamic Relief Worldwide,

Azadi Technologies, Chittagong.

Sagarika Samaj Unnayan Sangstha,

Coordinator: 

Partnership Coordinator: Bangladesh Open Source Network

Service Wings: MUTHOFUN |  aamarPay | eBiponon |

C: 880-1711-272324 | 880-1611-272324

E: c...@softbd.com | in...@softbd.com
W: www.softbd.com | www.softbd.net | www.softbd.info

Skype: softbd | GTalk: ishtiaque.sarwar | Yahoo: ishti_kristi

DISCLAIMER: This email (including any attachments) is intended only for use by the named addressee(s) and may contain private, confidential and/or privileged material. Any reliance, dissemination, distribution, review, copy or other use of this email by person(s) who are not the intended recipient is prohibited. If you have received this email in error, please notify the sender immediately by email and permanently delete the email and any copies (including print-outs). E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.

[Prashant Shah]

Hi,

On Mon, Jan 19, 2015 at 11:43 PM, A.M.Ishtiaque Sarwar
<ishtiaqu...@gmail.com> wrote:
> Please do record screencast in such a way that we can use any where without
> hesitation, and we can use that at our website for helping our clients
> without worrying about labels and names you will use at screencast

Checkout this video. It has no labels, etc and its in public domain.
You can use it without any hesitations.

https://www.youtube.com/watch?v=xBHbY9w9_SU

If you need the original video files let me know (150MB).

Regards.

[Kian Hua Ong]

Hi Prashant,

Nice piece of work, appreciate the work you have done.

We are using Webzash internally, and have made a few changes to suite our needs, namely, allow Alpha numeric "Number" field in entries, and sorting of accounts list in "Chart of Accounts".  We will be making more changes from time to time.

I would like to contribute my changes back to Webzash, if that is welcomed.  Please let me know how to go about contributing code back.  

Thanks.

[Prashant Shah]

Hi,

On Tue, Sep 1, 2015 at 10:28 AM, Kian Hua Ong <kianh...@gmail.com> wrote:
> Hi Prashant,
>
> Nice piece of work, appreciate the work you have done.
>
> We are using Webzash internally, and have made a few changes to suite our
> needs, namely, allow Alpha numeric "Number" field in entries, and sorting of
> accounts list in "Chart of Accounts". We will be making more changes from
> time to time.
>
> I would like to contribute my changes back to Webzash, if that is welcomed.
> Please let me know how to go about contributing code back.
>
> Thanks.

You can always send a pull request on github or email me the changes.

Did you try using the prefix / suffix option for number field ?

Regards.

[Prashant Shah]

Hi,

On Tue, Sep 1, 2015 at 6:38 PM, Kian Hua Ong <kianh...@gmail.com> wrote:
> Hi,
>
> No I'm not using prefix because the alphabets may be different for every
> entry. One example is we prefix the cheque number with bank code.

Number field is to hold the voucher / entry number. Why you using it
for cheque number ?

Either use narration to store cheque number or use this patch

https://github.com/prashants/webzash/wiki/Extra-fields

Regards.

[Kian Hua Ong]

Hi,

No I'm not using prefix because the alphabets may be different for every entry. One example is we prefix the cheque number with bank code.

[Prashant Shah]

Hi,

On Tue, Sep 1, 2015 at 8:44 PM, Kian Hua Ong <kianh...@gmail.com> wrote:
> I think my patch makes sense, as it allows both usage style. You can
> continue to put voucher number there as per your original design, or one can
> put the referred document number (eg cheque no, invoice no, po number...).

If you search the issue list at github, we already had patches for
handling cheques numbers, etc in past. It was implemented by adding a
extra field to the entry (rather than using entry number). Even I had
implemented it in a separate branch (which I have deleted). Yes, its
easy and it works, but it leads to other complications hence I had to
scrap the implementation. It took me 3 months to think how to
implement it so that its logically correct. The current implementation
is the right one, only thing is it has not received enough love :)

> This makes it very easy to view from the entry list, all reference number in

You can do that easily in the current implementation also.

> one glance. Anyway, this is just my accountant's request to make things
> easier for us. It's up to you whether you want to incorporate this change.

I do get patches where users have solved their issue by changing
something, but most of it is not suitable or flexible enough for
everyone. I end up borrowing the idea though and reimplementing to be
suitable for everyone :) So, patches are always welcomed.

Regards.

[Ramkrishna Mondal]

I have also fine-tuned WEBZASH :

1. Business Name & Address now getting printed on the printed reports.

2. Dr Cr symbols removed from the printed Balance Sheet/ Profit&Loss Statement.

3. PRINT button code changed to auto-hide it  on the  printed reports.

4. Changed and to & , so that row aligns remain intact when printing Profit & Loss Statement on A4 size paper.

[Kian Hua Ong]

Thanks for taking time to reply, but I would like to know what kind of complication will arise from changing the entry number field to alpha-numeric?  Don't want to get into trouble later.

--

Regards,
K.H.Ong

[Prashant Shah]

Hi,

On Fri, Sep 4, 2015 at 10:28 AM, Kian Hua Ong <kianh...@gmail.com> wrote:
> Thanks for taking time to reply, but I would like to know what kind of
> complication will arise from changing the entry number field to
> alpha-numeric? Don't want to get into trouble later.

There are no issues with changing entry numbers to alpha-numeric or
using it for cheque number if you are comfortable with that.

But, for some users having a common "entry level" cheque details might
cause issues (1) if they want to issue more than one cheque for making
a single payment entry or (2) they want to store cheque number with
the bank ledger and receipt number, etc with party ledger account or
something similar. Having a "ledger level" reference will properly
link the ledger entry with cheque/bill/receipt/invoice details which
is where it should belong and not with the whole entry.

Regards.

[Prashant Shah]

Hi,

On Fri, Sep 4, 2015 at 11:14 AM, Prashant Shah <pshah....@gmail.com> wrote:
> But, for some users having a common "entry level" cheque details might
> cause issues (1) if they want to issue more than one cheque for making
> a single payment entry or (2) they want to store cheque number with
> the bank ledger and receipt number, etc with party ledger account or
> something similar. Having a "ledger level" reference will properly
> link the ledger entry with cheque/bill/receipt/invoice details which
> is where it should belong and not with the whole entry.

I can do something like this

Eg:

Dr ABC Ltd
Ref : Bill no. 00001 / 18-august-2015
Cr XYZ Saving Bank Account
Ref : Ch. no. 12345 / 20-august-2015
Cr PQR Saving Bank Account
Ref : Ch. no. 67890 / 21-august-2015

It will properly link the cheque/bill numbers with the correct bank account.

[Kian Hua Ong]

Ahhh, I see.  Thanks.

Another issue I just found, if I view Ledger Statement, and use a date filter, the opening balance is wrong.  It does not take into account the "Opening Balance" I set in Ledger setting.  I have already filled a bug report in Github on this, together with the code to fix the bug.

File: Model/Ledger.php
Line: 344

$op_total = 0;
if (empty($op['Ledger']['op_balance'])) {
$op_total = 0;
} else {
$op_total = $op['Ledger']['op_balance'];
}

$op_total_dc = $op['Ledger']['op_balance_dc'];
if (is_null($start_date)) {
/* If start date is not specified then return here */
return array('dc' => $op_total_dc, 'amount' => $op_total);
}

--

Regards,
K.H.Ong

[Prashant Shah]

Hi,

On Fri, Sep 4, 2015 at 12:42 PM, Kian Hua Ong <kianh...@gmail.com> wrote:
> Ahhh, I see. Thanks.
>
> Another issue I just found, if I view Ledger Statement, and use a date
> filter, the opening balance is wrong. It does not take into account the
> "Opening Balance" I set in Ledger setting. I have already filled a bug
> report in Github on this, together with the code to fix the bug.

If you select a start date then it wont take the opening balance into
account. Leave the start date as blank if you want to include opening
balance.

Regards.

[Kian Hua Ong]

I need to see the statement for one month.  Anyway, the changes I sent you would have made the opening balance correct.  

Or was it your intention to NOT get the actual opening balance ?? I don't get what's the purpose.

[Prashant Shah]

Hi,

On Fri, Sep 4, 2015 at 3:00 PM, Kian Hua Ong <kianh...@gmail.com> wrote:
> I need to see the statement for one month. Anyway, the changes I sent you
> would have made the opening balance correct.
> Or was it your intention to NOT get the actual opening balance ?? I don't
> get what's the purpose.

Since you have already opened a issue, we can discuss this further there.

Regards.

[Tahir Mubeen]

Dear Ramkrishna

How to remove Dr Cr Symbols from the printed reports or vouchers and also print button????? please help.

best regards

Tahir Mubeen