web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Product receipt drive ...
Microsoft Dynamics AX (Archived)

Product receipt drive inventory aging. Is there a way to use Transfer of Ownership Date to drive Inventory Aging?

(0) ShareShare
ReportReport
Posted on by lmai 2,438

Hi All, 
I realized that the Product receipt date drives Inventory Aging.  I posted the product receipt today.  Run the Inventory Aging today and it shows the inventory is 1-day old which is correct.  In reality, I have the ownership of this inventory last month.  So I want to use the Ownership date to drive inventory aging date.  The problem is, the last month's accounting is closed.  I don't want to post the actual product receipt date into last month's book.  This is due to sea shipment which takes months to get to US.  I only want to drive the inventory aging date.  Have you seen a situation like this?  If so, how did you solve the problem?  Thanks



Now it sits in my Inventory Aging report as 1 day old:

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    I have seen companies using temporary warehouses denominated 'ship' or 'in tranport from...' to register and post the packing slip in order to record when ownership changes. By doing that, your inventory aging report should be ok. Is that an option for you?

    Best regards,

    Ludwig

  • lmai Profile Picture
    lmai 2,438 on at

    I can test that to see if it drives inventory aging date.  Thanks for your feedback.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Kim,

    Has your test worked out for you?

    Best regards,

    Ludwig

  • lmai Profile Picture
    lmai 2,438 on at

    No, Ludwig.  Thanks for checking in.  Perhaps I'm not doing it right.  Could you share screenshots...if possible?  

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    The workaround here is using a specific warehouse (e.g. 'Vessel') when posting the product receipt in order to track the time the ownership changed.

    1157.po.png

    Once the items actually arrive in your warehouse you can then use a transfer journal to shift the items from the warehouse 'Vessel' to your ordinary warehouses.

    Hope that answers your question.

    Best regards,

    Ludwig

  • lmai Profile Picture
    lmai 2,438 on at

    Ludwig, it was quick!  :-)  I'll test it.   Thank you!

  • lmai Profile Picture
    lmai 2,438 on at

    Hi Ludwig,

    Just tested it.  The set back on using inventory journal is missing amount field.  I need to transfer the amount as well.  :-(

    I would think if I don't do the amount transfer, the traceback and/or reconciliation may harder later.

    Thanks

  • Konrad U Profile Picture
    Konrad U 804 on at

    Hi Kim!

    We heavily track inventory aging aka slow moving inventory on both non serial and serial inventory. On serial inventory we have added a date of production that captures the date of manufacture. In our multi-warehouse multi-company setup the date of receipt does allow the serial to be tracked out to the distributor. And of course if you have clever enough users they transfer stuff around to restart the aging clock. Other enhancement we have made flatten sales history across all companies and item balance which records inventory flow for each month of the fiscal year (beginning balance, production, purchase, scrap, returns, sales, consumption, ending balance, plus max and min inventory for the month).

    So yes moving stuff should work.

    Konrad

  • lmai Profile Picture
    lmai 2,438 on at

    Thanks, Konrad, for your feedback.  

    Sorry, I'm not cleared on what you are saying.  We purchase products from the vendor.  At the point of posting product receipt, the system calculates inventory aging.  The production would be days later.  Some of our products or raw material we purchase go into production.  Others  don't.  So we want to calculate inventory aging at the point of transfer ownership rather than at the point of the actual product receipts.

  • Konrad U Profile Picture
    Konrad U 804 on at

    Maybe I misunderstood. We are multi-company, multi-warehouse with products moving all over. When they go across a company or to a new location they start as if new to the company etc. To us that is transfer of ownership.  If you go by the more strict accounting of when the inventory is paid for or invoiced you probably need to age based on the date financial in the inventory transaction.  In our case the two date physical and financial are close enough so there is no real quantitative difference.

    We have our own reports for aging given the serialized nature of our product and the complication of credit returns.

    As far as high dollar raw material we usually draw from our vendors as needed so there is no real raw material aging report there.  

    If the system report uses the date physical it might be easy to change it to use the date financial.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans