QBE Training ERP User Training

1. QBE TrainingERP User Training

2. QBE (Query by example) • When maintain order or report generation,can use QBE to query what data you want. • QBE set conditions can be combination, not just only one condition can used in one time.

3. How to use QBE Function

4. QBE Assumption 1 • Query Order number Start from “PO01”

5. QBE Assumption 2 • Query Order number Start from “PO01” ,middle is “1312”

6. QBE Assumption 3 • Query Order number Start from “PO01” ,middle is “13” and End with ”9”

7. QBE Assumption 4 • Query Order purchase Date is 17/12/2013

8. QBE Assumption 5 • Query Order purchase Date is before “17/12/2013”

9. QBE Assumption 6 • Query Order purchase Date is After “01/12/2013” and vender is “SU00017”

10. QBE Assumption 7 • Query Order Purchase Date Period is “10/12/2013 ~ 15/12/2013” and Creator is “tiptop”

11. QBE Assumption 8 • Query Order Create Date Period is “10/12/2013 ~ 15/12/2013” , Creator is “tiptop”And the purchase item is “MISC-F01”

13. Exercise Query PR order Create by yourself Status : confirmed Stock-in Date : 011213~101213