web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
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

I have the same question (0)
  • Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

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

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans