If it's not possible through the OpenCart 3.0 admin panel itself, maybe someone know how to properly do it through the DB side to not break logic/numeration on forward?
Thanks!
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Invoice ID is generated only when purchase is made and paid.
I have no business background on why it does matter, but that's what basically is requested, to not have unpaid invoices.
I see that there is possibility to connect to DB/oc_order table and then change invoice_no to 0 instead of its current number. Seems to work. Is it the way to go and it won't generate any unintentional behavior?
You should be able to just mark it as cancelled in your accounts.
It might do, if I were you I would cancel the invoice in your accounting system instead.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
This strategy would be inadvisable since claim statuses may reflect during income tax at the end of the year from financial licensing platforms since a constant cancellation technic would be used when gathering the data.It might do, if I were you I would cancel the invoice in your accounting system instead.
However, reversing the generated invoice number would not be suggested either. Rather build an 'after' event and either send the order information with the generated invoice number of the service provider rather than the invoice prefix and invoice number from Opencart orders via your financial system. The invoice number originating from service providers are related to financial claims on anyhow, in this case, which is what your financial system is requiring.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Which is exactly my point above. By cancelling the claim to your financial platform, the declaration of that order will no longer be considered as paid but rather a cancelled status and doing that continuously may affect the Business outcome with Service Strategy. As to leave it as is, that is not what has been written on my previous reply, it is rather written to send the transaction number from the service provider from the extension payment module you are using and forward that string number to your financial API. This will maintain the SLAs with your Business and between the service providers you are using by Service Design.Apparently they want to have all of generated invoices to be paid.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
What we currently have is OpenCart store with multiple payment options and one accountant.
When customer places order - Order ID is generated. When customer pays this order, we manually generate Invoice ID which we later on send to our customer and also one for our accountant.
Currently we have this unpaid order with Invoice ID generated which, kinda, mess things up. Accountant is asking for invoices which are only paid and invoices to be consisten in its numeration.
Maybe this logic is wrong and there is nothing wrong with unpaid invoices.
Which makes it a bit difficult to believe that you'd have a hard time grasping the idea if you also mention two lines below what you're actually doing and which is what my replies covers. Additionally, yes that is correct, the accountant is asking for invoices which are only paid and invoices to be consistent in its numeration which means the generated transaction ID from the payment service provider. Not from the one you manually generate. Which is why, I do not suggest to cancel any claims on your financial system unless the customer requests it (and noted).auu wrote: ↑Tue May 21, 2019 8:58 pmSorry, seems like my English or knowledge on the topic in general, isn't that good, as I'm having really hard time to grasp your idea
What we currently have is OpenCart store with multiple payment options and one accountant.
When customer places order - Order ID is generated. When customer pays this order, we manually generate Invoice ID which we later on send to our customer and also one for our accountant.
Currently we have this unpaid order with Invoice ID generated which, kinda, mess things up. [b[Accountant is asking for invoices which are only paid and invoices to be consisten in its numeration.[/b]
Maybe this logic is wrong and there is nothing wrong with unpaid invoices.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Native English speaker here with a very good knowledge of accounting and OpenCart and I have NO IDEA what straightlight is going on about either.
The words look like they've been run through a translator backwards.
Straightlight, your posts usually make sense but I don't think you're speaking English today. Are you a native English speaker?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Are you based in the UK?
If so this is the answer:
"What if there is a break in sequence, for example where I cancel an invoice or it is spoiled and never issued to a customer?
As long as you retain the cancelled or spoiled invoice in your accounting records, or you can provide an explanation for the break in sequence, this is acceptable."
https://www.gov.uk/hmrc-internal-manual ... vatrec5020
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Point being, which is why my previous replies were provided so to suggest alternative strategies in order to maintain the Continuity Service on your store.Currently we have this unpaid order with Invoice ID generated which, kinda, mess things up. Accountant is asking for invoices which are only paid and invoices to be consisten in its numeration.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Alternative strategies and options always good, we just couldn't understand the Englishstraightlight wrote: ↑Wed May 22, 2019 6:25 amPoint being, which is why my previous replies were provided so to suggest alternative strategies in order to maintain the Continuity Service on your store.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Users browsing this forum: niagato and 641 guests