Warehouse level item price / transfer order price report

(0) Share

Report

Posted on by sriram

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

I have the same question (0)

All responses (10)

Answers (1)

André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (0)

Report

Hi Sriram,

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

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

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

Was this reply helpful? Yes No
sriram 781 on at

Like (0)

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

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
sriram 781 on at

Like (0)

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

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

hi Sriram,

have you tried data entity 'Costing versions'?

Was this reply helpful? Yes No
sriram 781 on at

Like (0)

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

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

Hi Sriram,

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

Was this reply helpful? Yes No
Verified answer

Dolores Young on at

Like (0)

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

Was this reply helpful? Yes No
sriram 781 on at

Like (1)

Report

Hi Dolores

Thanks

Was this reply helpful? Yes No