Unit Cost(LCY) & Unit Cost is showing 0

navuser1

Dear all,

I have a problem - An item has Last Direct Cost is Rs.26000/- & Unit Cost is also Rs.26000/-(in the item card). When the same item was sold, then in Posted Sales Invoice, the Unit Cost(LCY) & Unit Cost is showing 0.

What is the reason behind it?


Note:NAVIN 4.0 SP3 HF5 NATIVE

AdamRoue

The sales order was put on prior to the last receipt and unit cost being populated.

When you run the adjust cost item entry the value in the ledger entries will be correct - the details on the sales line and posted invoice are never updated so you need to look to the ledgers.

navuser1

Hi adam,

Thnx for instant reply.

In some of the cases the Ledger entries showing such amount of "Unit Cost" value which are never applied for any Purchase Order.
What is the reason behind it?

AdamRoue

The ledger entry takes the current unit cost as an expected cost, it will then update this appropriately depending upon the costing method and the purhcase invoice processing with the adjust cost item entry routine being run and any revaluation, item charge processing etc, if you drill into the value entry it will show you the make up of the unit cost.

navuser1

Thanx for the reply.

But there is another issue. Some posted sales invoice shows unexpected Unit Cost & Unit Cost (LCY) which affects the Item Ledger & Value Entries table. If we change the values in these two tables manually, then what will be the effect? We will replace the cost amount (actual) field with Last Direct Cost.

AdamRoue

DONT change the cost fields directly in the table.

You need to understand the issue. Firstly the cost on the sales invoice will not "affect" the item or value ledger entry. Secondly look at the ledger entry value for the sales invoice, ignore the posted sales invoice, it is irrelevant, unless of course you are writing reports from the table which is not recommended. Third you need to investigate the costs, depends upon your processing, version and costing method, but please do not just go and change the cost directly in the table!