MouseTrack

MouseTrack

Mouse Track KZread channel will provide IT, Software related tips and tricks with Malayalam narration and in most cases with English Subtitles. Tutorials mainly include Excel, Odoo ERP, Other Software related Technical Matters

You may contact me at :
facebook.com/sirajsap
wa.me/919544104624

get customer statements

get customer statements

Пікірлер

  • @sahimsj5014
    @sahimsj501412 күн бұрын

    ❤❤❤

  • @mariajc4286
    @mariajc428612 күн бұрын

    In accounting module, the vendors and customer different will combine together. Wht will be the solution

  • @AkshayRamachandran-no2qr
    @AkshayRamachandran-no2qr14 күн бұрын

    sir cheytha odoo app video kandirunu instal cheyan nokitu nadakunilla database create entho prb uld help cheyamoo🙂🙂

  • @MouseTrack
    @MouseTrack13 күн бұрын

    More details about the issue please...

  • @AkshayRamachandran-no2qr
    @AkshayRamachandran-no2qr12 күн бұрын

    @@MouseTrack data base prb ayirnu solve cheythu thank you for the replay

  • @mariajc4286
    @mariajc428619 күн бұрын

    Ewaybill acknowledge no egane generate cheyyam

  • @MouseTrack
    @MouseTrack19 күн бұрын

    Can you explain more about your doubt?

  • @mariajc4286
    @mariajc428619 күн бұрын

    @@MouseTrack tallyil sales invoice create cheyyumbol nmmle ewaybill acknowlegement no enter cheyyumello. Odooil ath egane cheyyunnthua

  • @mariajc4286
    @mariajc428622 күн бұрын

    Eway bill no invoice egane add cheyyamoi

  • @mariajc4286
    @mariajc4286Ай бұрын

    Tally erp9il nmml different companyies cheyyunnthua poley ithil igane companies create cheyyunnthua

  • @MouseTrack
    @MouseTrackАй бұрын

    Yes, yo can create many companies. Go to settings ► General Settings ► Manage Companies ► New Then you must provide all the details, create chart of account or get one from odoo itself... Hope you understand

  • @shinojmknr8041
    @shinojmknr8041Ай бұрын

    Bank Reconciliation cheyyamo sir ❤

  • @mohamediqbal.p7622
    @mohamediqbal.p7622Ай бұрын

    നമ്പർ തരുമോ

  • @MouseTrack
    @MouseTrackАй бұрын

    9544104624

  • @mohamediqbal.p7622
    @mohamediqbal.p7622Ай бұрын

    എനിക്ക് online ആയി odoo പഠിക്കണം

  • @user-on2xh5jb2o
    @user-on2xh5jb2o2 ай бұрын

    set explaination

  • @MouseTrack
    @MouseTrack2 ай бұрын

    Thanks dear

  • @NasiKhaisha
    @NasiKhaisha2 ай бұрын

    can you explain how to make a payment of landing cost by pettycasah

  • @jamshikst9049
    @jamshikst90492 ай бұрын

    Bro plss make one vedeo journal entries and bank reconciliation odoo17

  • @Uwaisuk
    @Uwaisuk3 ай бұрын

    Really helpful thank you 🙏

  • @Uwaisuk
    @Uwaisuk3 ай бұрын

    Appo eth employide ledgeril effect aaville?

  • @Uwaisuk
    @Uwaisuk3 ай бұрын

    Hi

  • @Kris_Angelo
    @Kris_Angelo3 ай бұрын

    Thanks.. was very helpful. It seems like Odoo no longer has a reconciliation report. Is there a workaround in V17?

  • @Samu-gz3qj
    @Samu-gz3qj3 ай бұрын

    Boss learn Power Query😊

  • @rashidrosh
    @rashidrosh3 ай бұрын

    Nice video

  • @MouseTrack
    @MouseTrack3 ай бұрын

    Thank you ♥️

  • @faisaluddin2168
    @faisaluddin21683 ай бұрын

    THANKS A LOT..

  • @jishadsign7973
    @jishadsign79733 ай бұрын

    2 item 10 qty order ചെയ്തു,ഒന്നാമത്തെ item 10 qty സ്റ്റോറിൽ receive ചെയ്തു രണ്ടാമത്തെ item പിന്നെ വരും അപ്പോൾ എങ്ങനെ ആണ് grn enter ചെയ്യേണ്ടത്

  • @MouseTrack
    @MouseTrack3 ай бұрын

    In the Goods Receipt windows, make the second item's quantity 0, and proceed... See the below image after making second item rcvd qty zero proceed, then when asked choose "Create backorder" if you will receive it later, else if it will finish that process, choose no backorder ibb.co/ftDw9FX

  • @jishadsign7973
    @jishadsign79733 ай бұрын

    @@MouseTrack thanks

  • @aswathyvr7165
    @aswathyvr71654 ай бұрын

    Qty eganaya ariyunne

  • @MouseTrack
    @MouseTrack4 ай бұрын

    kzread.info/dash/bejne/nmegptCweLW5kdo.html Go to inventory > products > products (and select list view)

  • @aswathyshara6637
    @aswathyshara66374 ай бұрын

    Thanks Sir

  • @ramkmusics1998
    @ramkmusics19985 ай бұрын

    ❤️🙏

  • @Rey-gh3sm
    @Rey-gh3sm5 ай бұрын

    watching in 2024

  • @MouseTrack
    @MouseTrack5 ай бұрын

    Still that app works fine... 👍🏻👍🏻

  • @shajimonmk3990
    @shajimonmk39905 ай бұрын

    Office expense entry, with mentioned vendor

  • @JeniSudhi
    @JeniSudhi5 ай бұрын

    Type chaidha unicode copy paste cheyumbol letters full marunuu

  • @MouseTrack
    @MouseTrack5 ай бұрын

    Make sure you have installed the fonts. Install unicode fonts, like nota sans malayalam etc and try

  • @sahimsj5014
    @sahimsj50145 ай бұрын

    ❤❤

  • @kripakrishnan961
    @kripakrishnan9615 ай бұрын

    Sir,, bank reconciliation cheyyamo

  • @user-on2xh5jb2o
    @user-on2xh5jb2o5 ай бұрын

    please requesting for the payroll module

  • @MouseTrack
    @MouseTrack5 ай бұрын

    Next will try Payroll

  • @user-on2xh5jb2o
    @user-on2xh5jb2o5 ай бұрын

    thank you

  • @MouseTrack
    @MouseTrack5 ай бұрын

    The below transaction will be trying now in this video 1) Parent company provides Rs 10000 as petty cash 2) Receives rent bill from ABC Real Estate for RS 75600 for 12 months from Dec, Rs 25200 as main offic rent Rs 25200 as warehouse rent Rs 25200 as sales depo rent 3) Parent company pays the above rent bill of Rs 75600 All the transactions happens on 11 Dec 2023

  • @sahimsj5014
    @sahimsj50145 ай бұрын

    ❤❤❤

  • @abduraheem.c1566
    @abduraheem.c15665 ай бұрын

    hello sir thank u for ur effort, i mean " UPI/IOBA/400116319452/raheem C/UPI/AXIe1d90c0285f146aeb72fd10957adcb9e/meghachanayil@ " ingane varunnathil ninnum 12 digits upi ref no engane separate cheyyum ennathanu...😊 eg ivide 400116319452 enna number engane separate cheyyum ennathanu.. i hope ur valuable reply😊

  • @MouseTrack
    @MouseTrack5 ай бұрын

    *********** the vba code by chat gpt is below ******* Sub ExtractWordsWithAtSign() Dim ws As Worksheet Dim lastRow As Long Dim i As Long Dim description As String Dim words() As String ' Set the worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your actual sheet name ' Find the last row with data in column B lastRow = ws.Cells(ws.Rows.Count, "B").End(xlUp).Row ' Loop through each row For i = 2 To lastRow ' Assuming data starts from row 2 description = ws.Cells(i, 2).Value ' Get the description from column B ' Check if the description contains "@" sign If InStr(description, "@") > 0 Then ' Split the description into words words = Split(description, " ") ' Loop through each word For Each word In words ' Check if the word contains "@" If InStr(word, "@") > 0 Then ' Copy the word to column E ws.Cells(i, 5).Value = word Exit For ' Exit the loop after finding the first word with "@" End If Next word End If Next i End Sub

  • @abduraheem.c1566
    @abduraheem.c15665 ай бұрын

    hello sir bank statementil ninnum upi number matram engane separate cheyyam ..ennulla video cheyyamo...pls

  • @MouseTrack
    @MouseTrack5 ай бұрын

    You can achieve it using VBA script if the statement can be opened in excel. Let me check to create a video

  • @abduraheem.c1566
    @abduraheem.c15665 ай бұрын

    @@MouseTrack ok thank you.. video cheyyane..

  • @MouseTrack
    @MouseTrack5 ай бұрын

    @@abduraheem.c1566 Done.. its simple if this is what you mean: kzread.info/dash/bejne/hJd_2tOfqc-4fps.html

  • @MouseTrack
    @MouseTrack5 ай бұрын

    @@abduraheem.c1566 check my channel.. already done

  • @MouseTrack
    @MouseTrack5 ай бұрын

    Batch Payments and its Voucher Printing in Odoo Most of the time companies issue cheques to a vendor against their multiple due invoices. In such cases the cheque signing authority or the top management may need to know how the value of the cheque arrives. So a statement showing all the details of selected vendor bills to be attached to cheque. So let us see in this video how to get it from odoo without any additional customization

  • @shakirasaif5377
    @shakirasaif53777 ай бұрын

    Sir kooduthal videos cheyu. Asset depreciation, Bank reconciliation Salary Ithelaam please cheyaamo

  • @MouseTrack
    @MouseTrack7 ай бұрын

    Will try to do.. Thank you...

  • @user-fi5rm9kt5e
    @user-fi5rm9kt5e7 ай бұрын

    Perfect Explanation. Do more videos.. How to do Customer and Supplier Opening balance in Odoo

  • @MouseTrack
    @MouseTrack6 ай бұрын

    Sure I will

  • @user-fi5rm9kt5e
    @user-fi5rm9kt5e7 ай бұрын

    Perfect Explanation ! Expecting more Odoo videos..

  • @MouseTrack
    @MouseTrack6 ай бұрын

    More to come!

  • @dhaneshd4599
    @dhaneshd45997 ай бұрын

    ഇത്രയും നാൾ ഈ വീഡിയോ കാണാഞ്ഞതിൽ ഖേദിക്കുന്നു... (So informative bro🤝)

  • @pramodkumarmahe
    @pramodkumarmahe7 ай бұрын

    Malayalam font cheyyan pattunnilla 😢

  • @MouseTrack
    @MouseTrack7 ай бұрын

    Download and try FML Malayalam Fonts

  • @mishabt5118
    @mishabt51187 ай бұрын

    Gstr 1,Gstr2, എന്നിവ എങ്ങനെ എടുക്കുക

  • @MouseTrack
    @MouseTrack7 ай бұрын

    Will try to do soon.. Thanks..

  • @evinpaul3796
    @evinpaul37967 ай бұрын

    Thank you❤❤❤

  • @evinpaul3796
    @evinpaul37967 ай бұрын

    Any chance to get you're number sir? I want to clear odoo doubt's

  • @MouseTrack
    @MouseTrack7 ай бұрын

    Wa.me/919544104624

  • @evinpaul3796
    @evinpaul37967 ай бұрын

    Thank you❤❤❤

  • @lijiajay476
    @lijiajay4767 ай бұрын

    ചിലക്ഷരങ്ങൾ അടിക്കുമ്പോൾ / ® എന്ന ചിഹ്നമാണ് വരുന്നത്. Meera font വച്ചാണ് ടൈപ്പ് ചെയ്യുന്നത്. ഇത് മാറ്റുവാൻ എന്താണ് ചെയ്യേണ്ടത്. ന് +ctrl+shift+1 അടിച്ചാൽ ൻ വരും പക്ഷെ എല്ലാ സമയത്തും വരുന്നില്ല. Pls. Reply.

  • @MouseTrack
    @MouseTrack7 ай бұрын

    There are a lot of Unicode Malayalam fonts by Google. Search for Noto Sans Malayalam fonts and start using it instead of meera, your issue will get solved

  • @nasrurashrd
    @nasrurashrd5 ай бұрын

    ര്‍ ] ന്‍ shift V ല്‍ shift> ണ്‍ shiftX ള്‍ shift8

  • @MouseTrack
    @MouseTrack5 ай бұрын

    @@nasrurashrd This for ASCII or ISM method of typing. For Unicode no such tricks required. Sometimes, some fonts do not show it properly, in such cases try changing to different font. Nota Sans Malayalam are good. Also, try the same in notepad instead of word. sometimes, notepadi gives you correct word, if so the problem is with word and not with the font

  • @sunilkumararickattu1845
    @sunilkumararickattu18458 ай бұрын

    Best information video ❤

  • @abdulrasheedv.a3818
    @abdulrasheedv.a38188 ай бұрын

    Thanks u bro

  • @sadasivantthankappan3695
    @sadasivantthankappan36958 ай бұрын

    നന്ദി സന്തോഷം

  • @motif6526
    @motif65268 ай бұрын

    vendors PDC payment ingane cheyyaan pato. ?

  • @MouseTrack
    @MouseTrack8 ай бұрын

    We can manage it... Wait for next video..