You’re offline. This is a read only version of the page.
Announcements
20
Hi,
I want to get transfer number column in the inventtrans table. Which table and field should I join in order to achieve this?
Thanks
As I told you in my first reply, the relation is stored in multiple tables with names starting with InventTransOriginTransfer. For example. threre is InventTransOriginTransfer. Depending on your business requirements, you need to select either one of them or all.
You can join them with InventTrans via InventTransOrigin fields.
Hi,
I want something like this.
select a.ITEMID,a.STATUSISSUE,a.QTY,b.TRANSFERID from InventTrans as a join "b table" on a."keyfield"=b."keyfield"
I need the "b" table name and keyfield to join both tables.
Thanks
I don't understand your new problem. I thought you already have InventTrans, therefore you already have StatusIssue column as well.
But I need the statusissue column also from inventtranstable
The relation is stored in InventTransOriginTransfer* tables. Rather then dealing with those tables by yourself, consider something this:
Share
Report
All responses (
Answers (
InventTransferLine transferLine = inventTrans.inventTransOrigin.originator() as InventTransferLine;
if (transferLine)
{
info(transferLine.TransferId);
}
#1
André Arnaud de Cal...
294,099
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
