00:08When we generate our report
00:10for our customers
00:11at our items,
00:13maybe you will be able to
00:15generate your sales report
00:17for our customers.
00:20When we generate our sales by customer summary,
00:24it's not a sort.
00:28Kung sa items naman,
00:30yes, by item summary naman tayo.
00:34Mapapansin po ninyo na
00:35nauna yung duck, which is letter D,
00:37tapos yung chicken, which is letter C.
00:40Hindi rin po siya nakasort ng tama.
00:42Base po sa ating previous lesson,
00:44baka po maisip ninyo na
00:45baka pwede nating isort by item column
00:48yung mga list natin para ma-fix yung report natin.
00:51Kunwari sa ating item list,
00:52putapot tayo sa minobar,
00:54tapos click natin ang list,
00:55tapos item list.
00:58Pero tama naman po yung arrangement dito.
01:01C, C, D,
01:04alphabetical naman.
01:06Kasi,
01:07kinlik natin yung title po ng kanyang column,
01:09which is ang item name.
01:13Ayan po,
01:14una na yung C,
01:15then D,
01:16then E.
01:18Ulitin natin yung ating report sa sales
01:21per item,
01:25summary.
01:29Ganun pa rin.
01:30Nauuna pa rin yung D bago yung C.
01:34Bago po kayo ma-stress,
01:35i-inform ko na po kayo
01:36paano natin ito maayos.
01:39Dito po kasi sa ating item list,
01:41kahit po nakasort na po yan,
01:42sa ating item name,
01:44from A to Z,
01:47tapos yung report natin
01:49regarding items,
01:50mapa salesman.
01:54Ayan po,
01:55nauna yung D bago yung C,
02:01or kahit sa ang report sa ating item,
02:03hindi po tama
02:04yung pagkakasunod-sunod.
02:06Kahit po sa ating sales by item detail,
02:09nauna po yung letter D,
02:10which is ang duck,
02:11bago po yung C,
02:12which is ang chicken.
02:15Kahit tama po yung sorting natin
02:17sa ating item list.
02:18Nauna yung C,
02:21bago yung D,
02:23hanggang E,
02:24O, P, at U.
02:29Bago po natin ito i-fix,
02:31ang toto po nangyayari nito,
02:32kahit po naka-arrange po
02:33yung mga items natin dito,
02:35alphabetically,
02:37hindi po yung toto naka-arrange.
02:38Naka-arrange lang po yan
02:40base po sa ating columns
02:41pag-click sa title nito.
02:43Pero ang totoong arrangement po
02:45sa ating item list
02:46ay ang paggamit po
02:47ng resort list.
02:48Ang resort list
02:49ay makikita po
02:50dito po sa window
02:50ng ating item list,
02:51tapos item na button.
02:57Tapos makikita po natin
02:58sa drop-down menu
02:59ng item na button,
03:01ito pong resort list.
03:04Itong resort list,
03:05special po ito kasi
03:06ito po yung official na sorting
03:07ng ating item.
03:09Pag-click natin ito,
03:11tatanungin tayo ni QuickBooks
03:12kung i-re-resort natin.
03:13I-click lang po natin
03:14ng OK.
03:15At yan po,
03:16officially,
03:17nakasort na po
03:17yung ating item list.
03:19Kaya po,
03:19kung pupunta tayo
03:20sa ating reports,
03:22sales,
03:23sa ating mga items,
03:27nauna na po
03:27yung letter C
03:28bago mag-letter D.
03:30At kahit
03:31i-rearrange pa natin,
03:33itong columns natin
03:34gamit ang title
03:35ng ating mga columns,
03:36kunwari ganito,
03:38yan,
03:38guluhin natin.
03:40Nauna na yung U.
03:41Pag-generate natin
03:42ng sales reports
03:43sa ating mga items,
03:47mapasamari or detail,
03:51nauna pa rin po yung C
03:52bago mag-D.
03:57Paano naman po
03:58sa ating mga customers?
03:59Kasi kung dito sa ating reports
04:00sa ating customers
04:01na sales,
04:04by customer summary,
04:07makikita po natin dito
04:08na hindi po nakasort
04:09yung ating mga customer.
04:11Subukan natin sa customer.
04:12Baka mayro pong
04:13resort list na option.
04:15Close mo na natin.
04:17I-click po natin
04:17itong customers na button
04:19para ma-open
04:19yung customer center.
04:25Nakasort naman dito
04:27gamit
04:28ang column title.
04:30Ayan, no?
04:31Nakasort naman natin.
04:34Pero sa reports,
04:36para sa ating customers,
04:38hindi pa rin.
04:40Para pong magamit natin
04:42yung resort na feature,
04:43click lang po kayo
04:44kahit sa white space dito.
04:46Tapos,
04:47pag right-click,
04:47hanapin natin
04:49yung resort list,
04:50which is meron po
04:51dito sa ating customer center.
04:53Mag-click natin ito.
04:55Okay lang.
04:56At ayun po,
04:57officially na resort na po ito.
04:58Tingnan natin sa ating reports,
05:00sa ating mga customers.
05:01Kahit anong reports,
05:02basta may customer tayo.
05:04Kunwari,
05:05itong sales by customer summary.
05:08Ayun po,
05:08nakasort na po siya.
05:10Kaya po,
05:11kung hindi po nakarange
05:12yung mga customer na ninyo
05:13alphabetically,
05:14kahit inayos nyo na po
05:15yung mga list nila,
05:16gamit
05:17ang column title,
05:21baka kailangan po
05:22nyong gamitin
05:22itong resort list na option.
05:25Malaking tulong po yan
05:26para ma-fix po
05:27yung sortin
05:28ng ating mga items
05:28at saka mga customers.
05:31Tau ni
05:33hata kailangan po
05:34min
05:34ating mga
05:34in
05:34ka
05:34sa ating mga
05:36ha
05:36siya
05:36namo
Comments