3,027
Hi
In a report i have Purchase Receipt Header & Purchase Receipt Line . When i select No. filter in Purchase Receipt line list of items does not get displayed . How it can be done. Is it can be done in report itself.
Is it possible that in report Type = Item should be set as default in Purchase Receipt Line DataItem.
I have written below code but not working.
OnInit()
"Purch. Rcpt. Line".Type := "Purch. Rcpt. Line".Type :: 'Item';
Thanks
*This post is locked for comments
Hi
In Purch Rcpt Line Item has following table relation
IF (Type=CONST(G/L Account)) "G/L Account" ELSE IF (Type=CONST(Item)) Item ELSE IF (Type=CONST(Fixed Asset)) "Fixed Asset" ELSE IF (Type=CONST("Charge (Item)")) "Item Charge"
In report if user does not select Filter Type from Purch Receipt Line DataItem then when user selects Item No filter from Purch Rcpt Line DataItem no list of items is displayed. If user selects filter Type then accordingly list is displayed when user selects Item No.
Thanks
This is not possible. The dataitem in request page shows all the possible values.
Hi
It is a report . I want if on Request Page if user selects Purchase Receipt Line DataFilter Type then Item should be automatically displayed set as default when Request Page is loaded or user select Type Filter.
Thanks
Is this a report and you want to display lines with Type = Item? If so, you have to set a filter:
“Purch. Rcpt. Line”.SETRANGE(Type,“Purch. Rcpt. Line”.Type::Item).
If instead you want Type = Item set as default when creating a new line, in OnNewRecord set Rec.Type = Rec.Type::Item.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (