Announcements
No record found.
hi friends,
i want to set filter against customer no and cost center code using CAL code and want to get the customer based on cost center code in nav 2016
thanks & regards,
ashwni
*This post is locked for comments
do you want to show customers based on cost center field in page you mentioned. I cant see cost center field.
you need to write code in OnLookup trigger of Customer No field
Hi mohana
thank you for reply
i have used this code on account no field
IF "Account Type" = "Gen. Journal Line"."Account Type"::Customer THEN BEGIN
Customer.SETRANGE("No.","Global Dimension 1 Code"); but i did get pls give any solution.
thank you
Customer.SETRANGE("No.","Global Dimension 1 Code");
what value do you have in "Global Dimension 1 Code" of selected line? is it customer No?
Global dimension code having lot of cities like (Chennai Bangalore and Madurai) if i choose Chennai i need to show Chennai customers this my requirement mam i dont know how put filters against customer.
You are setting filter on Customer No with city code
like you are searching for Chennai in Customer no field.
you need to set filter on City name of customer table like
Customer.SETRANGE(City,"Global Dimension 1 Code");
you need to run page with above filters like
CustPage.SETTABLEVIEW(Customer);
CustPage.SETRECORD(Customer);
CustPage.LOOKUPMODE(TRUE);
IF CustPage.RUNMODAL = ACTION::LookupOK THEN BEGIN
VALIDATE("Account No.",Customer."No.");
END;
I didnt test code
Hi Mohana
thank you so much for you reply your very great. i got a solution
once again thank you
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
