Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

itemname function not recognizing field name

Posted on by Microsoft Employee

I am trying to use item name to get an item from a combo box. The combo box is a list of months abbreviated to the 3 letter form. What I am trying to do is pre populate this field with the current month. This is in the LinePre of a scrolling window. The error I get is that my field an Unknown Identifier.

Here's the code

    // '(L) PlanStartMonth' of window Compensation_Plan_Assignments = "JAN"; --- This I tried just to verify the name and reference work.
     RMC_StartMon of table RMCSC_RepPlanXref = itemname(field '(L) PlanStartMonth' of window Compensation_Plan_Assignments ,month(sysdate()); ---Here I set the table field from the name returned by the function. This part is not working.
    '(L) PlanStartMonth' of window Compensation_Plan_Assignments =  RMC_StartMon of table RMCSC_RepPlanXref  ; -- here I set the combobox value to the name returned previously.

If the function does not recognize the qualifier, is there another method to use the field? Or do I somehow have to locally create some sort of reference locally or get it from an SQL procedure? Is there another way to return what I want from dexterity directly.

*This post is locked for comments

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans