Posting Date in Job Queue using Report Request Page of Report 297: Batch Post Sales Invoices

(0) Share

Report

Posted on by Nick Webb

891

Can the Posting Date be set to use the run date, (i.e.) it updates itself every day?

i typed Today into the Posting Date in the Request Page, and it changed itself to a literal: '27/01/2022'. So the Job Queue is only good for today. I want it to run once a day and use whatever today's date is as the Posting Date?

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Nick,

You will need to contact your Partner to setup a custom Job Queue that will update the Posting Date to Work Date as the days change and the Job Queue runs each day.

Thank you,

Steve

Was this reply helpful? Yes No
MarilynG 70 on at

Like (0)

Report

Hi Nick!

Any suggestion on how this job queue / codeunit should looks like?

Thanks!

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 968 on at

Like (0)

Report

You can extend the report 297 Batch Post Sales Invoices

Add extension to the report that will updated the posting date to Today and Replace the Posting date as True.

Create a Codeunit Subscriber

add below mentioned code

[EventSubscriber(ObjectType::Report, Report::"Batch Post Sales Invoices", 'OnAfterOnOpenPage', '', false, false)]
local procedure OnAfterOnOpenPage(var CalcInvDisc: Boolean; var ReplacePostingDate: Boolean; var ReplaceDocumentDate: Boolean; var PrintDoc: Boolean; var PrintDocVisible: Boolean; var PostingDateReq: Date)
begin
ReplacePostingDate := True;
PostingDateReq := Today;
end;

Above code will make the posting date to Today and replace it as well.

Was this reply helpful? Yes No
Nick Webb 891 on at

Like (0)

Report

The way I got round this was, instead of running the report straight from the job queue, I configured it to call a codeunit that I had created instead. This filtered the table to records with a Posting date of today and then executed the report with no requestpage. Hope this helps.

Was this reply helpful? Yes No
Verified answer

Marco Mels on at

Like (0)

Report

Thank you for sharing final answer! Great work!

Was this reply helpful? Yes No