When we create a project invoice proposals with billing rules we will pass the constant start date, end date and invoice date.
When running this in recurrence batch mode on daily basis the system checks for the same dates which we supplied on the parameters for all days.
if we try to use (DayRange(-30,0)) in query range against Project date but it is not getting filtered out.
if we try to pass future date in start date and end date field it is throwing an error “End date cannot be later than current date of legal entity's time zone.”
as per the limitation of our product we cannot run this in recurrence batch mode.
The idea is to provide a feasibility to supply dynamic values for start date, end date and invoice date so that invoice and other dates will get updated regularly if it was running in recurrence batch mode.
Comments
Just adding to this Idea: It is important to us to have all date values dynamically supplied that way they are updated each time the batch run. You could potentially have a drop down to chosen the different variations:Invoice date = Batch dateInvoice date = Calculated day range - date range could range from one month prior to one month later - this way if they want to raise proposal on the 1st of the month but will be sent out with the invoice date as the last date of the month 30th/31st or could be the last date of the prior period. Invoice date = Today's date
Category: Project Accounting