[7.0] Account: Statement Reconcilation Menu missing

[Mustufa Rangwala (Open ERP)]

There is no menu available for Accounting/Periodical Processing/Statements/Statements Reconciliation in 7.0 and trunk.

Thanks,
Mustufa Rangwala
<email address hidden>

[Wolfgang Taferner (TaPo-IT) (w.taferner)]

Functionality of assigning move_line_ids to a bank statement does not work anymore either.

I tried to add the many2many widget for assigning move_line_ids to a bank statement and it throws a javascript error on adding move_line_ids...it is than possible somehow to assign move_line_ids to the bank statement (get all entries of move_line_ids from the opened window and choose from) ...

...BUT computation of end_balance (field_function) does not work properly too...it seems functionality was degraded in favor of redesigning the view/model.

I gave it some time, but I think it's better OpenERP will fix this...

[Wolfgang Taferner (TaPo-IT) (w.taferner)]

JavaScript Error on adding move_line_ids (many2many form widget):

Uncaught TypeError: Cannot read property 'set_editable' of undefined

Form view snippet

<page string="Journal Entries">
    <field name="move_line_ids" nolabel="1" widget="many2many" domain="[('account_id','=',account_id),('centralisation', '=', 'normal'),('statement_id', '=', False)]">
        <tree string="Statement lines">
            <field name="date"/>
            <field name="period_id"/>
            <field name="journal_id"/>
            <field name="name"/>
            <field name="account_id"/>
            <field name="debit"/>
            <field name="credit"/>
        </tree>
    </field>
</page>

[Paulo Buijs (p-buijs)]

As an end-user I also have a problem with bank statement and invoice payment reconciliation. I'm using the Import Payment Lines function on the Bank Statement. We register (mostly partial) payments on customer invoices (customer invoices -> select invoice -> register payment) and would then expect to be able to import the payment in the bank statement. However, when we select the Import Payment Lines function, nothing shows up, i.e. there are no payment lines that we can select! The invoice also does not show in the Import Invoices list, as if it has been marked as paid, while there still is a balance (due to a partial payment).

I'm not quite sure whether the problem we're experiencing is the same as what Wolfgang is describing above... I have reported my problem in ticket 591575.

Paulo

[Corinne Cobbel (ccobbel)]

Apparently OpenERP removed the menu Accounting/Periodical Processing/Statements/Statements Reconciliation from V7.0 because there was issue with multi curency account and it's not considered as a bug so they won't correct it.
It's to bad because a lot of companies used it as work around.

Paulo I aggree that bank statment can be used as it is. We are not able to access payment entries that are already in the system. I would like to folow up your ticket. Can you confirm the number, it's not 591575.
Thanks

[Paulo Buijs (p-buijs)]

Hi Corinne,

Thanks for your support. I have attached the confirmation mail I received after reporting the ticket. It does mention the ticketnr 591575. Perhaps you can find it using the description or via the assigned developer.

Regards,
Paulo

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Corinne Cobbel
Sent: maandag 22 april 2013 18:20
To: ALPHA UP - Paulo Buijs
Subject: [?? Probable Spam] [Bug 1154976] Re: [7.0] Account: Statement Reconcilation Menu missing

Apparently OpenERP removed the menu Accounting/Periodical Processing/Statements/Statements Reconciliation from V7.0 because there was issue with multi curency account and it's not considered as a bug so they won't correct it.
It's to bad because a lot of companies used it as work around.

Paulo I aggree that bank statment can be used as it is. We are not able to access payment entries that are already in the system. I would like to folow up your ticket. Can you confirm the number, it's not 591575.
Thanks

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

Title:
  [7.0] Account: Statement Reconcilation Menu missing

Status in OpenERP Addons (modules):
  New

Bug description:
  There is no menu available for Accounting/Periodical
  Processing/Statements/Statements Reconciliation in 7.0 and trunk.

  Thanks,
  Mustufa Rangwala
  <email address hidden>

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

Dear customer,

I have just opened your ticket (Reference 591575) and started working on it.
To help me find a solution, please provide, if not done already, any additional information you find helpful, such as:

* detailed steps to reproduce
* a short video and/or screenshots
* any relevant information about your system

Kind regards,

Regards,
Amit Dodiya
OpenERP Support Enterprise

Access your messages and personal documents through our Customer Portal <https://accounts.openerp.com?db=openerp#action=login&token=ST863ZDldQc6T0CHxC1I&type=signup>

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

Hi All,

Just to put one note here.

In OpenERP 6.1 version I can still reconcile bank statement with existing payment (Without using Statement Reconcilation Menu.. ). To do that I have to create manually bank statement lines and select customer payment in "Payment" field.. I know its workaround solution but can be use.. :)

But in 7.0 I can not select Payment on bank statement lines so its not possible to link payment entry from voucher in bank statement line.

Regards,
Mustufa Rangwala

[Corinne Cobbel (ccobbel)]

Hello all,

What I understand from various tests and reading other posts (e.g bug 1096096).
In Bank and Cash/Bank statement menu we can:
1/ keying manually bank entries
2/ Import unpaid invoices and register their payments
3/ Import payments that have been register by payment order only

Please, could someone from OpenERP confirm that my understanding is correct?

If yes, how can we reconcile other entries like?
- Customer payments already in the system
- Recurrent entries like loan and fees
- Supplier payments from voucher

There is several ways in OpenERP to register bank entries but they can not be reconcile in Bank statement because we can not access the entries, it doesn't make sense at all for me.

It’s a big regression from V6, what can we do? do we have to log another bug?

Thanks

[Wolfgang Taferner (TaPo-IT) (w.taferner)]

Ok, here is what I did to get it working again...fixing the computation method to include account_move_lines which are not created by the bank statement / transactions (see attached patch)

and adding a view for account.bank.statement
object: account.bank.statement
inherited view: account.bank.statement.form

The domain could be improved though, but at least it works again like expected from 6.1

<?xml version="1.0"?>
              <xpath expr="//page[@name='statement_line_ids']" position="after">
                   <page string="Journal Entries">
                      <field colspan="4" name="move_line_ids" nolabel="1" widget="many2many" domain="[('journal_id.type', '=','bank'),('statement_id', '=', False)]">
                          <tree string="Statement lines">
                              <field name="date"/>
                              <field name="period_id"/>
                              <field name="journal_id"/>
                              <field name="name"/>
                              <field name="debit"/>
                              <field name="credit"/>
                          </tree>
                      </field>
                  </page>
              </xpath>

Now the view for bank statements has the possibility to add account_move_lines from bank journals (take care you only choose move_lines from the proper account)

Hope this will help others and maybe OpenERP to fix this bug/regression quickly

[Wolfgang Taferner (TaPo-IT) (w.taferner)]

Here a better domain for the move_line_ids widget

domain="[('account_id.user_type.code','=','bank'),('statement_id', '=', False)]"

[Wolfgang Taferner (TaPo-IT) (w.taferner)]

('journal_id.type', '=','bank') is of course still useful ;-)

[Corinne Cobbel (ccobbel)]

Hello Paulo,

I don't know if OpenERP give you a solution as I don't have access to your ticket.
Regarding my ticket they finally agree to create a module that activate the menu Accounting/Periodical Processing/Statements/Statements Reconciliation.
I don't know if they have merged it yet or not.
If you want I can send you the module.
Let me know

Regards
Corinne Cobbel
Linko Solutions
[phone] ext. 100
http://www.linkosolutions.com

Le 2013-04-22 à 14:53, Paulo Buijs <email address hidden> a écrit :

> Hi Corinne,
>
> Thanks for your support. I have attached the confirmation mail I
> received after reporting the ticket. It does mention the ticketnr
> 591575. Perhaps you can find it using the description or via the
> assigned developer.
>
> Regards,
> Paulo
>
>
> -----Original Message-----
> From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Corinne Cobbel
> Sent: maandag 22 april 2013 18:20
> To: ALPHA UP - Paulo Buijs
> Subject: [?? Probable Spam] [Bug 1154976] Re: [7.0] Account: Statement Reconcilation Menu missing
>
> Apparently OpenERP removed the menu Accounting/Periodical Processing/Statements/Statements Reconciliation from V7.0 because there was issue with multi curency account and it's not considered as a bug so they won't correct it.
> It's to bad because a lot of companies used it as work around.
>
> Paulo I aggree that bank statment can be used as it is. We are not able to access payment entries that are already in the system. I would like to folow up your ticket. Can you confirm the number, it's not 591575.
> Thanks
>
> --
> You received this bug notification because you are subscribed to the bug report.
> https://bugs.launchpad.net/bugs/1154976
>
> Title:
> [7.0] Account: Statement Reconcilation Menu missing
>
> Status in OpenERP Addons (modules):
> New
>
> Bug description:
> There is no menu available for Accounting/Periodical
> Processing/Statements/Statements Reconciliation in 7.0 and trunk.
>
> Thanks,
> Mustufa Rangwala
> <email address hidden>
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-addons/+bug/1154976/+subscriptions
>
>
>
> Dear customer,
>
> I have just opened your ticket (Reference 591575) and started working on it.
> To help me find a solution, please provide, if not done already, any additional information you find helpful, such as:
>
> * detailed steps to reproduce
> * a short video and/or screenshots
> * any relevant information about your system
>
> Kind regards,
>
> Regards,
> Amit Dodiya
> OpenERP Support Enterprise
>
>
> Access your messages and personal documents through our Customer Portal <https://accounts.openerp.com?db=openerp#action=login&token=ST863ZDldQc6T0CHxC1I&type=signup>
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1154976
>
> Title:
> [7.0] Account: Statement Reconcilation Menu missing
>
> Status in OpenERP Addons (modules):
> New
>
> Bug description:
> There is no menu available for Accounting/Periodical
> Processing/Statements/Statements Reconciliation in 7.0 and trunk.
>
> Thanks,
> Mustufa Rangwala
> mra...

[vita (mia-1ngola)]

New problem:

sort in tree view with widget="many2many " don't work

Please Help!!

[Amit Parik (amit-parik)]

Hello all,

You guys can use this module, It will helps to you.
But one issue is that you have to save the record first then you can able to enter the jounal iteam due to domain doesn't work properly with widget="many2many".

Thank you!

[vita (mia-1ngola)]

Thanks for Amit Parik.

But my problem is in this code line:

<field colspan="4" name="move_line_ids" nolabel="1" widget="many2many" domain="[('account_id','=',account_id),('statement_id', '=', False)]">

This code run but after from creation, view list in this code line don't sort all record by fields!

Here is a screen shot to explain:

img.jpg

if I filter by date, filter don't run