Supply chain | Supply Chain Management, Commerce

How to add manufacturing date column to on-hand list.

(0) Share

Report

Posted on by Marcov

I would like to have the aging date of my batches from the on-hand list screen because that screen is what we use to monitor our inventory. I know we can use the shelf life as of date screen but this can be time consuming, especially when we almost always have the on-hand list open. Is it possible to add the date to the on-hand list and even the physical on-hand screen?

thanks.

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi Marcov,

Are you using D365 manufacturing module in your business?

Can you please clarify, What do you mean by time consuming and on hand list open?

Inventory batch contains critical information and we already have shelf time management with expiration date and everything so i don't suggest doing any customization on inventory on hand screen/batch information because that could seriously impact your inventory information.

Was this reply helpful? Yes No
jannawangD365 on at

Like (0)

Report

Hi Marcov,

Have you try the personalization functionality to add the column?

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi Marcov,

Did they help you fixing your problem or do you need any additional information/help? Please share updates with us.

Was this reply helpful? Yes No
Marcov 35 on at

Like (0)

Report

Our warehouse receives and ships pallets of product daily and most of our items don't last more than 2 weeks in our inventory with many lasting only a few days. we ship using a fifo strategy and we monitor our inventory through either the on hand list or the physical on hand inventory screen. the only thing missing from the on hand list is the ability to see the aging date on the batches in our on-hand list. we have to open a separate window to open the shelf life as of date and then change the date to some point in the future, then refresh and wait for the screen to load. the shelf life as of date has only 1 column that i need, it would be a great benefit for us to be able to see a column with the date of arrival in the on- hand list or on the physical on-hand inventory screens.

Was this reply helpful? Yes No
Marcov 35 on at

Like (0)

Report

Yes but i dont have a column that provides the information i need, namely to see the date or arrival/receipt/manufacturing of item batches

Was this reply helpful? Yes No
jannawangD365 on at

Like (0)

Report

hi Marcov,

Have you try to add the join table on the inventbatch table?

Was this reply helpful? Yes No
Aparisi82 2,188 on at

Like (0)

Report

Hello , I believe there is a little bit of confusion in here.

You are mentioning the manufacturing date which is when the batch number is produced and the shelf life which is the number of days to that batch to expire from manufacturing date so I believe you mean the expiry date or best before date.

If you need the manufacturing date , you can revise your batch number policy and use the batch number group with physical date ticked and the date which means your batch number will contain ,within the batch number , when the batch has been generated and ,thus, when looking at on hand on screen you will be able to filter based on manufacturing date.

If you need the expiry date ( or BBD) and it is not available on the ADD field option that is a customisation

Generally speaking , it would be a better idea to create a report of the stock on hand where you calculate for each batch the product life remaning for each batch.

Last but not least , if you are using the advanced warehouse functionality , you can generate picking work based on FIFO or even better FEFO so actually the system picks the stock in the right priority without you assessing any report or stock on hand.

Was this reply helpful? Yes No
Suggested answer

Kiran Waghmare 35 on at

Like (0)

Report

Instead you can use the standard available inquiry form in D365, which is available at Inventory management> Inquiries and reports> Batches> Shelf life as of date

Wherein user can get the Item number, Description, Batch number, Manufacturing date, Physical inventory, Available inventory etc.

Was this reply helpful? Yes No