Find Cost Value in Inventory Transactions

schoolkid

Hi,

I face an issue and need help,

we have developed a new module in which we use items for the transactions and post them into Inventtrans Table.

In this case the Transaction is seen in the table, but I am unable to fetch the CostValue and also for the Inventory OhHand updates. Where as when a SalesOrder or a Profit/Loss Journal is posted it calculates a CostValue and Inventory OnHand. I want to fetch the COSTVALUE and deduct the ONHAND that is calculated as mentioned.

Any help would be great.

Thanks in advance

kranthi

Hi,

updating inventtrans only does not solve u r problem.

To calculate costprice the inventsum has to be updated.
and the respective finacial postings has to be done when u post the inventory transactions through code.
which is a bit complicated.

Really i didnot understand u r requirement of posting inventory transaction throughcode.

schoolkid

Hi Kranthi,

My requirement is that i will use the items in my tables and then post them,it has to deduct the items in the inventory on hand and calculate the costvalue just like how it calculates when a sales order is invoiced.

yes i am updating the InventTrans,InventSum and also the inventtransposting tables and also the ledgertrans tables.

I am able to insert my records and calculate them but i face the issue only when i try to calculate the CostValue for the Item
and insert it in the Table.

Thanks,

kranthi

Hi,

I propably suggest u to utilize the standard functionality available in ax.
example: Profit/Journal or Movement Journal.

If custamization is must u just observe the standard code used in above journal posting.