Default demo fails when choosing Mexican Chart of accounts

[Kenneth Andresen]

This failure is with OpenERP 6.0.3 server and OpenERP 6.0.3 client-web. The defect is also present in the latest nightly build of the two above 6.0.3 packages for November 18th.

0) Create a new OpenERP database with the following setup
- install with demo data
- Interface : Simplified
- default company data
- modules: Warehouse Management, Invoicing, Sales Management, Accounting & Finance
- Chart of Accounts: Mexico - Chart of Account
- choose default Accounting configuration
--- This should conclude the preparation and automatically log us in as "Administrator".
--- The following steps are perfromed as Administrator

1) Click "Sales" and then click "Sales Orders"
2) Open Order with reference code SO001
3) Click to "Confirm order"
4) Click to "Create Final Invoice"
-- notice, this will create a pop-up, you might need to accept this popup for the next step
5) Click Validate
6) Click Payment
7) Choose Paymenet Method "Current"
8) See Payment Information details "Invoices and outstanding transactions"

Expected information should be a Journal ITEM: "SAJ/2011/001(SO001)"
However if "accounting plan: "Mexico - Plan of accounts" was selected in the setup, there will be no elements displayed and balance will stay zero.

Since the problem is NOT present when choosing the default Belgian plan of accounts, it is assumed the problem is either in the default Mexican plan of Accounts, or with the module selecting an invalid account during "Payment Method" under Step 7.

[Kenneth Andresen (kandresen)]

Defect will be triggered: Always
The defect is also present when not loading Demo data and creating an order from scratch.

[Kenneth Andresen (kandresen)]

There are at least two solutions to this problem:
1) Create a different association between step 7 "Payment Method" dependent upon which "Chart of Accounts" is chosen
2) Add the "expected" account to "Mexico - Chart of Account" (Notice: every country may have a different chart of accounts, it may thus not be good to require specific account numbers to be present in every "chart of accounts", it is however likely the quickest fix).

[Kenneth Andresen (kandresen)]

I have found the problem. In this case it is the Mexican Chart of Accounts that have the defect - there is no account of type:
"receivable".

I did a database update on the non-working system and change type of the account "Ganancia en Paridad Cambiaria" from type "other" to type "receivable". I performed a logout and a login, and tried again. Now everything is working.

[Kenneth Andresen (kandresen)]

Apparently I spoke too soon - The "Payment Dropdown" now works, displaying the values correctly, but when I try to click "Verify", I now get the error:
"The account is not defined to be reconciled !".

I do however now know for sure that it is the "Mexican - Plan of Account" that is bad, and the defect has likely nothing to do with the modules related with "Payment Methods".

[Kenneth Andresen (kandresen)]

For the Reconcile part it was only to update the SQL database again for account_account and setting "reconcile" to "true" on the account with the name "Ganancia en Paridad Cambiaria".

Now validation too is working.

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

Same problem exists in Supplier invoice too. You can change Account type to receivable/payable and boolean reconcile=true for its respected Accounts.

Thanks,
Mustufa

[Kenneth Andresen (kandresen)]

Correct, I am in fact stopped even earlier than that:

Same setup as step "0" above except adding the "Purchase Management" module.

1) Click on "Purchases"
2) Under "Request for Quotations", click PO00001.
3) Click "Convert to Purchase Order"

Instead of converting the order to a Purchase order we now see a warning:
"You can not confirm purchase order without Purchase Order Lines."

This might be a separate defect, however, again, it only happens when using the Chart of Accounts: "Mexico - Chart of account".

[Kenneth Andresen (kandresen)]

I did submit a separate defect on the conversion of "Purchase Quote" to "Purchase Order" as defect 893593:
https://bugs.launchpad.net/openobject-addons/+bug/893593

[DJ Patel (OpenERP) (mdi-openerp)]

Hello Kenneth Andresen,

Thanks for reporting. The solution for this bug is proposed in the branch : https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-892660-mdi/

with following Revision ID and Number.

Revision ID : <email address hidden>
Revision Number : 5788

Thanks and Regards,

Divyesh Makwana(MDI)

[Raphael Collet (OpenERP) (rco-openerp)]

landed in trunk
Revision:5999
revid:<email address hidden>