PauloV Posted April 15, 2015 Report Share Posted April 15, 2015 (edited) Hello Paul/Tyson/Cody EU Commission Information: http://ec.europa.eu/taxation_customs/taxation/vat/how_vat_works/telecom/index_en.htmHow to Register for and Use the VAT Mini One Stop Shop (MOSS): https://www.gov.uk/register-and-use-the-vat-mini-one-stop-shopVAT Rates by Country: http://ec.europa.eu/taxation_customs/resources/documents/taxation/vat/how_vat_works/rates/vat_rates_en.pdf We need to "polish" Eu Billing/Pro-Forma invoices in blesta, there is alredy alot of talk in blesta foruns and a recent one in WebHostinTalk about how blesta needs to go to be fully EU compatible, so I open this forum to male "pressure" for you acomplish every aspect asap Im now finalising a new VAT MOSS Report for blesta (will release later today for free for evryone in EU) (VAT moss its finished please check here ) The most completed and Biggest Thread to fix all issues with EU/Pro-Forma invoices in Blesta Problem: New EU Law Compilant for Data Protection Solution: https://dev.blesta.com/browse/CORE-2463 Problem: Wirth the new EU Law that is active since 1 January 2015, EU consumers have to see prices with TAX of the country of origin. Wen activating tax inclusive or excluse, dosent reflect on order form prices.Solution: Wen a client is not logged in, in blesta, it show show a POPUP to select country of origin, or use GEO to pre select the country, but always have an option to the client change saving as a cookie or session. After that the order forms have to diplay prices with and without TAX, and also shoe the tax rate, for exemple show like this example [Hostin Plan starting at €1.23 and then below a note saying (Prices incl. 23% VAT)] Problem: Wen acidentaly creating an Pro-Forma invoice with "0" (zero) Euros, it converts automaticly to an "Final Invoice", this cannot happen, because sometimes we can make mistakes (i did, I put the price in the quantity field insted of the Unit Cost field)Solution: Do not auto convert "0" (zero) invoices to final invoice. Problem: Pro-Forma invoices numbering are not sequential. (CORE-1287)Solution: Dont reuse numbering wen converting a pro-forma invoice to an invoice, wen creating a new pro-forma invoice. Problem: Final invoices can be edited by Staff/Admin. (added sugestion naja7host) Solution: Wen Pro-Forma is enable on Blesta, put an option in ACL to disable Final invoice editing, only be able to edit "Notes" field on Invoice. Final Invoice (even if unpaid), cannot ever never be "EDITED" by any Staff/Admin with the ACL enable (i know in phpMyAdmin is always possible, but...). Problem: Invoice Details are changed, wen a client changes details in contacts. (i think there is alredy a CORE TASK)Solution: Save as an array the details in the invoice table in a new field Problem: Wen converting to final invoice the date mantains the original date. (CORE-1605) Alredy Fixed but not confirmedSolution: Wen converting to final invoice, put the date of the convertion. Wen there is a final invoice (Paid/UNpaid/Partial Paid), the date as to be always changed to the date of the convertion of the final invoice. Problem: We cannot create a manual final invoice, only Pro-Forma invoices.Solution: Wen Pro-Forma is enable on Blesta, add an option to convert to final invoice, even if unpaid. Sometimes we need to Creat a Final Invoice but "Unpaid". Problem: As I saw in webhosting talk: "the way it handles rounding for the transactions, the system stores the values to 4dp in the db so things like tax rules (as mentioned earlier in thread) and auto foreign exchange rate calculations lead to unexpected results because Blesta does the math to 4dp but Paypal for e.g. only cares about 2dp so the user could pay an invoice and suddenly end up with a 1c credit without knowing what went wrong."Solution: Calculate it better Alredy Fixed but not confirmed Problem: Wen final invoice, the email is not sended to the client. (CORE-1561 but not completed with a second wen Full Paid) Fixed and ConfirmedSolution: Send an email with the invoice wen converted to final invoice, and also wen is full PAID. Problem: We dont have an option to create "CREDIT NOTES" wen voiding an invoice.Solution: Auto and Manually create a new type of document/invoice called "CREDIT NOTE" if voiding an invoice, with a new sequential numbering. Problem: Total tax, is not being saved in database on "invoice_lines" table. The value must be saved because rounding issues, this way we have to alwaes calculate tha VAT that was in that time to try to get the correct VAT/TAX total. For exemple for the Vat MOSS to work I have to make extra calculations to make it right, but there are companies that like to round value in Total of the invoice, and people that like to round in total for each line.Solution: Create a new field on invoice_lines table, and save the total vat/tax, also i think is better to sabe also the Tax Rate in this table, and not only the ID of the the external table to get the TAX Rate. Alredy Fixed but not confirmed Problem: Creating an account dosent validate VAT MOSS requirements. Solution: On order from wen creating an account, add option to tell if its a Company or an Individual, if company in "EU Country List" show default blesta company TAX Rule, if its an individual, than use the Tax Rule from the individual country in "EU Country", if the Company and or Individual is outside of EU, then show default TAX Rule from Blesta Company Country. Problem: Wen an pro-forma is converted to final invoice, we cannot find the old pro-forma number for tracking proposes.Solution: Add an option to show on Admin/Staff client invoices a new colum with the old number, and be able to search with the old number also. Problem: Custummers dosent have a Country Select Box to select "Country Tax" to show on Services and on Checkout (yes, i know after register the VAT is recalculated).Solution: Add an option or better yet a BOX to show (wen pro forma is enable in admin) on any Blesta Page wen enterying for the first time, (If not Logged In), to select a Country Flag with a warning telling its to show prices with country VAT.Exemple: All Flags or a drop box for countries If anyone elese as anything to add, or any opinion on how to, please share it here, we need this DONE asap Regards,PV Edited February 28, 2018 by PauloV New EU Law for Data Protection on 2018 Blesta Addons, a.daniello, serge and 1 other 4 Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted April 15, 2015 Report Share Posted April 15, 2015 just to note CORE-1605 is fixed CORE-1561 is fixed i have not yet tested the fix . PauloV 1 Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted April 15, 2015 Report Share Posted April 15, 2015 Problem: Final invoices can be edited by Staff/Admin. Solution: Wen Pro-Forma is enable on Blesta, put only be able to edit "Notes" field on Invoice. Final Invoice (even if unpaid), cannot ever never be "EDITED" by any Staff/Admin (i know in phpMyAdmin is always possible, but...). Problem: Invoice Details are changed, wen a client changes details in contacts. (i think there is alredy a CORE TASK) Solution: Save as an array the details in the invoice table in a new field some countries law , is not stricted to this issue , so i think allow only admins to edit the info , and of cource add the edit action in the ACL list , that way i'm shure no one from my staff can edit invoices Problem: We cannot create a manual final invoice, only Pro-Forma invoices. Solution: Wen Pro-Forma is enable on Blesta, add an option to convert to final invoice, even if unpaid. Sometimes we need to Creat a Final Invoice but "Unpaid". good piont here , i have already do a custom work for this piont , and is so easy to be implemented . Problem: Wen acidentaly creating an Pro-Forma invoice with "0" (zero) Euros, it converts automaticly to an "Final Invoice", this cannot happen, because sometimes we can make mistakes (i did, I put the price in the quantity field insted of the Unit Cost field) Solution: Do not auto convert "0" (zero) invoices to final invoice. i imagine this is not a bug , also is not in high pritiority , but can be improuvement after the others pionts are done Problem: We dont have an option to create "CREDIT NOTES" wen voiding an invoice. Solution: Auto and Manually create a new type of document/invoice called "CREDIT NOTE" if voiding an invoice, with a new sequential numbering. a must have feature , i vote to be in 3.5.0 ; is trivial for us . Michael and PauloV 2 Quote Link to comment Share on other sites More sharing options...
Michael Posted April 15, 2015 Report Share Posted April 15, 2015 a must have feature , i vote to be in 3.5.0 ; is trivial for us . 3.5.x is almost completed so won't be added in that version, maybe vote for it to be 4.0 PauloV 1 Quote Link to comment Share on other sites More sharing options...
PauloV Posted April 15, 2015 Author Report Share Posted April 15, 2015 some countries law , is not stricted to this issue , so i think allow only admins to edit the info , and of cource add the edit action in the ACL list , that way i'm shure no one from my staff can edit invoices good piont here , i have already do a custom work for this piont , and is so easy to be implemented . i imagine this is not a bug , also is not in high pritiority , but can be improuvement after the others pionts are done a must have feature , i vote to be in 3.5.0 ; is trivial for us . Thanks naja7host I hve added your sugestion 3.5.x is almost completed so won't be added in that version, maybe vote for it to be 4.0 Yep, every day I went to Dev CORE dev.blesta.com/browse/CORE to see what is done Quote Link to comment Share on other sites More sharing options...
Michael Posted April 15, 2015 Report Share Posted April 15, 2015 Thanks naja7host I hve added your sugestion Yep, every day I went to Dev CORE dev.blesta.com/browse/CORE to see what is done Visit: http://dev.blesta.com/secure/RapidBoard.jspa?rapidView=1&view=planning&selectedIssue=CORE-1451&versions=visible PauloV 1 Quote Link to comment Share on other sites More sharing options...
Paul Posted April 15, 2015 Report Share Posted April 15, 2015 Thanks for starting this thread PauloV, makes it easy to see everything in one place. I'll be going through this in more detail shortly to ensure we have a task for anything outstanding. Looking forward to the VAT MOSS report, many will thank you! PauloV and Michael 2 Quote Link to comment Share on other sites More sharing options...
Paul Posted April 15, 2015 Report Share Posted April 15, 2015 Problem: Wen acidentaly creating an Pro-Forma invoice with "0" (zero) Euros, it converts automaticly to an "Final Invoice", this cannot happen, because sometimes we can make mistakes (i did, I put the price in the quantity field insted of the Unit Cost field) Solution: Do not auto convert "0" (zero) invoices to final invoice. How should this be handled? If the invoice is not positive, then close it but leave it as pro-forma? Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted April 16, 2015 Report Share Posted April 16, 2015 How should this be handled? If the invoice is not positive, then close it but leave it as pro-forma? i don't think is the perfect solution , because i can give another case that need a proforma with "o" to be converted to invoice . what i imagine as a solution , a pop up modal when proforma has "0" , to make the admin attention with it . PauloV 1 Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted April 16, 2015 Report Share Posted April 16, 2015 How should this be handled? If the invoice is not positive, then close it but leave it as pro-forma? i don't think is the perfect solution , because i can give another case that need a proforma with "o" to be converted to invoice . what i imagine as a solution , a pop up modal when proforma has "0" , to make the admin attention with it . Quote Link to comment Share on other sites More sharing options...
a.daniello Posted April 16, 2015 Report Share Posted April 16, 2015 If i can, i would edit a point: CORE-1561 "Requeue invoice for delivery when converted from proforma" seems work only with proforma generated by an order. If i create "manually" a proforma and then send to client, when he pay and record the transaction proforma is converted to invoice as "not sended" (correct, fix the original issue) but Blesta doesn't send the invoice (issue). Thanks Blesta Addons and PauloV 2 Quote Link to comment Share on other sites More sharing options...
PauloV Posted April 16, 2015 Author Report Share Posted April 16, 2015 How should this be handled? If the invoice is not positive, then close it but leave it as pro-forma? My vote goes to naja7host ideia: ... what i imagine as a solution , a pop up modal when proforma has "0" , to make the admin attention with it . If i can, i would edit a point: CORE-1561 "Requeue invoice for delivery when converted from proforma" seems work only with proforma generated by an order. If i create "manually" a proforma and then send to client, when he pay and record the transaction proforma is converted to invoice as "not sended" (correct, fix the original issue) but Blesta doesn't send the invoice (issue). Thanks Thanks for test it, I have changed, and also have added a new issue founded, on first post Quote Link to comment Share on other sites More sharing options...
Tyson Posted April 16, 2015 Report Share Posted April 16, 2015 If i can, i would edit a point: CORE-1561 "Requeue invoice for delivery when converted from proforma" seems work only with proforma generated by an order. If i create "manually" a proforma and then send to client, when he pay and record the transaction proforma is converted to invoice as "not sended" (correct, fix the original issue) but Blesta doesn't send the invoice (issue). Thanks How did you send the proforma invoice to the client? Proforma invoices are only requeued for delivery if they were queued for delivery and sent before. If you don't click the "Email" checkbox when you create the invoice, then it was not originally queued for delivery. When it is later converted to a normal invoice it sees that it was not queued for delivery before so it will not be queued for delivery again. This is the intent of CORE-1561. The system also makes no distinction between how the invoice was created (by order, manually, etc.) when requeuing it for delivery. Quote Link to comment Share on other sites More sharing options...
Paul Posted April 16, 2015 Report Share Posted April 16, 2015 i don't think is the perfect solution , because i can give another case that need a proforma with "o" to be converted to invoice . what i imagine as a solution , a pop up modal when proforma has "0" , to make the admin attention with it . What would be a use case where you would want a $0 invoice? And, what are the consequences of having a $0 due invoice if you accidentally submit a proforma invoice with a 0 balance? It is simple for us to say, if invoice type is proforma, and amount is 0, do not convert to invoice. But, it is more difficult to pop up a modal box and request action from the staff member. Also consider that the system could potentially generate a $0 proforma invoice itself, and manual intervention is not possible. We want to go with the simplest solution that works in as many cases possible. Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted April 17, 2015 Report Share Posted April 17, 2015 What would be a use case where you would want a $0 invoice? And, what are the consequences of having a $0 due invoice if you accidentally submit a proforma invoice with a 0 balance? It is simple for us to say, if invoice type is proforma, and amount is 0, do not convert to invoice. But, it is more difficult to pop up a modal box and request action from the staff member. Also consider that the system could potentially generate a $0 proforma invoice itself, and manual intervention is not possible. We want to go with the simplest solution that works in as many cases possible. simple case i will give a client a free domaine , so i will create a preforma with 0€ , and it should normally converted to invoice but i think you have misunderstand the PualoV case , go to admin side , select client , add new proforma . normally when adding a proforma it remain proforma until is paid . in case of proforma amount is 0 is not created as proforma and in thge next cronjob converted to invoice , it created directly invoice . so the simple solution 1 - if invoice type is proforma, and amount is 0, do not convert to invoice auto and show a popup with this . 2 - in the cronjob add new cron to convert proformas with 0 to invoice . the option 2 can be remplaced with what PauloV suggested about converting proforma to invoice even if not paid , in that case we can say . 1 - if invoice type is proforma, and amount is 0, do not convert to invoice . then we can convert it manually that's so easy PauloV 1 Quote Link to comment Share on other sites More sharing options...
a.daniello Posted April 17, 2015 Report Share Posted April 17, 2015 Tyson, when we created the proforma we also checked for send email: so Blesta sent the proforma. Then, users have paid these proforma: proforma began invoices with status "not sent" but... after more then a day these invoices were always here with status "not sent" (also log not reports anything). At the end, we had to send it manually. I hope that this (and my english ) can explain better the case. Thanks PauloV 1 Quote Link to comment Share on other sites More sharing options...
Tyson Posted April 17, 2015 Report Share Posted April 17, 2015 Tyson, when we created the proforma we also checked for send email: so Blesta sent the proforma. Then, users have paid these proforma: proforma began invoices with status "not sent" but... after more then a day these invoices were always here with status "not sent" (also log not reports anything). I'm not able to duplicate that behavior. If the invoice status is shown as "Unsent" in the interface, then it hasn't been delivered automatically. If you have checked the "Email" delivery option when you created the proforma invoice, it would have been queued for delivery via email and sent when the cron next ran. If it was then delivered successfully, the status would be shown as "Sent" in the admin interface. If the invoice is then paid and converted to a normal invoice, it would be requeued for delivery and emailed to the client when the cron runs next. Invoice delivery requeuing was added in v3.4.3 of Blesta. If the status continues to show "Unsent", then there may be an issue with the cron running the "Deliver Invoices" task, or the server may be failing to deliver email properly. PauloV 1 Quote Link to comment Share on other sites More sharing options...
PauloV Posted April 17, 2015 Author Report Share Posted April 17, 2015 Tyson, when we created the proforma we also checked for send email: so Blesta sent the proforma. Then, users have paid these proforma: proforma began invoices with status "not sent" but... after more then a day these invoices were always here with status "not sent" (also log not reports anything). At the end, we had to send it manually. I hope that this (and my english ) can explain better the case. Thanks I can confirm, that is working OK, wen I manual create an Pro-Forma invoice, and after the cron run (sent the pro-forma by email), I have submited Manual Payment in "Record Payment for invoice", then pay in full, I didnt check the option "Email Receip", then click on Continue, and in Closed invoices, the final invoice show emidiatly the status "sent" without time for the cron to run, but after 5 minuts (my cron runs) and I have recived the "Copy" email with the final invoice. @Tyson: Its working ok a.daniello 1 Quote Link to comment Share on other sites More sharing options...
a.daniello Posted April 17, 2015 Report Share Posted April 17, 2015 Yes! For me too. We did several tests and all works fine. Sorry for bad submission, but we were confused by a fact: in Tools > Log > "Invoice delivery" we didn't see the invoice delivery as aspected because when a proforma begin invoice, "Invoice delivery" doesn't add a new record on top, but change only the invoice number of the proforma with the number of invoice (this is ok) but show date and time of proforma delivery and not of invoice (this isn't ok). [we have also verified that in "invoice_delivery" db table you store two records, one for proforma and one for invoice, but in "Invoice delivery" reports you show only one record with "date_sent" older). Sorry... and thanks, Achille PauloV 1 Quote Link to comment Share on other sites More sharing options...
Tyson Posted April 17, 2015 Report Share Posted April 17, 2015 but show date and time of proforma delivery and not of invoice (this isn't ok). Could you clarify this point? I'm not sure which dates you are referring to. Quote Link to comment Share on other sites More sharing options...
a.daniello Posted April 18, 2015 Report Share Posted April 18, 2015 Tyson, see attach. Isn't a bug but only a thing that can generate confusion. Two records seems the same, but only fron date_sent i understand that one is proforma, and other is the invoice. Only, the real problem is that we lost history of proforma, but isn't a big problem because data useful to pay tax are only invoices. Thanks Quote Link to comment Share on other sites More sharing options...
Tyson Posted April 20, 2015 Report Share Posted April 20, 2015 I see. The invoice number changed when it was converted from proforma to a normal invoice, and the system doesn't keep history of the old proforma invoice information for reference in that table. Michael 1 Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted April 21, 2015 Report Share Posted April 21, 2015 I see. The invoice number changed when it was converted from proforma to a normal invoice, and the system doesn't keep history of the old proforma invoice information for reference in that table. This is bacause i think here it use a inner joir request, is better to store the field in the log table serge and PauloV 2 Quote Link to comment Share on other sites More sharing options...
PauloV Posted April 21, 2015 Author Report Share Posted April 21, 2015 I have added a new problema to the list: Problem: Wen an pro-forma is converted to final invoice, we cannot find the old pro-forma number for tracking proposes. Solution: Add an option to show on Admin/Staff client invoices a new colum with the old number, and be able to search with the old number also. lukasP and Blesta Addons 2 Quote Link to comment Share on other sites More sharing options...
Tyson Posted April 21, 2015 Report Share Posted April 21, 2015 This is bacause i think here it use a inner joir request, is better to store the field in the log table No, it's because the proforma invoice and the normal invoice are the same record. I have added a new problema to the list: Problem: Wen an pro-forma is converted to final invoice, we cannot find the old pro-forma number for tracking proposes. Solution: Add an option to show on Admin/Staff client invoices a new colum with the old number, and be able to search with the old number also. This isn't currently possible without either creating separate records for proforma/normal invoices, or keeping history of just the old proforma number. But since the proforma numbers can be reused, searching by proforma number could yield multiple results. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.