Purchases detailed report grouped by supplier


#1

I have managed to achieve this report but iam failing to get totals per supplier. I have set my suppliers as Transaction Types so when i receive from a supplier i just choose the transaction type with that supplier name. Now i want to get total invoice per supplier and i also want to include the user name column so that i know who received the invoice.

[Bhadella Purchases report:1,1,2,2, 1,1,1, 1]

>>Invoice|Time|Product|Target|Quantity|Unit|Amount
{REPORT INVENTORY TRANSACTION DETAILS:D.Description,T.Time,T.Name,T.Target,T.Quantity,T.Unit,[T.TotalPrice.Sum]/[T.Quantity.Sum],[T.TotalPrice.Sum]:(ITT= Bhadhella Purchases)}



[Metro Purchases report:1,1,2,2, 1,1,1, 1]

   >>Invoice|Time|Product|Target|Quantity|Unit|Amount
{REPORT INVENTORY TRANSACTION DETAILS:D.Description,T.Time,T.Name,T.Target,T.Quantity,T.Unit,[T.TotalPrice.Sum]/[T.Quantity.Sum],[T.TotalPrice.Sum]:(ITT= Metro Purchases)}

#2

I managed to do what I asked for, I will post it shortly just in case someone need it :slight_smile:


#3

Hi Castech post it am in need of it thanks


#4

Hey, did you get the solution?


#5

Yes, I have created suppliers as entities and it’s easy to report that way. I WILL SHARE WITH YOU WHEN I GET TO MY LAPTOP


#6

ok @Castech ,Thanks I ll test out


#7

Hi, any feedback sir?


#8

Haven’t gotten time to prepare the steps. Have been busy with something lately but I will try this week


#9

ok,thanks will be waiting


#10

exelent ill be watting too