Share
Report
47Afternoon All,
I am trying to assign a customer to an item, i have added the table extensions and page extension however how do i get this to transfer to the sales lines so that we can use this to filter the items based on customer or is there another way to do this.
I have added the extension to the sales lines table however the boxes are there but they are not transffering from the item page to this.
the end use for this is to have a list that is filterable by customer for the items as this is how we operate as a business as we dont sell the items we provide a service on them.
I have tried the below which didnt work as this was on the microsoft help but wasn't much help!
tableextension 60100 CustomerParts extends Item
{
fields
{
field(60100; /Customer Name/; Text[200])
{
Caption = 'Customer Name';
FieldClass = FlowField;
CalcFormula = lookup(Customer.Name where(/No./ = field(CustomerNo)));
}
field(60101; CustomerNo; code[20])
{
Caption = 'Customer No';
TableRelation = Customer;
trigger OnValidate()
begin
CalcFields(/Customer Name/);
end;
}
}
local procedure CopyFields()
var
dt: DataTransfer;
dest: Record /Sales Line/;
src: Record Item;
begin
dt.SetTables(Database::Item, Database::/Sales Line/);
dt.AddFieldValue(src.FieldNo(CustomerNo), dest.FieldNo(CustomerNo));
dt.AddSourceFilter(src.FieldNo(CustomerNo), '=%1', 'A');
dt.CopyFields();
end;
}
All responses (
Answers (
