Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Invoice & Payment System Update [Gold & Silver] (Patreon)

Published:
2023-01-23 12:15:00
Imported:
2026-06

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s Invoice & Payment System training.

Here are the updates I made for this training:

· Customer Summary Email added by Randy Austin

· Customer Overpayment Credit added by Randy Austin

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

Geoffrey Metz

Found a minor bug in Invoice_Delete. As it is now, when the last invoice in the DB is deleted, the new blank invoice created at the end of the script by Invoice_New creates a gap in the Invoice Numbers. If the Invoice-New line at the end of the script is moved down to just above End Sub, then it works as I'm sure you intended.

Geoffrey Metz

Another thing - (sorry) - seems to me better to save the number of days in the DB instead of the full text (much less space in large sheet). Easy to translate on Load and Save/Update to get the full text on the actual invoice page. This also allows easy conditional formatting on the Invoice DB Row (RED!!!) if invoice date + value < Today making a simple downscale version of the Payment Manager.

Excel For Freelancers

HI Gary, thanks for the details. I will have a close look at this and make the necessary updates. Much appreciated.

Excel For Freelancers

Very nice ideas and thanks so much. I will try to accommodate those in upcoming training. Much appreciated.

Fadhel Hussain

Randy, Payments_Load is not included in Worksheet_Change(Payments sheet). Do you have any suggestions for how I can run Payments_Load macro?

Excel For Freelancers

Hi Fadhel, thanks for your comment. The Payments Load macro is in the updated workbook and will trigger on Previous and Next button clicks. I hope this helps and thanks so much.