Issue  The Unit Cost has a value on Item Card but has zero Qty on Hand


Solution

The "Unit Cost" box in the "Item Card" dialog box has a value even when the "Quantity on Hand" box contains a zero in Navision

SYMPTOMS
In Microsoft Business Solutions - Navision versions 3.70 and 4.0, the Unit Cost box in the Item Card dialog box has a value even when the Quantity on Hand box contains a zero. This problem occurs after you run the Adjust Cost - Item Entries batch job from the Periodic Activity dialog box.

Note: Microsoft Navision 3.60 Service Pack A and earlier versions update the Unit Cost box to a value of $0.00 if the quantity in the On Hand box is zero.

CAUSE
This problem occurs because certain restrictions and changes have been implemented in Microsoft Navision. These restrictions and changes affect the new unit cost calculation so that the calculation includes the invoiced costs and the expected costs of the current inventory. The following are the restrictions and the changes that affect the calculation:. For all outgoing entries, the unit cost is not calculated during posting. Instead, the Unit Cost box in the outgoing line uses the value from the Unit Cost box in the Item Card dialog box. This value is the last valid unit cost.

Therefore, the initial cost of goods sold (COGS) in an outgoing line is a fair estimate of the current item cost. The initial cost of goods sold will always be in the ordinary range of the purchase cost.

. The Unit Cost box in the Item Card dialog box is only updated during posting when the following conditions are true
. The Net Invoiced Quantity box in the Item Card dialog box changes from a negative value or zero to a positive value.
. The unit cost in the Item Card dialog box is zero.
If these conditions are met, the direct unit cost from the order is used to initialize the unit cost.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the 'Applies to' section.



MORE INFORMATION
Steps to reproduce the problem
Note These steps apply to the North American version of Microsoft Navision 3.70.

Part 1: Create an item
1. In the Main Menu window, click Inventory, and then click Item.
2. In the Item Card dialog box, press F3. On the General tab, specify the following settings:a.  In the No. box, select Test.
b.  In the Base Unit of Measure box, select PCS.
 
3. On the Invoicing tab, specify the following settings:a.  In the Costing Method box, select FIFO.
b.  In the Gen. Product Posting Group box, select RETAIL.
c.  In the Inventory Posting Group box, select RESALE.

Part 2: Enter a purchase order
1. In the Main Menu window, click Purchase & Payables, and then click Orders.
2. In the Purchase Order window, press F3, and then specify the following settings:a.  In the Buy-from Vendor No. box, type 10000.
b.  In the Type box, select Item.
c.  In the No. box, type Test.
d.  In the Quantity box, type 5.
e.  In the Unit Cost box, type 10.

Note Enter the unit cost by using the local currency (LCY).

Part 3: Post the purchase order receipt
1. In the Purchase Order window, click the Posting button, and then click Post.
2. When you are prompted to select the purchase order type, select Receive, and then click OK.



Part 4: Enter a sales order
1. In the Main Menu window, click Sales & Receivables, and then click Orders.
2. In the Sales Order window, press F3, and then specify the following settings:a.  In the Sell-to Customer No. box, type 10000.
b.  In the Type box, select Item.
c.  In the No. box, type Test.
d.  In the Quantity box, type 5.
e.  In the Unit Price box, type 20. 



Part 5: Post the sales order as a shipment
1. In the Sales Order window, click the Posting button, and then click Post.
2. When you are prompted to select the purchase order type, select Receive, and then click OK.



Part 6: Invoice the purchase order receipt
1. In the Main Menu window, click Purchase & Payables, and then click Invoices.
2. In the Purchase Invoice window, press F3, and then specify the following settings:
. In the Buy-from Vendor No. box, type 10000.
. In the Vendor Invoice No. box, type 123.  
3. Click the Functions button, and then click Get Receipt Lines.
4. In the Get Receipt Lines window, select the purchase order receipt that you posted in part 3, and then click OK.
5. In the Invoice window, click Posting, click Post, and then click Yes.

Part 7: Invoice the shipment
1. In the Main Menu window, click Sales & Receivables, and then click Invoices.
2. In the Sales Invoice window, press F3. In the Sell-to Customer No. box, type 10000.
3. Click the Functions button, and then click Get Shipment Lines.
4. In the Get Shipment Lines window, select the shipment that you posted in part 5, and then click OK.
5. In the Invoice window, click Posting, click Post, and then click Yes.



Part 8: Enter another purchase order and another sales order
1. Enter another purchase order. To do this, follow the steps in part 2, and then specify the following settings:a.  In the Buy-from Vendor No. box, type 10000.
b.  In the Type box, click Item.
c.  In the No. box, type Test.
d.  In the Quantity box, type 5.
e.  In the Direct Unit Cost box, type 20.

Note: Enter the direct unit cost by using the local currency (LCY).
 
2. Post the purchase order receipt by following the steps in part 3.
3. Enter another sales order. To do this, follow the steps in part 4, and then specify the following settings:a.  In the Sell-to Customer No. box, type 10000.
b.  In the Type box, click Item.
c.  In the No. box, type Test.
d.  In the Quantity box, type 5.
e.  In the Unit Price box, type 20.
 
4. Post the sales order as a shipment. To do this, follow the steps in part 5.



Part 9: Final steps
1. Invoice the purchase order receipt that you posted in part 8. To do this, follow the steps in part 6.
2. Invoice the shipment that you posted in part 8. To do this, follow the steps in part 7.
3. In the Main Menu window, click Inventory, click Periodic Activities, and then click Adjust Cost - Item Entries.
After you complete part 1 through part 7, locate the Item Card dialog box for the Test item. The Unit Cost box in the Item Card dialog box contains a value of 20.00. After you complete part 8 and part 9, the Unit Cost box contains a zero.