00:08When we monitor our inventory with the report
00:14on the inventory stack status by item,
00:19I'll show you what we're going to do with the inventory stack status by item.
00:31We'll show you what we want to do with the inventory stack status by item.
00:33coming na po. At pag na-receive na natin,
00:36galing on PO na column, lilipat po ito
00:37sa column ng on hand. Kaya ngayon, meron na po tayong
00:39balance na 200.
00:41Ngayon naman po, magpo-focus naman tayo
00:43sa column na on sales order.
00:45At ito po yun.
00:48Idrag natin ito, katabi
00:49ng on hand na column.
00:51Idrag natin ito, katabi ng on hand na column.
00:55Ngayon po,
00:55zero po ang on sales orders.
00:57Paano natin ito gagamitin? Base po sa title
00:59ng column na ito, sales order.
01:02Kaya sigurado ako
01:03nahulaan na ninyo kung anong transaksyon
01:05yung gagamitin natin. At ang transaksyon
01:08na ito ay makikita sa homepage sa section
01:09ng customers, ang sales orders.
01:13Sa ating
01:13previous lesson, pinakita ko po paano
01:15gamitin ng sales orders at kung anong
01:17function ito. Ginagamit natin ito
01:19para kunin yung mga purchase orders ng ating mga
01:21customers. Open natin.
01:25Kaya gagawa tayo ng sales orders para
01:27magamit natin yung column ng on sales orders.
01:30Kunwari pipiliin ko si company customer for
01:33nabibili ng chicken egg tray na small.
01:36Kunwari
01:38150 pieces.
01:40Kaya 150
01:41times 6
01:43equals
01:44900.
01:45Save nyo na natin.
01:47At ayun po.
01:49Meron na po tayong sales orders ng 150.
01:52Close na natin.
01:53Pero bago natin ito i-close,
01:54kung matatandaan nyo po yung lesson natin sa
01:56sales orders, meron po itong reports.
01:57Dito sa reports, tapos sales,
02:01tapos
02:02open sales orders by customer,
02:04at open sales orders by item.
02:07By item yung pipiliin natin kasi
02:09nakafocus tayo sa inventory.
02:12Makikita po natin sa open sales order sa
02:14report yung quantity
02:15ng ating pending
02:17na sales order sa ating customer.
02:24Pareho quantity natin sa ating report.
02:27Refresh lang natin
02:28sa ating inventory
02:29stock status by item.
02:31Kasi yung sales orders natin na
02:32column or yung
02:33column natin
02:34na on sales orders,
02:35meron na pong 150.
02:38Kaya asahan po ninyo
02:39na pareho po yung quantity
02:40ng open sales orders
02:41at inventory
02:42stock status by item
02:43na on sales order na
02:44column.
02:47Close muna natin to
02:48para walang distraction.
02:51Kaya dahil po sa
02:52transaction ng sales orders,
02:53meron na po tayong 150
02:54dito sa column
02:55ng on sales orders.
02:57At kung makikita ninyo
02:58yung on hand natin,
02:59200 pa rin.
03:01Bakit ganun?
03:02Kasi nga po
03:03ang ating sales orders
03:04ay parang purchase orders din,
03:06hindi pa po to final
03:07hanggat hindi po natin
03:08nare-receive.
03:08Pending pa po ito
03:09or non-posting pa.
03:11Pero gamit po
03:12ang report na
03:13inventory stock status
03:13by item,
03:14nakikita po natin dito
03:15kahit pending
03:16or non-posting po
03:17yung transaction natin
03:18which is ang sales order.
03:20Kaya ngayon,
03:21alam natin
03:21na meron pong pending
03:22na kailangan lumabas
03:23na 150 na quantity
03:25para po sa ating
03:26chicken egg tray na small.
03:29Subukan na natin ito
03:30iserve sa ating customer
03:31gamit ang
03:31create invoice.
03:34I-minimize muna natin
03:34itong report na ito
03:36at i-close na rin natin
03:37itong sales orders
03:38kaya po dito sa homepage
03:39sa section ng customers
03:40galing pong sales orders
03:42i-click natin
03:42itong create invoices.
03:47Piliin natin
03:47si company customer 4
03:49na merong sales orders.
03:50Ayan po
03:51na-detect ni QuickBooks.
03:52Click lang natin
03:53tapos
03:54click OK.
03:55OK lang ulit
03:56at ayan po.
03:58I-receive natin ito
03:59in full.
04:02Save in you.
04:03No lang.
04:04At ayun na po.
04:06Na-receive na natin.
04:09Tapos yung sales orders
04:10nito
04:12invoice in full na.
04:14Palikan natin
04:15yung ating report
04:16sa ating inventory
04:17status by item.
04:19At makikita po natin
04:20dito
04:20na wala na po
04:21yung 150
04:21dito sa on sales orders
04:23na column
04:23at yung 200
04:24dito sa on hand
04:25naging 50 na lang.
04:27Bumawas pala
04:28yung 150
04:28sa 200
04:29dito sa ating on hand
04:30kaya 50 na lang po
04:31yung natira.
04:32Kanina po
04:33na merong 150
04:34dito sa on sales orders
04:35pending pala yun
04:36na babawa
04:37sa ating on hand.
04:38Kaya po
04:38nung sinerve na natin
04:39gamit ang create invoice
04:40doon na po
04:41na finalize
04:42at bumawas na po
04:43sa ating 200
04:43yung on hand
04:4450
04:44dito sa on sales orders.
04:46Kaya po
04:47sasabihin ko ulit
04:48dito po sa ating report
04:49na inventory
04:50status by item
04:51makikita po natin
04:52yung mga pending
04:52na incoming inventory
04:53balance
04:54at yung mga
04:55outgoing na inventory
04:56balance
04:56sa ating mga
04:57inventory type
04:58na items.
04:59Kaya ngayon
04:59alam na natin
05:00yung on hand
05:01on PO
05:01at on sales orders
05:02na column
05:03dito sa ating report
05:04na inventory
05:04status by item.
05:06Dito din po
05:07sa ating homepage
05:08section ng company
05:09pag i-open natin
05:11ang inventory center
05:14pwede din po
05:15natin ilabas
05:16yung column
05:17ng on sales orders.
05:18I-right click lang po natin
05:20kahit sa white spot
05:21tapos
05:22click natin
05:23ang customize columns
05:26hanapin po natin
05:27sa available columns
05:28yung quantity
05:30on sales order
05:32i-add natin to
05:34tapos
05:35move up natin
05:35katabi ng
05:36quantity on
05:37purchase orders
05:39tapos click natin
05:40yung ok
05:40maximize natin
05:42adjust ko lang
05:42sandali
05:45alam ninyo
05:45itong type
05:46total inventory center
05:47naman to
05:47at alam natin
05:48na inventory type
05:49to lahat
05:49tanggalin na lang
05:50natin
05:50para lumuwag
05:52tayo
05:57kaya ngayon
05:58meron na tayong
05:58on hand
06:00on purchase order
06:01at on sales order
06:04sa inventory center
06:06which is
06:07pwede din po
06:07sa items and services
06:09or item list
06:11tapos click lang po tayo
06:13sa white space
06:15tapos
06:17customize columns
06:20dito po sa
06:21available columns
06:22hanapin natin
06:22yung on sales order
06:25add natin
06:26tapos move up
06:28click ok
06:32on hand
06:33on purchase orders
06:35on sales orders
06:36dito sa item list
06:37magkaiba din o
06:38on sales order lang
06:39pero sa inventory center
06:44may quantity po
06:46yung on sales order
06:52item list
06:52on sales order lang
06:53tama nga naman
06:55kasi ito pong item list
06:56composed po of
06:56inventory items
06:57at non-inventory items
06:59kaya po hindi kailangan
07:00yung quantity
07:00sa on sales orders
07:01dito lang po
07:04sa inventory center
07:12kaya yun po
07:12ang gamit
07:13ng on sales orders
07:14na column
07:15sa ating report
07:16na inventory stack
07:16status by item
07:19side by side po
07:20ang on PO
07:20on sales orders
07:21at on hand
07:25by the way
07:26kung hindi nyo po
07:26makita
07:27yung on sales orders
07:28na column
07:30puntala po kayo
07:30sa menu bar
07:31by clicking edit
07:32tapos preferences
07:36tapos dito po
07:37sa left side
07:38ng preferences
07:38na window
07:39i-click po natin
07:40itong items
07:40and inventory
07:44tapos pag
07:44na-highlight na po
07:45ng green
07:46galing pong
07:46may preferences
07:47lipat po tayo
07:48sa company preferences
07:51baka po
07:51hindi nakacheck
07:52itong quantity
07:53on sales orders
07:56kasi po
07:57kung naka-uncheck ito
08:05wala po tayo
08:05makikita
08:06na on sales orders
08:07na column
08:10sa ating report
08:11na inventory stack
08:12status by item
08:13kaya para
08:14magkaroon tayo
08:14ng column
08:15na on sales orders
08:16punta lang po tayo
08:17sa menu bar
08:17by clicking edit
08:18tapos preferences
08:21items and inventory
08:23tapos may preferences
08:25lipat tayo
08:25sa company preferences
08:28tapos i-check po
08:29itong quantity
08:29on sales orders
08:32ok lang
08:37balik tayo
08:38sa ating report
08:39sa inventory
08:40stack status
08:40by item
08:43at ayun po
08:44bumalik na po
08:44yung column
08:44ng on sales order
08:47tandaan pa rin nyo po
08:48itong re-rearrange
08:49para
08:49kung ano po yung priority
08:51or gusto nyo i-compare
08:52sa on PO ba
08:53or on sales orders
08:56ayan po
08:57pwede
08:57on PO muna
08:59tapos
08:59on hand
09:00then
09:00on sales orders
09:01kasi yung on PO
09:03papasok
09:03then
09:04nung pumasok
09:04meron na tayong balance
09:05sa on hand
09:06then
09:06ilalabas po ito
09:07sa ating mga customers
09:08gamit ang sales order
09:10ka pumasok
09:10ka pumasok
09:13jen
09:13ka pumasok
09:14punasok
09:14ako
09:15ka
09:15pinasok
09:15ka
09:15pa
09:15mäng
09:15ka
09:15ka
09:15ka
09:15ka
09:15ka
09:15ka
Comments