Small and medium business | Business Central, N...

Re: Cash Receipt Journal: Using SetRange for dynamic Journal Template Name.

(1) Share

Report

Posted on by CU25111417-0

Hi,

I have used SetRange in the Cash Receipt Journal for the Journal Template Name. I need to know how to set a dynamic SetRange for the Journal Template Name. Below is the code I have used

Note: GenJournalBatch.SetRange("Journal Template Name", 'CASHRECEPT');

'CASHRECEPT' _ I need this name to have a dynamic value

For Exapmle;

trigger OnLookup(var Text: Text): Boolean
var
GenJournalBatch: Record "Gen. Journal Batch";
begin
GenJournalBatch.Reset();
GenJournalBatch.SetRange("Journal Template Name", 'CASHRECEPT');
if PAGE.RunModal(Page::"General Journal Batches", GenJournalBatch) = ACTION::LookupOK then begin
Rec."Batch ID" := GenJournalBatch.Name;
end;

end;

Thank You ,

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Re: Cash Receipt Journal: Using SetRange for dynamic Journal Template Name.

This requirement looks the same as the Batches button on the General Journal Template, which will open the Batches corresponding to the Journal Template Name.

Hope this can give you some hints.

Thanks.

ZHU
Suggested answer

Yi Yong 1,470 Super User 2024 Season 2 on at

Like (0)

Report

Re: Cash Receipt Journal: Using SetRange for dynamic Journal Template Name.

Hello,

You can create a var text and then GenJournalBatch.SetRange("Journal Template Name", TextVar);
Suggested answer

Saif Ali Sabri 370 on at

Like (0)

Report
Re: Cash Receipt Journal: Using SetRange for dynamic Journal Template Name.

My response was crafted with AI assistance, tailored to provide detailed and actionable guidance for your query.

To make the SetRange value for the "Journal Template Name" dynamic, you can replace the hardcoded value 'CASHRECEPT' with a variable. This allows you to pass the dynamic value to the SetRange at runtime. Here's how you can modify your code:

Modified Code:

al

trigger OnLookup(var Text: Text): Boolean var GenJournalBatch: Record "Gen. Journal Batch"; JournalTemplateName: Text; // Define a variable to hold the dynamic template name begin // Set the dynamic value for JournalTemplateName JournalTemplateName := 'CASHRECEPT'; // Replace this with logic to assign the dynamic value GenJournalBatch.Reset(); GenJournalBatch.SetRange("Journal Template Name", JournalTemplateName); // Use the variable here if PAGE.RunModal(Page::"General Journal Batches", GenJournalBatch) = ACTION::LookupOK then begin Rec."Batch ID" := GenJournalBatch.Name; end; end;

Explanation:

Dynamic Value: The JournalTemplateName variable is introduced to store the dynamic value for the journal template name.

You can assign this variable any value based on your application's context, such as user input, a configuration record, or another field in your page.

SetRange with Variable: Instead of hardcoding 'CASHRECEPT', the variable JournalTemplateName is passed to the SetRange method. This allows you to dynamically filter the records based on runtime conditions.

Logic for Dynamic Value: Replace the JournalTemplateName := 'CASHRECEPT'; line with your logic to determine the dynamic value for the journal template name, for example:

Retrieve the value from a field in the current record.

Fetch the value from a setup table or user preferences.

Example for Dynamic Assignment:

If the value is based on a setup table, you can do something like this:

al

var GeneralJournalSetup: Record "General Journal Setup"; begin if GeneralJournalSetup.Get() then JournalTemplateName := GeneralJournalSetup."Default Journal Template Name" else Error('General Journal Setup is not configured.'); end;

By making the JournalTemplateName dynamic, the code becomes flexible and reusable for different scenarios.