6.0 - Partner report - impossible to get open invoices in the past

[Frederic Clementi - Camptocamp]

If you try to print for example the report today, it is not possible to get open (unreconcile) invoices on the 31/12/2010.

If "include reconcile entries" is unticked, the report will exclude entries reconciled after the 31/12/2010 which means that today the report is almost empty because open invoices on the 31/12/2010 are almost all paid. And if you compare with the partner balance, of course it does not match.

This is a legal document, it must work.

[Frederic Clementi - Camptocamp (frederic-clementi)]

Simple comment : This is handled already very well by opening entries wizard which generate what we need for accounts with the defferal method ' unreconciled'

[David Mitchell (www.novapointgroup.com) (david-novapointgroup.com)]

Hi Frederic,

It is critical - in our opinion - that open invoices are able to be brought in to the system - and the opening entries wizard is not sufficient. We've received feedback from many organization's Chief Financial Officer's and accountants that OpenERP is deficient in this area. Many of the other commercial ERP systems allow users to bring in "open" invoices and their history. This would enable OpenERP to accurately show the status of any invoice: closed, open, draft, etc in the right state.

The primary issue is that in some countries (the US being one) - you need to actually bring in the invoice detail - in particular because you have to retain "payment terms" on the invoices. This invoice detail is also required when dealing with more complex invoice payments - where for instance a national parent is making a payment across several of their children - and children's children. E.g. GE corporate is making a payment for the parent, a child and a child of a child. If you are missing some of the invoices - it is a nightmare to reconcile.

So . . . we do not agree with the assessment that the opening entry wizard is sufficient. It is only sufficient in the simpliest organization . . . and does not stand-up to IRS(revenue service) audit here in the US.

See the attached workflow as an example.

[David Mitchell (www.novapointgroup.com) (david-novapointgroup.com)]

This is an example of the requirement to solve the problem and enable "open invoices" to be created upon opening balances.

[Frederic Clementi - Camptocamp (frederic-clementi)]

I agree David, initial import of open invoices is not handled a easy way in
OpenERP and your methodology seems to be a good one. I like the idea to
create a specific journal for this (although I think a specific period is
maybe a better idea because it could help solving other issue on exchange
rate used for opening entries : https://bugs.launchpad.net/bugs/736890 )

Frédéric CLEMENTI
Business Solutions
CamptoCamp SA
Tel : + 41 (0)21 619 1041
http://www.camptocamp.com

 <email address hidden>

2011/4/11 David Mitchell (www.novapointgroup.com) <email address hidden>

> This is an example of the requirement to solve the problem and enable
> "open invoices" to be created upon opening balances.
>
> ** Attachment added: "NPG_OpenInvoicesPayables_RequirementsDoc.odt"
>
> https://bugs.launchpad.net/openobject-addons/+bug/750308/+attachment/2016302/+files/NPG_OpenInvoicesPayables_RequirementsDoc.odt
>
> --
> You received this bug notification because you are a member of C2C
> OERPScenario, which is subscribed to the OpenERP Project Group.
> https://bugs.launchpad.net/bugs/750308
>
> Title:
> 6.0 - Partner report - impossible to get open invoices in the past
>
> Status in OpenERP Modules (addons):
> In Progress
>
> Bug description:
> If you try to print for example the report today, it is not possible
> to get open (unreconcile) invoices on the 31/12/2010.
>
> If "include reconcile entries" is unticked, the report will exclude
> entries reconciled after the 31/12/2010 which means that today the
> report is almost empty because open invoices on the 31/12/2010 are
> almost all paid. And if you compare with the partner balance, of
> course it does not match.
>
> This is a legal document, it must work.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~c2c-oerpscenario
> Post to : <email address hidden>
> Unsubscribe : https://launchpad.net/~c2c-oerpscenario
> More help : https://help.launchpad.net/ListHelp
>

[David Mitchell (www.novapointgroup.com) (david-novapointgroup.com)]

Hi Frederic,

We are working on new code to enable bringing in open invoices/credit
memos upon initial import. Our use case is "how to properly bring in
all open invoices/credit memos" in the right state that were opened in
another ERP system prior to conversion to OpenERP.

We will publish this code as soon as it is done.

On the exchange rate - when initial opening entries are made -
wouldn't the exchange rate already be factored in. When we import the
open invoices we are bringing them in with their original date and all
their details. Including the original period in which they were first
loaded. Wouldn't the exchange rate only become an issue when the
Payment is made??
We don't have to deal with exchange rate very much in the US - which
is why I ask.

Dave

On Tue, Apr 12, 2011 at 4:04 AM, Frederic Clementi - Camptocamp.com
<email address hidden> wrote:
> I agree David, initial import of open invoices is not handled a easy way in
> OpenERP and your methodology seems to be a good one. I like the idea to
> create a specific journal for this (although I think a specific period is
> maybe a better idea because it could help solving other issue on exchange
> rate used for opening entries : https://bugs.launchpad.net/bugs/736890 )
>
>
> Frédéric CLEMENTI
> Business Solutions
> CamptoCamp SA
> Tel : + 41 (0)21 619 1041
> http://www.camptocamp.com
>
>  <email address hidden>
>
>
>
> 2011/4/11 David Mitchell (www.novapointgroup.com) <email address hidden>
>
>> This is an example of the requirement to solve the problem and enable
>> "open invoices" to be created upon opening balances.
>>
>> ** Attachment added: "NPG_OpenInvoicesPayables_RequirementsDoc.odt"
>>
>> https://bugs.launchpad.net/openobject-addons/+bug/750308/+attachment/2016302/+files/NPG_OpenInvoicesPayables_RequirementsDoc.odt
>>
>> --
>> You received this bug notification because you are a member of C2C
>> OERPScenario, which is subscribed to the OpenERP Project Group.
>> https://bugs.launchpad.net/bugs/750308
>>
>> Title:
>>  6.0 - Partner report - impossible to get open invoices in the past
>>
>> Status in OpenERP Modules (addons):
>>  In Progress
>>
>> Bug description:
>>  If you try to print for example the report today, it is not possible
>>  to get open (unreconcile) invoices on the 31/12/2010.
>>
>>  If "include reconcile entries" is unticked, the report will exclude
>>  entries reconciled after the 31/12/2010 which means that today the
>>  report is almost empty because open invoices on the 31/12/2010 are
>>  almost all paid. And if you compare with the partner balance, of
>>  course it does not match.
>>
>>  This is a legal document, it must work.
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~c2c-oerpscenario
>> Post to     : <email address hidden>
>> Unsubscribe : https://launchpad.net/~c2c-oerpscenario
>> More help   : https://help.launchpad.net/ListHelp
>>
>
> --
> You received this bug notification because you are a member of OpenERP
> Drivers, which is subscribed to OpenERP Addons.
> https://bugs.launchpad.net/bugs/750308
>
> Title:
>  6.0 - Partner report - impossible to get open invoice...