20
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 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.
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.
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?
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.
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,556
Super User 2024 Season 2
#2
Martin Dráb
228,625
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (