Inventory report detailed

V5 Question
1

Hello Everybody

I want get a detailed report for all the items(not daily) in the inventory which can give me following information.

  1. Item name
  2. Cost price
  3. Quantity in stock
  4. Quantity sold
  5. Selling price
  6. Group code

Thank you

2

https://kb.sambapos.com/en/cat/reports/

That is your resource for everything reports. You should be able to learn how to build any report by reading through that knowledge base.

3

I used the report inventory consumption and it have first 4 information but selling price and group code it dont have. How can i get that?

4

image
image1920×1080 231 KB

i tried and these all the info except selling price. Can plz help me out to get selling price in this?

@{REPORT CONSUMPTION DETAILS:I.GroupCode.asc::,}
[Inventory Consumption:5,5,5,5,5,5,5,5,5,2]
Item|Sell|Unit|InStock|Purchase|Removed|Warehouse|Cost
$1
{REPORT CONSUMPTION DETAILS:
C.Name.asc,C.Consumption.Sum,C.Unit,C.Inventory.Sum
,C.Added.Sum,C.Removed.Sum,C.Warehouse,C.Cost:I.GroupCode==“$1”}

5

@JTRTech u have any idea how to add selling price in this report?

6

Anybody here who can help?

7

I’m not sure there will be a report expression for sell price.
Typically a recipe would consist of more that one ingredient and you wouldn’t say you sell 100g of flower for the 10$ you might sell the finished dish for…
If your working on a 1:1 retail type scenario you would need to match inventory items to product names and add a sub report or something to call product price with same name.

8

Yes you are right but how can i call product price with the same name. I tried to combine the two tags like:
{Report Cost Details:X}|{Report Consumptions Details:X}
But its only giving me output first tag.