Microsoft Dynamics NAV (Archived)

Direct unit cost as the value for PO

(0) Share

Report

Posted on by santarzan

405

Hi All,

Just wanted to know do we have an option in NAV 2015 to default the unit cost instead of direct unit cost.

4331.Screenshot_5F00_1.png

So that when I select the item in the po line the value will be calculated based on the unit cost and not from the direct unit cost

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

You need to customize it

Was this reply helpful? Yes No
santarzan 405 on at

Like (0)

Report

Hi Amol,

Thanks for the information I also want to know that will it work if I create a batch update items through journal entries to update the Direct Unit Cost so that it matches the Unit Cost?

Was this reply helpful? Yes No
Hasitha Jayasuriya 645 on at

Like (0)

Report

Hi Santarza,

There could be a workaround. Does the Unit cost of your item change frequently ?. What sort of costing method do you use ?

Regards,

Hasitha J

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

Why don't you use purchase price then ?

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Hi Santarzan,

You can create an setrange between the Item no in the page and Item table then fetch the Unit cost from Item table.

In the OnValidate trigger of No field you can code as below

IF Type=Type::Item THEN BEGIN

Item.GET(Rec."No.");

Description:=Item.Description;

"Unit Cost":=Item."Unit Cost";

"Unit Of Measure Code":=Item."Base Unit of Measure";

END;

This will populate the Unit cost field with the default unit cost from Items

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report

Hi Santarzan,

Yes. You can create a batch. Create a function in a code unit .In OnRun trigger call this function. Now in the function you have to write the following code:

Itemtable.reset

If Itemtable.findfirst then begin

Itemtable.direct unit cost := Itemtable.unit cost;

Itemtable.modify(true);

End;

Now create a job queue and set this codeunit object to run.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

When po get created then it picks up laat dirct cost and display in po unless you define the purchase prices.

Your issue belongs to purchase order line amount and not with item card.

Best option would be make changes at PO level rather than updating cost on item card.

Was this reply helpful? Yes No
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

Hi there,

you could set up "Indirect Cost %" for an approximation. Depends a little on what you want to achieve... See here: msdn.microsoft.com/.../hh175422(v=nav.90).aspx

with best regards

Jens

Was this reply helpful? Yes No