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
Hi Mohana
thank you so much for you reply your very great. i got a solution
once again thank you
Customer.SETRANGE("No.","Global Dimension 1 Code");
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
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.
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?
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (