Diaplay Alternative Item Id

Hi Friends,
I created some records in InventTable like
ItemId AltItemID(OtherTab) Use(OtherTab) Click the OnhandButton in Inventtable
See the Available Physical
Car1 Car2 Nothing In Inventory Car1 Item id Ava.Phy is 250
Car2 Car3 Nothing In Inventory Car2 Item id Ava.Phy is 1000
Car3 Car4 Nothing In Inventory Car3 Item id Ava.Phy is 500
Car4 Car5 Nothing In Inventory Car4 Item id Ava.Phy is 600
Car5 Car6 Nothing In Inventory Car5 Item id Ava.Phy is 450
And so on……………….And then I saved these Records in InventTable.
After that I am creating a record in SalesTableèSalesLineèLines TabèCtrl+N
Here I am Choosing
ItemNumber as
Car1
Then I am clicking a button(Newly Created button on SalesTable)on this form .I want to open a NewForm. In this NewForm I want to display Alternative itemids like this…
AltItemID Available Physical
Car2 Car2 Item id Ava.Phy is 1000
Car3 Car3 Item id Ava.Phy is 500
Car4 Car4 Item id Ava.Phy is 600
Car5 Car5 Item id Ava.Phy is 450
Car6 nothing in available Physical for this altitemid
For example:
Case: In sales Table–>lines Tab–>ctrl+N
item id
choose–>car1 -->click the button–>open new form–>i want to disply the following records.
AltItemID Available Physical
Car2 Car2 Item id Ava.Phy is 1000
Car3 Car3 Item id Ava.Phy is 500
Car4 Car4 Item id Ava.Phy is 600
Car5 Car5 Item id Ava.Phy is 450
Car6 nothing in available Physical for this altitemid
Case: In sales Table–>lines Tab–>ctrl+N
item id
choose–>car1 -->click the button–>open new form–>In this NewForm I am able to display only one record i.e; car2.
AltItemID Available Physical
Car2 nothing I am geeting here
Please help me to resolve this Problem.
Your help is greatly appreciated.

Hi,

still i dint get any kind reply for you Guys…

Plz Help Me

Regards

Hi,

I would like to request to you.

Please read the issue…

Help Me

Hello there!

Am I getting your prolem right? that you are not seeing the items you made on the item master data when you create a sales order?

Hi Prasad,

Try to pass the alternate itemid of car1 and find its alternative itemid.

just lik,

code loops based on condition if needed

tablename.alternativeitemid = Inventtable::find(salesline.itemid).alternativeitemid;

tablename.alternativeitemid = Inventtable::find(tablename.alternativeitemid).alternativeitemid;

Regards,

S.Kuppusamy

What is your logic to show the Available Physical???

A item can have only one alternative item - So it is showing only one item car 2 which is an alternative item for the selected sales item - Car1

Remember the Car3 is an alternative item for car2 and not for car1.

Based on the your alternative item setup the system will pick up the available alternative item automatically if the Sales Item is unavailable.

Let me understand your requirement - what final output you are expecting in the system???

In sales Table–>lines Tab–>ctrl+N

item id

choose–>car1 -->click the new button–>open new form–>i want to display the following records.

wt ever the record we r selecting in IN sales line ItemID.

In Invent Table ->if this Item id hav altItemID. we have to take that record.

then that AltItemId (ItemID) if have any AltItemID we have get in this way we hv to get altItemIDs

AltItemID

Car2

Car3

Car4

Car5

Car6