Sales picking in warehousing

(0) Share

Report

Posted on by Anurag Nagarkoti

180

Hello everyone,

I am trying to find the best way to pick the items for sales orders in warehousing. I have assigned fixed locations for the items.

Suppose items A exists in 3 locations: LOC-01, LOC-02, LOC-3. All these locations exists in the same warehouse.

Item A was purchased on 07/06/18, and the put away was created for LOC-2.
Item A was purchased on 09/06/18, and the put away was created for LOC-3.
Item A was purchased on 12/06/18, and the put away was created for LOC-1.

My requirement is to pick the items, according to the date. The items which were purchased first should be sold first. (FIFO)

So, in the above scenario, Item A will be picked from LOC-2 first, then LOC-3, then LOC-1.

How to achieve this functionality in AX?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi,

I was going to say that, unless you were using the Batch dimension, you can't. But then I did a quick test.

If you have a non-Batch item, and no special setup on the Item model group, then AX will reserve inventory in Location ID order.

But if you tick FIFO date-controlled on the Item model group, it behaves differently. For example in the scenario you give, it behaves exactly as you describe. However, if, for example, LOC-2 contains the receipt from the 7th and then a fourth receipt from the 15th, AX will reserve LOC-2 last, not first.

So, for the ultimate solution, I think you should consider using the Batch dimension. If you can't use Batch, for something close, but not perfect, test the FIFO date-controlled parameter.

That parameter is describe a bit here (but is referred to simply as Date-controlled).

technet.microsoft.com/.../aa571170.aspx

Was this reply helpful? Yes No
Anurag Nagarkoti 180 on at

Like (0)

Report

Hi,

I tried to enable the FIFO date-controlled checkbox on the Item model group, but it gives the below error:

One or more items associated with this Item model group are controlled by processes defined for warehouse management and the use of reservation hierarchy. FIFO date-controlled reservations will not be used for these items.

I am using advance warehousing for sales picking.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Right. That's pretty crucial information! And what is your view on using the Batch dimension?

Was this reply helpful? Yes No
Anurag Nagarkoti 180 on at

Like (0)

Report

Hi Guy,

I don't want to use the Batch dimension because it is not implemented in our business.

And even if I use the batch dimension, AX won't allow me to use FIFO date-controlled reservation when I am using warehouse management. I found this information in the link below: -

https://community.dynamics.com/ax/f/33/t/221640

Is there any workaround with the help of which I can achieve this date-controlled sales picking without using Batch dimension ?

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

If you're using the Warehouse management module, the Location directive is responsible for determining which location to use first. And in my view, there is no way to configure it to use the 'oldest' inventory if you are not using the Batch dimension.

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Crispin,

I can't comment on the technical aspects of that customisation, because that is just not my role!

I don't think I have ever been asked to implement FIFO on items which AX does not really know which inventory was received first. And, let's be clear, anything you do without using the Batch dimension and Batch dates is a best guess. For example, if at any time you put multiple receipts in to the same location, then it becomes impossible for AX to distinguish between the inventory received on different receipts just as it is impossible for the picker to determine; you have no way of knowing that you actually received the items in the order in which they expire or were manufactured.

When picking items which are not Batch controlled, there are often rules around which location to use first, but FIFO is not one that I have used, and if it were crucial, I would suggest using the Batch dimension.

Was this reply helpful? Yes No
Suggested answer

Sagar Suman 6,550 Super User 2025 Season 2 on at

Like (1)

Report

Hi Anurag Nagarkoti ,

This is easily possible in AX where you want to sort the item picking based on there receipt dates even when they do not have any batch and serial numbers.

Just navigate to your location directive for the pick and navigate to the sorting tab where you need to select the on hand inventory table and physical date as a field after which select ascending in the search direction.

Now as you will release the sales order to warehouse Dynamics will pick the items from the location which were received earlier as per the physical date.

Consider this scenario

Item qty Loc Receipt date

Item A 11 LOC-01 1 jan

Item A 11 LOC-02 1 Feb

Item A 11 LOC-04 1 Mar

In the above scenario same item was received in three months and is not serial and batch controlled.

Now if you do the setup as I have stated above and create a sales order for the same item for 11 pcs and release to warehouse, Dynamics will pick the item from location LOC-01 as it the location where the items were received earliest.

If you change the search direction to descending then Dynamics will pick items from location LOC-04.

Works like Silk.

Was this reply helpful? Yes No