Help with a simple query.

[Former Member]

A customer of mine wishes to run a report to show the following.

Item Code, Item Description, Item Cost, Base Price for all items in Warehouse 10

Could you provide me with the syntax required as I'm not fully sure on which Tables/Fields etc to use.

Please respond if you require further info.

Thanks

Steve.

[vasileiosfasolis · Accepted solution]

HI

TRY THIS

SELECT OITM.ITEMCODE, OITM.ITEMNAME, OITM.PRICE, OITW.WHSCODE,OITM.LASTPURPRC FROM OITM,OITW WHERE OITW.WHSCODE='10'

[Former Member · Accepted solution]

This query is just what I was after.

Thanks to everybody else who replied.

Steve.

[Former Member]

Hi,

Try to check Inventory Audit Report.

Inventory>Inventory Reports>Inventory Audit Report

Regards

Jambulingam.P

[jitin_chawla]

Hi,

Check this :

select t2.itemcode as 'Item Code', t2.ItemName as 'Item Description',
t2.AVgPrice as 'Item Cost', t2.LstEvlPric as 'Base Price ', t0.whsname as 'Warehouse Name'
from OWHS T0  
INNER JOIN OITW T1 ON T0.WhsCode = T1.WhsCode 
INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode
where t1.whscode = '10'

Also, please let us know what is meant by Base Price which you require in your query?

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Lowery......

Please try this.......

SELECT T1.[ItemCode], T0.[ItemName], T1.[OnHand], T1.[AvgPrice]

FROM OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode WHERE T1.[WhsCode] ='10'

Regards,

Rahul