Finance | Project Operations, Human Resources, ...

How to get transferid in inventtrans table

(0) Share

Report

Posted on by prashanthr

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

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Martin Dráb 239,381 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
The relation is stored in InventTransOriginTransfer* tables. Rather then dealing with those tables by yourself, consider something this:

InventTransferLine transferLine = inventTrans.inventTransOrigin.originator() as InventTransferLine; if (transferLine) { info(transferLine.TransferId); }

Was this reply helpful? Yes No
prashanthr 20 on at

Like (0)

Report
Copy link

Link copied!

But I need the statusissue column also from inventtranstable

Was this reply helpful? Yes No
Martin Dráb 239,381 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I don't understand your new problem. I thought you already have InventTrans, therefore you already have StatusIssue column as well.

Was this reply helpful? Yes No
prashanthr 20 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,381 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No