Zero Counting journal cost price

(0) Share

Report

Posted on by Nabil Abdelrahman

1,552

Item Cost price is missing for items based on sites while creating counting journal .After checking price Button from Item master I did found that cost price defined for same items but diffrent site on costing version Form ,such cost price are identical same cost prices exist when checking item details >> on-hand button >> onhand tab >>cost price field , if I do checked Latest cost price would this update my costing version sheet for missing sites? how to update to keep costing version updated with most recent cost prices avilable on On-hand form ?

Thank you .

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

guk1964 10,888 on at

Like
a
(0)

Report
Copy link

Link copied!

If the prices are identical then why have Site specific costing?

The maintenance of costs depends on your costing methodology.

Costing versions apply to standard costs and those are not generally updated by last purchase price.

If the cost is constantly being updated with last purchase then does that need a new costing version each time??

see https://technet.microsoft.com/en-us/library/gg231168.aspx

and

https://community.dynamics.com/ax/f/33/t/184777

and

https://community.dynamics.com/ax/f/33/t/28437

maybe this will help

https://extendingdynamicsax.com/2013/11/14/using-costing-versions-to-perform-a-mass-cost-calculation/

Was this reply helpful? Yes No
Nabil Abdelrahman 1,552 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi magic1949

thank you for replying , I'm not sure why system has diffrent costing version based site but by comparing costing verson item cost site wise vs its exact on-hand but i need to be able to update them sites cost prices to get them while creating counting journals .

Thank you

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What is your costing method? Presuming it is not standard then the cost price will be updated when you check the latest cost price which will then be used on your counting journal for positive entries, although for negative entries the cost on the journal is not relevant, AX adjusts the cost as per the costing method on posting.

Was this reply helpful? Yes No
Guy Terry 29,013 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Becatcho,

On the Inventory model group of your items, what is the 'Inventory model' set to?

Was this reply helpful? Yes No
Nabil Abdelrahman 1,552 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Steven I'm using WA "Weighted avg." ,I can see once I have selected site on counting journal cost price is picked up and no matter Qty I update (+/-) system dose not update the cost at all.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

In a test system remove the stock, is the cost used 0?

What is your dimension group set to for financial costing for that item?

Was this reply helpful? Yes No
Nabil Abdelrahman 1,552 on at

Like
a
(0)

Report
Copy link

Link copied!

When try to remove stock to 0 system reject it .

I'm using Site & warehouse (Financial Inventory is checked for both )

Was this reply helpful? Yes No
Guy Terry 29,013 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Becatcho,

With the Weighted average cost model, AX will only look at the Costing version or Cost price on the item master if it does not already know the cost of the item. Typically, if the item is in stock, AX knows the cost price of it.

If you do a count journal for an item which is not in stock, in a Site which has no Costing version, and where the item has no cost price on the item master, then AX will not know the cost of the item. You'll have to enter it manually on the count journal line.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What does it tell you when it is rejecting the posting of the journal?

Was this reply helpful? Yes No