mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 5:12 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Point that Inventory is Physically posted
PostPosted: Tue Apr 17, 2012 8:31 pm 
Offline

Joined: Tue Mar 19, 2002 8:01 am
Posts: 206
Location: Vancouver
Country: Canada (ca)
Hi all,

Been using NAV for years but now working on my AX skill set.

I've configured the system to use the AIF framework to automatically export an XML file of the InventTrans record on Insert using the InventoryTransactionService AXD.

However what I have discovered is that even by creating a Adjustment Journal Line AX will generate an InventTrans record.

What I really need to do is generate the AIF export into the Queue when the physical inventory is posted either -Ve or +ve.

I've been working around the posting routines and looking at other tables including the InventSum, but am still a little lost as to the best place to put my AIF generation trigger.

Anyone happen to be able to recommend the best place to look at for placing this call?

many thanks

t


Top
 Profile  
 
 Post subject: Re: Point that Inventory is Physically posted
PostPosted: Sun Apr 22, 2012 12:56 pm 
Offline

Joined: Sun Feb 28, 2010 10:38 am
Posts: 11
Country: India (in)
Hi!

Unlike NAV wherein only posted entries are updated in ILE (Inventory ledger Entry) in AX even unposted lines are updated on Invent trans table as "order" type entries. NAV has multiple columns for the quantities to display.....in AX it creates multiple rows depending upon the transactions for the line item on source document.

Regards,

Sridhar


Top
 Profile E-mail  
 
 Post subject: Re: Point that Inventory is Physically posted
PostPosted: Mon Apr 23, 2012 7:05 pm 
Offline

Joined: Tue Mar 19, 2002 8:01 am
Posts: 206
Location: Vancouver
Country: Canada (ca)
Hey Sridhar,

Thanks for the reply.

I've already figured out that the InventTrans table gets populated before the actual inventory change takes place, what I was looking for was a "common" point in the system to which I could add on AIF generation code to export an XML file of that transaction.

I think you're reply has only reaffirmed what I had previously discovered.

So far the best I have is in the updatePhysicalIssue and updatePhysicalReceipt in the InventUpd_Phyiscal class.

After some testing it seems a pretty solid solution.. guess time will tell.

t


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: