Error in Purchase Order Direct Unit Cost Excluding VAT field

(0) Share

Report

Posted on by Community Member

Hi,

I made an item with a unit cost of $100 (refer to screenshot below).

6663.Capture.PNG

However, when I make a PO with the same item, the Direct Unit Cost Excluding GST is automated and changes on its own (refer to screenshot below).

4111.Capture1.PNG

May I know why I the field does not input $100 automatically but displays another value instead? Thank you for your kind attention.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Indikauk 1,759 on at

Like (0)

Report

Hi Sree,

Item Card Unit Cost Update Automatically when the adjust cost entries batch job is run.

if Post one purchase Unit Cost & Direct Unit Cost fields are automaitcally getting updated in the Item Card.

when you enter new purchase Direct Unit Cost Including GST is Automatically updating throught the "Last Direct Cost" field from the Item Card

below is the Microsoft Explanations about it.

"If you selected the FIFO, LIFO, Specific, or Average costing method, the program updates the field when you run the Adjust Cost-Item Entries batch job.

With the costing methods other than Standard, the program will also update this field during the posting of purchase invoices if one of the following conditions is true:

The net invoiced quantity of the item changes from negative or zero to positive.

The unit cost on the item card is zero." [Microsoft Explanation]

and Direct Unit Cost excluding GST

"The program automatically retrieves the cost from the Last Direct Cost field in the Item table. If the Item Vendor table contains a cost for this vendor, the program will enter that price instead.

Important :-

If you change the direct unit cost, the program updates the contents of the Line Amount and Line Discount Amount fields. The contents of the Inv. Discount Amount field will be deleted if the direct unit cost is changed. This means that the invoice discount amount will have to be recalculated." [Microsoft Explation]

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Dear Sree Sangeeth ,

got your point , please note that this is note an issue .

Ill explain you this very simple

On Item card System keep unit cost as Actual cost , Its actually average coset

Assume .....

You have purchase "A" Item as like this

2017-01-30 === > Price as $100

2017-01-29 === > Price as $150

2017-01-28 === > Price as $120

2017-01-27 === > Price as $90

2017-01-26 === > Price as $88

so..........

if you see your item in your item card your cost will show : $109.6

Reason : ($100+$150 + $120 + $90 + $88) / 5 = $109.6

so if you going to make order just change the cost form "line tab" that's it

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Maneesha,

Thank you for your explanation. That means I can only fill in the cost manually right?

Also, you said "so if you going to make order just change the cost form "line tab" that's it" - don't mind may I know where is the cost form line tab? Are you referring to the line tab in a Order?

Thank you for your kind attention.

Sree

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Sree Sangeeth ,

yes but also its depend , because if you make PO through Purch. Quotes then you no need to add it again

Refer the following images with costing you will realize the pattern

See the pattern of Unit Cost and Last Direct cost on Item card

and see the purchase order getting the amount..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Understand. That means there isn't a way to change the Direct Unit Cost field to only display the Unit Cost we have setup?

Thank you,

Sree

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

By default it carries that value from last direct cost but you can change that in purchase order

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your reply. So we can only change it manually and there is no way to make it automated?

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Dear Sree Sangeeth ,

Yes , its get and show you the last direct cost

Actually its opportunity to you because you don't need to find what is the cost you have purchase at last time ,

System will show you and suggest the last purchase cost , then you can realize even you take it from higher/lower value from previous last buy

What you need to do is if there any differ , just change the cost and do the PO

Hope you understand the operation well now :)

Was this reply helpful? Yes No