Hi , In Axapta, the cost price is base on your model. Standard or Non Standard.
The cost price of standard cost can be retrieve on the Item Master (InventTableModule table, ModuleType = Invent) But if you are running FIFO or LIFO or Avg... then you should check the table InventSum, InventDim. These table contain data of inventory on-hand and cost price. Hope this help. Khue ----- Original Message ---- From: Faiqa Khushi <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, June 8, 2007 7:38:25 PM Subject: RE: [Axapta-Knowledge-Village] Cost Price I think you have not marked inventory>>Item Setup tab(Latest Cost Price check box) or using dimension cost prices. Also check inventDimCombinatio n table. AX keeps the record in different tables , I could not figure out on which form you are exactly looking for the item cost. Anyhow you can get the relevant table by right click the form >>Setup>>Query Tab. Regards, Faiqa From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of setiaji Sent: Friday, June 08, 2007 8:33 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: [Axapta-Knowledge- Village] Cost Price I have check InventTableModule table for Purchase,Sales, and Cost Price. But there is only empty value. I have check Item who have Sales Order and Production Order. I see via Transaction, and On Hand. In On Hand, i see value Cost Price, but there is nothing in InventTableModule for that item. Is there a class, handling cost price that i can use for count cost price? - setiaji - Faiqa Khushi wrote: > > You can get purchase, sales and cost price from InventTableModule table. > > Regards, > > Faiqa > [Non-text portions of this message have been removed] ____________________________________________________________________________________ Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html [Non-text portions of this message have been removed]
