Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Warehouse level item price / transfer order price report

(0) ShareShare
ReportReport
Posted on by 781

Hi,

We upload the item price on Standard Cost every month at site level and transfer price at site and warehouse level monthly.

Do we have any standard report to see the item price at warehouse level

  • sriram Profile Picture
    781 on at
    RE: Warehouse level item price / transfer order price report

    Hi Dolores

    Thanks

  • Verified answer
    Dolores Young Profile Picture
    on at
    RE: Warehouse level item price / transfer order price report

    Hello Sriram,

    Since standard cost is held at the Site level, it will be the same for all warehouses within that site.  There is no report to display standard cost at the warehouse level that I know of.

    Regards

    Dolores

  • YOG Profile Picture
    414 on at
    RE: Warehouse level item price / transfer order price report

    Hi Sriram,

    I can think of one option that is, create custom entity for your requirement.

  • sriram Profile Picture
    781 on at
    RE: Warehouse level item price / transfer order price report

    Hi,

    In costing version , we can have the price list based on the versions like . standard, planned etc..

    however the cost uploaded will be on site basis. but I need to have a report of item price based on any of the costing version at warehouse level.

    for eg., refer below table

    pastedimage1595908319113v1.png

  • YOG Profile Picture
    414 on at
    RE: Warehouse level item price / transfer order price report

    hi Sriram,

    have you tried data entity 'Costing versions'?

  • sriram Profile Picture
    781 on at
    RE: Warehouse level item price / transfer order price report

    Hi,

    we have made a customisation to upload the cost price of all items .

    however , the standard feature , we have can upload the cost price as per the below path Inventory Management -> Setup -> costing version -> select Cost type (Planned / Standard) - >select Item price....

    After uploading we can activate them in the same screen.

    Now I  want to have a report to see all the cost of the item at site and warehouse level

  • YOG Profile Picture
    414 on at
    RE: Warehouse level item price / transfer order price report

    how did you upload prices? is it a trade agreement?

    where can you see price in system? can you share screenshot?

  • sriram Profile Picture
    781 on at
    RE: Warehouse level item price / transfer order price report

    Hi,

    I have a path defined for the uploading of the Standard cost price and transfer price.

    I upload the standard cost of the item at site level and each site has 4 warehouses.

    I want to know , is there any standard report available to see the uploaded  item standard cost at warehouse level

  • YOG Profile Picture
    414 on at
    RE: Warehouse level item price / transfer order price report

    Hi Sriram,

    you need to explain your requirement.

    there are two ways for uploading pricing

    1)  Base price - you can import base price against each item (Released products v2 - data entity) and system will use it in average cost calculation (only in the case where system could not find any cost during transaction) -- note- base price is general and do not look at any site/warehouse)

    2) Trade agreements - this is where you use trade agreement journal to import price by site/warehouse/item status. data gets stored under PriceDiscTable. There is no standard report or data entity available. you can customise data entity for reporting or look at price through table browser

  • André Arnaud de Calavon Profile Picture
    292,884 Super User 2025 Season 1 on at
    RE: Warehouse level item price / transfer order price report

    Hi Sriram,

    Can you explain what exact details you expect on the report?

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... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,754 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans