Open Forum

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Troy,

Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP
------------------------------

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Happy New Year Steve,
I have screenshots of Warehouse Entries and ILE to hopefully clear up the questions. The original receipt date was 10/18 however there are entries on both ILE and Warehouse Entries that involve the issue.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Original Message:
Sent: Jan 04, 2021 11:28 AM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Troy,

Using the images below, I see in the ILE 3 Purchase Receipts and 2 with an offsetting Negative Qty. On the Warehouse Entries, which are for the Bin entries, I see 3 Receipts, 1 Transfer from Location 01 to Location 03 and 1 Pos/Neg that washes to itself. My question now is where did the 2 Negative PO Lines from the Receipts get posted too in Location 01. My gut is telling me they are NOT in a Bin or Bin = '' (this means Blank). Can you Navigate on the 2 Posted PR document and see what Bin each record shows?

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP
------------------------------

Original Message:
Sent: Jan 04, 2021 12:26 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Happy New Year Steve,
I have screenshots of Warehouse Entries and ILE to hopefully clear up the questions. The original receipt date was 10/18 however there are entries on both ILE and Warehouse Entries that involve the issue.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 11:28 AM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Steve,
When I navigate on the Posted Purchase Receipt I find a couple of things.
1. I find that there are 2 ILE postings for each "Receipt" BUT only 1 Warehouse Entry
    PR114208
           ILE              Warehouse Entry
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)
    PR114212
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)

After seeing this I did find out that the Warehouse Manager added the -101,200 on he receipt to try to "fix it" TWICE. Now I am thinking that these are not applied entries however I took a quick look (I spent a whole 2 minutes looking around) and didn't really see what to apply.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Original Message:
Sent: Jan 04, 2021 01:57 PM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Using the images below, I see in the ILE 3 Purchase Receipts and 2 with an offsetting Negative Qty. On the Warehouse Entries, which are for the Bin entries, I see 3 Receipts, 1 Transfer from Location 01 to Location 03 and 1 Pos/Neg that washes to itself. My question now is where did the 2 Negative PO Lines from the Receipts get posted too in Location 01. My gut is telling me they are NOT in a Bin or Bin = '' (this means Blank). Can you Navigate on the 2 Posted PR document and see what Bin each record shows?

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Jan 04, 2021 12:26 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Happy New Year Steve,
I have screenshots of Warehouse Entries and ILE to hopefully clear up the questions. The original receipt date was 10/18 however there are entries on both ILE and Warehouse Entries that involve the issue.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 11:28 AM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Troy,

OK, this answers my question. The negative entries DID NOT post to the Warehouse Entries as the Bin Code was blank. Your goal is to take the Location 01, Bin Code = Packaging, and eliminate the 202,400, correct? If yes, here is my suggestion...

1. Using an Item Journal, first reverse the 2 Negative Entries which DO NOT have a Bin Code (create a Positive Adjustment). Please make sure you use the correct Posting Date as the next entry is the correction one.
2. Now that the 2 negative entries are eliminated from the Item, using the same Posting Date so this all washes to 0, lets create a correct Negative Adjustment entry, which points to Location 01 and Bin Code = Packaging. Post this entry and you will see the Bin have a Qty = 0.

This should solve the issue you are trying to acheive.
Thanks,
Steve


------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP
------------------------------

Original Message:
Sent: Jan 04, 2021 02:56 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Steve,
When I navigate on the Posted Purchase Receipt I find a couple of things.
1. I find that there are 2 ILE postings for each "Receipt" BUT only 1 Warehouse Entry
    PR114208
           ILE              Warehouse Entry
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)
    PR114212
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)

After seeing this I did find out that the Warehouse Manager added the -101,200 on he receipt to try to "fix it" TWICE. Now I am thinking that these are not applied entries however I took a quick look (I spent a whole 2 minutes looking around) and didn't really see what to apply.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 01:57 PM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Using the images below, I see in the ILE 3 Purchase Receipts and 2 with an offsetting Negative Qty. On the Warehouse Entries, which are for the Bin entries, I see 3 Receipts, 1 Transfer from Location 01 to Location 03 and 1 Pos/Neg that washes to itself. My question now is where did the 2 Negative PO Lines from the Receipts get posted too in Location 01. My gut is telling me they are NOT in a Bin or Bin = '' (this means Blank). Can you Navigate on the 2 Posted PR document and see what Bin each record shows?

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Jan 04, 2021 12:26 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Happy New Year Steve,
I have screenshots of Warehouse Entries and ILE to hopefully clear up the questions. The original receipt date was 10/18 however there are entries on both ILE and Warehouse Entries that involve the issue.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 11:28 AM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Steve,
I see where this would work however I cannot post to a Bin Code that is blank. NAV will not allow. I also tried to post this all in one with a reclass journal just to try it. That did not work either. (I know grasping at straws but I had to try).


------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Original Message:
Sent: Jan 04, 2021 04:22 PM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

OK, this answers my question. The negative entries DID NOT post to the Warehouse Entries as the Bin Code was blank. Your goal is to take the Location 01, Bin Code = Packaging, and eliminate the 202,400, correct? If yes, here is my suggestion...

1. Using an Item Journal, first reverse the 2 Negative Entries which DO NOT have a Bin Code (create a Positive Adjustment). Please make sure you use the correct Posting Date as the next entry is the correction one.
2. Now that the 2 negative entries are eliminated from the Item, using the same Posting Date so this all washes to 0, lets create a correct Negative Adjustment entry, which points to Location 01 and Bin Code = Packaging. Post this entry and you will see the Bin have a Qty = 0.

This should solve the issue you are trying to acheive.
Thanks,
Steve


------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Jan 04, 2021 02:56 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Steve,
When I navigate on the Posted Purchase Receipt I find a couple of things.
1. I find that there are 2 ILE postings for each "Receipt" BUT only 1 Warehouse Entry
    PR114208
           ILE              Warehouse Entry
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)
    PR114212
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)

After seeing this I did find out that the Warehouse Manager added the -101,200 on he receipt to try to "fix it" TWICE. Now I am thinking that these are not applied entries however I took a quick look (I spent a whole 2 minutes looking around) and didn't really see what to apply.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 01:57 PM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Using the images below, I see in the ILE 3 Purchase Receipts and 2 with an offsetting Negative Qty. On the Warehouse Entries, which are for the Bin entries, I see 3 Receipts, 1 Transfer from Location 01 to Location 03 and 1 Pos/Neg that washes to itself. My question now is where did the 2 Negative PO Lines from the Receipts get posted too in Location 01. My gut is telling me they are NOT in a Bin or Bin = '' (this means Blank). Can you Navigate on the 2 Posted PR document and see what Bin each record shows?

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Jan 04, 2021 12:26 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Happy New Year Steve,
I have screenshots of Warehouse Entries and ILE to hopefully clear up the questions. The original receipt date was 10/18 however there are entries on both ILE and Warehouse Entries that involve the issue.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 11:28 AM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Troy,

This is perplexing as without looking at the Location Card, you have Bin Mandatory = TRUE, yet the Location has entries without a Bin posted. You cannot turn this Boolean off after Bins are populated. I do know of a way to fix this but it will require a programmer to update the tables directly populating the Bin Code field for those 2 negative entries in the Bin Content Table and Warehouse Entry Table.  The ILE and Value Entry do not have Bin Code on the table. It is not a hard request back to your Partners programmer.

This is the best suggestion to resolve this issue given the Location is locked with Bin Mandatory and you have these 2 entries that need resolution.
Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP
------------------------------

Original Message:
Sent: Jan 05, 2021 12:45 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Steve,
I see where this would work however I cannot post to a Bin Code that is blank. NAV will not allow. I also tried to post this all in one with a reclass journal just to try it. That did not work either. (I know grasping at straws but I had to try).


------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 04:22 PM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

OK, this answers my question. The negative entries DID NOT post to the Warehouse Entries as the Bin Code was blank. Your goal is to take the Location 01, Bin Code = Packaging, and eliminate the 202,400, correct? If yes, here is my suggestion...

1. Using an Item Journal, first reverse the 2 Negative Entries which DO NOT have a Bin Code (create a Positive Adjustment). Please make sure you use the correct Posting Date as the next entry is the correction one.
2. Now that the 2 negative entries are eliminated from the Item, using the same Posting Date so this all washes to 0, lets create a correct Negative Adjustment entry, which points to Location 01 and Bin Code = Packaging. Post this entry and you will see the Bin have a Qty = 0.

This should solve the issue you are trying to acheive.
Thanks,
Steve


------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Jan 04, 2021 02:56 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Steve,
When I navigate on the Posted Purchase Receipt I find a couple of things.
1. I find that there are 2 ILE postings for each "Receipt" BUT only 1 Warehouse Entry
    PR114208
           ILE              Warehouse Entry
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)
    PR114212
    a. -101,200        NO ENTRY ON TABLE
    b.  101,200        Posted to Packaging (Bin)

After seeing this I did find out that the Warehouse Manager added the -101,200 on he receipt to try to "fix it" TWICE. Now I am thinking that these are not applied entries however I took a quick look (I spent a whole 2 minutes looking around) and didn't really see what to apply.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 01:57 PM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Using the images below, I see in the ILE 3 Purchase Receipts and 2 with an offsetting Negative Qty. On the Warehouse Entries, which are for the Bin entries, I see 3 Receipts, 1 Transfer from Location 01 to Location 03 and 1 Pos/Neg that washes to itself. My question now is where did the 2 Negative PO Lines from the Receipts get posted too in Location 01. My gut is telling me they are NOT in a Bin or Bin = '' (this means Blank). Can you Navigate on the 2 Posted PR document and see what Bin each record shows?

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Jan 04, 2021 12:26 PM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

Happy New Year Steve,
I have screenshots of Warehouse Entries and ILE to hopefully clear up the questions. The original receipt date was 10/18 however there are entries on both ILE and Warehouse Entries that involve the issue.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI

Original Message:
Sent: Jan 04, 2021 11:28 AM
From: Steven Chinsky
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

Thanks,
Steve

------------------------------
Steven Chinsky
Manager
Wipfli
Mansfield MA
NAVUG/BC Programming Committee Member
NAVUG All-Star, Granite Award Recipient, MCP, DCMP

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Troy,

You could try Whse. Phys. Invt. Journal and perform Calculate Inventory for just that one item.
You may find a two bins, one you can adjust negative, and one you can adjust positive, then register.
That won't affect your inventory. The negative may be sitting in your receive bin.

------------------------------
Joseph Flynn
Sr. Dynamics NAV Developer
Gold Star Foods INC
Ontario CA
------------------------------

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Joseph,
We do not have advanced warehouse turned on. The WHSE Phy Journal will not work.

Thank you for the idea.

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Original Message:
Sent: Jan 04, 2021 11:39 AM
From: Joseph Flynn
Subject: Quantity in Bin Contents NOT in on-hand

Troy,

You could try Whse. Phys. Invt. Journal and perform Calculate Inventory for just that one item.
You may find a two bins, one you can adjust negative, and one you can adjust positive, then register.
That won't affect your inventory. The negative may be sitting in your receive bin.

------------------------------
Joseph Flynn
Sr. Dynamics NAV Developer
Gold Star Foods INC
Ontario CA

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------

Can you do a Warehouse Inventory Journal?  I saw that you can't do the Whse. Phys. Inv. Journal.

In our system, I would do a negative Warehouse Inventory Journal entry, and then do a positive Item Journal Entry to offset it.  Your inventory should not change, but you will have removed it from the bin.

------------------------------
Eric Moe
Global Supply Chain Manager
Industrial Revolution
Tukwila WA
------------------------------

Original Message:
Sent: Dec 31, 2020 11:25 AM
From: Troy Harkness
Subject: Quantity in Bin Contents NOT in on-hand

I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

We are using NAV 2017 On-Prem

Thank you,

------------------------------
Troy Harkness
Miller Baking Company
Milwaukee, WI
------------------------------