Deployment failure - Flow field where lookup table is a Custom table

[krhee1026]

I have created a FlowField on my Item card that I can't deploy

I added a lookup field to the Vendor table. This is looking up a list called "INCO Terms" which is a custom table to us. I wanted this field to flow through to the item card. The flowfilter is Vendor : No. :: Item : "Vendor No." . So the path is

"INCO Terms" (custom list) ------> "INCO Terms" field added to Vendor ----Flowfilter----> "INCO Terms" field on Item

When I try to deploy, I get the error below.

Deployment failed. Errors: App ID : 84c745c4-c596-4c1c-b218-8db5c5cd8702 Message : { Extension compilation failed TableExtensions/Item_TableExt.al(13,34): error AL0134: 'Lookup' is not recognized as a valid type TableExtensions/Item_TableExt.al(13,34): error AL0427: Field "INCOTerms" cannot be converted to type Code[20]. }

You can see from the screenshot that I was able to add a FlowField to the Item card for the existing field "Shipment Method Code" on the Vendor table.

[hougaard]

A "lookup" field is a field where you lookup stuff (like a customer No.) it's not a "FlowField Lookup" field, that's different thing.

I'm not 100% sure I get what you're trying to accomplish?

[krhee1026]

Thanks for responding Erick. I've got three tables:

INCOTerms (Table 70938806) Vendor Item

I created a new Lookup field on the Vendor table that looks at table 70938806 for it's list like so: @.***

That part is good. Now what I'd like to do is have the INCOTerms FIELD that is newly on the vendor table flow to an item. I tried to set that up like so:

@.***

When I try to publish the second thing is when I get the error in deployment.

[A black and white sign Description automatically generated with low confidence] Kevin Rhee @.**@.> T: 410-381-9000 ext.1711 C: 443-851-0610

[Text Description automatically generated]

From: Erik Hougaard @.> Sent: Wednesday, September 6, 2023 3:37 PM To: hougaard/Simple-Object-Designer @.> Cc: Kevin Rhee @.>; Author @.> Subject: Re: [hougaard/Simple-Object-Designer] Deployment failure - Flow field where lookup table is a Custom table (Issue #283)

A "lookup" field is a field where you lookup stuff (like a customer No.) it's not a "FlowField Lookup" field, that's different thing.

I'm not 100% sure I get what you're trying to accomplish?

- Reply to this email directly, view it on GitHubhttps://github.com/hougaard/Simple-Object-Designer/issues/283#issuecomment-1708981961, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BBZV72LEN2IBASEO44D2QCDXZDGHDANCNFSM6AAAAAA4N2F2PE. You are receiving this because you authored the thread.Message ID: @.***>

[hougaard]

Can't see the pictures when you just use the email reply, use the github page instead please :)

[krhee1026]

Thanks for responding Erick. I’ve got three tables:

INCOTerms (Table 70938806) Vendor Item

I created a new Lookup field on the Vendor table that looks at table 70938806 for it’s list like so:

That part is good. Now what I’d like to do is have the INCOTerms FIELD that is newly on the vendor table flow to an item. I tried to set that up like so:

When I try to publish the second thing is when I get the error in deployment.

[krhee1026]

Eric, I posted back on Github with the pictures

[hougaard]

Thanks, I'll try to replicate it tonight...