bins without warehouse

gri · 2006-11-15

hi there

does anybody uses bins without warehouse management?

since version 4.0 you can order bin granule without ordering warehouse granules, but what for?
ok, you can use item reclassification journals to move items between bins, but is there any standard report which will show you what is where?

do you use bins in a much simpler setup than that required for a warehouse (for example, a store)?

thanx in advance, looking forward for your replies.

ara3n · 2006-11-15

Yes you can use bins without warehouse management. To see what you have in inventory for bins, you simply look at bin content table. On sales order, PO, Item journal, you can specify the bin.

I believe, you can't go negative on bins.

Alex_Chow · 2006-11-15

Can you still use ADCS without warehouse management?

ara3n · 2006-11-15

Well ADCS is build for warehouse management by default. But you can change it to handle sale orders etc. I'm not sure exactly what you are going to use for on sales or purchasing side, Considering you have to work with sales orders.

Cristina · 2006-11-17

My question is:
I want to test the inventory on Sales Order in combination location + bin. But the reservation is not doing by bin in 4.0 (in 3.6 was this functionality). I can sale on bin (because if on location card, bin is manadatory) but the inventory is not check by bins.
So, what is the reason to change bin functionality in 4.0?

ara3n · 2006-11-17

The reason they changed it is because warehouse management was added, and it bin is a warehouse management functionality. With bins you have zones, area associated and it would be really hard to sync item ledger with warehouse entry. Having just location, makes it it a lot easier.

Nobody · 2006-11-17

Just an FYI (SQL version only I think

)

When you use bins without warehousing there is a nasty code loop in
CU -21. When you use bins without warehousing it goes through an error routine that checks to make sure there are no warehouse entries for the line. Problem is the filter is not set right so it looks at every Item Jounral Line. This causes a huge loop and a lot of overhead. I have even seen this make adjust cost run longer.

Here is what I did to get around it.

CU - 21

CheckWarehouse(VAR ItemJnlLine : Record "Item Journal Line")

//ItemJnlLine2.COPY(ItemJnlLine);
//IF ItemJnlLine2.FIND('-') THEN
// REPEAT
GetLocation(ItemJnlLine."Location Code");
IF Location."Directed Put-away and Pick" THEN
EXIT;

CASE ItemJnlLine."Entry Type" OF
ItemJnlLine."Entry Type"::Output:
IF ((NOT Location."Require Receive" AND Location."Require Put-away") AND
(ItemJnlLine.Quantity >= 0)) OR
((NOT Location."Require Shipment" AND Location."Require Pick") AND
(ItemJnlLine.Quantity < 0))
THEN
IF WhseValidateSourceLine.WhseLinesExist(
DATABASE::"Prod. Order Line",
3,
ItemJnlLine."Prod. Order No.",
ItemJnlLine."Prod. Order Line No.",
0,
ItemJnlLine.Quantity)
THEN
ShowError := TRUE;
ItemJnlLine."Entry Type"::Consumption:
IF ((NOT Location."Require Receive" AND Location."Require Put-away") AND
(ItemJnlLine.Quantity < 0)) OR
((NOT Location."Require Shipment" AND Location."Require Pick") AND
(ItemJnlLine.Quantity >= 0))
THEN
IF WhseValidateSourceLine.WhseLinesExist(
DATABASE::"Prod. Order Component",
3,
ItemJnlLine."Prod. Order No.",
ItemJnlLine."Prod. Order Line No.",
ItemJnlLine."Prod. Order Comp. Line No.",
ItemJnlLine.Quantity)
THEN
ShowError := TRUE;
END;
IF ShowError THEN
ERROR(
Text012,
ItemJnlLine.FIELDCAPTION("Entry Type"),
ItemJnlLine."Entry Type",
ItemJnlLine.FIELDCAPTION("Document No."),
ItemJnlLine."Document No.",
ItemJnlLine.FIELDCAPTION("Line No."),
ItemJnlLine."Line No.");
// UNTIL ItemJnlLine2.NEXT = 0;

bbrown · 2006-11-18

ara3n wrote:

I believe, you can't go negative on bins.

I have found one area where a system without "Advanced Warehouse Management" will allow inventory to go negative in bins. The issue involves lot tracked inventory and the item reclass journal. If the user drills down to the lot form, then only lot in that bin are displayed. However, if the user manually types the lot number, the system will except any valid lot for the item regardless of which bin.

Our client was using bins with picking only. They posted directly to bins thru the output journal and use the reclass journal to move inventory.

I found this in version 3.7. I am not sure if its been fixed in 4.0. I reported it to Microsoft and got their standard "That's they way it works" response.

ara3n · 2006-11-18

While we are on warehouse management and lot tracking subject, Why on warehouse journal you cannot do a lookup for lot no?

bins without warehouse

Comments

Categories