Form InventOnhandItem and display modifier by two datasources

(0) Share

Report

Posted on by Lauras U

961

Hello

There is a form InventOnhandItem. I want to display info of InventSerial.ProdDate into grid of InventOnhandItem. Normaly i would use display method modifier on one of the InventOnhandItem Data Sources (InventSum or InventDim) but InventSerial relation needs InventSum.itemId and InventDim.InventSerialId.It is imposible to find InventSerial record using simple display modifier like this:

display InventSerialProdDate prodDate (inventSum _invSum)

or this

display InventSerialProdDate prodDate (InventDim _invDim)

Because I need both _invSum.itemId and _invDim.inventserialId. From InventDim_DS i cannot see current InventSum.ItemID or from InventSum_DS I cannot see InventDim.InventSerialId. I tried looking at InventDimCtrl_Frm_OnHand class with no luck :(

So what could be the solution to display InventSerial.ProdDate into InventOnhandItem form`s grid joining by InventSum.ItemId and inventDim.InventSerialId

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Lauras U 961 on at

Like
a
(0)

Report
Copy link

Link copied!

Bump. Anyone? I don`t have a working solution yet :(

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Vukis,

Why can't you write a display method? You can get to inventDim from InventSum datasource by using the InventSum_DS.inventDim() method.

Was this reply helpful? Yes No
Lauras U 961 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kent,

Your suggestion works only when record becomes active. But after selecting another record date disapears. By the way I`m talking about opening InventOnhandItem for all items not for specific item.

Was this reply helpful? Yes No
Amir Nazim 5,994 on at

Like
a
(0)

Report
Copy link

Link copied!

i also had the similar requirements, i created the display method on the InventSum table, i need to show the some field from ConfigTable table.

ConfigTable( this.itemId, InventDim::find(this.inventDimId).ConfigId).someField.

Was this reply helpful? Yes No
Lauras U 961 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Amir, but it didn`t worked. I created display method directly on table, but this.inventDimId is empty. Are you sure you had your requirements on same form? Does the form had sums by inventdimParms?

Was this reply helpful? Yes No
Verified answer

Lauras U 961 on at

Like
a
(2)

Report
Copy link

Link copied!

Found solution myself. I used xrecord.joinChild();

So the full solution:

display InventSerialProdDate prodDate (inventSum _invSum)

InventDim invDim;

;

invDim = _inventSum.joinChild();

return InventSerial::find(invDim.inventSerialId,_inventSum.ItemId).ProdDate;

Was this reply helpful? Yes No
Ahmad Zbeeb 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot vukis, worked like a charm, this kept me dizzy for a while now

Was this reply helpful? Yes No
Brandon Wiese 17,790 on at

Like
a
(1)

Report
Copy link

Link copied!

The reason that you can't just use inventSum.inventDim() or any variation on inventSum.inventDimId is because the InventOnhandItem form presents records that are grouped on fields like ItemId and various inventory dimensions. When queries returned grouped results, only those fields which are grouped BY or aggregated have values, and InventDimId is not one of those fields (nor can it be) and so it is blank.

Thus, using inventSum.joinChild() reveals the InventDim record that is associated with the InventSum record from the same query, and contains the needed InventLocationId, WMSLocationId, etc., and specifically in this case InventSerialId (if it is being grouped on).

Was this reply helpful? Yes No
Lam Tran 500 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi VUKIS,

great post!Thanks

Lam Tran,

Was this reply helpful? Yes No
Samy123 455 on at

Like
a
(0)

Report
Copy link

Link copied!

Brandon. I don't have much luck in my case:

In my situation I need to display a field from InventItemLocation on the InventOnHandItem grid the InventItemLocation find method requires itemId AND InventDimId as parameters. I see there are both ItemId and InventDimId in InventSum datasource but InventDimId always blank. I tried to pass invDim.InventDimId as suggested above using joinChild() method but no luck it is always null or empty.

Any suggestions ?

Was this reply helpful? Yes No