Post by kestas » Sun Jun 19, 2011 11:30 pm

I upgraded from1.4.7to1.5.0.5
I have use the same prefix but invoice number start from the first (1). I have try to edit invoice number in Database (through phpmy admin) what I need but nothing... keep going 1,2,3,4,5 ....
Of course I can edit this invoice number through phpmy admin all time... but this is very inconvenient... :( ;)
Second problem I can't use version 1.5.x until I can't generate invoice number manualy.
Why? Some customers canceling the order but want to keep this orders in history. For thoose orders I not need invoice numbers. All invoices must be in sequential order, but not cancelled. So I need generate invoice manualy.
Maybe you can add some setting to choose manualy or automatic generate invoice?

Thank you in advance

kestas

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by Daniel » Sun Jun 19, 2011 11:35 pm

just fixed it in svn.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by kestas » Sun Jun 26, 2011 4:10 pm

Daniel wrote:just fixed it in svn.
ok Thank you. ;)

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by kestas » Mon Jul 18, 2011 11:26 pm

kestas wrote:
Daniel wrote:just fixed it in svn.
ok Thank you. ;)
hello again Daniel.

I have instaled new 1.5.1 version but rpoblem seems is not solved ???
I repeating my request regarding invoices.
problem I can't use version 1.5.x until I can't generate invoice number manualy.
Why? Some customers canceling the order but want to keep this orders in history. For thoose orders I not need invoice numbers. All invoices must be in sequential order, but not cancelled. So I need generate invoice manualy.
Maybe you can add some settings to choose manualy or automatic generate invoice?

It is very important

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by Daniel » Mon Jul 18, 2011 11:46 pm

generate an invoice button is not coming back. if people cancel there order it needs to be recorded. its not about what you want it to do its how invoicing system should work.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by kestas » Tue Jul 19, 2011 12:43 am

Daniel wrote:generate an invoice button is not coming back. if people cancel there order it needs to be recorded. its not about what you want it to do its how invoicing system should work.
:(

I try to set order canceled... but invoice number not dissapear.
So after that I need to explain (write some aditionall reports regarding order canceling) to our accounting department why no money, why order is canceled instead do not generate the invoice.
So... there is very bad decision to remove this option. :( :( :(
If you do not return this option invoices will be not usable... Or I need to edit this number of invoices by hand manualy.

Thank you for undersanding.
sorry for my bad english ;)

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by Daniel » Tue Jul 19, 2011 12:49 am

I don;t know why you are arguing with me. its the LAW to provide an invoice number even if some one cancels it.

i don't have time to run around searching the web and posting links for you but i'm sure there are members from the EU that agree with me here.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by kestas » Tue Jul 19, 2011 1:24 am

Daniel wrote:I don;t know why you are arguing with me. its the LAW to provide an invoice number even if some one cancels it.

i don't have time to run around searching the web and posting links for you but i'm sure there are members from the EU that agree with me here.

I'm very sorry... maybe I'm bothersome... Yes you are right. I'm from Lithuania. also EU. I know the LAW... But regarding Lithuanian LAW if some transaction was canceled we need to write some reports to explain why... not enough to say the order was canceled... So for us simply beter do not generate invoice. In this reason I ask to add some option to generate invoice manualy or automatic. Or maybe you can say what files is affected to return this button? I'll try to solve this by myself... maybe :)

thank you

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by i2Paq » Tue Jul 19, 2011 2:44 am

Daniel wrote:I don;t know why you are arguing with me. its the LAW to provide an invoice number even if some one cancels it.

i don't have time to run around searching the web and posting links for you but i'm sure there are members from the EU that agree with me here.
I completely DISAGREE, there is no such LAW in the EU.

The only law is that you have to provide an invoice in LESS then 10 days after the order is delivered.
The numbers should be in order.
It should contain order-date, invoice-date, payment and shipping method, taxes and products.
have a look at my Prof. Invoice and Packingslip, this is how it should look like.

If an order is canceled BEFORE being shipped there is NO NEED for an invoice. If an order is canceled AFTER being shipped it should be refunded WITH a second invoice. The amount of the 2nd invoice is then - x.xx, so in the case of such an order you need 2 invoices. I rather see that this is implemented.

IN NO WAY there should be an invoice-number generated when an order is placed, I do not know whoever give you that idea?
Why the hell would I need an invoice-number if an order is not shipped yet and maybe canceled before that.
How can I delete an order now, this will interrupt the whole admin part of OC as it will be floated with orders never sold/shipped.

Now the whole Invoice-numbering system is USELESS!

sorry that I sound pissed-off, but I am. This is a change that should be discussed BEFORE being implemented instead afterwards we must argue why this should be reverted back.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by kestas » Tue Jul 19, 2011 2:55 am

i2Paq wrote:
Daniel wrote:I don;t know why you are arguing with me. its the LAW to provide an invoice number even if some one cancels it.

i don't have time to run around searching the web and posting links for you but i'm sure there are members from the EU that agree with me here.
I completely DISAGREE, there is no such LAW in the EU.

The only law is that you have to provide an invoice in LESS then 10 days after the order is delivered.
The numbers should be in order.
It should contain order-date, invoice-date, payment and shipping method, taxes and products.
have a look at my Prof. Invoice and Packingslip, this is how it should look like.

If an order is canceled BEFORE being shipped there is NO NEED for an invoice. If an order is canceled AFTER being shipped it should be refunded WITH a second invoice. The amount of the 2nd invoice is then - x.xx, so in the case of such an order you need 2 invoices. I rather see that this is implemented.

IN NO WAY there should be an invoice-number generated when an order is placed, I do not know whoever give you that idea?
Why the hell would I need an invoice-number if an order is not shipped yet and maybe canceled before that.
How can I delete an order now, this will interrupt the whole admin part of OC as it will be floated with orders never sold/shipped.

Now the whole Invoice-numbering system is USELESS!

sorry that I sound pissed-off, but I am. This is a change that should be discussed BEFORE being implemented instead afterwards we must argue why this should be reverted back.
You are right i2Paq I trying to explain this. but maybe my english is poor... Yes, if the order was canceled befor shipping I not need the inwoice at all. But I need to keep the history of ordering even order was canceled.

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by i2Paq » Tue Jul 19, 2011 4:06 am

Because of this stupid change I now have to manually generate a second invoice with the - amount of the first invoice of EVERY order that has been canceled!
This to prove to the Tax department I never received that money!


Please revert it back OR make it auto-generate when an order gets the status of: Processed.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by uksitebuilder » Tue Jul 19, 2011 4:24 am

Haven't tested, but am I right in thinking that now with 1.5.1 that an Invoice is generated at time order is placed on the system?

This is going to cause an un-needed amount of extra paperwork for credit notes to keep accountants happy.

scenarios
-------------

Customer orders and chooses bank payment or cheque payment and doesn't send it

Is this also the same for "missing orders" i.e. someone opts to pay by 3rd party payment provider (paypal standard et al) but they don't complete the transaction or cant for some reason (order goes into missing orders)
An Invoice is created for these too?

IMHO craziness

Should be up to the site admin to generate the invoice.

No good getting it to auto-generate in my opinion because order statuses can be edited by the user and different statuses mean different things to some users. i.e. as i2Paq said processed, or even shipped can mean complete.

Unless a fixed status of completed can be added that cannot be edited/deleted.

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by SXGuy » Tue Jul 19, 2011 4:47 am

if an order is cancelled it is perfectly fine to keep the invoice number as the cancelled order. If you have to give a reason, cancelled order is more than fine.

The order can easily be reconciled by showing it as a credit and then again as a debit, with a cross reference.
(true this is an issue if you want to reconcile, something should be added to do so)

People panic way to much about little things like this. So long as there is a clear paper trail it is fine.

And invoices are generated after payment, not after shipping has or has not taken place. it has nothing to do with shipping.

An invoice is proof of payment.

A pro forma is a pre invoice stating the amount to pay.

And if you really dont want to generate an invoice till after shipping, make all orders pending until your asignment has been sent out

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by Qphoria » Tue Jul 19, 2011 5:02 am

Why is this just coming out now? Automatic invoice generation was there as of 1.5.0 BETA

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by allenshea » Tue Jul 19, 2011 6:30 am

I have to say, the invoice design is really bad, it is even worse than 1.4

I know nothing about PHP and SQL, but I still try my best to understand it.


Active Member

Posts

Joined
Mon Dec 14, 2009 10:01 pm

Post by kestas » Tue Jul 19, 2011 12:41 pm

The simply way to make the next... when order is placed is generating proforma invoice (for Paymet) without invoice number (only order ID) when the money is received and order is processed generating automatic or manualy VAT INVOICE with invoice number. In Lithuania also need to write amount in Words (in version 1.4.7 i implement this script by mysel).
And this is not a trifle.

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by Daniel » Tue Jul 19, 2011 12:46 pm

OK OK OK i will put it back in the next release. I always thought you had to account for every order.

so should i set it to be generated when the order status hits complete? or do you want the button back?

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by i2Paq » Tue Jul 19, 2011 12:50 pm

Daniel wrote:OK OK OK i will put it back in the next release. I always thought you had to account for every order.

so should i set it to be generated when the order status hits complete?
If an order is Processed then is the right time to (auto) generate an Invoice, no problems with that.
But the best way is to have it the way it was, generate at your own choice.

Thanks for understanding Daniel!

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by Daniel » Tue Jul 19, 2011 12:52 pm

so the button needs to go back?

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by kestas » Tue Jul 19, 2011 12:54 pm

Thanks all for the understanding and help ;)
Daniel wrote:so the button needs to go back?
Yes the button must go back.

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am
Who is online

Users browsing this forum: No registered users and 22 guests