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.
0
Comments
I believe, you can't go negative on bins.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
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?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
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;
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.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n