Dynamic Accounting & Finance Tips
Dynamic Accounting & Finance Tips
  • 53
  • 24 487
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
Переглядів: 294

Відео

Vendor Rebates
Переглядів 56010 місяців тому
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
Переглядів 39710 місяців тому
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,6 тис.11 місяців тому
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
Переглядів 297Рік тому
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
Переглядів 207Рік тому
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
Переглядів 298Рік тому
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,7 тис.Рік тому
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
Переглядів 323Рік тому
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
Переглядів 337Рік тому
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
Переглядів 241Рік тому
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
Переглядів 757Рік тому
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
Переглядів 249Рік тому
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
Переглядів 288Рік тому
Invoice Capture - Video 8 - Invoice with PO - Mismatch Vendors
Invoice Capture - Video 4 - Utility Invoice
Переглядів 629Рік тому
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
Переглядів 529Рік тому
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
Переглядів 579Рік тому
Invoice Capture - Video 6 - Invoice with PO - Not Received in D365
Invoice Capture - Video 3 - Invoice with NO PO - but PO was issued
Переглядів 874Рік тому
Invoice Capture - Video 3 - Invoice with NO PO - but PO was issued
Invoice Capture - Video 7 - Invoice with PO (Header)
Переглядів 393Рік тому
Invoice Capture - Video 7 - Invoice with PO (Header)
D365 Intercompany Trade with a Twist
Переглядів 737Рік тому
D365 Intercompany Trade with a Twist
D365 Financial Tags
Переглядів 742Рік тому
D365 Financial Tags
Asset Leasing Module
Переглядів 425Рік тому
Asset Leasing Module
D365 Environment Marker
Переглядів 263Рік тому
D365 Environment Marker
Debits & Credits in D365
Переглядів 243Рік тому
Debits & Credits in D365
Beginners D365 Navigation Introduction
Переглядів 210Рік тому
Beginners D365 Navigation Introduction
Tip of the Day - See all Customer or Vendor Transactions in Grid
Переглядів 162Рік тому
Tip of the Day - See all Customer or Vendor Transactions in Grid

КОМЕНТАРІ

  • @gilbertgk
    @gilbertgk 11 днів тому

    thank you for this walkthrough, do you know if OCR can support 'Prepayment invoice' against a PO?

    • @DAFTD365
      @DAFTD365 11 днів тому

      Yes, there is a parameter under AP, automatically apply prepayments. Then when the final invoice comes in, the system recognizes if there is a prepayment on the purchase order, then the prepayment is applied automatically.

  • @RobHOUTX46285
    @RobHOUTX46285 18 днів тому

    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.

    • @DAFTD365
      @DAFTD365 18 днів тому

      Use accounting source explorer to pull that data.

  • @bhaveshgoswami.
    @bhaveshgoswami. Місяць тому

    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.

    • @DAFTD365
      @DAFTD365 Місяць тому

      This has always been a requirement from most clients. Recommend putting an idea to Microsoft or creating a customized grid.

    • @bhaveshgoswami.
      @bhaveshgoswami. Місяць тому

      @ is this possible to achieve through a customisation?

  • @EdnaMutschler
    @EdnaMutschler Місяць тому

    Great video Jolie! thank you for always sharing your knowledge.

  • @isabellasommer1572
    @isabellasommer1572 Місяць тому

    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.👍

  • @lt_tech
    @lt_tech Місяць тому

    Where can I enable the automatic match? between invoice and product receipt? Thanks

    • @DAFTD365
      @DAFTD365 Місяць тому

      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.

  • @mk-qp9ow9db1x
    @mk-qp9ow9db1x Місяць тому

    How were you able to embed the invoice capture fast tabs for Captured Invoices and Received Files?

    • @DAFTD365
      @DAFTD365 Місяць тому

      Yes, this was something I learned from Dan's Corner (Blog). www.danscorner.info/2023/05/using-full-page-apps-in-dynamics-365.html

  • @yugandharkambam9616
    @yugandharkambam9616 2 місяці тому

    Hi thank you for sharing. Is there any report we can reconcile production WIP

  • @cathymak1027
    @cathymak1027 2 місяці тому

    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

  • @garygong506
    @garygong506 2 місяці тому

    Very informative 😃

  • @lilliamcolon-gilzean9739
    @lilliamcolon-gilzean9739 3 місяці тому

    Jolie, is there a way to invoice multiple Pos with one received invoiced.

    • @DAFTD365
      @DAFTD365 3 місяці тому

      Yes select PO on the line level. If PO is not on the line you will need to add in configuration.

  • @lilliamcolon-gilzean9739
    @lilliamcolon-gilzean9739 3 місяці тому

    What is the additional app that you use to create the test flow

  • @michaelagostini2443
    @michaelagostini2443 3 місяці тому

    Were you able to do the Deduction workbench demo? ty

    • @DAFTD365
      @DAFTD365 3 місяці тому

      Not yet but it’s in my queue to complete. Hope to have out soon

  • @KrutiPatel-w5k
    @KrutiPatel-w5k 3 місяці тому

    Hi Jolie, can you please tell me how did you embed invoice capture in d365?

  • @johnandreneernst2786
    @johnandreneernst2786 4 місяці тому

    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?

  • @oliverbensliman6035
    @oliverbensliman6035 4 місяці тому

    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 👋🍀

  • @sbvendors
    @sbvendors 5 місяців тому

    The process you showed is really smooth ...Thanks for sharing.

  • @maryjuanas4265
    @maryjuanas4265 5 місяців тому

    I would advise watching in 1.5X speed, as she struggles to get to the point

  • @phatnh1970
    @phatnh1970 5 місяців тому

    Good clip

  • @Shariff.0051
    @Shariff.0051 6 місяців тому

    Please post new videos

  • @KaylaPexton
    @KaylaPexton 6 місяців тому

    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

    • @DAFTD365
      @DAFTD365 6 місяців тому

      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.

  • @kathieL-uo7yv
    @kathieL-uo7yv 7 місяців тому

    Hello Just wonder if you have had success answering the question below

  • @DAFTD365
    @DAFTD365 7 місяців тому

    Are you in the vendor invoice form or in the power app?

  • @jameseden9380
    @jameseden9380 7 місяців тому

    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

  • @StuLeders
    @StuLeders 8 місяців тому

    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?

    • @DAFTD365
      @DAFTD365 8 місяців тому

      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.

  • @TiNmyJ
    @TiNmyJ 8 місяців тому

    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

  • @AndreaPinto-ow5yg
    @AndreaPinto-ow5yg 8 місяців тому

    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.

    • @DAFTD365
      @DAFTD365 8 місяців тому

      www.danscorner.info/2023/05/using-full-page-apps-in-dynamics-365.html?m=1

  • @pigneshdani
    @pigneshdani 8 місяців тому

    Very Knowledgeable and very helpful topic.

  • @evilchaperone
    @evilchaperone 10 місяців тому

    Thanks you. Looking forward to reviewing this series. We are converting to D365 now and automated ap is definitely high on the list.

  • @DAFTD365
    @DAFTD365 10 місяців тому

    I disabled the invoice capture feature and the processes were still there. I assume you are an ADMIN.

  • @golfnutt1969
    @golfnutt1969 10 місяців тому

    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.

    • @DAFTD365
      @DAFTD365 10 місяців тому

      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.

    • @golfnutt1969
      @golfnutt1969 10 місяців тому

      @@DAFTD365 10.0.38. Getting ready to upgrade to 10.0.40 this year.

  • @AmerAli-rm5gl
    @AmerAli-rm5gl 10 місяців тому

    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.

  • @bigmacdaddy1234
    @bigmacdaddy1234 10 місяців тому

    I am using the most current version of BC but it looks different from yours. I can't even find 'Main Accounts' under COA.

    • @DAFTD365
      @DAFTD365 10 місяців тому

      This is Dynamic’s 365 not BC.

    • @bigmacdaddy1234
      @bigmacdaddy1234 10 місяців тому

      @@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.

  • @doareuable
    @doareuable 11 місяців тому

    Can pictures be added when a maintenance request is created in the Asset management mobile app?

  • @guillermovillayandre4896
    @guillermovillayandre4896 11 місяців тому

    Jolie, great explanation!

  • @vijesh4K
    @vijesh4K 11 місяців тому

    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?

    • @DAFTD365
      @DAFTD365 11 місяців тому

      Not sure I understand, "both legal entities are within the same location"?

    • @vijesh4K
      @vijesh4K 11 місяців тому

      @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.

    • @DAFTD365
      @DAFTD365 11 місяців тому

      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?

  • @socksWithHolesInThem1971
    @socksWithHolesInThem1971 11 місяців тому

    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!

  • @williamm18
    @williamm18 11 місяців тому

    Thank you for sharing

  • @zaheerahmad3896
    @zaheerahmad3896 11 місяців тому

    A handy feature

  • @Shariff.0051
    @Shariff.0051 11 місяців тому

    Great thanks for this valuable video

  • @TheGrassman451
    @TheGrassman451 Рік тому

    Thank you :")

  • @zaheerahmad3896
    @zaheerahmad3896 Рік тому

    Yes, it helped a lot. Thanks for sharing . . .

  • @NatureCozySnow
    @NatureCozySnow Рік тому

    Hello mam! can I talk to you about your UA-cam channel? I wanna give you some secret tips about your UA-cam channel You will benefit from it. I think you are thinking something serious about your UA-cam 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.

  • @JJJG111
    @JJJG111 Рік тому

    Thank you for the amazing content! I learnt a lot from your videos!

  • @ziaullah4936
    @ziaullah4936 Рік тому

    Thanks for sharing valuable experience

  • @anilnair7920
    @anilnair7920 Рік тому

    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

    • @DAFTD365
      @DAFTD365 Рік тому

      I’m not sure I understand your question. Is there a certain posting profile you can’t reconcile?

    • @anilnair7920
      @anilnair7920 Рік тому

      @@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

  • @anilnair7920
    @anilnair7920 Рік тому

    Good informative video👍

  • @AsteroSSB
    @AsteroSSB Рік тому

    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

    • @DAFTD365
      @DAFTD365 Рік тому

      So true! Was just thinking about this video a few days ago. Thank you for the comment as it should help others know.

  • @bigmacdaddy1234
    @bigmacdaddy1234 Рік тому

    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???

    • @DAFTD365
      @DAFTD365 Рік тому

      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.

  • @avishekbiswas9777
    @avishekbiswas9777 Рік тому

    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.