00:08Dito po sa QuickBooks, na-segregate natin yung mga customers natin
00:12Gamit po ang Customer Type
00:13Kung titignan natin, dito sa Homepage, sa section ng Customers
00:17Tapos i-click natin itong Customers na icon
00:22Pakikita natin dito
00:25Si Company Customer 1 at 2
00:27Meron pong Convenience slash Pharmacy na Customer Type
00:32At si Company Customer 3 naman at 4
00:34Meron ding Wholesale
00:39Ang the rest, pwede po natin lagyan
00:41Kunwari
00:43Add nyo tayo
00:47Ordinary
00:56Ayan po, so lahat po ng Customer natin meron na mga Customer Type
01:00Except lang po si Walk-in Customer
01:03Ngayon po, gusto ko lang po ipakita sa inyo na meron pa tayo isa pang klaseng classification or categorization
01:08Dito po sa ating QuickBooks, except po sa Customer Type
01:11At ang tawag dito ay Job Type
01:16Makikita pa rin natin ito sa ating Customers
01:18Kunwari, balik tayo kay Company Customer 1
01:20Right-click natin, tapos Edit Customer, colon Job
01:25Dito sa kanyang form, meron pong apat na tabs
01:27Galing pong address info, lipat tayo sa Job Info
01:31Click natin
01:33Dito naman po sa Job Info na section or na tab
01:37Meron po itong field ng Job Type
01:40At tulad ng Customer Type, meron po itong drop down arrow
01:44Click natin
01:45Dalawa po yung Job Type nito
01:46Commercial at Residential
01:49Siguro, yung mga Customer kung nakatayo sa Residential
01:53Residential ilalagay natin
01:54Kung nakatayo naman sa Commercial
01:56Or pang Commercial yung pagkakatayo niya
01:59Pwede po natin piliin yung Commercial
02:00Ngayon po, kung ayaw ninyo ng Job Type na ito
02:03Pwede nyo pong baguhin ito
02:05Kailangan lang po natin pumunta ito sa menu bar
02:07Tapos List
02:10Tapos Customers and Vendor Profile List
02:13Kung nasaan ang Customer Type List
02:15Nandun din ang Job Type List
02:19Open natin
02:20Ayun po, Commercial and Residential
02:23Itong pong Job Type
02:25Isipin nyo lang po na another classification to
02:27Or categorization sa ating mga customer
02:29Kung baga, panibagong grupo naman ito
02:31Kung gusto nyo gamitin itong Commercial or Residential na Job Type
02:34Okay din po
02:35Kung gusto nyo po itong baguhin
02:37Kayo pong bahala
02:38Pwede nyo yung tagdagan
02:39Or pawasan
02:40Or i-edit kung ayaw yung mga naka-term dito
02:43Basta kung gusto nyo ulit ma-segregate
02:45Or ma-classified
02:46Or ma-categorize yung mga customer ninyo
02:48Another level po ito ng division
02:50Pwede nyo ulit ma-categorize by Job Type naman
02:53Kunwari, itong commercial i-edit ko
02:55Baguhin ko ito kunwari, Key Accounts
02:58Ibig sabihin ng Key Accounts
02:59Sila po yung mga customer na pinapautang ng malaki
03:03Tapos, ito namang isa
03:06Regular customer
03:10Kunwari, itong mga regular customer naman
03:14Sila po yung mga malilit pa yung mga limit na mga pautang
03:17Kunwari, ganun
03:18Yun yung naisip ko
03:18Key Accounts, mga malaki na pautang
03:20Kunwari, 100,000 pataas
03:22Ito namang regular na customer
03:24Mga 30,000 pa baba
03:26Yung pwede nilang utangin sa atin
03:27Ganun lang
03:30So si company customer 1
03:31Dahil malaki business niya
03:33Key Accounts siya
03:35At ganun lang po
03:37Ganun din si company customer 2
03:40Key Accounts
03:423
03:45Key Accounts
03:464
03:50Key Accounts
03:51At ang the rest
03:54Regular na
03:58Kayo po bahala kung nung gusto nyo i-segregate
04:00Gamit po ang job type na classification or categorization
04:03Ngayon po, para malaman natin yung mga customers natin
04:06Na meron job type
04:07Pwede din po natin ilabas yung column ng ating job type
04:11Maximize natin para maklaro natin
04:13Right-click lang po kahit saan dito sa white part
04:16Tapos
04:18Customize Columns
04:22Ngayon po, tanggalin muna natin itong attach
04:26At notes
04:28Kasi pampasiki po sila
04:30Ayan po, wala na
04:32Ngayon, dito po sa available columns
04:34Hanapin natin yung job type
04:37Ayan po
04:37Job type
04:39Click natin
04:40Tapos add
04:42Katabi ng customer type
04:44Tapos
04:45Click natin ang ok
04:48Ayan po
04:49Magkatabi na
04:50Yung customer type
04:51At job type
04:54Kaya
04:55Pag magre-report tayo sa ating mga customers
04:57Pili po kayo kahit anong report sa customers
05:00Ako, sales pa rin
05:02Sales by customer summary
05:05Kung gusto nyo sa balance ng customer
05:06Okay din po
05:07Basta involve ang customer
05:09Fresh
05:10Ayan
05:10Ngayon po, pupunta ako sa customize report na button
05:13Click natin
05:15Sa window ng modify report
05:16Galing pong display na tab
05:18Lipa tayo sa filters
05:21Tapos
05:23Ang isasearch naman natin dito ngayon
05:25Job type
05:26So job type po, yung pipiliin natin
05:28Pag na-highlight na po ng green
05:31Lipa tayo dito sa job type
05:32Na mayroong drop down arrow
05:34Tapos pili tayo
05:35Kunwari, key accounts
05:37Click natin
05:40Then click ok
05:41At ayun lang po
05:43Yung mga customer lang po
05:44Na nilagay natin ng key accounts
05:45Yung lalabas dito
05:46Tama ba to?
05:48Check nga natin
05:54Tama po
05:57Customize ulit tayo
05:59Galing display
06:00Lipa tayo sa filters
06:03Search natin job
06:06Tapos job type
06:07Piliin natin
06:08At pag ma-highlight na
06:09Lipa tayo dito
06:10Ngayon naman
06:12Napipiliin natin
06:13Regular
06:15Pagpiliin natin
06:16Okay lang
06:18At ayun
06:19Nagbago yung ating report
06:20Jenny, Mickey
06:22At si Randy
06:24Pareho
06:26Pwede nyo rin po
06:26Pagsamahin yung job type
06:27At saka yung customer type
06:30Balik lang po tayo
06:31Sa customers report
06:57Unang-unang filter
07:00Tapos isearch natin
07:01I-search natin
07:01Si customer type
07:03Highlight natin
07:05Tapos
07:07Piliin natin
07:08Yung convenience
07:09Slash pharmacy
07:12Okay natin
07:14Yun
07:14Mas nawala pa yung dalawa
07:16At ito na lang po
07:17Dalawang natira
07:17Si company customer 1
07:18At si company customer 2
07:20So pwede nyo po
07:21Ipag-combine
07:22Yung dalawang
07:23Classification natin
07:24Or categorization
07:25Yung job type
07:26At saka yung customer type
07:27Kaya po
07:28Kung gusto nyo pang
07:29I-segregate
07:29Yung mga customers ninyo
07:31Pagkatapos gamitin
07:32Ang customer type
07:34Job type naman
07:35Another level po
07:37Nang segregation
07:37Or another level
07:39Nang classification
07:39At categorization
07:42Gamit po ang
07:42Classification natin
07:43Or categorization natin
07:45Mas madali po natin
07:46Man-narrow down
07:46Yung pag-generate
07:47Natin ng mga data
07:48At hindi po
07:49Overloaded
07:50Yung paggawa natin
07:51Ng mga reports
07:51Kaya kung gusto nyo lang
07:53Mabiew yung mga
07:53Key accounts
07:54Key accounts lang
07:55Regular
07:57Regular customer lang
07:59Gusto nyo lang
08:00Mabiew yung mga
08:00Convenience store
08:01At pharmacy
08:01Sila lang po yung lalabas
08:03Yung wholesale
08:04Sila lang
08:05Yung mga ordinary
08:06Sila lang din
08:09Kayo na pong
08:09Bahalang dumiskarte
08:10Kung anong
08:11Classification
08:11Or categorization
08:13Yung ilalagay ninyo
08:14Sa ating mga
08:14Customers
08:17Tandaan
08:17Dahil ginamit natin
08:18Sa customer
08:19Ng job type
08:19Basta po
08:20About customers
08:21Lalabas po yan
08:21Kaya po
08:22Sa ating reports
08:24Mga pa-customers
08:26And receivables man
08:27Kung walit
08:28More balance detail
08:30Pwede nyo pong gamitin
08:32Ng filters natin
08:34Ng job
08:37Or
08:39Customer type
08:42Job type
08:46Dito sa ating balance
08:47Sa ating customers
08:48Kunwari
08:49Key accounts
08:49Ito maraming balance
08:51Kasi key accounts
08:52Umuot lang ito
08:53Nang malaki
08:53O ayan
08:55Sila lang yung lumabas
08:57Bakit po sa ating sales report
09:00Pwede din
09:01Kahit itong mga items
09:02Kunwari
09:02Sales by item detail
09:06Dumita natin
09:07Ng job
09:10Kunwari key accounts
09:12Sige
09:13Regular naman
09:18Bakit gumagana
09:19Kahit all about items
09:20Yung report natin
09:21Gumagana po siya
09:22Kasi
09:24Involve po ang customer
09:25Sa mga items
09:26Na ito
09:27Key accounts tayo
09:30Ayan po
09:30Naging
09:32Company customer one
09:34One two one two
09:35Ayan po
09:36Yung ating column
09:36Sa name
09:40Job type ulit tayo
09:42Regular
09:45Ayan
09:45Sila Randy Ortiz
09:47Yung ni Ramirez
09:47Na dito sa column
09:48Natin sa name
09:51Sales by item
09:52Ito
09:52Bakit
09:52Nagagamit natin
09:53Yung mga job type
09:54At customer type
09:55Dito
09:56Gumagana po
09:57Yung mga job type
09:58At customer type
09:58Dito
09:58Dahil
09:59Involve po
10:00Ang customers natin
10:01Dahil
10:02Sila po yung bumibili
10:03Ng mga items natin
10:04Kaya po
10:05Pwede natin gamitin
10:06Sa ating mga report
10:06Sa pagbenta
10:07Sa ating mga items
10:09Benta sa mga items
10:10Gamit ang sales by item detail
10:13Benta sa mga customers
10:14Gamit ang sales by customers
10:16Summary or detail
10:19At
10:20Balances
10:22Customers and receivables
10:23Mga balance ng customer
10:26As long as
10:27Involve po ang customers
10:28Pwede nyo po
10:29Experiment
10:29Na gamitin
10:30Ang customer type
10:31At job type
10:32Dito po sa ating QuickBooks
10:34Pwede 해주es like
10:35Pwede
10:35Pwede
10:35Pwede
10:36Pwede
10:37Pwede
Comments