How to display Vendor No. on Lot No Information Card

(0) Share

Report

Posted on by ERPlatanos

Hi all,

I have created an extension page for the Lot No Information card and added a new field to the card for Vendor No.

Lot No Info Card does not have vendor on its table so I need to retrieve it elsewhere. My thought process was use the Lot Info No record to get the associated Item, then use the items table to find the correlated vendor.

I have already attempted to create a record variable to hold the item record, which I would then use to retrieve the Vendor No. but I am stuck trying to figure out the proper methods or functions

All responses (10)

Answers (1)

ERPlatanos 67 on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Daniele,

Splendid! That worked! I appreciate your help on this.
Verified answer

DAnny3211 9,274 Moderator on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Hi

Excuse me

it was my mistake of distraction

this is the correct code:

field(50100; vendorid; Code[20])

{

Caption = 'vendorid';

FieldClass=FlowField;

CalcFormula=lookup(Item. "Vendor No." where ("No."=field("Item No.")));

}

check my answer if it helped you, thanks

DAniele
ERPlatanos 67 on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Daniele,

There is a vendor value for the item
Suggested answer

DAnny3211 9,274 Moderator on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

hi

I know I may seem obvious

but have you checked that the vendor is not valued for that item?

DAniele
ERPlatanos 67 on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Daniele,

I appreciate your help so far. I updated the table extension to the code you provided...

However, I'm still not seeing anything in the VendorID field..

Is there an issue with my page extension code here as well? You can see I have a breakpoint set here, but no breakpoints are getting hit at all in the debugger now. They used to, but I have no idea what changed.
Suggested answer

DAnny3211 9,274 Moderator on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Hi

then you only need to do this

create a flowfield in join between the lot information and the item with the Item No. field of the item = the Item No. field of the Lot information

and then show it on the page card

tableextension 50100 LotNo extends "Lot No. Information"

{

fields

{

field(50100; VendorID; Code[20])

{

Caption = 'VendorID';

FieldClass=FlowField;

TableRelation=item."Vendor No." where ("No."=field("Item No."))

}

}

}

check my answer if it helped you, thanks

DANiele
Suggested answer

YUN ZHU 77,981 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Hi, you should use FlowField (Lookup).

https://yzhums.com/5802/

TableRelations is valid when selecting data, and does not automatically bring the value.

For example,

https://yzhums.com/22220/

Hope this helps.

Thanks.

ZHU
ERPlatanos 67 on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

I found TableRelations are available for this type of process, however I'm unsure still how to find the Vendor ID from the connected Item table.

I have the following for my table extension...

My logic: connect the "Lot No Info" table and "Item" table by item no, then use the relationship to grab Vendor number from Item table to display on the page as "VendorId"...

As a result, nothing shows in the field in BC...
ERPlatanos 67 on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Danny,

To clarify, on the Lot No Info Card Page, I want a custom field to show the Vendor Number associated with the item used for the Lot No Info Card.

Items cards can have a vendor associated with them, like so...

Please disregard the methods I have already tried following the OnAfterGetRecord() trigger. I am new to development and trying everything available that seems logical. Documentation seriously lacks IMO for fairly simple tasks.

My thought process was to retrieve the item record from the available item number on the Lot No Info Card. Once I have the item record, I should be able to grab the vendor ID from that record, and set it to a variable for me to use in the custom field.

Does that thought process make sense?
Suggested answer

DAnny3211 9,274 Moderator on at

Like (0)

Report

RE: How to display Vendor No. on Lot No Information Card

Hi

I don't understand what exactly you want to retrieve?
do you need the item no?
haven't you already entered it in a custom field?

it's not very clear what you want to achieve

why do you call it VendorID if it's the Item No