00:08For those who are not aware of the two reports regarding
00:13the open invoices and customer balance details,
00:22I'll show you in full detail for you to be able to make sure you are able to do it.
00:28For those who understand, please skip this tutorial for you.
00:33What we're going to do is make sure you are able to do it with customers.
00:37Let's go to the homepage of customers,
00:43Let's open customer center,
00:46let's get started with a new customer,
00:48as a new customer,
00:50Kunwari, si Miki Diaz.
00:55Tapos, click OK.
01:00Kay Miki Diaz natin gagawin yung full example.
01:05Para po umpisahan, click natin itong Create Invoices.
01:16Ang Tagwo 100 na Egg Tray.
01:20Ito po ay nakakahalaga ng 2,100.
01:26Yung kanyang invoice, baguhin natin.
01:33Bawin natin siya sa invoice.
01:35Tapos, ang date natin, February 28, 2026.
01:39Save and new.
01:41Ngayon po, i-open natin yung dalawang report natin.
01:46Customer balance detail.
01:50Open invoices.
01:55Tingnan natin, si Miki Diaz.
01:58Ayan po, 2,100.
02:01Open invoices.
02:03Ayan din po.
02:042,100.
02:07Adjust ko lang.
02:09Ayan po, 2,100.
02:13Ngayon po, magkapareho pa sila ngayon.
02:18Ayan, ulitin natin.
02:20Ito, customer balance detail.
02:25Ito, open invoices.
02:29Ayan, subukan natin mag-deceive payments.
02:36Ki Diaz.
02:38Ito yung invoice niya.
02:39Ito yung invoice niya.
02:40Check natin.
02:42Yes lang.
02:43Ngayon, ang pabayaran ko lang is 1,000.
02:50Kaya magkakaroon tayo ng underpayment na 1,100.
02:56Cash lang, then save.
02:59Cash lang, then save.
03:27Wala tayong payment na makita.
03:29Invoice lang.
03:30Yung payment, hindi lumalabas kasi settled na po yun.
03:33Kung baga, yun po yung bumawas.
03:35Nagamit lahat yung payment para mabayaran yung transaction natin na invoice.
03:39Kaya hindi na importante na makita yung payment dito.
03:43Kasi yung report natin sa open invoices, ito po yung mga hanging o yung mga hindi pa settled.
03:48Balik tayo kay Mickey Diaz.
03:50Dito makikita natin yung payment.
03:54So ngayon po, may balance pa yung ating customer na worth 1,100.
04:011,100.
04:05Mag-credit memo naman tayo.
04:06O, Mickey Diaz pa rin.
04:14Ngayon na sinuli niya, ay nagkakalaga ng 700.
04:18Return number 19.
04:21Save-in yun natin.
04:24Retain lang.
04:25Or pili kayo kahit ano, basta retain at saka apply to an invoice.
04:30Click OK.
04:31By the way, kung ayaw yung pumili dito sa tatlo,
04:34tapos pinili nyo itong X for close,
04:37or hindi nyo sinasadyang na-click itong X para i-close ng available credit na window,
04:43automatic po,
04:44pag kinlose itong window na ito,
04:46by clicking sa X,
04:49ito pong dalawa ang automatic na mapipili na option.
04:54Subukan natin.
04:56Close ko ito.
04:58Retain as an available credit po ang nangyari.
05:00Balikan natin yung ating reports.
05:04Customer balance detail.
05:06May lumabas na credit memo.
05:12Sa open invoices.
05:14May lumabas din na credit memo.
05:20Pareho po ulit sila.
05:25400 yung ending balance sa ating open invoices.
05:28400 din ang ending balance sa customer balance detail.
05:35Ngayon po, magkaiba pa rin sila.
05:37Nandito yung payment,
05:38dito wala,
05:39pero yung credit memo lumabas.
05:41Ngayon po,
05:42lumabas ang credit memo
05:44ni Mickey Diaz dito po sa open invoices
05:46dahil hindi pa po natin ito na-apply
05:48or naliles sa mga invoices
05:50gamit ang receive payments
05:52or sa loob ng credit invoice.
05:55Dito naman,
05:56sa customer balance detail,
05:58talagang lalabas ang credit memo.
06:00At kung makikita ninyo,
06:02binawas na rin ito
06:03sa last balance niya ng 1,100.
06:06Sa open invoices naman,
06:09nakabawas na rin,
06:10pero nagre-reflect yung credit memo.
06:13Indicating,
06:14o ibig sabihin,
06:15na hanging pa itong credit memo.
06:17Hindi pa ito nagagamit
06:18or hindi pa ito nasasettle.
06:20Kung maga,
06:21pending pa itong credit memo
06:22na gamitin
06:23para sa mga invoices
06:24sa loob ng credit invoice
06:26or sa loob ng receive payments.
06:28Ano mangyayari
06:29pag in-apply na natin yung credit memo
06:31para bumawas
06:32sa mga existing balance
06:33ni Mickey Diaz?
06:35Gamitin natin
06:36itong credit invoices.
06:38Balikan natin yung last transaction natin.
06:43Ito po yun,
06:43si Mickey Diaz
06:44na may SI number 18.
06:48I-click natin
06:49ang apply credits.
06:53At yung credit memo niya
06:54na 700.
06:56Gamitin natin ang buho
06:57itong 700.
07:00Click natin yung done.
07:03Tapos save.
07:04And you.
07:06Ang nangyari po
07:07sa ating report
07:07sa open invoices
07:08kay Mickey Diaz,
07:11nawala yung credit memo.
07:12Nawala
07:13kasi ginamit natin lahat.
07:15Nung ginamit natin lahat,
07:16huli settle na siya.
07:17Kaya hindi niya na kailangan
07:18makita
07:19dito sa ating report
07:20sa open invoices.
07:25Pero yung kanyang invoice,
07:26nabawasan.
07:27Naging 400 na lang.
07:29Pero kahit nabawasan ito,
07:30may balance pa rin.
07:31Kaya kahit piso na lang
07:32natitira sa inyong invoice,
07:34magre-reflect
07:35at magre-reflect pa rin
07:36dito sa ating report
07:37na open invoices.
07:42Yung 2,100 na original amount
07:44ng ating invoice,
07:45unti-unti nang lumiliit.
07:46Pero kahit gano'ng pakaliit yan,
07:48hanggang hindi fully paid,
07:49magre-reflect pa rin
07:50sa ating report
07:51na open invoices.
07:54Dito naman sa ating
07:55customer balance detail,
07:58nandun pa rin yung
07:59credit memo.
08:01Tapos nakabawas din siya.
08:02At tama yung ending balance,
08:03400 din,
08:04dahil pareho sila ni
08:06ni Mickey Diaz
08:07dito sa open invoices,
08:09400 din.
08:12Ano pa kasing nanggayari?
08:13Ganito po,
08:14sa open invoices,
08:15hanggang hindi settled,
08:17kahit piso na'y
08:18natitira sa ating
08:19balance sa customer,
08:20mananatili dito
08:21naka-reflect.
08:22At yung mga transaction
08:23na payment at credit memo,
08:24kung nagamit lahat,
08:26ibig sabihin,
08:26hindi na kailangan
08:27mag-reflect dito
08:28kasi nagamit na lahat.
08:30Ang pinagkaiba po nila,
08:32si customer balance detail
08:33ay nagiiwan
08:34ng mga trace
08:35ng transaction,
08:36kung ano yung mga event
08:37o yung mga ganap
08:38sa transaction
08:39ni Mickey Diaz.
08:42Dito naman
08:43sa open invoices
08:44ni Mickey Diaz,
08:45wala po itong trace
08:46ng mga transaction.
08:48Trace lang po ito
08:49ng mga unsettled transaction,
08:50yung mga hindi pa
08:51fully paid
08:52or fully settled.
08:54Ganun lang pong
08:55pinagkaiba nila.
08:56Kaya po,
08:57kung meron kayo
08:57nakikita ng credit memo
08:58dito kay Mickey Diaz,
09:00pero dito kay Mickey Diaz
09:01na open invoices
09:02na report,
09:03wala.
09:04May iisip ninyo na,
09:05ah,
09:06nagamit atong credit memo
09:07na ito
09:08or fully settled na
09:10yung credit memo
09:11na naka-indicate
09:11sa ating report
09:12sa customer balance detail.
09:18Kaya po,
09:18kung gusto ninyo malaman,
09:19kunwari dito kay
09:23Company Customer Tree,
09:24ang daming transaction nito,
09:26saan dito ang settled na,
09:28saan dito ang hindi pa,
09:29at nasaan dito,
09:30yung mga partial pa lang.
09:33Kung titina natin
09:34sa open invoices
09:35kay Company Customer Tree,
09:38ito na lang pala
09:39yung mga
09:39unsettled na
09:40transaction.
09:44Mapapaisip siguro kayo,
09:46hindi na siguro
09:46importante itong
09:47customer balance detail
09:48or itong
09:49open invoices.
09:50Dahil makikita naman lahat
09:52sa customer balance detail
09:53yung ganito,
09:53sa open invoices
09:54yung mga ganito,
09:55hindi po,
09:56pareho po yung importante.
09:59Ang open invoices,
10:00magagamit natin
10:01para sa mga unsettled,
10:02at least alam natin
10:03yung mga,
10:03kailangan natin
10:04isettle ng mga
10:04transaction sa ating customer.
10:06Ang customer balance detail
10:07naman,
10:08magagamit natin ito
10:08pang trace
10:10sa mga ganap
10:11or event
10:12sa mga transaction
10:12natin sa ating mga
10:13customers.
10:15Isettle na po natin
10:16itong invoice
10:17ni Mickey Diaz
10:18na 400.
10:21Punta tayo
10:22ng receive payments.
10:29A venue in full.
10:35Punta tayo
10:36sa customers and receivables
10:37tapos customer balance detail.
10:42Makikita natin
10:43si Mickey Diaz
10:46na zero balance na.
10:55Dito naman sa ating
10:56open invoices,
11:02hindi na natin
11:03makikita
11:04si Mickey Diaz
11:07dahil fully settled na siya
11:08at wala nang
11:10unsettled transaction.
11:12Hindi na kailangan
11:12i-reflect yung account
11:13ni Mickey Diaz
11:15dito sa ating
11:15open invoices
11:16dahil fully settled na siya.
11:19Pero dito sa ating
11:20customer balance detail
11:22kahit fully settled na
11:23si Mickey Diaz
11:25nandito pa rin
11:26yung mga
11:26trace
11:27ng mga transaction niya
11:28hanggang maging zero.
11:30Kasi
11:31kasi po
11:32ito po yung mga ganap
11:33or mga event
11:33simula nung
11:34nag-invoice tayo
11:35at ganun din
11:36sa ating mga iba
11:37pang customer.
11:43Ito si
11:43company
11:44customer tree
11:44simula
11:45nung February 15
11:46yun po yung mga
11:47transaction niya
11:47tapos
11:48ito po yung
11:48February 22
11:49na transaction.
11:51Kaya po
11:52importante yung
11:53dalawang report na ito.
11:55Open invoices
11:56para malaman
11:57yung mga
11:57unsettled transaction
11:58at malaman natin
11:59yung mga kailangan
12:00i-settle.
12:03Customer balance
12:04detail naman
12:05yung detali po
12:06ng mga event
12:07or ganap
12:08sa mga transaction
12:09ng ating mga
12:09customers.
12:10Magagamit po natin
12:11ito
12:11pag-trace
12:13ng mga transaction
12:14at magagamit din
12:15ito
12:15para sa ating
12:17statements.
12:19Dahil ang statements
12:20ay pareho din
12:21sa ating report
12:23ng customer balance
12:23detail.
12:25Kaya ganun lang po
12:26ang simple
12:26pagkakaiba
12:27ng ating reports
12:27sa open invoices
12:29at customer balance
12:30detail.
12:35kaya ganun langbook
12:35pagkakaipa
12:35kaya
12:35mga
Comments