Small and medium business | Business Central, N...

unidentified cost value in Business Central

(0) Share

Report

Posted on by Fahed Srour

Hi,

Using BC 16.3, we are using the average costing method, on daily basis, suddenly experienced an unidentified cost of some of the items where the cost jumps from 37 to 391 with no obvious. reason.

Has anyone experienced something like this, or where should I look to figure it out.

Thanks in advance

Fahed

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

We had similar issue and it turns out user made a stock transaction with high amount. Another case was PO with wrong price.

Go to Item Card then look for Unit Cost. Now you can click on unit cost and in new page check and see when cost has changed and why. That can help you to find the error.

After that make sure to use item revaluation journal to fix the error.

Was this reply helpful? Yes No
Fahed Srour 20 on at

Like (0)

Report

Hi MahGah

already did and the only time the cost jumps were during the cost adjustment job, the issue here is the value that did have any reference in all the transactions, seems to be a bug or some manual insertion that I could not find. Keep in mind that this item was purchased only once.

Thanks

Fahed

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Trace the applied entries and the cost there on. There is a reason but it can take some research. The adjust cost is matching inbound costs to outbound costs. So something inbound was at a very high cost....probably a user error and you might need to revalue that transaction.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (1)

Report

Hi Fahed

As Kim mentioned you need to use Application Worksheet and Application entries.

Go to Item then Related -> History -> Ledger Entry select the transaction (start from PO) then Related -> Application -> Application Worksheet in Application Worksheet try Navigate -> Applied Entry to see more

Keep in mind sometimes some fields are hidden in each page. You can use Page Inspector to see more fields and review the info.

docs.microsoft.com/.../across-inspect-page

Was this reply helpful? Yes No
Fahed Srour 20 on at

Like (0)

Report

Thank you, Kim, I investigated it earlier, but couldn't find any high input, I will try to do more searches. Are you aware of any bugs in BC?

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

There are no bugs for costing. Can you add screenshots of item ledger entry that has the large cost and it's associated value entries?

Was this reply helpful? Yes No
BrianDev 105 on at

Like (0)

Report

You may have an Item (Charge) for freight as an example which was applied incorrectly and was associated with a single line item.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

In the Item card you should be able to do a drildown on the "Unit cost" field and get an overview of how your average cost is calculated.

You should do that and look at all the movements there to see if you find something suspicious.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

I think you sent me a subset of both the item ledger and the value ledger entries. I think this because you start with two sales. Anyway cost actual stays around 45.58/45.59 until a direct transfer on 5/25 that changes the cost actual to 276.25….could you have an incorrect cost in the DIP location/stockkeeping unit card? You then add a quantity of two with posting date 5/23 with a positive adjustment of 783.18 which means your unit cost was 391.59 on that transaction. If you look at the value entries for the transfers date 5/19 and later, you see 391.59 less 346.01 which is 45.58. If you are using stockkeeping units, you should check the unit cost on HQW that seems to be where things start.

The last entry is a cycle count for location FZN and it uses the large cost. Stockeeping unit, cost? What does your inventory setup look like? Are you costing by item or by item/location/variant.

And last but not least, you have modifications to your system. I know this by seeing fields such as Offer No. and OFS…. With modifications, we always question what they are doing to your system.

Was this reply helpful? Yes No