POS module with French chart of accounts

Bug #1246847 reported by Jean-Christophe BOILLON
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Invalid
Undecided
Unassigned

Bug Description

On a freshly openERP v7 with accounting and POS modules installed I get a validation error when closing the POS session after validating sale entries.

here are the operations I performed on my openERP windows instance

I configured the POS module by creating 3 payment's method : Cash (with control at the opening checked and cash control checked) account for debit 531100, account for credit 531100, account for profit 168700, account for loss 168700, account for internal tr 168700, Check : account for debit 511200, account for credit 511200, Credit card : account for debit 512102, account for credit 512102.
I attached those 3 payments method at the "main" point of sale
I opened a new session with zero cash for the opening.
I made a sale entry, selected the payment mode (half in Cash, the other half in check) and validate the sale.
When I exit and close the session, I keep getting a validation error saying that an account used by the POS process can't be a view

I checked all those accounts and none of them is view !
If I update the table account_account and replace all view settings with the value other, I am able to close the POS session and see the GL movements generated by the POS process, all the accounts that have movements are not views !
I tried the same configuration with another chrt of accounts and I do not have the same problem !

Revision history for this message
Amit Parik (amit-parik) wrote :

Hello Jean,

Tested same scenario at my end, working fine. Would you please checked the attached video which will show you the same example as you provide.

Please check and notify me.

Thank you!

Revision history for this message
Amit Parik (amit-parik) wrote :
Changed in openobject-addons:
status: New → Incomplete
Revision history for this message
Jean-Christophe BOILLON (boillon-jc) wrote : Re: [Bug 1246847] Re: POS module with French chart of accounts

Hi,

Thank you for your assistance.

I watched your video and the only diffences with my scenario is that for the cash journal, I checked the following options : OPENING WITH LAST CLOSING BALANCE and CASH CONTROL,

I don’t know if it matters ?

I have no idea why it keeps giving to me this error, I can re-install the DB ten times more ith different settings and it’s always the same error.

The only way to get out from this error is when I choose a different Chart of accounts, instead of the french one !

Many thanks for your help

JC

De : Amit Parik (OpenERP)
Envoyé : ‎jeudi‎ ‎7‎ ‎novembre‎ ‎2013 ‎14‎:‎22
À : <email address hidden>

** Attachment added: "pos_fr.ogv"
   https://bugs.launchpad.net/openobject-addons/+bug/1246847/+attachment/3902348/+files/pos_fr.ogv

** Changed in: openobject-addons
       Status: New => Incomplete

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1246847

Title:
  POS module with French chart of accounts

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  On a freshly openERP v7 with accounting and POS modules installed I
  get a validation error when closing the POS session after validating
  sale entries.

  here are the operations I performed on my openERP windows instance

  I configured the POS module by creating 3 payment's method : Cash (with control at the opening checked and cash control checked) account for debit 531100, account for credit 531100, account for profit 168700, account for loss 168700, account for internal tr 168700, Check : account for debit 511200, account for credit 511200, Credit card : account for debit 512102, account for credit 512102.
  I attached those 3 payments method at the "main" point of sale
  I opened a new session with zero cash for the opening.
  I made a sale entry, selected the payment mode (half in Cash, the other half in check) and validate the sale.
  When I exit and close the session, I keep getting a validation error saying that an account used by the POS process can't be a view

  I checked all those accounts and none of them is view !
  If I update the table account_account and replace all view settings with the value other, I am able to close the POS session and see the GL movements generated by the POS process, all the accounts that have movements are not views !
  I tried the same configuration with another chrt of accounts and I do not have the same problem !

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1246847/+subscriptions

Revision history for this message
Amit Parik (amit-parik) wrote :

Hi Jean,

I did the same please check 0:08 sec on my video.

Thank you!

Revision history for this message
Jean-Christophe BOILLON (boillon-jc) wrote :

Hi Amit,

I am just a bit busy this we, I’ll contact you next week.

Regards

JC

De : Amit Parik (OpenERP)
Envoyé : ‎jeudi‎ ‎7‎ ‎novembre‎ ‎2013 ‎14‎:‎22
À : <email address hidden>

** Attachment added: "pos_fr.ogv"
   https://bugs.launchpad.net/openobject-addons/+bug/1246847/+attachment/3902348/+files/pos_fr.ogv

** Changed in: openobject-addons
       Status: New => Incomplete

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1246847

Title:
  POS module with French chart of accounts

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  On a freshly openERP v7 with accounting and POS modules installed I
  get a validation error when closing the POS session after validating
  sale entries.

  here are the operations I performed on my openERP windows instance

  I configured the POS module by creating 3 payment's method : Cash (with control at the opening checked and cash control checked) account for debit 531100, account for credit 531100, account for profit 168700, account for loss 168700, account for internal tr 168700, Check : account for debit 511200, account for credit 511200, Credit card : account for debit 512102, account for credit 512102.
  I attached those 3 payments method at the "main" point of sale
  I opened a new session with zero cash for the opening.
  I made a sale entry, selected the payment mode (half in Cash, the other half in check) and validate the sale.
  When I exit and close the session, I keep getting a validation error saying that an account used by the POS process can't be a view

  I checked all those accounts and none of them is view !
  If I update the table account_account and replace all view settings with the value other, I am able to close the POS session and see the GL movements generated by the POS process, all the accounts that have movements are not views !
  I tried the same configuration with another chrt of accounts and I do not have the same problem !

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1246847/+subscriptions

Revision history for this message
Amit Parik (amit-parik) wrote :

Hello Jean,

Would you please try this

http://nightly.openerp.com/7.0/nightly/exe/openerp-allinone-setup-7.0-latest.exe

and installed the latest version of today with above link.

Please try with this and let us know If you still face the problem or not?

If you still faced the same problem then you can reopen this.

Thank you!

Changed in openobject-addons:
status: Incomplete → Invalid
Revision history for this message
Jean-Christophe BOILLON (boillon-jc) wrote :

Hi Amit,

I downloaded the latest version through the link you gave me and everything worked fine this time.

Thank you very much for your time and for your very appreciated help.

JC

De : Amit Parik (OpenERP)
Envoyé : ‎mardi‎ ‎12‎ ‎novembre‎ ‎2013 ‎07‎:‎16
À : <email address hidden>

Hello Jean,

Would you please try this

http://nightly.openerp.com/7.0/nightly/exe/openerp-allinone-
setup-7.0-latest.exe

and installed the latest version of today with above link.

Please try with this and let us know If you still face the problem or not?

If you still faced the same problem then you can reopen this.

Thank you!

** Changed in: openobject-addons
       Status: Incomplete => Invalid

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1246847

Title:
  POS module with French chart of accounts

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  On a freshly openERP v7 with accounting and POS modules installed I
  get a validation error when closing the POS session after validating
  sale entries.

  here are the operations I performed on my openERP windows instance

  I configured the POS module by creating 3 payment's method : Cash (with control at the opening checked and cash control checked) account for debit 531100, account for credit 531100, account for profit 168700, account for loss 168700, account for internal tr 168700, Check : account for debit 511200, account for credit 511200, Credit card : account for debit 512102, account for credit 512102.
  I attached those 3 payments method at the "main" point of sale
  I opened a new session with zero cash for the opening.
  I made a sale entry, selected the payment mode (half in Cash, the other half in check) and validate the sale.
  When I exit and close the session, I keep getting a validation error saying that an account used by the POS process can't be a view

  I checked all those accounts and none of them is view !
  If I update the table account_account and replace all view settings with the value other, I am able to close the POS session and see the GL movements generated by the POS process, all the accounts that have movements are not views !
  I tried the same configuration with another chrt of accounts and I do not have the same problem !

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1246847/+subscriptions

Revision history for this message
Amit Parik (amit-parik) wrote :

Hello Jean,

Thanks for your response!

That indicates that your problem was resloved meanwhile after relased the v7, but its ok the important thing is that your issues is sloved :-)

Revision history for this message
Jean-Christophe BOILLON (boillon-jc) wrote :

hi Amit,

I have a question regarding the Point of Sale module and as you were very helpful Iast time, I allow myself to ask you again for your assistance,

is there a possibility to enhanced the POS module and add some features ?

I would like to be able to select a client through the POS module and if I select one of my customers, I would like that the sale generates the same movements as the sale were entered through the sale module.

I would like to see those operations on my customer’s file and be able to get the monthly figures by customer.

Thanks in advance

JC

De : Amit Parik
Envoyé : ‎lundi‎ ‎18‎ ‎novembre‎ ‎2013 ‎15‎:‎59
À : <email address hidden>

Hello Jean,

Thanks for your response!

That indicates that your problem was resloved meanwhile after relased
the v7, but its ok the important thing is that your issues is sloved :-)

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1246847

Title:
  POS module with French chart of accounts

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  On a freshly openERP v7 with accounting and POS modules installed I
  get a validation error when closing the POS session after validating
  sale entries.

  here are the operations I performed on my openERP windows instance

  I configured the POS module by creating 3 payment's method : Cash (with control at the opening checked and cash control checked) account for debit 531100, account for credit 531100, account for profit 168700, account for loss 168700, account for internal tr 168700, Check : account for debit 511200, account for credit 511200, Credit card : account for debit 512102, account for credit 512102.
  I attached those 3 payments method at the "main" point of sale
  I opened a new session with zero cash for the opening.
  I made a sale entry, selected the payment mode (half in Cash, the other half in check) and validate the sale.
  When I exit and close the session, I keep getting a validation error saying that an account used by the POS process can't be a view

  I checked all those accounts and none of them is view !
  If I update the table account_account and replace all view settings with the value other, I am able to close the POS session and see the GL movements generated by the POS process, all the accounts that have movements are not views !
  I tried the same configuration with another chrt of accounts and I do not have the same problem !

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1246847/+subscriptions

Revision history for this message
Amit Parik (amit-parik) wrote :

Hello Jean,

Yes, you can do this via small customization at your end.
You can edit the pos order via js and add the customer on pos order object/view.

We can create an invoice from the POS order and when you confirm the invoice it will generate the sales entry ,
Now as per my Opinion the sloution is as follow.

Add the customer on pos order and when you validate the pos order from the pos forntend (Tocuch screen) then same time it will also creates the customer invoice. You can override the validate button of pos order and create the invoice the value are as follow.
Invoice =pos line
Customer for invoice : Customer field on POS order (new field add on pos order).
Journal : You can set by defualt sales journal or you can add journal field too.

Please also change the string of the "Validate" button and change it to "Validate and Create Invoice".

Hope this help to you!

Revision history for this message
Jean-Christophe BOILLON (boillon-jc) wrote :
Download full text (3.2 KiB)

Hi Amit,

Thank you for your answer.

Even if I have been a developper a very long time ago,I am not sure to be able to implement the things you explained to me by myself.

Is it suitable for you to make the customisation at your end and then, send me the reworked file to replace in my openERP server ?

I can perform the test for you or define in more details the functionnalities to add.

I am pretty sure that this type of enhancement to the POS module will interest many other users.

What do you thing ?

JC

De : Amit Parik
Envoyé : ‎lundi‎ ‎25‎ ‎novembre‎ ‎2013 ‎12‎:‎26
À : <email address hidden>

Hello Jean,

Yes, you can do this via small customization at your end.
You can edit the pos order via js and add the customer on pos order object/view.

We can create an invoice from the POS order and when you confirm the invoice it will generate the sales entry ,
Now as per my Opinion the sloution is as follow.

Add the customer on pos order and when you validate the pos order from the pos forntend (Tocuch screen) then same time it will also creates the customer invoice. You can override the validate button of pos order and create the invoice the value are as follow.
Invoice =pos line
Customer for invoice : Customer field on POS order (new field add on pos order).
Journal : You can set by defualt sales journal or you can add journal field too.

Please also change the string of the "Validate" button and change it to
"Validate and Create Invoice".

Hope this help to you!

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1246847

Title:
  POS module with French chart of accounts

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  On a freshly openERP v7 with accounting and POS modules installed I
  get a validation error when closing the POS session after validating
  sale entries.

  here are the operations I performed on my openERP windows instance

  I configured the POS module by creating 3 payment's method : Cash (with control at the opening checked and cash control checked) account for debit 531100, account for credit 531100, account for profit 168700, account for loss 168700, account for internal tr 168700, Check : account for debit 511200, account for credit 511200, Credit card : account for debit 512102, account for credit 512102.
  I attached those 3 payments method at the "main" point of sale
  I opened a new session with zero cash for the opening.
  I made a sale entry, selected the payment mode (half in Cash, the other half in check) and validate the sale.
  When I exit and close the session, I keep getting a validation error saying that an account used by the POS process can't be a view

  I checked all those accounts and none of them is view !
  If I update the table account_account and replace all view settings with the value other, I am able to close the POS session and see the GL movements generated by the POS process, all the accounts that have movements are not views !
  I tried the same configuration with another chrt of accounts and I do not have the same probl...

Read more...

Revision history for this message
Amit Parik (amit-parik) wrote :

Hello Jean,

I will make the module for this when I will get the time and send you soon.

Thank you!

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.