Delete or Null invoice

[Carlos Eduardo Sotelo Pinto]

Dear Coders

I need to find a way to delete an invoice, it could be posted, then I need to get back all its movements or delete them. The reason is since I couldnt get them back with a credit note, i just need them nulled or deleted to notice tax authority as nulled as if never have been posted

Best regards

--

Carlos Eduardo Sotelo Pinto
    Agile Coach | Python Software Developer | Tryton ERP Consultant

    Claro RPC +51 989550602

    Skype: csotelop

    GNULinux RU #379182 | GNULinux RM #277661

Please consider the environment before printing this email

Join the campaign at http://thinkBeforePrinting.org

[Cédric Krier]

Hi,

On 2018-01-14 19:19, Carlos Eduardo Sotelo Pinto wrote:
> I need to find a way to delete an invoice, it could be posted, then I need
> to get back all its movements or delete them. The reason is since I couldnt
> get them back with a credit note, i just need them nulled or deleted to
> notice tax authority as nulled as if never have been posted

What type of invoice? For supplier invoice you can cancel a posted
invoice which will create a cancel move.
For Customer invoice, you can only make a credit note (with refund). It
is forbidden to delete an invoice because it may appear as a fraud
tentative.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[Carlos Eduardo Sotelo Pinto]

Hi Cedrik

On Mon, Jan 15, 2018 at 4:02 AM, Cédric Krier <cedric...@b2ck.com> wrote:

Hi,

On 2018-01-14 19:19, Carlos Eduardo Sotelo Pinto wrote:
> I need to find a way to delete an invoice, it could be posted, then I need
> to get back all its movements or delete them. The reason is since I couldnt
> get them back with a credit note, i just need them nulled or deleted to
> notice tax authority as nulled as if never have been posted

What type of invoice? For supplier invoice you can cancel a posted
invoice which will create a cancel move.
For Customer invoice, you can only make a credit note (with refund). It
is forbidden to delete an invoice because it may appear as a fraud
tentative.

The issue is that some invoices were wrong filled​, and is no possible to acredit the invoice. I have asked the tax authority and is possible to solve this issue if the invoice were not generated, like if the invoice have no exixted and the number was an error. My argument was

1. was filled on a wrong way

2. it has a number generated

3. was not sent to the tax authority ( each invoice is sent inmediatleey to the tax authority ) 

but, it is on system, then I need to find a way, probably directly on database for this case, to delete all generated data related to this invoice

Best regards

 

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

--
You received this message because you are subscribed to the Google Groups "tryton" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20180115090236.GG4241%40kei.

[Cédric Krier]

On 2018-01-15 17:42, Carlos Eduardo Sotelo Pinto wrote:
> On Mon, Jan 15, 2018 at 4:02 AM, Cédric Krier <cedric...@b2ck.com> wrote:
> > On 2018-01-14 19:19, Carlos Eduardo Sotelo Pinto wrote:
> > > I need to find a way to delete an invoice, it could be posted, then I
> > need
> > > to get back all its movements or delete them. The reason is since I
> > couldnt
> > > get them back with a credit note, i just need them nulled or deleted to
> > > notice tax authority as nulled as if never have been posted
> >
> > What type of invoice? For supplier invoice you can cancel a posted
> > invoice which will create a cancel move.
> > For Customer invoice, you can only make a credit note (with refund). It
> > is forbidden to delete an invoice because it may appear as a fraud
> > tentative.
> >
>
> The issue is that some invoices were wrong filled​, and is no possible to
> acredit the invoice. I have asked the tax authority and is possible to
> solve this issue if the invoice were not generated, like if the invoice
> have no exixted and the number was an error. My argument was
>
> 1. was filled on a wrong way
> 2. it has a number generated
> 3. was not sent to the tax authority ( each invoice is sent inmediatleey to
> the tax authority )
>
> but, it is on system, then I need to find a way, probably directly on
> database for this case, to delete all generated data related to this invoice

It looks like you have a distributed transaction issue with your tax
authority. At some point, the invoice should be sent to the tax
authority for validation prior to posting if they can decide if it is
valid or not.

Any way, I think the only proper way is still to make a credit note.

[Carlos Eduardo Sotelo Pinto]

​Any posted invoice must be sent to the tax authority in mediatley or at least 7 days as later via soap service

 

Any way, I think the only proper way is still to make a credit note.

​I am sure of that, but I have just some wird case that I couldnt make a credit note​

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

--
You received this message because you are subscribed to the Google Groups "tryton" group.

To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20180116151407.GQ4241%40kei.

[Cédric Krier]

On 2018-01-16 10:23, Carlos Eduardo Sotelo Pinto wrote:
>
> ​Any posted invoice must be sent to the tax authority in mediatley or at
> least 7 days as later via soap service
>
> >
> > Any way, I think the only proper way is still to make a credit note.
> >
>
> ​I am sure of that, but I have just some wird case that I couldnt make a
> credit note​

I see contradiction in those two statements. If you have to send all the
posted invoice to the tax authority than how would you be allowed to
delete a posted invoice? You should have already sent it to the tax
authority so for the integrity you must keep it in the system.

[Carlos Eduardo Sotelo Pinto]

Hi

On Tue, Jan 16, 2018 at 11:09 AM, Cédric Krier <cedric...@b2ck.com> wrote:

On 2018-01-16 10:23, Carlos Eduardo Sotelo Pinto wrote:
>
>

​​

​Any posted invoice must be sent to the tax authority in mediatley or at
> least 7 days as later via soap service
>
> >
> > Any way, I think the only proper way is still to make a credit note.
> >
>
> ​I am sure of that, but I have just some wird case that I couldnt make a
> credit note​

I see contradiction in those two statements. If you have to send all the
posted invoice to the tax authority than how would you be allowed to
delete a posted invoice? You should have already sent it to the tax
authority so for the integrity you must keep it in the system.

"""
​

​

​Any posted invoice must be sent to the tax authority in mediatley or at least 7 days as later via soap service​

​"""

My issue is that I can not sent this 4 o 5 invoices. for been as clear as possible

​There were errors like

- NO taxes

- Unit price as cuantity

Then the boss on the institution and accountant request information for make then null, and tax authority said "when an invoice is no sent on the period it is considered as nulled", then they just no sent these wrong invoices

Issue: as this incvoices were marked as nulled for not been on the limit time, and considered nulled for the tax authority, is no possible to generate a credit note cause

- numbers were considered as nulled

- content was no fuilled on a right way

Note: nulling invoice is ok  as a tool for institutions, the last resource for an issue, but as you say is no so good, but is a tool. But on tryton is no possible to marked as null a posted invoice

Best regards

​​

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

--
You received this message because you are subscribed to the Google Groups "tryton" group.

To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20180116160941.GT4241%40kei.

[Cédric Krier]

On 2018-01-16 16:32, Carlos Eduardo Sotelo Pinto wrote:
> ​
> ​
> ​Any posted invoice must be sent to the tax authority in *mediatley or
> at **least
> 7* days as later via soap service​

> ​"""
>
> My issue is that I can not sent this 4 o 5 invoices. for been as clear as
> possible
>
> ​There were errors like
>
> - NO taxes
> - Unit price as cuantity
>
> Then the boss on the institution and accountant request information for
> make then null, and tax authority said "when an invoice is no sent on the
> period it is considered as nulled", then they just no sent these wrong
> invoices
>
> Issue: as this incvoices were marked as nulled for not been on the limit
> time, and considered nulled for the tax authority, is no possible to
> generate a credit note cause
>
> - numbers were considered as nulled
> - content was no fuilled on a right way
>
> Note: nulling invoice is ok as a tool for institutions, the last resource
> for an issue, but as you say is no so good, but is a tool. But on tryton is
> no possible to marked as null a posted invoice

I must say all this sounds very strange and archaic.
But anyway, as you just say that you are allowed to not sent the invoice
to tax authority, you can also just not send the credit note.

After that if you want you can change the sequences to be as you wish it
to be.

[Carlos Eduardo Sotelo Pinto]

Hi

On Tue, Jan 16, 2018 at 6:19 PM, Cédric Krier <cedric...@b2ck.com> wrote:

On 2018-01-16 16:32, Carlos Eduardo Sotelo Pinto wrote:
> ​
> ​
> ​Any posted invoice must be sent to the tax authority in *mediatley or
> at **least
> 7* days as later via soap service​
> ​"""
>
> My issue is that I can not sent this 4 o 5 invoices. for been as clear as
> possible
>
> ​There were errors like
>
> - NO taxes
> - Unit price as cuantity
>
> Then the boss on the institution and accountant request information for
> make then null, and tax authority said "when an invoice is no sent on the
> period it is considered as nulled", then they just no sent these wrong
> invoices
>
> Issue: as this incvoices were marked as nulled for not been on the limit
> time, and considered nulled for the tax authority, is no possible to
> generate a credit note cause
>
> - numbers were considered as nulled
> - content was no fuilled on a right way
>
> Note: nulling invoice is ok  as a tool for institutions, the last resource
> for an issue, but as you say is no so good, but is a tool. But on tryton is
> no possible to marked as null a posted invoice

I must say all this sounds very strange and archaic.

​Unfortunately is the way on working SUNAT, the tax authority on Peru​

 

But anyway, as you just say that you are allowed to not sent the invoice
to tax authority, you can also just not send the credit note.

​Yo are right, I was looking the way on managing a way on cal or get back movements , but if there is no possible, just I could do it on data base, deleting referencces​

 

After that if you want you can change the sequences to be as you wish it
to be.

​That is that I was to avoid​

 

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

--
You received this message because you are subscribed to the Google Groups "tryton" group.

To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20180116231956.GZ4241%40kei.

[Raimon Esteve]

Hie Carlos,

Maybe you are interesting with

https://bitbucket.org/trytonspain/trytond-account_invoice_posted2draft

Regards

[Carlos Eduardo Sotelo Pinto]

Hi Raimon

That is exactly was I as looking for

Best regards

--

You received this message because you are subscribed to the Google Groups "tryton" group.

To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/CAN2HbXVzhWTwpR04Ms3Gfuc15C%2BiEAA3-zTzSoTZT81GOpvVMQ%40mail.gmail.com.