Hi
I kindly request for an improvement or new VBA code which can enable the production of record of invoices which include VAT Amounts on the record of invoices worksheet. The current VBA it does not produce VAT amount on record of invoices worksheet. The other shortfall is that the formula on the Invoice template in the Price column which automatically write price when an item is selected on the description column is deleted whenever I press start new invoice button.
Thank you.
Please Login or Register to view this content.Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Hi
Thank you for the VBA code. I'm still trying it. Thank you
I noticed there is no check to see if an invoice already exists so it is possible to submit te same invoice twice unless, following a submission of an invoice, you select the next (new) one.
Hi
Yes it is possible, I select the next (new) one.
Hi JohnTopley
I have tried VBA codes are working as desired. However if possible can you kindly provide a control VBA, that will not allow someone to print before clicking Add to Record button , so that there is no situation where someone is given an invoice which is not recorded.
Please I appreciate your help. Thank you.
Both "RecordofInvoce" and "SaveasPDF" update the "Record of Invoices" sheet so you get duplicate records: so which do you want?
Hi
Record of invoice and save as PDF. Thank you.
Hi John Topley
I want Record of invoice and save as PDF. I thought you did not see my reply. Thank you
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #1 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Why not simply use "SaveAsPDF" which records the Invoice Details (identical to "Record of Invoice" which is redundant)
Please Login or Register to view this content.
Hi JohnTopley
Thank you for the VBA. SAVE AS PDF is working but it does not record the name of the customer, amount and VAT. I also want include security measure that it should not allow printing before saving as pdf and also to protect invoice number not to be deleted. See the attached sheet.
Wrong! I added the VAT (highlighted in my previous post) and it does record the other 2 items .it does not record the name of the customer, amount and VAT.
None of your macros are secure as I pointed out earlier: it is easy to add duplicate copies of an invoice on "Record of Invoices" simply by doing "Add To Record" followed by "SaveAs PDF".
Last edited by JohnTopley; 04-26-2024 at 02:27 AM.
Hi John Topley
Thanks for the VBAs. I think it's best I start a new workbook that incorporates control measures.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks