Consolidating Invoices in Business Central
7:29
Eliminations in Business Central
10:47
Notifications in Business Central
10:22
Пікірлер
@HannoNiemeijer-wc2gb
@HannoNiemeijer-wc2gb Сағат бұрын
Unluckely the functionality that was available in many countries as a local functionality (apply G/L entries), that also provides a remaining amount for entries that cannot be applied fully in a particular period has vanished with the introduction of this functionality. I looks like MicroSoft does not have too much knowledge of financial flows, assuming this can just replace that functionality
@MarieBailey-v2d
@MarieBailey-v2d 3 күн бұрын
Timely that you have created this video. We are currently looking at options to create consolidated invoices for our customers on a monthly basis. The Shopify connection as standard will create an invoice for each order, but we're looking for a way to combine them and only send 1 invoice per month. Is there any functionality in BC to do that?
@gurdeepbahra6843
@gurdeepbahra6843 3 күн бұрын
@MarieBailey-v2d hey Marie! Good to hear from you! Honest answer is I'm not sure, but after having a quick look - you could potentially use the Shopify functionality to create sales orders, then once they have been shipped you could use the get shipment lines function on a sales invoice. There is another function which may be useful called "combine shipments", it's on my list of videos to record so watch this space!
@gurdeepbahra6843
@gurdeepbahra6843 2 күн бұрын
@@MarieBailey-v2d check out this video Marie, it may help with the issue you mentioned above - i hope it does!!! kzbin.info/www/bejne/b6Orhp2EfKqMmLssi=GN6OmCGKOss9gJ9G
@hagitns
@hagitns 6 күн бұрын
Excellent and helpful
@gurdeepbahra6843
@gurdeepbahra6843 6 күн бұрын
@hagitns thank you for this lovely feedback! If you can think of any videos you may find useful pls do let me know!
@rishi-khanna
@rishi-khanna 9 күн бұрын
Jambo paji. Great video
@gurdeepbahra6843
@gurdeepbahra6843 7 күн бұрын
@@rishi-khanna asante sana ndugu, mimi nakupenda wewe 🙏🏽❤️
@TheLastEmperorXiXinPig
@TheLastEmperorXiXinPig 19 күн бұрын
So external users like an accountant do not need a Business Central license?
@gurdeepbahra6843
@gurdeepbahra6843 18 күн бұрын
@TheLastEmperorXiXinPig hello! Thank you for reaching out, yes this is correct, they are granted access without a typical license. Last time I checked, I think it was up to 3x users like this. Hope this helps!
@NS-tp3vr
@NS-tp3vr 20 күн бұрын
Very Informative. Gurdeep one doubt can a cue be created just for one profile Id(Role)?
@gurdeepbahra6843
@gurdeepbahra6843 19 күн бұрын
hello there! thank you for reaching out! so yes, you can indeed create a cue for a single profile ID, you would need to find the page ID of the role you want to add to (also make sure the same page ID is not used across multiple profiles!) then you can just go ahead and create a cue as you would like to! hope this helps
@NS-tp3vr
@NS-tp3vr 19 күн бұрын
@@gurdeepbahra6843 Is there a video in your channel regarding it?
@gurdeepbahra6843
@gurdeepbahra6843 19 күн бұрын
@NS-tp3vr no! But i will add it to the list - full disclosure, i am not a developer so it will be a learning exercise for me too! But watch this space, i will try my best to help!
@snehashetty5745
@snehashetty5745 20 күн бұрын
Hi Gurdeep, thank you for the video with the detailed explanation. Is there a way to include column captions/headers in the exported file? Also, how can I export the file directly as a .csv?
@gurdeepbahra6843
@gurdeepbahra6843 19 күн бұрын
hello Sneha, thank you so much for reaching out! you can certainly export data from BC including captions and headers - i would use a configuration package to do this. in order to export a csv file you will need to do a small amount of development, but it is also possible quite easily - i hope this helps!
@gislisveinbergsson2833
@gislisveinbergsson2833 21 күн бұрын
Thank you for the video. One question: Can you please explain the Document No T001? In the vendor ledger entries in the video it is 108211 and in the customer ledger entries it is 103228. How and where does T001 comes from? I am having difficulties netting because of the Document No.
@gurdeepbahra6843
@gurdeepbahra6843 19 күн бұрын
hello there! thank you for reaching out - so this document no. T001 is for the entry which will be applied to the customer/vendor ledger entries. After i have posted the journal to net the vendor & customer balances, when we review the customer and vendor ledger entries you will notice in each of the screens we have a transaction with our document no T001, these are the transactions which are applied to each of the customer and vendor balances to net them off. i hope this makes sense!
@TheLastEmperorXiXinPig
@TheLastEmperorXiXinPig 21 күн бұрын
🚀
@gurdeepbahra6843
@gurdeepbahra6843 21 күн бұрын
@@TheLastEmperorXiXinPig thank you for this feedback! If you can think of any other videos you'd like to see just let me know- all the best!!!!
@hrtrack76
@hrtrack76 25 күн бұрын
Very helpful
@hrtrack76
@hrtrack76 25 күн бұрын
Very helpful
@arcangla
@arcangla Ай бұрын
Hi Gurdeep, Thank you for the video, very insightful. Question: In the Workflow User Group, can I add Amount Limits too? I have the below scenario: On General Journal Lines User Joy needs to belong to a Group (Group A) Whenever Joy creates a Gen Journal Line since she is part of Group A, the Approval request always goes to User Grace but then depending on the Value of the Journal Line it will also go - to User Tom if it is up to 5k but more than 5k up to 10k then it goes to User John. User Lorry needs to belong to a Group (Group B) Whenever Lorry creates a Gen Journal Line since she is part of Group B, the Approval request always goes to User Kat but then depending on the Value of the Journal Line it will go to User Tom if it is up to 5k but more than 5k up to 10k then it goes to User John.
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@arcangla hello there! Thank you for reaching out and thank you for the feedback! You might be able to achieve this without a modification (but it will be very difficult to maintain)... I have done something similar for a customer before, it would be fairly easy to add some new fields (via development) which allow us to group users together, this field can then also be used to identify which user belongs to which group, and drive your approvals. It's a lot to type - i hope this makes sense, pls reach out if it doesn't & we can discuss further!
@arcangla
@arcangla Ай бұрын
@@gurdeepbahra6843 Thank you so much for your prompt feedback, I will reach out to a developer and see what we can do. I wanted to make sure that I am not missing any setup which would support this out of the box. Thank you once again.
@sandaliHettikanda
@sandaliHettikanda Ай бұрын
Hi how I can get the demo environment. Could you please create videos for this .
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@sandaliHettikanda hello there! You can access the same type of demo environment that I use if you have a Microsoft Partner email address, or if you have an existing BC subscription. It is also possible to setup a demo environment on a local machine/docker as opposed to in the cloud. If these are of interest pls reach out to me on LinkedIn and I can give u some more info
@hrtrack76
@hrtrack76 Ай бұрын
Hey gurdeep I want a video on dimension topic
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@hrtrack76 hello there! For sure, this video is on my list, its quite a big area to cover so please bear with me - i will record and upload as soon as possible!! Thank you for reaching out!
@hrtrack76
@hrtrack76 Ай бұрын
Hy how can i contact you i want to consultant something with you
@hrtrack76
@hrtrack76 Ай бұрын
@@gurdeepbahra6843 it's possible can you make in hindi language
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@@hrtrack76 I will try to!
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@hrtrack76 if you search in linkedin you should be able to find me!
@OmarSiroco
@OmarSiroco Ай бұрын
Thanks for this helpful tutorial, I have a question please, what button did you click to open the BC inspection without opening the Help & Support tab?
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@OmarSiroco hello there! Thank you for your amazing feedback! So you'd need to press "Ctrl, Alt & F1" on your keyboard at the same time, if you have a function key, then it's "Fn, Ctrl, Alt & F1" hope this helps!
@hrtrack76
@hrtrack76 Ай бұрын
Good
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@hrtrack76 thank you for the feedback it means a lot! If you'd like to see any specific video just let me know!
@rajnish_mahaseth
@rajnish_mahaseth Ай бұрын
Thanks for sharing the video, it was really very helpful!
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@@rajnish_mahaseth thank you bro for this amazing feedback!
@SigmaUK-q3d
@SigmaUK-q3d Ай бұрын
Hi Gurdeep, we offer our customers discount if they pay by the 15th of the following month which is fine if they pay by that date, however sometimes the 15th of the month might fall on a weekend and so we allow them to take discount still if paid on the Monday (which may be 16th or 17th of the month) how do we enter this on BC to still allow discount to be taken but keep the correct posting date when the money was received in the bank.
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
hi there! thank you so much for reaching out, to accommodate this i would use a combination of payment discounts on your payment terms setup, but also setup the payment discount tolerances module - however you would need some sort of modification which will tell BC when the 15th falls on a weekend so the tolerance can be applied to that invoice - hope this makes sense! happy to discuss further if you wanted to!!!
@PeterLawrence193
@PeterLawrence193 Ай бұрын
Good Morning great videos very helpful. How do I become a d365bc consultant. I have been using d365bc every day for 5+ years as Accountant, 20+ years FCCA
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@PeterLawrence193 hello Peter! Thanks for the amazing feedback and for reaching out! So I think you'd be best of reaching out to a Microsoft Partner for this type of role! If you reach out to me on LinkedIn I can give you some further guidance
@mussaabdi
@mussaabdi Ай бұрын
Where can i get privacy shortcut added and in which version is it included
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
hello there! thank you for reaching out! so out of the box you will need to assign yourself the IT Manager Role Centre, however if you are building a bespoke page for your Role Centre you should be able to add this in using the same page object ID as the IT Manager, hope this helps!
@mussaabdi
@mussaabdi Ай бұрын
Very useful especially when you switch from admin to a normal user.. great job 👍🏿👍🏿👍🏿 kindly do API that come with BC how to activate and have access oData
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
thank you so much for your lovely feedback! i will add this request to my list, watch this space & i will upload a video on this very soon!
@takescake
@takescake Ай бұрын
Bussin video. I'm fighting with Business Central now your videos are helping
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
thank you for this amazing feedback! if you can think of any videos you'd like to see just let me know! all the best!!
@takescake
@takescake Ай бұрын
@@gurdeepbahra6843 I'm struggling getting a bank account imported from fresh. Never used any other tool like this just trying to extract expenses but I can't get the bank reconciliation to work. I'm confused how I can't import the document and click save. I get a balance is not equal warning. Tldr. How to import all bank transactions from scratch
@arifskarchan1skardu276
@arifskarchan1skardu276 Ай бұрын
Kindly make a video on " Editing or updating Posted purchase invoices" after payment through apply entries
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
hey there & thank you so much for reaching out! for sure!! i will put this request on to the backlog, watch this space!
@arifskarchan1skardu276
@arifskarchan1skardu276 Ай бұрын
Thank you so much sir from Pakistan
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
thank you for your lovely feedback!
@spacebiscuitslive
@spacebiscuitslive Ай бұрын
Does copying the company get all the records or just the configurational data?
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
hello there! Thank you so much for reaching out!! i can confirm the copy company function will copy all of the configuration data as well as the transactions, hope this helps!
@SigmaUK-q3d
@SigmaUK-q3d Ай бұрын
Hi Gurdeep this is a great explanation of the Sales receipts with discount. I am currently testing on BC before we go live and when I post the payment the vat entry appears to be showing in 2 lines all the time and I don't know why this is happening. It is showing a + figure and a - figure for the base value and the amount (which would be vat) and they come to the total of what they should do but I want it to show on BC as yours does as one vat entry. Please can you tell me where I might be wrong. Thanks
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
hey there! thank you so much for reaching out, this could depend on a few things, but are you able to check the VAT Calculation Type field on the combination of VAT Prod & Business posting group? what does this currently read please
@MarieBailey-v2d
@MarieBailey-v2d 2 ай бұрын
Hello, I'm finding all your videos really useful and clear. I'm in the process of setting up field monitoring. I was having an issue with Notification Status "Email Enqueued" and found it was because there was no job queue entry for notifications. I've now created one and the emails for changes have sent, but I'm wondering if it will continue to run and notify me each time a field is changed. I wasn't sure what settings would be correct to ensure this continuous notification, please could you help?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@MarieBailey-v2d hmm it's strange, I would expect BC to auto send the email without any user intervention. This said, it could be something to do with permissions - can I check, on which page were you getting the notification status "Email Enqueued"? I will then investigate further for you
@MarieBailey-v2d
@MarieBailey-v2d 2 ай бұрын
​@@gurdeepbahra6843 My third time trying to reply. It hasn't been saving. The page is Monitored field log entries. The emails send after setting up the job queue, but still show in the Monitored field log entries page as "Email Enqueued".
@gurdeepbahra6843
@gurdeepbahra6843 Ай бұрын
@@MarieBailey-v2d hey there! thank you for your reply! this is not how i'd expect BC to behave, however it would be difficult to further investigate without seeing your system... if you'd like me to investigate further perhaps find me on LinkedIn & we can organise a call :)
@MarieBailey-v2d
@MarieBailey-v2d 2 ай бұрын
Thanks for the clear explanation. It was good to see the first migration option, so if my understanding was correct would that have just assigned all the multiple permission sets from the user group directly on the user? I'm not quite following why we then have to add the permission sets again to the security group, does it override the migration? What if a permission set was assigned to a member in the migration, but then not added to the security group they were assigned to? I'm then wondering if the second migration option would be better, do you have a video of that one in action?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@MarieBailey-v2d this is a great shout Marie and I will put together a video showing this option - you are right it would be the more efficient option for moving to security groups
@drakegossi1560
@drakegossi1560 2 ай бұрын
Keep em coming, Gurd! I'm learning!!!❤
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@drakegossi1560 thanks for the lovely feedback Drake! Hope youre doing well 🙏🏽❤️
@collinsmusa6366
@collinsmusa6366 2 ай бұрын
Can I use Tires as Components?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@collinsmusa6366 hello! You most certainly could! But don't forget this configuration will mean you'll need to maintain an entirely separate fixed asset card for the tyres. How much benefit will this bring is up to you, hope this helps!
@Imran_A-Mumin
@Imran_A-Mumin 2 ай бұрын
👍
@Imran_A-Mumin
@Imran_A-Mumin 2 ай бұрын
👍
@Imran_A-Mumin
@Imran_A-Mumin 2 ай бұрын
👍
@Imran_A-Mumin
@Imran_A-Mumin 2 ай бұрын
👍
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@Imran_A-Mumin thank you my bro, hope you doing good ❤️🙏🏽
@marshallfox5116
@marshallfox5116 2 ай бұрын
Thanks 🎉🎉🎉
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@marshallfox5116 you are most welcome!! Thank you for taking the time to feedback 🙏🏽❤️
@SigmaUK-q3d
@SigmaUK-q3d 2 ай бұрын
Hi Gurdeep Can you help me with a query about VAT on fuel scale charges, I need to put this through on Business Central but can not see a way of doing it. On our old system I do a journal to Debit road fuel account and then Credit output VAT and our old system would include this in the output VAT figure due to HMRC. Many Thanks
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
hi there! thank you for reaching out - so you should be able to this from the general journal, you will need to assign the relevant g/l accounts on the journal line, but the important fields for the vat element will be the "gen posting type" which will either be sale or purchase, then the "vat prod. posting group" which will determine the rate of VAT. Pls give this a go & let me know if you struggle, i can record a video for you if you struggle!
@akzil2420
@akzil2420 2 ай бұрын
Thanks for the video! I like your accent! 😀
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@akzil2420 thank you for this amazing feedback, if you'd like to see any video in particular just let me know and I'll get it recorded!
@rishi-khanna
@rishi-khanna 2 ай бұрын
Smashed it G🎉
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@rishi-khanna thank u my bro, if you can think of any videos you may like to see just let me know
@rishi-khanna
@rishi-khanna 2 ай бұрын
@@gurdeepbahra6843 will do bro
@marshallfox5116
@marshallfox5116 2 ай бұрын
🎉🎉🎉🎉🎉 amazing 🎉🎉🎉
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@@marshallfox5116 it is genuinely such a pleasure to get such feedback, thank you so much for reaching out!
@marshallfox5116
@marshallfox5116 2 ай бұрын
Keep you are doing well 🎉
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@marshallfox5116 thank you so much for the amazing feedback!!!
@katebrown1401
@katebrown1401 2 ай бұрын
Thanks for this - it's the clearest explanation I've found!
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
thanks for this lovely feedback! i'm glad it helped!! if you can think of any other videos you'd like to see please do let me know & i'll get them uploaded!
@clddnc
@clddnc 2 ай бұрын
I don't understand where MS goes with all this options. To prevent to post invoice you can just cut write rights on posted invoices table (for shipment on posted shipments table).
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
i agree! this can be handled using permissions you are absolutely correct!!
@clddnc
@clddnc 2 ай бұрын
@@gurdeepbahra6843 More than that. This check box don't prevent user to delete or to cancel/revert a shipent line, for example,
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@@clddnc very good point! i didnt consider this...
@ayushmaheshwari2902
@ayushmaheshwari2902 2 ай бұрын
Hi i have a query that what if my bank statement bifurcated the amount fields as withdrawls & deposits.
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@ayushmaheshwari2902 hello! Thank you for reaching out!! So in this scenario you should be able to map both columns in your bank statement to the relevant transaction amount field in BC itself, hope this helps - please do reach out if you struggle & I will try to assist!
@cherylokane2289
@cherylokane2289 2 ай бұрын
Hi there, thanks for this, definately something to think about! Could, you please advise how the tax is affected, for. example, I'm in Australia and the Invoice posting date generally you want to have as the same as the GST posting date. However, in this case, well, how is the accountinge affected? Or is it just that we're giving customers extended payment terms/payment plan?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@cherylokane2289 hello there! Thanks for reaching out and this is a great question!! So in this particular scenario the VAT is unaffected, the VAT is posted and recognised on the posting date (we work the same way in the UK). Even the 3 customer ledger entries have the same posting date, but they have different due dates. This functionality is purely for splitting the debt on our customer ledger, even the customer will only see a single invoice - but on our system we will see 3x customer ledger entries. Hope this helps!!! Pls reach out if you have any other questions!
@wendytheskydiver
@wendytheskydiver 2 ай бұрын
This was EXTREMELY helpful! I've only been using BC for a month and was able to create this as a .csv file with success subsequent upload! Great video!
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@wendytheskydiver thank you so much for the amazing feedback, it's great to know it helped you so much! If you think of anything else which may be useful do let me know and I'll get it recorded!
@ringleaderuk
@ringleaderuk 2 ай бұрын
%1 corresponds to currency code, %2 Corresponds to amount in FC
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
thank you for confirming this!! thanks for watching & hope you found the video useful!
@jakubrozkosz179
@jakubrozkosz179 2 ай бұрын
You could've downloaded the report file and show us how it looks like but generally very good video ;)
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
hey there! thank you for reaching out & thank you for the feedback! i will add this video on to my to-do list & get around to it asap - watch this space!
@initman12
@initman12 2 ай бұрын
Hi Great vid, thanks. Would it be possible to get a copy of the config package you used please?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@initman12 hello! Yes for sure I can share this, if you could get me your email address somehow (if you don't want to post on here you can find me on LinkedIn to share it) I can send it to you!
@initman12
@initman12 2 ай бұрын
@@gurdeepbahra6843 Thanks Gurdeep, I think i am already one of your connections i will drop you a mesaage :)
@aspasia727
@aspasia727 2 ай бұрын
Thanks for the video, is there any way to to show the payment discount (How much you pay if you paid within the discount time) in the posted sales invoices?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
hey there! thank you so much for the feedback & for reaching out!! so you cannot see this information on the posted sales invoice record itself, but if you find the invoice on the customer ledger entries screen, it should tell you on some fields on this page - hope this helps!
@aspasia727
@aspasia727 2 ай бұрын
@@gurdeepbahra6843 Thank you - the customers would like to see when they receive invoice - what would be a best solution for it?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@aspasia727 you should be able to pass the value from CLE to the invoice layout, it will then show the value when you generate the invoice! I hope this helps
@HardcorowaChusteczka
@HardcorowaChusteczka 3 ай бұрын
Do You know maybe how to change retention policy in change log? E.g. I want to set up change log on the table Payment Terms (3) Log insertion and modification on some fields. And now i want to set up retention policy on field X (In Peyment Terms) for 3 y and on another field Y for 5 y.
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@HardcorowaChusteczka hey there! Thank you so much for reaching out!! So you could try using the "Record Retention Polciy" section of the retention policy to add your table, and field, then set the retention period as desired. Give it a go and let me know how you get on, I can assist further if required
@HardcorowaChusteczka
@HardcorowaChusteczka 2 ай бұрын
​@@gurdeepbahra6843 Thank You. Im thinking about fields "Protected" and "Filed Log Entry Feature: Monitor Sensitive Fields". Do You know what it is exactly? What kind of data is protected and Sensitive Fields?
@gurdeepbahra6843
@gurdeepbahra6843 2 ай бұрын
@HardcorowaChusteczka I would need to investigate but after having a quick look it looks like these settings are defined in the background, I.e. where a field is protected it will come from a particular table. Hope this helps!