You’re offline. This is a read only version of the page.
150
We have some items showing up in the SOP10200 table with zero cost associated with them. After they post to SOP30300 the correct costs are associated. We are wondering how this happens and what we can do to prevent it. So far, the only thing consistent among the items is they all have zero Current Cost in IV00101..not sure how Current Cost is used by GP or how it is set or if it is significant to this issue. Would greatly appreciate any direction.
Thank you,
Tim
*This post is locked for comments
The Current Cost field on the Item Master is updated each time an increase to inventory is posted. The increase can be a receipt or an item transaction/adjustment. This current cost amount falls onto the SOP document when the sop doc is first created. This can be very misleading because the current cost number is completely irrelevant to the COGS that is entered for the transaction once the SOP doc is posted. You can modify SOP setup such that the current cost isn't displayed.
Current Cost is the amount that drops onto a PO when you enter it for a new vendor. It's also used for returns that are not created using the SOP Return action. Cost, on the other hand, is calculated upon posting according to your inventory costing settings on the item. There is no way to prevent this behavior 'out of the box'.
Willoware Software creates a 'tweak' that will force the current cost to be used as the actual cost in COGS, but I would not use this tool if I were you.
A pretty brief explanation, let me know if you have any questions via e-mail and I will be happy to address them. leslievail@earthlink.net
Kind regards,
leslie
The costs will be assigned at the time you post the invoice. It is possible that the items on the order did not have a cost at the time the order was entered. However, after the order was entered a PO receipt was entered and posted and a cost was assigned. At the time of posting these costs will be then be used for these items. Of course, this will also be dependent upon the valuation method assigned to the item.
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...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (