FEFO and item tracking on warehouse pick

(0) Share

Report

Posted on by elfiaa

Situation: I have a Warehouse shipment with 144 in total quantity of product 63051 that I want to pick according to FEFO AND get a suggestion of the Lot on the Pick line.

Product: 63051 bin content

(Utlev Bin Is a Shipment bin and all quantity is reserved to picked shipments)

Locations setup test 1:

Item tracking code setup test 1: (No strict Expiration posting)

Create pick from Warehouse shipment: (The system suggests to pick only 123 on first pick so I have to create 1 more)

(The system suggests to pick only 123 on first pick so I have to create 1 more before the shipment can be fully picked):

When I create 2:nd pick I get “Nothing to handle”:

Test 2:

Same location setup as Test 1 but with Strict expiration posting:

Create Pick: (The system gives me the same first pick as test 1)

Lot no list (!!)

Test 3:

Location setup

Item tracking code setup:

Create Pick:

(The system wants me to pick 144, but gives me no Lot as a suggestion)

Test 4: (Same location setup as Test 3 but with strict expiration posting on item tracking code)

Create Pick: (The system created a pick for a total of 48 in quantity from 2 different bins)

Bin Lot no information (21 On the “REST” Bin with an earlier expiration date and the rest is on HLP Bin):

I create a pick for the 2:nd time on test 4 and the system creates a pick for the remaining quantity:

As described, my ideal scenario would be if the system created 1 pick for (similar to the one in test 3 but with the full quantity) – Would that be to much to ask?

I have the same question (0)

All responses (5)

Answers (0)

Alfredo_Iorio 1,262 on at

Like (0)

Report

Something doesn't add up to your test No. 3 and 4

You seems to have a location where required pick is disables but you still managed to create a warehouse pick.

The most likely explanation to the results of test 1 is that in HLP bin you only have 123 available to pick of that item. Either the rest of the stock is reserved to other demand or other picks have already reserved the inventory.

This would explain why the second time you try to create a pick for the remainder, you get a "Nothing to handle" error. The Strict Expiration Posting flag does not control reservation or lot tracking. You can still get an expired lot in the warehouse pick but you will not be able to post the shipment line.

Was this reply helpful? Yes No
elfiaa 25 on at

Like (0)

Report

Regarding test 3 & 4 I have set up a shipment bin code so the system creates picks even though pick is not Required.

Regarding Bin content I have plenty of quantity left on HLP bin:

Was this reply helpful? Yes No
Bryan Tschosik on at

Like (1)

Report

Hi Elfia,

Yes this can get a bit tricky. So for some reason, in Test 1, it only pulls 123 qty, which is 21 short...is not pulling the 21 that it "maybe" should be pulling from Bin REST, since I see from Test 4, screenshot that has earlier exp. date with 21 Total Avail. Qty.

We can see in TEST 3, with 'Pick According to FEFO' = NO, it pull in full 144 qty from HLP Bin. When we do Not Pick according to FEFO, we have more lenient availability....and we do not suggest Lot Number....so that explains that.

Can you check to see if there is any other demand that has assigned that Lot Number that sits in REST Bin? Maybe Sale, Purchase Credit Memo, or some movement...perhaps internal movement. Also check the Physical Inventory Journal, Item Reclassification Journal (and be aware if other batches), to see if this item with assigned Lot is sitting in any of these.

If non of this tells us anything, or we don't get very far, you may need to analyze the Warehouse Entries, in table 7312...for this item. Sort it by Location > Bin > Entry No. and see if we can see anything there. If that doesn't tell us anything, submit it to BC Support team. Thank you.
Bryan

Was this reply helpful? Yes No
Amit 2,557 on at

Like (0)

Report

Hi,

Adding info-:

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

elfiaa 25 on at

Like (0)

Report

Thanks for great feedback Bryan!

Regarding REST bin the only demand is the 21 from the pick pick I created

However, there is other sales demand on the same item that has been picked to UTLEV-bin (reserved so should not be a problem anyway...)

The only thing that sticks out when I look at the warehouse enteries is that we have some credit memos against UTLEV bin, however the same quantity and Lot No have been invoiced directly so should defenently not be a problem anyway.

However, when I have location setup to "Require pick" and "Require shipment" and below booleans:

I get the result that I want (21 from rest bin and 123 from HLP):

But, since the manufacturing module is in use it would be ideal not to "require pick" so they have the option to post from the production Journal without picking. I think we will have to use this setup and maybe customize our way through the production problem if you don't have any other ideas?

Thanks again for great feedback!

Was this reply helpful? Yes No