thanks joe... for ur valuable reply... ya ur right i am now getting the both purchase price....
with regards kishore --- In Axapta-Knowledge-Village@yahoogroups.com, "joeinvcost" <jfv...@...> wrote: > > Kishore, > I'm not sure I completely understand your issue, but it sounds like you're > trying to retrieve both the sales price and purch price from > InventTableModule using the same join. If that's true, the problem is that > the same Price field is used for Invent, Purch and Sales price and you need > to join on ModuleType for each. Purchase is moduletype=1, Sales is > moduletype=2. I hope this helps. > > Joe > --- In Axapta-Knowledge-Village@yahoogroups.com, "kishore_jyoth" > <kishore_jyoth@> wrote: > > > > I have a Issue on Report > > I want to display the purchase price and date of purchase. Here the issue > > is no purch table has not there in datadictonary. which dat purch table > > taking the datasource of InventtableModule table which is named as purch > > table and innerjoin to inventtable. > > so > > when checking the purchase price check box the the price of sales is > > automatically update with profit by entering the purchase price. here i am > > geting sales price... but purchase price not getting... how slove this > > issue please suggetion as early as possible...... > > > > > > > > thanks > > kishore > > >