Announcements
No record found.
Hi
I have below code . I want Integer value
IF Customer.GETFILTER("Customer Posting Group") <>'' THEN CPG := Customer.GETFILTER("Customer Posting Group")ELSE CPG := '';
Thanks
*This post is locked for comments
IF Customer.GETFILTER("Customer Posting Group") <>'' THEN
EVALUATE(CPG, Customer.GETFILTER("Customer Posting Group"))
ELSE
CPG := 0;
I am getting below erroe
The Value 'DEB-DE' cannot be evaluated to type Integer
I thought that names of Customer Posting Groups are digits-only. So what do you want to transform into integer?
How come you can take this DEB-DE into an Integer??
In Customer Posting Group it shows like Domestic,Export. I want Index value
IF Customer.GETFILTER("Customer Posting Group") <>'' THEN BEGIN CustomerPostingGroup.GET(Customer.GETFILTER("Customer Posting Group")); CPG := CustomerPostingGroup.<YourOptionFieldWithIndex>; END ELSE CPG := 0;
where CustomerPostingGroup is record 92. I don't have any option fields there - so it should be a customization. Option converts to integer directly without EVALUATE.
It's not a Option Type, so you cant convert it into an integer.
P.S - Option returns integer only.
It has Code DataType. In a report when User selects filter Customer Posting Group from Customer table then list of Posting Groups is displayed. Can we get its Index value or not.
You can get the real value of the posting groups but not in integers obviously.
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!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
