Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Items with zero cost i...
Microsoft Dynamics GP (Archived)

Items with zero cost in table SOP10200

(0) ShareShare
ReportReport
Posted on by BBCOMTT 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

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Items with zero cost in table SOP10200

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Items with zero cost in table SOP10200

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans