<!-- wbcprint:header1 -->
SetFont('Arial','',8)
SetDrawColor(128,128,128)
SetFillColor(255,255,255)
Cell(80,4,'Inventurliste',1,0,'L',0)
Cell(20,4,'{app.datum}',1,0,'L',0)
Cell(20,4,'Seite '.$this->PageNo(),1,0,'L',0)
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
Cell(70,4,'{firma}',1,0,'L',0)
<!-- wbc:end -->
Ln()
Ln()
SetDrawColor(128,128,128)
SetFillColor(204,204,204)
Cell(25,5,'Artikel-Nr',1,0,'L',1)
Cell(60,5,'Bezeichnung/Text',1,0,'L',1)
Cell(20,5,'Sollbestand',1,0,'R',1)
Cell(20,5,'Istbestand',1,0,'R',1)
Cell(20,5,'von Datum',1,0,'C',1)
Cell(20,5,'Abweichung',1,0,'R',1)
Cell(25,5,'Lagerwert',1,0,'C',1)
Ln()


<!-- wbcprint:header2 -->
SetFont('Arial','',8)
SetDrawColor(128,128,128)
SetFillColor(255,255,255)
Cell(80,4,'Inventurliste',1,0,'L',0)
Cell(20,4,'{app.datum}',1,0,'L',0)
Cell(20,4,'Seite '.$this->PageNo(),1,0,'L',0)
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
Cell(63,4,'{firma}',1,0,'L',0)
<!-- wbc:end -->
Ln()
Ln()
SetDrawColor(128,128,128)
SetFillColor(204,204,204)
Cell(25,5,'Artikel-Nr',1,0,'L',1)
Cell(60,5,'Bezeichnung/Text',1,0,'L',1)
Cell(20,5,'Sollbestand',1,0,'R',1)
Cell(20,5,'Istbestand',1,0,'R',1)
Cell(20,5,'von Datum',1,0,'C',1)
Cell(20,5,'Abweichung',1,0,'R',1)
Cell(25,5,'Lagerwert',1,0,'C',1)
Ln()
Cell(25,5,'Übertrag',1,0,'L',1)
Cell(60,5,'',1,0,'L',1)
Cell(20,5,'',1,0,'R',1)
Cell(20,5,'',1,0,'R',1)
Cell(20,5,'',1,0,'C',1)
Cell(20,5,'',1,0,'R',1)
Cell(25,5,$this->GetVar("zsumme1","wrg"),1,0,'R',1)
Ln()


<!-- wbcprint:footer2 -->
SetFillColor(204,204,204)
Cell(25,5,'Übertrag',1,0,'L',1)
Cell(60,5,'',1,0,'L',1)
Cell(20,5,'',1,0,'R',1)
Cell(20,5,'',1,0,'R',1)
Cell(20,5,'',1,0,'C',1)
Cell(20,5,'',1,0,'R',1)
Cell(25,5,$this->GetVar("zsumme1","wrg"),1,0,'R',1)

<!-- wbcprint:footer3 -->
SetFillColor(204,204,204)
Cell(25,5,'Summen',1,0,'L',1)
Cell(60,5,'',1,0,'L',1)
Cell(20,5,'',1,0,'R',1)
Cell(20,5,'',1,0,'R',1)
Cell(20,5,'',1,0,'C',1)
Cell(20,5,'',1,0,'R',1)
Cell(25,5,$this->GetVar("zsumme1","wrg"),1,0,'R',1)


<!-- wbcprint:body -->
<!-- wbc:begin table="inventory as b left join items as a on a.pid=b.pid left join itemcats as c on c.rid=b.rid" select="b.*,a.produktid,a.parentid as parentvar,a.bezeichnung,c.bezeichnung as catname" where="b.pid>0" order="a.produktid" -->
SetDrawColor(128,128,128)
Cell(25,5,'{a.produktid}',1,0,'L',0)
CellMax(60,5,'<!-- wbcif:begin query="data" var="parentvar" value="0" operator="<" --><!-- wbc:begin table="items" where="pid={parentvar}" maxrows="1" select="bezeichnung" -->{bezeichnung} <!-- wbc:end --><!-- wbcif:end -->{a.bezeichnung}',1,0,'L',0)
Cell(20,5,'{abestand:num}',1,0,'R',0)
Cell(20,5,'{ibestand:num}',1,0,'R',0)
Cell(20,5,'{adatum:datum}',1,0,'C',0)
SaveVar("idiff",{ibestand:num}-{abestand:num},0)
Cell(20,5,$this->GetVar("idiff","num"),1,0,'R',0)
SaveVar("wert",{abestand:num}*{b.iek:num},0)
SaveVar("zsumme1",{abestand:num}*{b.iek:num},1)
Cell(25,5,$this->GetVar("wert","wrg"),1,0,'R',0)
SaveVar("anzitem",1,1)
Ln()
<!-- wbc:end -->