Hello, On the item Bin Contents I've created two new fields, Sell-to Customer Name and Item Description. I'm trying to retreive these from the Item Card.
My assumption was
recItem.GET(recItem."No.");
"Sell-to Customer Name" := recItem."Sell-to Customer Name";
Would work but it doesn't? What should I change
*This post is locked for comments
You need to read some help regarding using GET function.
how to you get customer record with Item No?
recCustomer.GET("Item No.")
Thank you again. I Have the Sell to Customer No and item Description populating However I realise I need to get the Sell-to Customer Name from the Customer table. I Attempted to create a flowfield for this
Lookup(Customer.Name WHERE (Name=FIELD(Sell-to Customer Name)))
And wrote
IF recCustomer.GET("Item No.") THEN BEGIN
"Sell-to Customer Name" := recCustomer.Name;
END;
But It errors and the page doesn't load, what should I alter?
You have to write something like:
IF recItem.GET("Item No.") THEN BEGIN
"Item Description" := recItem.Description;
"Sell-to Customer Name" := recItem."Sell-to Customer Name";
END;
Note: Here "Item No" is a Bin Contents Filed
Hi Thank you, I've attempted to create a flowfield
However now when I go into the Item Bin Contents Page I get this error
As Mohana suggested you need to have those field on the source table from there you can show the values on target table
Check the fields and relationship between two tables.
you can also create flow fields in Bin Contents table
do you have Sell-to Customer Name field in Item table?
recItem.GET(<use item field from Bin Content record>);
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156