Daily Cash Closing/hand over by Cash Clerk at Cash counter

[Khurram Shahzad]

Dear Community,

We have many cash counters at our hospital where Cash Clerks prepare invoices for various services/goods rendered to Customers. The customers pay Cash to the Cash Clerks to settle the invoice amount. 

What the finance department wants is that at the end of the shift every Cash Clerk comes to finance department with the cash collected and hands it to over to some Senior Cashier. Now the senior cashier wants to confirm that Cash Clerk has handed over all the money against all the invoices he received payments from customers. In other words, we want to have a financial document (or statement) showing all the payments received by a Cash Clerk and - one statement for one per cash clerks one shift.

How can it be achieved using Tryton?. We are using GNU Health modules too.

Thanking you in anticipation.

Regards,

Khurram Shahzad.

[Sergi Almacellas Abellana]

El 21/09/16 a les 18:48, Khurram Shahzad ha escrit:

> Dear Community,
>
> We have many cash counters at our hospital where Cash Clerks prepare
> invoices for various services/goods rendered to Customers. The customers
> pay Cash to the Cash Clerks to settle the invoice amount.
>
> What the finance department wants is that at the end of the shift every
> Cash Clerk comes to finance department with the cash collected and hands
> it to over to some Senior Cashier. Now the senior cashier wants to
> confirm that Cash Clerk has handed over all the money against all the
> invoices he received payments from customers. In other words, we want to
> have a financial document (or statement) showing all the payments
> received by a Cash Clerk and - one statement for one per cash clerks one
> shift.

I think you are searching for the account_statment module. Have a look
at it's docs:

http://doc.tryton.org/4.0/modules/account_statement/doc/index.html

--
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

[Cédric Krier]

Since 3.8, there is a report based on cash journals, see
https://bugs.tryton.org/issue4891

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[Cédric Krier]

I do not think statement is the right workflow here because statements
are for asynchronous payment (from bank or cashier).
Here I think they are just using the "Pay" button on the invoice.

[E. Boer]

You can take a look at tryton-sale_pos https://bitbucket.org/zikzakmedia/trytond-sale_pos . It seems that it will fit all your needs. It need some configuration to get it running but it's worth to try.

 

[Khurram Shahzad]

Dear Sergi and Cedric,

Thank you very much for the responses.

According to the documentation:
" The account_statement module allows to book statements. Statement can be used for bank statement, cash daybook etc."

However, Cedric is right that we are planning to complete the transaction using "Pay" button on invoice.

But, I am unable to understand how the "Cash Journals" report can be used to get the list of cash receipts by a specific user. Even if that can be done, that would be a manual confirmation for which there will be no financial transaction booked and hence no documentation.

Keeping this and the definition of statement in view, I think Sergi may be right. But, how will I extract the cash receipts from Cash Journal for a specific user and what accounts will be debited/credited when I post the statement.

Some financial software record an Account Payable entry for the Cash Clerk for each cash receipt made by him/her and at day close nullify it after receiving and posting cash entry.

Regards,

Khurram.

--
You received this message because you are subscribed to the Google Groups "tryton" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20160922074219.GU29096%40tetsuo.

--

 

Regards,

Khurram.

[Cédric Krier]

On 2016-09-22 14:22, Khurram Shahzad wrote:
> Dear Sergi and Cedric,
>
> Thank you very much for the responses.
>
> According to the documentation:
> " The account_statement module allows to book statements. Statement can be
> used for bank statement, cash daybook etc."
>
> However, Cedric is right that we are planning to complete the transaction
> using "Pay" button on invoice.
>
> But, I am unable to understand how the "Cash Journals" report can be used
> to get the list of cash receipts by a specific user. Even if that can be
> done, that would be a manual confirmation for which there will be no
> financial transaction booked and hence no documentation.

This is a solution where you only check the total per journal.
It is not a complete solution with full auditing.

> Keeping this and the definition of statement in view, I think Sergi may be
> right. But, how will I extract the cash receipts from Cash Journal for a
> specific user and what accounts will be debited/credited when I post the
> statement.

I still do not think that statement is the right solution because as I
said it is asynchronous. For example, the invoices will not be marked as
paid until the statement is posted.

> Some financial software record an Account Payable entry for the Cash Clerk
> for each cash receipt made by him/her and at day close nullify it after
> receiving and posting cash entry.

This sounds like a good solution the method Invoice.pay_invoice could be
extended by a module to use instead of the default debit/credit account
of the journal, a specific account defined per employee. Than a document
will allow to balance this account with the default accounts of the
journal per employee and journal.
I think it worse starting a feature topic on https://discuss.tryton.org/


PS: Please do not top-post on this mailing list, see
http://groups.tryton.org/netiquette

[Khurram Shahzad]

Can I have any solution to this problem?

What if I create a petty cash journal for every cash clerk and record all cash receipts in that journal without posting them. The senior cashier at the end of the day posts those transactions.

Any thoughts?

[Sergi Almacellas Abellana]

El 23/09/16 a les 07:47, Khurram Shahzad ha escrit:

Could be a valid workflow.

You can also add a custom action to easly filter the moves to be posted,
so the senior cashier can easly find the moves to post.

P.S: Don't top post on this mailing lists. See
https:http://groups.tryton.org/netiquette

[Mathias Behrle]

* Sergi Almacellas Abellana: " Re: [tryton] Daily Cash Closing/hand over by
Cash Clerk at Cash counter" (Fri, 23 Sep 2016 09:42:50 +0200):

Hi Sergi,

> P.S: Don't top post on this mailing lists. See
> https:http://groups.tryton.org/netiquette

This remark seems to be the downside of automatic detection of top postings.
The mail in question wasn't a top post aside from the URL being corrupt and
pointing finally to a discussion thread instead of a hint on top of the group
page (where it should be, if and after some consensus about this topic is
achieved).

May be those notices could be omitted? They don't add to a welcoming style in
our Tryton groups and usually users are accepting much better when given a real
example.

What do you think?

Best,
Mathias


--

Mathias Behrle
MBSolutions
Gilgenmatten 10 A
D-79114 Freiburg

Tel: +49(761)471023
Fax: +49(761)4770816
http://www.m9s.biz
UStIdNr: DE 142009020
PGP/GnuPG key availabable from any keyserver, ID: 0xD6D09BE48405BBF6
AC29 7E5C 46B9 D0B6 1C71 7681 D6D0 9BE4 8405 BBF6

[Sergi Almacellas Abellana]

El 23/09/16 a les 12:07, Mathias Behrle ha escrit:

>
> Hi Sergi,
>
>> P.S: Don't top post on this mailing lists. See
>> https:http://groups.tryton.org/netiquette
>
> This remark seems to be the downside of automatic detection of top postings.

No, I manually added the text because i missed the context about "this
problem".

> The mail in question wasn't a top post aside from the URL being corrupt and
> pointing finally to a discussion thread instead of a hint on top of the group
> page (where it should be, if and after some consensus about this topic is
> achieved).
>
> May be those notices could be omitted? They don't add to a welcoming style in
> our Tryton groups and usually users are accepting much better when given a real
> example.

So you think we must be more polite when complaining about netiquette?
>
> What do you think?

We can discuss in a separate topic if you want ;-)
>
> Best,
> Mathias

[Mathias Behrle]

* Sergi Almacellas Abellana: " Re: [tryton] Daily Cash Closing/hand over by

Cash Clerk at Cash counter" (Fri, 23 Sep 2016 14:34:08 +0200):

> El 23/09/16 a les 12:07, Mathias Behrle ha escrit:
> >
> > Hi Sergi,
> >
> >> P.S: Don't top post on this mailing lists. See
> >> https:http://groups.tryton.org/netiquette
> >
> > This remark seems to be the downside of automatic detection of top
> > postings.
> No, I manually added the text because i missed the context about "this
> problem".

Ok, so you were missing a citation, which is different from complaining about
top posting.

> > The mail in question wasn't a top post aside from the URL being corrupt and
> > pointing finally to a discussion thread instead of a hint on top of the
> > group page (where it should be, if and after some consensus about this
> > topic is achieved).
> >
> > May be those notices could be omitted? They don't add to a welcoming style
> > in our Tryton groups and usually users are accepting much better when given
> > a real example.
> So you think we must be more polite when complaining about netiquette?

I think it is not constructive this way. If a mail gets unreadable, because
someone answers top and another one answers bottom, the problem is evident and
most people will happily adopt a style, that complies to our standard to read
from top to bottom. Raising constantly those concerns tends to generate an
intimidated atmosphere.

Besides that: there should first be reached a broader agreement if and in which
way we are concerned about netiquette. Finally if there is a consensus it should
be an element on the group's front page, that now just says:

Welcome to the Tryton discussion group.
Archive can be found on Mail Archive
If you have a bug, please visit our issue tracking system at
http://bugs.tryton.org/
If you'd like to find documentation, please visit http://docs.tryton.org/
If you'd like to download Tryton, please visit
http://www.tryton.org/download.html

> > What do you think?
>
> We can discuss in a separate topic if you want ;-)

Done;)

[Cédric Krier]

On 2016-09-22 12:09, Cédric Krier wrote:
> On 2016-09-22 14:22, Khurram Shahzad wrote:
> > Some financial software record an Account Payable entry for the Cash Clerk
> > for each cash receipt made by him/her and at day close nullify it after
> > receiving and posting cash entry.
>
> This sounds like a good solution the method Invoice.pay_invoice could be
> extended by a module to use instead of the default debit/credit account
> of the journal, a specific account defined per employee. Than a document
> will allow to balance this account with the default accounts of the
> journal per employee and journal.
> I think it worse starting a feature topic on https://discuss.tryton.org/

For the record, the topic is
https://discuss.tryton.org/t/daily-cash-book-management/209/2

[Cédric Krier]

On 2016-09-23 15:27, Mathias Behrle wrote:
> Besides that: there should first be reached a broader agreement if and in which
> way we are concerned about netiquette. Finally if there is a consensus it should
> be an element on the group's front page, that now just says:
>
> Welcome to the Tryton discussion group.
> Archive can be found on Mail Archive
> If you have a bug, please visit our issue tracking system at
> http://bugs.tryton.org/
> If you'd like to find documentation, please visit http://docs.tryton.org/
> If you'd like to download Tryton, please visit
> http://www.tryton.org/download.html

We already have it here: http://www.tryton.org/community.html#netiquette
But no problem to add it on the mailing list pages.
I will do it for English and French one, please administrator of other
languages do the same.

[Sergi Almacellas Abellana]

El 23/09/16 a les 15:58, Cédric Krier ha escrit:

> I will do it for English and French one, please administrator of other
> languages do the same.

I added it also for Spanish and Catalan languages.

[Mathias Behrle]

* Cédric Krier: " Re: [tryton] Netiquette: (was: Daily Cash Closing/hand over
by Cash Clerk at Cash counter)" (Fri, 23 Sep 2016 15:58:45 +0200):

> On 2016-09-23 15:27, Mathias Behrle wrote:
> > Besides that: there should first be reached a broader agreement if and in
> > which way we are concerned about netiquette. Finally if there is a
> > consensus it should be an element on the group's front page, that now just
> > says:
> >
> > Welcome to the Tryton discussion group.
> > Archive can be found on Mail Archive
> > If you have a bug, please visit our issue tracking system at
> > http://bugs.tryton.org/
> > If you'd like to find documentation, please visit http://docs.tryton.org/
> > If you'd like to download Tryton, please visit
> > http://www.tryton.org/download.html
>
> We already have it here: http://www.tryton.org/community.html#netiquette

This is just another link to the same thread.

> But no problem to add it on the mailing list pages.
> I will do it for English and French one, please administrator of other
> languages do the same.

You are completely missing the point about "...first be reached a broader
agreement" and "consensus".

[Jean Cavallo]

2016-09-23 17:44 GMT+02:00 Mathias Behrle <mbe...@m9s.biz>:

> But no problem to add it on the mailing list pages.
> I will do it for English and French one, please administrator of other
> languages do the same.

You are completely missing the point about "...first be reached a broader
agreement" and "consensus".

 

The decision was made some time ago, so we should stick with it.

https://groups.google.com/forum/?hl=en#!topic/tryton/-IA9TLq5qag

Jean Cavallo

Coopengo

[Mathias Behrle]

* Jean Cavallo: " Re: [tryton] Netiquette: (was: Daily Cash Closing/hand over
by Cash Clerk at Cash counter)" (Fri, 23 Sep 2016 18:01:15 +0200):

Still the same thread. I see a (quite limited) discussion, not a broad
agreement.

This discussion diverges from my initial intention. I am absolute in favor of
'netiquette', but netiquette is about much more than looking at the posting
style.[0][1]

"Rule 10: Be forgiving of other people's mistakes

Everyone was a network newbie once. And not everyone has had the benefit of
reading this book. So when someone makes a mistake -- whether it's a spelling
error or a spelling flame, a stupid question or an unnecessarily long answer --
be kind about it. If it's a minor error, you may not need to say anything. Even
if you feel strongly about it, think twice before reacting. Having good manners
yourself doesn't give you license to correct everyone else.

If you do decide to inform someone of a mistake, point it out politely, and
preferably by private email rather than in public. Give people the benefit of
the doubt; assume they just don't know any better. And never be arrogant or
self-righteous about it. Just as it's a law of nature that spelling flames
always contain spelling errors, notes pointing out Netiquette violations are
often examples of poor Netiquette."[2]

Please have a look especially at the last sentence, that explains much better
the actual case than I could do.

So I propose to use *and* apply to a real 'netiquette' document instead of the
quite short discussion thread as the pointer for Tryton discussion groups.

I am very much in favor of [1], as [3] is contradictory in itself (using
capitals and multiple exclamation marks for e.g. "DO NOT TOP-POST and DO trim
your replies!!!" while saying in the very same document "Don't SHOUT! While it
might look clearer to you if everything is in capitals in your message, it is
considered SHOUTING, and therefore very rude.")



[0] https://en.wikipedia.org/wiki/Posting_style
[1] http://www.albion.com/netiquette/book/index.html
[2] http://www.albion.com/netiquette/book/0963702513p45.html
[3] http://linux.sgms-centre.com/misc/netiquette.php

[Khurram Shahzad]

While installing the trytond_sale_pos, I am unable to find the following dependency:

trytond_sale_payment

Can anybody guide me where to find this module?

Thanks in advance.

Regards,

Khurram.

[Sergi Almacellas Abellana]

El 29/09/16 a les 06:35, Khurram Shahzad ha escrit:

>
>
>
> While installing the trytond_sale_pos, I am unable to find the following
> dependency:
>
> trytond_sale_payment
>
> Can anybody guide me where to find this module?

The dependency is also available on bitbucket, but in the trytonspain
account. See:

https://bitbucket.org/trytonspain/trytond-sale_payment

[Khurram Shahzad]

Dear Sergi,

Thanks a lot. I installed trytond_sale_payment successfully.

After upgrading the database, I opened "Modules" from Tryton client. I selected following modules for installation:

sale-payment
sale-pos
sale-shop
sale-w-tax

But, when I clicked on "Upgrade" button, I received following error message:

Invalid xml for view "sale.line"

After closing error dialogue, I can see that only "sale_pos" is not installed.

When I list the installed python packages, I see that following four packages are installed:
trytonzz-sale-payment (3.8.0)
trytonzz-sale-pos (3.8.0)
trytonzz-sale-shop (3.8.0)
trytonzz-sale-w-tax (3.8.0)

Can anybody guide me on what I have missed, please.
--

 

Regards,

Khurram.

[Sergi Almacellas Abellana]

El 29/09/16 a les 12:02, Khurram Shahzad ha escrit:

>
> But, when I clicked on "Upgrade" button, I received following error message:
> Invalid xml for view "sale.line"
>
> After closing error dialogue, I can see that only "sale_pos" is not
> installed.

It seems that you found the error described on this issue:

https://bitbucket.org/zikzakmedia/trytond-sale_pos/issues/5/error-installing-sale_pos-module-in-tryton

[Khurram Shahzad]

Dear Sergi,

On Thu, Sep 29, 2016 at 7:31 PM, Sergi Almacellas Abellana <se...@koolpi.com> wrote:

El 29/09/16 a les 12:02, Khurram Shahzad ha escrit:

But, when I clicked on "Upgrade" button, I received following error message:
Invalid xml for view "sale.line"

After closing error dialogue, I can see that only "sale_pos" is not
installed.

It seems that you found the error described on this issue:

https://bitbucket.org/zikzakmedia/trytond-sale_pos/issues/5/error-installing-sale_pos-module-in-tryton

Thank you so much. Issue is resolved. My PoS is flying high!!!

[Khurram Shahzad]

Dear All,

I have successfully installed and configured the PoS. It is excellently fulfilling the Sales at cash counter along with cash management.

Now the requirement in hand is "Can we open an already created invoice and take the cash for it?" using this PoS, This way, we can easily auto-create invoices against various services and send the customer to cash counter who can save time by taking cash for an already created invoice. Since, this is also a cash receipt so it must go through cash statement of the cashier.

Thanking you in anticipation.