Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Query to add costs..
Microsoft Dynamics RMS (Archived)

Query to add costs..

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

Is there a query that I can use to put item costs? At this moment, I've added all my items with prices only.  It's taking me too long to go through my old invoices to find the cost of every item I have purchased so I decided to put approximate costs for every item for now and fix them as we get new shipments everyday.  

I would like to know if there's a query that I can use to put item costs for any items under Supplier "XYZ" which cost=0, to be 33.33% of prices I entered.  I need a query for HQ database please.

Thank you in advance for your assistance.

Al

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Query to add costs..

    Hello Antonijo,

    I tried my partner but he only told me how to update the transactioncost, not the actual item cost.  He seems like he doesn't know how to do it... :(

    I only have standard items in the suppliers that I want to add costs.  For the "snapshot" costs or "cost per store" you mentioned, isn't it possible to just use the worksheet 302 (Change Item Costs) to apply to store levels as long as I have the costs in the item table? i.e wouldn't the worksheet or "data upload from store" update costs automatically in other tables if we have costs in the Item Table?

    Thank you.

    Al

  • Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Query to add costs..

    Hi there.

    I suggest you talk to your partner, as making direct tSQL queries have to be done by someone knowledgeable, always with a previous backup of the database and always with RMS HQ Server stopped.

    Also, You will have to define better what You want, as Cost value is not only in the Item table. If you have Matrix Items, there is a Cost value in ItemClass table or there is a Cost (snapshot) in ItemDynamic table (Cost per store)...

    hope this helps a little bit... A.

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans