Re: [Axapta-Knowledge-Village] Job to Zero Out Inventory Cost

[Pooja .]

Hi all..,

existing (Ax 4.0)
Project - Projects- Item task - Purchase Order- create PO
post Purchase Order
post.Reciept List
post Packing Slip
stop posting invoicethen look at 
projects -Transactions -Itemthere are no Item transaction and 
voucher Transaction
But if post the Invoice ,then you can find the Item Transactions.


Requirement...
When we package slip post only ..item transaction,voucher transaction shuold be 
happan...
when we post Invoice ...Item transaction and voucher transaction should be 
updated (reverse and re-invoice)

Please give me guid lines to do this.

Pooja





From: Sumit Loya loya.su...@gmail.com
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Fri, 19 February, 2010 7:57:39 AM
Subject: Re: [Axapta-Knowledge-Village] Job to Zero Out Inventory Cost

  
Hi,

I think you should use counting or P  L journal for such scenarios.

Regards,
Sumit Loya


On Thu, Feb 18, 2010 at 10:09 AM, new_it_guy_ar anthony.mcchristian @pipelife- 
jetstream. com wrote:

  
We are running AX 3.0 SP6. We have recently decided to write off a number of 
items from our spare parts inventory. I have created a movement journal to 
zero out the cost for the inventory value and a temporary table that contains 
all of the item numbers that should be affected. I have created the job below 
to zero out the Inventory cost on the Price/Discount tab of the item. The job 
runs and shows activity but when I look at the items there is still a cost 
price. Any suggestions?

static void ItemWriteOff( Args _args)
{
InventTableModule inventTableModule;
TmpExcelData tmpExcelData;
;
while select tmpExcelData
{
ttsbegin;
select forupdate InventTableModule
where InventTableModule. ItemId == tmpExcelData. AccountNum 
InventTableModule. ModuleType == 1; 
if (InventTableModule)
{
inventtableModule. price = 0.00 ;

inventTableModule. update();
}
ttscommit;
}
}






  
__
Win 1 of 4 Sony home entertainment packs thanks to Yahoo!7.
Enter now: http://au.docs.yahoo.com/homepageset/

Re: [Axapta-Knowledge-Village] Job to Zero Out Inventory Cost

[Sumit Loya]

Hi,

I think you should use counting or P  L journal for such scenarios.

Regards,
Sumit Loya

On Thu, Feb 18, 2010 at 10:09 AM, new_it_guy_ar 
anthony.mcchrist...@pipelife-jetstream.com wrote:



 We are running AX 3.0 SP6. We have recently decided to write off a number
 of items from our spare parts inventory. I have created a movement journal
 to zero out the cost for the inventory value and a temporary table that
 contains all of the item numbers that should be affected. I have created the
 job below to zero out the Inventory cost on the Price/Discount tab of the
 item. The job runs and shows activity but when I look at the items there is
 still a cost price. Any suggestions?

 static void ItemWriteOff(Args _args)
 {
 InventTableModule inventTableModule;
 TmpExcelData tmpExcelData;
 ;
 while select tmpExcelData
 {
 ttsbegin;
 select forupdate InventTableModule
 where InventTableModule.ItemId == tmpExcelData.AccountNum 
 InventTableModule.ModuleType == 1;
 if (InventTableModule)
 {
 inventtableModule.price = 0.00 ;

 inventTableModule.update();
 }
 ttscommit;
 }
 }