Invoice Due Date required to be linked to Promised Date

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Contributing Cover User
8 Posts
Contributing Cover User
Contributing Cover User




Solved: Go to Solution

Invoice Due Date required to be linked to Promised Date



My Customers book with us up to two years in advance for actually paying the final Invoice.  We use the Promised Date field as the date that their Wedding is with us and their final payment is due 1 month prior to this date.


Is there a way to use the Promised Date field as the date that Customer payment Terms/Overdue etc are geared to ?  If not, what would be the best way to configure Customer Terms for our scenario whereby there can be a long period between the original Invoice date and the Date that final payment is required?


Kind regards,



Ultimate Partner
2,574 Posts
Ultimate Partner
Ultimate Partner




Accepted Solution Solved

Re: Invoice Due Date required to be linked to Promised Date



Welcome to the MYOB Community Forum, I hope you find plenty of useful information.


As far as I know there is no way to link the Promised date to the Terms.

The only thing to do would be to set the Terms to a Given number of days and work out how many days to when the payment is due and enter that in the due date in the terms on their card for that client.


customer terms.PNG

As you can see it does allow for over a year in days, you can have up to 999 days.


If my response to your query and has helped, please mark my post as a solution to help others in the future.
Graeme Day
Registered BAS Agent #24745540
Gralord Enterprises Pty Ltd
Mobile: 0402 841 627
MYOB Certified Consultant
MYOB Diamond Partner
Super Partner
469 Posts
Super Partner
Super Partner




Re: Invoice Due Date required to be linked to Promised Date

Hi @Steve_Bilpin 


What a clever use of the Promised field and great way to keep track of the Actual Wedding day for each customer!


As @GDay53 has explained you are able to enter in the exact number of days into the due date - you just have to calculate them each time.


Some of the MYOB Add-on Solutions might also help here.

As an example our Business Intelligence solution BI4Cloud allows you to include the Promised data as part of your Aged Debtors report.  So you can Sort invoices based on Promised date for example to see which ones are coming due in the next month. This may help you to save time?


Tell me do you also use Jobs in MYOB? 

If you set up a Job card for each wedding you could:

  • Link the Job to the Customer
  • Set up Start & End dates on the Job card - You could set the Start date as 1 month before the wedding say and the End date on the Wedding day 
  • Track your invoices to the customer and also any expenses and purchases related to that wedding to the job
  • See the  section on Start & End dates - Super charge your Jobs reporting to Better Manage Project Type Jobs

Using BI4Cloud you can also do very flexible Jobs reporting including Filtering and reporting by Job Start and End dates. This would also help you to report on each Wedding in the Date order of the actual wedding and not on the date of the original invoice. Just a thought.


All details and a free trial of BI4cloud are on our website 

Jennifer Kelly CA
BI4Cloud- powered by Interactive Reporting
02 8011 1511
Valued User
192 Posts
Valued User
Valued User




Re: Invoice Due Date required to be linked to Promised Date

HI Steve


Shoot me an email to and I will give you a report that will do this for you.



Matt Jones

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
Get the conversation started and make a new post Start a Post