Custom Report P&L profit and loss

Version 4
16

I don’t understand participation sales but for the rest I’ve prepared something with V5.

Pasted image2560×1600 226 KB 

[PL Report:5, 3, 3, 3, 3, 3, 3, 3]
>Name|Qty|Sales|Cost|Cost%|PM%|PM|P%
{REPORT COST DETAILS:[C.Name]+'.'+[C.PortionName],
C.Quantity.Sum,
[([C.AvgPrice]*[C.Quantity]).Sum],
[([C.Cost]*[C.Quantity]).Sum],
[($4/$3)];%##.00;-%##.00,
[($3-$4)/$3];%##.00;-%##.00,
[($3-$4)];#.00,
[(($3-$4)/$4)];%##.00;-%##.00}`
3 Likes