Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sam Clark]

Hello All,

Is there a way to get a number of days supply report from AX?

Thanks,

Sam

——————————
Sam Clark
Business Systems Analyst
Team Technologies
Morristown TN
——————————

[Andrew Lencsak]

Hi Sam, I’ve had a few other clients ask for this type of report. We usually create a custom one just because AX doesn’t necessarily look at inventory that way. You can use things like Safety stock calculation and the Net requirements screen to view your average usage or how long your inventory will last based on open transactions but I would say typically create a custom report. Here’s a quick dissection of something I told one of my clients to use to create such a report:

“Opening balance in Net requirements is equal to on-hand:

You should be able to get on-hand from the InventSum table, using the (InventSum).PhysicalInvent field.

Receipts and Issue you can get from ReqTrans:

That should have a direction (receipt, issue), quantity, and date and should be Reftype of stuff like Purchase order, sales order, BOM line, etc. we may need to look together. Those two columns should not include reftype of “planned * order,” those will be in the Planned order column.

Then the closing is just the expected inventory taking on hand plus receipts and planned orders and minus the issues to be a figure of the expected on hand at that date.”

Hope that helps!!

 

 

——————————
Andrew Lencsak
Senior Application Consultant
eBECS
Atlanta GA
——————————
——————————————-

[Sam Clark]

Thanks Andrew!

I’ll try it. 🙂

Sam

——————————
Sam Clark
Business Systems Analyst
Team Technologies
Morristown TN
——————————
——————————————-