Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Post invoice automatically from billing schedule

(3) ShareShare
ReportReport
Posted on by 1,419
Hi experts, 
 
Is anybody else finding this system behavior incoherent or does anybody has any tip to get a different result? Being able to post the invoice automatically would be very convenient if we could select the correct invoice date. 
 
It seems that only by entering today's date on the invoice date field, I'm able to see the transactions pending to be invoiced, in which case, no matter what date the transactions have will be included on an invoice with date today: 
 
What if I want to back date an invoice and create it for example with date 30/04/2025. That I would change the invoice date field to 30/04/2025 with the expectation to see all the transactions up to that date and the invoice generated on that date as well but it seems that I can only select transactions to be included on an invoice if invoice date is today or later. Also, if it's later, for example if I enter as invoice date 31/12/2025, I still can only see invoices up to June. 
 
The filters on the general section seem to filter on the billing schedule header dates not the lines so they are not useful in this case either. 
 
I see the same issue when selecting the posting option "Show Posting invoice or Create invoice proposal page", an invoice proposal is created with an non-editable invoice date: 
 
Does this mean that we cannot back date invoices and directly post/create them from billing schedules? Isn't it a very common business scenario that invoice for the previous month are only created 5/6 days after month end but they are back dated to the last day of the previous month? 
 
Please share your experiences with this functionality, thank you!!! 
 
 
Categories:
  • CapsLock Profile Picture
    1,419 on at
    Post invoice automatically from billing schedule
    Hi Adis thanks for trying to help but unfortunately that filtering doesn't apply to this form. 
     
    Arvind: 
    1. That's exactly what I'm saying doesn't happen 
    2. If left blank, today is picked as invoice date. There are multiple reasons why invoices can't be generated on the day the month ends. Just as with other invoices we should be able to back date, I think this is poor design or I'm overlooking something. 
  • Suggested answer
    Arvind Bharti Profile Picture
    495 on at
    Post invoice automatically from billing schedule
    Hi,
     
    See it has two key things.
     
    1. Transactions to be included in billing cycle which will come from above from and to date based on the schedule you have created 
     
    2. Billing date for those transactions : now this will be based on parameter you define in next tab. In case you leave this field blank in my view it will pick the date when that batch job will run but then it will consider bill start and end date from schedule. 
     
    Why don't you create invoice on last date of subscription? Why you want to delay for 5-6 days? any specifc reason? 
     
    Can you try using batch job for generate billing?
  • Adis Profile Picture
    5,113 Super User 2025 Season 1 on at
    Post invoice automatically from billing schedule
    Hi,
     
    Havent used this function but this is my input to this if it helps.
     
    First of all, have you tried using relative dates? And if yes, whats the outcome? 
     
    You can read up some syntax here:
    Keep in mind that it didnt work for me when I used (LessThanDate(7)), instead I used (LessThanDate(-7)), which filtered by all records that are older than 7 days from now.
     
    I am not sure how the dates in that dialog work in the background, however, keep in mind that no date means usually 1900-01-01, so the system wont find anything as there are no dates with 1900-01-01. Thats why I would put in a (relative) date.
     
    In your case, try the following:
     
    In invoice date put in: (Day(0)) - so it should set the invoice date for today, whenever the batch job runs.
    From & to date put in: (LessThanDate(-x)) - So if you want records that are older than 7 days, put in 7.
     
    Please try and give feedback.
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 565

#2
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2025 Season 1

Product updates

Dynamics 365 release plans