qbe training erp user training n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
QBE Training ERP User Training PowerPoint Presentation
Download Presentation
QBE Training ERP User Training

Loading in 2 Seconds...

play fullscreen
1 / 13

QBE Training ERP User Training - PowerPoint PPT Presentation


  • 210 Views
  • Uploaded on

QBE Training ERP User Training. 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. How to use QBE Function. QBE Assumption 1.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'QBE Training ERP User Training' - wayne-kim


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
qbe query by example
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.
qbe assumption 1
QBE Assumption 1
  • Query Order number Start from “PO01”
qbe assumption 2
QBE Assumption 2
  • Query Order number Start from “PO01” ,middle is “1312”
qbe assumption 3
QBE Assumption 3
  • Query Order number Start from “PO01” ,middle is “13” and End with ”9”
qbe assumption 4
QBE Assumption 4
  • Query Order purchase Date is 17/12/2013
qbe assumption 5
QBE Assumption 5
  • Query Order purchase Date is before “17/12/2013”
qbe assumption 6
QBE Assumption 6
  • Query Order purchase Date is After “01/12/2013” and vender is “SU00017”
qbe assumption 7
QBE Assumption 7
  • Query Order Purchase Date Period is “10/12/2013 ~ 15/12/2013” and Creator is “tiptop”
qbe assumption 8
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”
exercise
Exercise

Query PR order

Create by yourself

Status : confirmed

Stock-in Date : 011213~101213