Query = "STNAME CNSUPPID=>^@0 & CNSUPPID<=^@1 & CNPRODTYPE="2"&((CNQTYINST+CNQTYONORD-CNQTYALLOC)<CNREOLEVEL)&CNREOQTY<>0 ORDER BY CNSUPPID+CNPRODID"
Macro = "1LU:Select from PLNAME where PNCODE=STNAME.CNSUPPID"
BreakOn = "STNAME.CNSUPPID"
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "TRIM(SYSTEM.COMPNAME)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 270
Left = -15
Top = 405
Width = 11070
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Stock Re-Order by Supplier"
Font = "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 420
Left = 135
Top = 675
Width = 11025
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "DTOC(DATE())"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 135
Top = 705
Width = 1800
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Page: "+PAGENUM()"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 9585
Top = 720
Width = 1395
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Product ID"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 30
Top = 945
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Description"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2265
Top = 945
Width = 1245
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Quantity"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4380
Top = 945
Width = 780
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "In Stock"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4380
Top = 1215
Width = 780
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Quantity"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5190
Top = 945
Width = 915
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Allocated"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5190
Top = 1215
Width = 915
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "On"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6270
Top = 945
Width = 780
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Order"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6270
Top = 1215
Width = 780
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Re-Order"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7080
Top = 945
Width = 780
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Quantity ""
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6945
Top = 1215
Width = 915
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Unit"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7890
Top = 945
Width = 510
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Supplier ID:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 30
Top = 555
Width = 1080
End
Begin Control CNSUPPID
Type = "Text"
Style = 0
Fieldname = "CNSUPPID"
Filename = "STNAME"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1080
Top = 540
Width = 1365
End
Begin Control PNNAME
Type = "Text"
Style = 0
Fieldname = "PNNAME"
Filename = "PLNAME"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2520
Top = 540
Width = 5415
End
Begin Control CNPRODID
Type = "Text"
Style = 0
Fieldname = "CNPRODID"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 30
Top = 150
Width = 1635
End
Begin Control CNDESC
Type = "Text"
Style = 0
Fieldname = "CNDESC"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1830
Top = 150
Width = 2355
End
Begin Control CNQTYINST
Type = "Text"
Style = 0
Fieldname = "CNQTYINST"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4170
Top = 150
Width = 870
End
Begin Control CNQTYALLOC
Type = "Text"
Style = 0
Fieldname = "CNQTYALLOC"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5115
Top = 150
Width = 870
End
Begin Control CNQTYONORD
Type = "Text"
Style = 0
Fieldname = "CNQTYONORD"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6060
Top = 150
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)<0),"Free Stock Exceeded",IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)=0),"Down to Zero Free Stock",IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)<STNAME.CNMINSTOCK),"Down to Min. Stock","")))"