- Видео 53
- Просмотров 23 813
Dynamic Accounting & Finance Tips
США
Добавлен 1 янв 2015
I am an experienced Dynamics 365 end user and Finance Consultant with a strong passion for Accounting. Throughout my career, I have encountered numerous challenges faced by accounting teams, such as difficulties in finding information, reconciling reports, and the lack of time to fully grasp the functionalities within Dynamics 365. My ultimate objective has always been to bring value to the Accounting/Finance field by leveraging the capabilities of the system, automating processes, and simplifying operations. In line with these goals, I am dedicated to creating user-oriented videos.
As a Senior Finance Consultant at sa.global, I have the privilege of focusing on what I am truly passionate about - assisting professionals in effectively utilizing Dynamics 365. I have recently obtained certification from Microsoft as a Finance Consultant. It is important to note that knowledge is an ongoing journey, and no one can claim to have complete mastery or be immune to the constant changes.
As a Senior Finance Consultant at sa.global, I have the privilege of focusing on what I am truly passionate about - assisting professionals in effectively utilizing Dynamics 365. I have recently obtained certification from Microsoft as a Finance Consultant. It is important to note that knowledge is an ongoing journey, and no one can claim to have complete mastery or be immune to the constant changes.
Rebate Management w/ Pricing Management
Learn how to utilize rebate management capabilities in FSCM to enhance pricing strategies, improve competitiveness, and adapt to market changes
Просмотров: 279
Видео
Vendor Rebates
Просмотров 53910 месяцев назад
Rebate management module in D365 allows for several types of calculation methods. In this demonstration, I will walk through each one of those methods using the vendor rebates in the Rebate Management module. How great when we can automate the process, in which if we spend a qty or value, D365 will calculate those agreements automatically. Enjoy friends!
Ledger Account Alias
Просмотров 39610 месяцев назад
Accounting teams really need all the help they can get in savings minutes, seconds and reducing errors. Check out this short video on how ledger account alias can be used. Enjoy!
Rebate Management
Просмотров 2,5 тыс.10 месяцев назад
In this demonstration, I will walk you through Microsoft's module - Rebate Management. How great that Microsoft has improved sales agreements and trade allowance utilizing billback workspace by giving us a full Rebate Management module. This module solves user issues like easily changing/adding to the rebate agreement(Deal), workflows, easily adding products to the deal. Upcoming features - thi...
Sessions Date
Просмотров 25711 месяцев назад
In D365, when you open your browser the system defaults to the current date. When you are posting transactions in the system, typically you will notice the current date populate. In accounting, it's important to easily backdate transactions for month end close processes. In this demonstration, I will walk you through areas that changing your sessions date will be beneficial during month end clo...
GL Default Dimensions
Просмотров 28511 месяцев назад
Did you know there are over 250 pages that let you enter default dimensions? Why does Microsoft give us so many areas to setup default dimensions. My thoughts is that they want users not to have to think about financial dimensions when making entries/transactions. Once I worked in an accounting system were I had to memorize all main accounts, cost centers, department and I coded every transacti...
General Ledger Financial Dimension Allocation Templates
Просмотров 200Год назад
Another form of Allocations - Did you know Microsoft created away to assign financial dimensions to a template and easily use that template in Free Text Invoices and Purchase orders? I just learned this and thought I would share in case I'm not the only one who didn't know this. Purchase orders can always use this feature with procurement categories. This is a good thing! If we can save a D365 ...
General Ledger Reporting Groupings
Просмотров 189Год назад
Accounting teams need ability to view additional reporting groupings for net income, gross margin, COGS Products, COGS Services so much more. Yes, BI, Management reporter, and our new upcoming BPA will be our ultimate tools for reporting. This solution is for the day in day out checks & balances that accountants do to review numbers in preparation for those financial reports listed above. We wi...
General Ledger Allocation Term
Просмотров 293Год назад
Accountants love allocations. This feature allows accountants to skip the step of creating a monthly allocation journal. The allocation happens immediately as transactions posted to ledger.
Inventory Reconciliation
Просмотров 2,6 тыс.Год назад
Has your accounting team struggled with reconciling inventory to the general ledger? This short demo will walk you through the posting types directly related to inventory and what subledger reports will tie to your inventory.
Invoice Capture - Video 12 - Vendor sends 1 file with Multiple Invoices
Просмотров 311Год назад
Witness the magic as we unveil Microsoft's vision of seamless invoice reception and initial capture. D365 Invoice Capture handles incoming invoices, extracts crucial data, and sets the stage for a fully automated journey. In this video we walk through when the vendor sends many invoices in one file. With Microsoft power tools, anything is possible.
Invoice Capture - Video - 11 Invoice arrives with NO PO - Vendor is not setup in D365
Просмотров 319Год назад
Witness the magic as we unveil Microsoft's vision of seamless invoice reception and initial capture. D365 Invoice Capture handles incoming invoices, extracts crucial data, and sets the stage for a fully automated journey. In this video, we walk through when the vendor is not setup in D365. Additionally, we ran into several standard issues that we resolved.
Invoice Capture - Video - 10 - Invoice with PO - Project Management & Accounting
Просмотров 229Год назад
Witness the magic as we unveil Microsoft's vision of seamless invoice reception and initial capture. D365 Invoice Capture handles incoming invoices, extracts crucial data, and sets the stage for a fully automated journey. In this video, we walk through Invoice capture when the company is a service company using the Project Management & Accounting module in D365.
D365 Drag & Drop Attachments
Просмотров 742Год назад
Every active document in D365 only allows attaching files one document at a time. This amazing functionality allows drag & drop for any form in D365. Let sa.global assist you with this. It's a very easy customization that our team would love to help you with. I'm excited for anyone using D365 on a daily basis. This is a big win for Accounting teams who must have support documentation for audit ...
Invoice Capture - Video 9 - Invoice with PO - PO Missing Numbers or Alpha Numeric
Просмотров 243Год назад
Witness the magic as we unveil Microsoft's vision of seamless invoice reception and initial capture. D365 Invoice Capture handles incoming invoices, extracts crucial data, and sets the stage for a fully automated journey. In this video we walk through when the vendor invoice has a purchase order but the vendor has left off the alpha numeric and leading zeroes. Microsoft AI recognizes the PO is ...
Invoice Capture - Video 8 - Invoice with PO - Mismatch Vendors
Просмотров 281Год назад
Invoice Capture - Video 8 - Invoice with PO - Mismatch Vendors
Invoice Capture - Video 4 - Utility Invoice
Просмотров 614Год назад
Invoice Capture - Video 4 - Utility Invoice
Invoice Capture - Video 1 - Introduction
Просмотров 2,8 тыс.Год назад
Invoice Capture - Video 1 - Introduction
Invoice Capture - Video 5 - Invoice with PO - Lines do not match Receipt
Просмотров 507Год назад
Invoice Capture - Video 5 - Invoice with PO - Lines do not match Receipt
Invoice Capture - Video 2 - Invoice with PO - Exact Match
Просмотров 1,2 тыс.Год назад
Invoice Capture - Video 2 - Invoice with PO - Exact Match
Invoice Capture - Video 6 - Invoice with PO - Not Received in D365
Просмотров 552Год назад
Invoice Capture - Video 6 - Invoice with PO - Not Received in D365
Invoice Capture - Video 3 - Invoice with NO PO - but PO was issued
Просмотров 849Год назад
Invoice Capture - Video 3 - Invoice with NO PO - but PO was issued
Invoice Capture - Video 7 - Invoice with PO (Header)
Просмотров 379Год назад
Invoice Capture - Video 7 - Invoice with PO (Header)
Tip of the Day - See all Customer or Vendor Transactions in Grid
Просмотров 161Год назад
Tip of the Day - See all Customer or Vendor Transactions in Grid
Is there a way to filter by Vendor or Customer Number? I'm trying to find a report that shows me for one vendor all the various expense accounts we have hit. So I thought I could do Main account range to only show the P&L accounts and then filter by vendor number. But I cannot find a join in a table to get the vendor number to show as a field.
Use accounting source explorer to pull that data.
when we run vendor transaction report, it is not possible to see offset account. for example there is one vendor with whom we purchase raw material, packing material, general maintenance items etc. There is separate main account for all such expense. when we run vendor transaction report there should be one column which shows offset-account so that we get to know type of purchase from particular vendor.
This has always been a requirement from most clients. Recommend putting an idea to Microsoft or creating a customized grid.
@ is this possible to achieve through a customisation?
Great video Jolie! thank you for always sharing your knowledge.
Thanks Jolie for taking the time to create this!. As a developer extending an ISV solution with FinTags, I was looking for a video showing how users would import the tags from a file.👍
Where can I enable the automatic match? between invoice and product receipt? Thanks
Under system administration>Setup>Initialize Process Automations - tab to background processes. There is an automatic batch job setup that will match product receipts - called "Match vendor invoice lines with product receipts". You can change the interval on that batch job but minimum is once an hour.
How were you able to embed the invoice capture fast tabs for Captured Invoices and Received Files?
Yes, this was something I learned from Dan's Corner (Blog). www.danscorner.info/2023/05/using-full-page-apps-in-dynamics-365.html
Hi thank you for sharing. Is there any report we can reconcile production WIP
Hi Jolie, thanks for your sharing. But what if we are using BOM journal? what posting type we should use to recon the GL? thanks
Very informative 😃
Jolie, is there a way to invoice multiple Pos with one received invoiced.
Yes select PO on the line level. If PO is not on the line you will need to add in configuration.
What is the additional app that you use to create the test flow
Were you able to do the Deduction workbench demo? ty
Not yet but it’s in my queue to complete. Hope to have out soon
Hi Jolie, can you please tell me how did you embed invoice capture in d365?
Can you do a demo of the Vendor rebate functionality on Sales orders so the rebate would be based on Customer or Customer rebate group + Item with a posting profile setup for one Fixed account Vendor Please include once the provision is posted how to manage processing the rebate once the vendor has issued the credit... what is a good way to manage the trigger of that?
Thank you very much. If you know it how it is done it is so easy. Thank you to share your wisdom at make me know 👋🍀
The process you showed is really smooth ...Thanks for sharing.
I would advise watching in 1.5X speed, as she struggles to get to the point
Good clip
Please post new videos
Hi Jolie- These are great videos. I've been trying to follow along but my Purchase Order field doesn't allow me to input a PO like you did in yours. Instead it says 'Select' and when I do it can't find any POs in my environment. Have you seen this before/know where I went wrong? Thanks
Hi Kayla, yes I see this often. Make sure the items are identified on the line first. What you will see is that the system recognizes which PO's the item you have on the line has available.
Hello Just wonder if you have had success answering the question below
Not yet
Are you in the vendor invoice form or in the power app?
These are really helpful videos, thanks for posting. I have an issue when processing invoices - when my imported invoice is in 'pending' i can open the invoice and view 'related documents' At header level, my related PO is blank (hover over PO number to view details) - no PO number or lines. In the Line Details section of the pending invoice Line details > general > PO i can hover over my PO and view number, lines etc. This causes my workflow to fail when submitting the invoice as it is expecting a related PO value. Have you seen anything similar? Thanks
Hi Jolie, thank you for the videos they have been a great help. In the video where you assigned the invoice with errors to yourself where would the user this in D365 and how would they be notified?
Hi Stu, thank you for the question. With the Power automate features, we could test using the trigger from invoice capture to route to users in Teams, Outlook etc.
Hi. Amazing serie. I was testing this thanks to your videos. When I Transfer an Invoice using the Header Only or PO Invoice Type I get the error message "The vendor invoice was generated with an error.Trading partner record for vendor "VendorNo" does not exists". When I use the Cost Invoice it's Ok. I believe we have to use the Vendor Invoice Journal to post but for some reason doesn't work like you have show. TIA
hi Jolie. Can you provide the link of the video of this Dan where he explains the setup to have the workspace embed as you mentions in the beginning of the video? Thanks a lot for the videos, very helpful.
www.danscorner.info/2023/05/using-full-page-apps-in-dynamics-365.html?m=1
Very Knowledgeable and very helpful topic.
Thanks you. Looking forward to reviewing this series. We are converting to D365 now and automated ap is definitely high on the list.
I disabled the invoice capture feature and the processes were still there. I assume you are an ADMIN.
Great video. I plan to watch this entire series, as the documentation for the Invoice Capture isn't much. At 11:39 in your video, you show 4 Process Automation background processes but I don't have those. Are these something installed while setting up Invoice Capture? I'm not sure why I don't see these.
Hi Jeff, Thank you for watching! What version environment are you in? That could be the trigger. I have access to an environment that does not have any parameters setup for invoice capture and the 4 process automations steps are still available.
@@DAFTD365 10.0.38. Getting ready to upgrade to 10.0.40 this year.
Didn't knew it was so simple. We use charge code to add/subtract differential amounts, but I think this is proper way to handle this.
I am using the most current version of BC but it looks different from yours. I can't even find 'Main Accounts' under COA.
This is Dynamic’s 365 not BC.
@@DAFTD365 Yes! You are right! I did a bit of research and now understand they are two distinct products. I come from a Dynamics GP background and am slowly learning the new software online from Microsoft. Thank you for the quick response, I really do appreciate it.
Can pictures be added when a maintenance request is created in the Asset management mobile app?
Jolie, great explanation!
Hi, Great content on Intercompany SO PO, i really appreciate. We have a scenario where both the legal entities are within the same location and they require the Sales order packing slip to trigger the product receipt on the other legal entity, which is practical because the same guy ships and recevies the order. I thought of submitting an idea on this requirement, what do you think is it a something other customers are looking for as part of intercompany setup?
Not sure I understand, "both legal entities are within the same location"?
@DAFTD365 two legal entries are literally operating in the same building one in the first floor another one in the ground floor and they share a common warehouse managed by a single warehouse manager. That's why they require the feature of intercompany sales order packing slip to automatically post the product receipt in the other legal entity.
The product receipt triggers the packing slip. Are you asking if I think it’s a good idea to submit to MS, to post packing slip which will post receipt?
17:37 Was this because the calculation type in the rebate deal is "Total?" ALSO - how do we process the provision when the rebate is supposed to be based on the customer's own sales of the product, and not simply what they bought? Tnx!
Thank you for sharing
A handy feature
Great thanks for this valuable video
Thank you :")
Yes, it helped a lot. Thanks for sharing . . .
Hello mam! can I talk to you about your RUclips channel? I wanna give you some secret tips about your RUclips channel You will benefit from it. I think you are thinking something serious about your RUclips channel in the future from where you can generate a passive income. You have already a lot of published videos on your channel but none of the videos are getting good views. Benefits of 100% SEO score: Views will increase Likes will increase Comments will increase Subscribers will increase Viewing time will be increasing So, If you want your channel to increase subscribers, views, likes, and comments with proper video SEO, Google Ads, and monetization. It will be your right decision. If you want to grow your channel video SEO score to 95 then we can talk about it.
Thank you for the amazing content! I learnt a lot from your videos!
Thanks for sharing valuable experience
This is helpful but when i tried to extract this report i was not able to find the adjustment amount included in this report. Only the financial cost and physical cost are included.Do you know why or have you seen any such scenario
I’m not sure I understand your question. Is there a certain posting profile you can’t reconcile?
@@DAFTD365an individual inventory transactions can have financial cost ,physical cost and adjustment cost .when we add the Financial cost and adjustment cost the final cost amount will get updated which normally reflects in the standard inventory valuation report. Now when I ran inventory storage report with transaction detail and when i checked the Column’s only financial cost and physical cost related cost is shown .Adjustment amount column itself is not shown. So Iam not able to match the voucher with actual inventory cost because adjustment cost is missing. Hope this is clear
Good informative video👍
Hi Jolie, The Financial Tags are now present in the Sales Order and Invoice section, so you can use them from there as of Oct -13- 2023. In Feature management there is a feature: Enable financial tags for sales order invoicing. About the Copy/Paste feature, the first paste only generates the number of lines in the Journal Lines table as you have it in the source excel. Then the second paste serves to populate the naked lines that were created during the first paste. Kindest regards, M
So true! Was just thinking about this video a few days ago. Thank you for the comment as it should help others know.
This is the most confusing accounting system I have ever seen. Way too much jumping all over the place just to find basic things. Where are the basic debit& credit distributions???
I can understand completely. That’s how my accounting team also felt when we moved from CYMA to D365. It’s really changing a standard way of seeing both sides of the entry to thinking about one side DR/CR and the other (offset). Let me know if you want to see any videos that might help you along the way.
Very well presented. I am looking forward to a detailed video showcasing all the capabilities of this module with an exhaustive example. Thanks for making this video.
Hi!, thank you so much for this useful information :)... Do you know how can I add View History button on pending vendor invoices?
Yes, make sure in AP parameters - under vendor invoice automation - that you have the "automatically" settings checked to yes.