c2c-oerpscenario team mailing list archive

["Atik Agewan\(OpenERP\)" <aag@xxxxxxxxxxx>]

Public bug reported:


In Addons : 5369
   server : 3761

  In menu Accounting/Periodical Processing/End of Period/Generate
Opening Entries when create a Entries gives ProgrammingError.

Programming error: syntax error at or near ")"
LINE 17:                        AND b.period_id IN ()
                                                    ^
, in query 
                INSERT INTO account_move_line (
                     name, create_uid, create_date, write_uid, write_date,
                     statement_id, journal_id, currency_id, date_maturity,
                     partner_id, blocked, credit, state, debit,
                     ref, account_id, period_id, date, move_id, amount_currency,
                     quantity, product_id, company_id)
                  (SELECT
                     b.name, b.create_uid, b.create_date, b.write_uid, b.write_date,
                     b.statement_id, %s, b.currency_id, b.date_maturity,
                     b.partner_id, b.blocked, b.credit, 'draft', b.debit,
                     b.ref, b.account_id, %s, b.date, %s, b.amount_currency,
                     b.quantity, b.product_id, b.company_id
                     FROM account_move_line b
                     WHERE b.account_id IN %s
                       AND b.reconcile_id IS NOT NULL
                       AND b.period_id IN ()
                       AND b.reconcile_id IN (SELECT DISTINCT(reconcile_id)
                                          FROM account_move_line a
                                          WHERE a.period_id IN ()))

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/874052

Title:
  [Trunk][Account]In menu Accounting/Periodical Processing/End of
  Period/Generate Opening Entries when create a Entries gives
  ProgrammingError.

Status in OpenERP Addons (modules):
  New

Bug description:
  
  In Addons : 5369
     server : 3761

    In menu Accounting/Periodical Processing/End of Period/Generate
  Opening Entries when create a Entries gives ProgrammingError.

  Programming error: syntax error at or near ")"
  LINE 17:                        AND b.period_id IN ()
                                                      ^
  , in query 
                  INSERT INTO account_move_line (
                       name, create_uid, create_date, write_uid, write_date,
                       statement_id, journal_id, currency_id, date_maturity,
                       partner_id, blocked, credit, state, debit,
                       ref, account_id, period_id, date, move_id, amount_currency,
                       quantity, product_id, company_id)
                    (SELECT
                       b.name, b.create_uid, b.create_date, b.write_uid, b.write_date,
                       b.statement_id, %s, b.currency_id, b.date_maturity,
                       b.partner_id, b.blocked, b.credit, 'draft', b.debit,
                       b.ref, b.account_id, %s, b.date, %s, b.amount_currency,
                       b.quantity, b.product_id, b.company_id
                       FROM account_move_line b
                       WHERE b.account_id IN %s
                         AND b.reconcile_id IS NOT NULL
                         AND b.period_id IN ()
                         AND b.reconcile_id IN (SELECT DISTINCT(reconcile_id)
                                            FROM account_move_line a
                                            WHERE a.period_id IN ()))

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