On-account on a T&M project and dimensions
Dimensions when the customer advance is posted comes from the Project. Dr AR – Dimensions from Project – 1000 Cr DeffRev – Dimension from Project – 1000 When the transaction is posted, dimensions come from the respective records like employee or manually selected. Dr Cost – Dimensions different from project – 200 Cr Payroll allocation – Dimensions different from project – 200 When… Continue...
Customer advance and NTE
Customer advance created for GBP 12,000 but the NTE value on the project contract header is GBP 10,000. The customer advance invoice posted without any issues as NTE is not checked at advance level. The NTE values on the project contract are also unaltered. First project transaction of expense was posted for GBP 8,000, with a NTE check as “Success & Committed”. This transaction was successfully… Continue...
Creation of Credit Note in ProjOps
Once the invoice is “Confirmed” in ProjOps and project invoice proposal “Posted” in FinOps , user can create a credit note by clicking the “Correct invoice” button, which creates a negative invoice in ProjOps. Once the negative invoice is “Confirmed”, then system does NOT automatically create a negative project invoice proposal in FinOps. System gives this error: The user has to...
Project Contract – Before and after confirmation
Scenario 1 – Change of cost and sales price before confirmation of project contract Before project contract confirmation, the time transaction has following actuals transactions: The cost and sales price are updated and the project contract is “Confirmed”. This is the message which system gives. Highlighted part is important. After project contract confirmation, the time transaction has… Continue Reading...
Straight Line Rev Rec – Observation with respect to dimensions on individual milestones (On-account)
If there are two on-account (milestones) lines on the Straight Line Rev Rec project, with different dimensions, other than the one on the project, for example as below, then rev-rec line ignores the dimensions on the lines and inherits the dimensions from the project. If the project has no dimensions, then the rev-rec line also will inherit no dimensions, even if there are dimensions on the… Continue Reading noreply@blogger.com...
Invoice, Invoice in Advance and Invoice in Arrears – T&M
Scenario 1 – Rev rec at Invoicing Fee Journal DR Project WIP Sale Value (B/S) – 1000 CR Project Accrued Revenue – Sale value (P&L) – 1000 Expense Journal – Consumption...
Changing the Bill Type – D365 Project Operations
Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on their blog Changing the Bill Type – D365 Project Operations Changing the Bill Type – D365 Project Operations Blog Syndicated with noreply@blogger.com (Sarang Kusare)’s...
Lead to Project journey – Project Operations
Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on their blog Lead to Project journey – Project Operations No Description Blog Syndicated with noreply@blogger.com (Sarang Kusare)’s...
Microsoft Dynamics 365 FinOps – New Book on Sales order based Revenue Recognition
I am very much excited to announce the launch of my second Microsoft Dynamics 365 FinOps book on Amazon called “Microsoft Dynamics 365 FinOps – Sales Order-based Revenue Recognition In-depth”. Please check the link below. This book is available in paperback and e-book format (Kindle). Link for Microsoft Dynamics 365 FinOps – Sales Order-based Revenue Recognition In-depth Microsoft… Continue Reading noreply@blogger.com...
Project posting profile – Front end and Back end terminology mapping – Quick Post
Please refer to the screenshot below. This screenshot maps the different project posting profile on the front end to the project posting profile on the back end in the project ledger posting definition data entity.ThanksSarang Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on their blog Project posting profile – Front end and Back end terminology mapping – Quick Post Please refer to the screenshot...
Expense report, Expense voucher, Expense vendor invoice, Expense payment voucher – D365FO
Short post – Please refer to the table below to check how the system behaves when there are following different scenarios with respect to an expense report, expense voucher, expense vendor invoice and expense payment to the employee.ThanksSarang Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on their blog
D365 Finance and Operations – Expense Mileage
Default mileage rate can be set at the expense parameters:Mileage type expense categories can be set up and optionally mileage tiers can be set up at:Mileage tiers can be defined per mileage expense category:Mileage rate tiers can be defined for miles or number of passengers and can be date bound as well. Once the employee books the mileage, the system picks the applicable mileage rate into… Continue Reading...
Project budgets and cost control in Dynamics 365 FinOps
Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on their blog
Open in Excel v/s Export to Excel
Open in Excel v/s Export to Excel This is a short post explaining the subtle difference between ‘Open in Excel’ and ‘Export in excel feature’ in Dynamics 365 FinOps.Open in excel When the ‘Open in Excel’ option is clicked on the data grid in Dynamics 365 FinOps, then the system opens the DYNAMIC excel sheet using ‘Data connector’. That DYNAMIC excel sheet is nothing but the ‘Data...
Was “Hit Refresh” by “Microsoft Future Decoded 2018” – Part 1
What a timing I must say, I just finished reading “Hit Refresh” by Satya Nadella and within a few days I received registration confirmation from Microsoft that I can attend the “Microsoft Future Decoded 2018” event. I was very much excited to attend the event as that was my chance to experience what I just finished reading in “Hit Refresh”. However, before I write about my… Continue Reading noreply@blogger.com (Sarang...
Was “Hit Refresh” by “Microsoft Future Decoded 2018” – Part 2
s mentioned in the previous post, with all those thoughts from “Hit Refresh” fresh in my mind, I just fully immersed myself into the event for the next two days. The keynote speeches, the HoloLens demo, Virtual reality demo, classroom sessions on various topics ranging from AI, Quantum computing to Augmented reality, PowerApps etc. were just amazing and fantabulous. with Will… Continue Reading noreply@blogger.com (Sarang...
New book on Microsoft Dynamics 365 FinOps – “Microsoft Dynamics 365 FinOps – Fixed Price Projects Revenue Recognition In-depth”
I have released a new paperback book called “Microsoft Dynamics 365 FinOps – Fixed Price Projects Revenue Recognition In-depth” on Amazon about the fixed price projects revenue recognition last Thursday .i.e. 27th September 2018. In this blog post i am going to talk about the book and the motivation behind that. I knew basic fixed price projects revenue recognition and how to… Continue Reading noreply@blogger.com (Sarang...
Split the On-account invoice transaction for Credit note
When the project invoice includes just one on-transaction, then system does not allow the user to split that single transaction during the credit note.Single on-account transaction cannot be split during credit note However when the project invoice involves multiple on-account transactions from the same and / or multiple projects / sub-projects, then the user can split the credit note and… Continue Reading noreply@blogger.com...
Reverting the SAME project transaction which is in ‘Selected for credit note’ back to ‘Invoiced’
I just now came to know a way of reverting the SAME project transaction which is in ‘Selected for credit note’ back to ‘Invoiced’. When the project transaction is invoiced, the ‘Transaction status’ is changed to ‘Invoiced’: When you select the transaction for credit note, the ‘Transaction status’ is changed to ‘Selected for credit note’ I was wondering how do i...
Calculation Method and Balancing Fee Journal
There are three calculation methods when it comes to fixed price projects, they are:None Markup percent total Markup percent estimate line This post is not about describing what each of the calculation method does but this post is the super summary of when does the system create the balancing fee journal and when it does not. This post is for the advanced users of revenue recognition… Continue Reading noreply@blogger.com (Sarang...
Quick Post – Fixed Price project eliminate button and invoice posting date
Everyday you learn, no matter what and that’s absolutely true. However more important is to retain what you have learnt today and reduce the time in re-inventing the wheel later. I just now learnt a very small thing but i still wish to put this in writing so that i remember it in future and also if it helps others then, nothing like it. If the project is over and the ‘Eliminate’… Continue Reading noreply@blogger.com (Sarang...
Recognizing the remaining “On-account” on T&M project by dimension
Business case – A prepayment is received from the customer for an additional support contract for 35 hours on top of the actual core project. However the contract is such that whenever a consultant spends time on this engagement, that time is booked on the separate support project and a zero value invoice is raised against the project for the customer to know the hours spend till date…. Continue Reading noreply@blogger.com...
AXAPTAMANIAC: Dynamics 365 FinOps workflow
Workflows in Dynamics 365 FinOps are of two kind and they are:Company specific workflows Organization wide workflows These workflows are system designed and thats how they are. Details of which workflows are company specific and which ones are organization wide is available on technet. However you could also get to know this when you create workflows. If the ‘Association’ points to a… Continue Reading...
AXAPTAMANIAC: Workflow not kicking in
Many times there is a situation where the workflow does not kick in, no matter what. It does not give any error but it does not progress either. In such situations, a functional person can do the following debug steps before going to a a technical consultant. Most of the times this should resolve the issue, if it doesn’t then definitely it needs to be looked into by a technical… Continue Reading noreply@blogger.com (Sarang...
AXAPTAMANIAC: Sales price on a project PO
Reinventing the wheel is always frustrating and royal waste of time. To avoid that, i am writing this post. This is nothing big but just a small note so that it becomes permanent in my memory and i need spend time on it in future if it crosses my path again.Sales price field on the project tab in the project PO behaves differently based on whether it is for item or procurement category and… Continue Reading noreply@blogger.com...
Sales price on a PO when the cost is to be consumed on the project
Reinventing the wheel is always frustrating and royal waste of time. To avoid that, i am writing this post. This is nothing big but just a small note so that it becomes permanent in my memory and i need spend time on it in future if it crosses my path again.Sales price field on the project tab in the project PO behaves differently based on whether it is for item or procurement category and… Continue Reading noreply@blogger.com...
AXAPTAMANIAC: Revenue Recognition – Jumping months in Straight Line Rev Rec.
In my recent project i had to work a lot on the straight line rev rec functionality in detail and had to test many different scenarios. This gave me more insight into what is system capable of doing and what the system is not capable of doing with respect to recognizing revenue in a straight line scenario.Straight line revenue recognition will always recognize revenue (approx.) equal revenue… Continue Reading noreply@blogger.com...
AXAPTAMANIAC: Straight Line Revenue Recognition
Standard calculation for straight line revenue recognition is as follows: Original contract value = 12000 Original contract value Actual start date = 1st July 2018 Actual end date = 30th June 2019 Start and End dates Estimation for first three periods (months) Estimation for first 3 months Calculation for Accrued revenue is as follows: Accrued revenue = (Total contract value /… Continue Reading noreply@blogger.com (Sarang...
AXAPTAMANIAC: Resource Scheduling in Dynamics 365 FinOps
I got to get my hands dirty with this functionality in the new project that i started working on and i must say this has been one of the complex areas in PSA. There are couple of bugs still in the system but overall the functionality started making sense only after i tried and tested the scenarios umpteen number of times. The ‘penny drop’ moment finally happened when i realized that the same… Continue Reading...
AXAPTAMANIAC: Sales Order, Item requirements and Project PO (& auto created Item requirement)
Sales Order cycle:Open Order Delivered Invoiced Item requirements cycle:Open Order (Sales order of ‘Item requirements’ created in the background, with Sales order line status ‘Open order) When the Item requirements is ‘Packing slip’ updated: The Item requirements and the associated Sales order line will be in status ‘Delivered’, if there is NO (cost price = 0) cost price on the item....
WBS and the display of Sales (Procurement) Category
By default the lines created on the WBS are of ‘Hour’ type. They are displayed on the ‘Schedule planning’ tab. However if you wish to define and plan for other project transaction types like, ‘Expense’, ‘Item’ and ‘Fee’, you need to navigate to the ‘Estimated costs and revenue’ tab. ‘Hour’, ‘Expense’ and ‘Fee’ type transactions...
Calculation Method and Revenue Posting
Calculation Method = None Project Cost center = A Contract Value = 100,000 Hours Forecast = 10,000 Total Cost Posted = 7,000 Cost for employee ABS which belongs to Cost Center A = 3000 Cost for employee XYZ which belongs to Cost Center B = 4000 % cost complete = 70% (7000/10,000) Revenue to recognize = 70,000 Note: In this method, the sales price / amount that is displayed against… Continue Reading noreply@blogger.com (Sarang...
Max Hours Calendar and Maximum Working Time
When the resource is setup for timesheets, he is assigned the ‘Period Code’ and a ‘Max Hours Calendar’, however ‘Max Hours Calendar’ is not mandatory.In ‘Max Hours Calendar’ a calendar is selected which has hours specified for the weekdays. Mostly the value is 8 hours per day.If the ‘Max Hours Calendar’ is defined on the ‘Resource setup’ form, then the system...
AXAPTAMANIAC: VLOOKUP – Quick Reference
Today i was using VLOOKUP after long (as was involved in Data Migration validation) and i kind of struggled a bit initially. It is straightforward once you know it, but if you have forgotten the mechanism and the logic behind it, it takes a few, not much, but a few iterations to get it right. The purpose of this quick reference blog post is to stop wasting the time in re-inventing the… Continue Reading noreply@blogger.com...
Reverting the transaction status from ‘Selected for credit note’ back to ‘Invoiced’
I just now came to know a way of reverting the SAME project transaction which is in ‘Selected for credit note’ back to ‘Invoiced’. When the project transaction is invoiced, the ‘Transaction status’ is changed to ‘Invoiced’: When you select the transaction for credit note, the ‘Transaction status’ is changed to ‘Selected for credit note’ I was wondering how do i...
AXAPTAMANIAC: Two IMP things to remember before a presentation
The reason to write this post is to take a not of a major disaster i faced while i was presenting the solution to bunch of individuals, who were supposed to test it later and ingrain that learning so that i never forget again.Batch transfer rules This small setting can take your presentation to an all together different disastrous path. I had my presentation planned in the afternoon and… Continue Reading noreply@blogger.com...
Accounting distributions VERSUS Source document
I have summarized the system behavior for “Accounting distributions” and “Source document” parameter setting in General Ledger module in the form of an excel table, for easy understanding and future reference. The example below is to explain the dimension initialization on the vendor invoice, with respect to the setting and its impact on the postings done to the general ledger.Account… Continue Reading...
Item requirements, Chargeable categories and No project transaction voucher
I would like to quickly register the three important points that i encountered.1. Item requirement record on Project recordWhen all the three parameters are switched on for auto creation of item requirement record (for cost consumption on project on product receipt) on project, we expect the ‘Item requirement’ and eventually the Sales order record to be auto created and we tend to search the… Continue Reading...
Product receipt postings with and without Item Requirement on the Project
Item requirements NOT used on the projectWhen the Item requirements are not used on the Project, then at the time of Project PO receipt postings, cost is not consumed on the project. Please find below the postings at the time of product receipt and supplier invoice.PO created for an Item A for GBP 4000.PO receipt postingsDr Cost of purchase material received 4000 Cr Purchase… Continue Reading noreply@blogger.com (Sarang...
Item setup with respect to Procurement category and Project Category.
Item to Procurement category relationMany items can be a part of single Procurement category. This relation can be obtained by attaching each item with the procurement category from the ‘Product categories’ option on the ‘Setup’ tab on the action pane. When the PO is to be created for all the items related to one procurement category, then on the PO header, the click on the ‘Add… Continue Reading...
Project postings with Billing Rule
When Progress Billing Rules are used on the Time and Materials project, then the following things should be kept in mind:1. The postings setup at the group level for On-accounts and Fee, does not matter. The revenue is directly posted to PNL.Revenue is posted to à Invoiced revenue (CR) Accounting entry is as follows: DR Accounts Receivable Project postings with Billing RuleBlog Syndicated with noreply@blogger.com...
On account postings with respect to BS and PNL
On account set to à PNL Revenue is posted to à Invoiced – On account (CR) Accounting entry is as follows: CR Invoiced – On account CR VAT payable On account set to à BS Revenue is posted to à WIP Invoiced – On account (CR) Accounting entry is as follows: On account postings with respect to BS and PNLBlog Syndicated with noreply@blogger.com (Sarang Kusare)’s...
Item requirement and Project PO receipt postings on project
Out of the box, whenever the project PO is receipted (Product receipt posted), the accrual transactions are posted on the GL (General Ledger) level but the cost is not posted on the project. The cost is posted on the project or consumed on the project only after the project PO is invoiced updated (Supplier invoice posted). To make the project PO receipt reflect on the project, there are… Continue Reading noreply@blogger.com...
Dimensions on Project and Project Contract
Dimensions on the Project: Department – 001 Cost Center – 002 Dimensions on the Project contract:Department – 001Cost Center – 003Dimensions on the Hours, Expense, Fee, On-account transaction posted (from Project):Department – 001Cost Center – 002Dimensions on the Project Purchase order (from Project):Department – 001Cost Center – 002When the invoice is raised:Dimensions on the...
Budget and Billing rule Contract value changes and its impacts
Edits in the Billing Rule contract value Contract value in the Billing rule can only be changed till the time a project transaction is posted to the project. Once the project transaction is posted, the contract value on the billing rule gets non-editable.Contract value is read-onlyEdits in the Cost Budget In the example below:Cost Budget = 10,000Contract value = 100,000Hours transaction… Continue Reading noreply@blogger.com...
AXAPTAMANIAC: Fee Billing Rule – Strange Behaviour
Fee billing rule also has some strange behavior. Will update this post once i find the right reasons for this behavior. But for now just wanted to note this behavior for future reference.Fee billing rule can only be defined if there is an existing billing rule in place, which is other than fee or else you get this error message. This is a standard behavior, which is ok and accepted.Error… Continue Reading noreply@blogger.com...
AXAPTAMANIAC: Progress Billing Rule – Strange Behaviour
This is just a post for me to remember the strange behavior about the billing rule functionality.Whenever a progress billing rule is configured, for it to make it automatically calculate the % complete, all the projects till date should be selected in the ‘Selected projects’ section, with ‘Chargeable categories’ selected for the project configured in the ‘Billing rules’ section.If all the…...
Receipt of a Non-stocked item versus a Stocked item
Receipt postings for the ‘STOCKED’ type of a project:DEBIT Cost of purchased materials received 1000 CREDIT Purchase expenditure, un-invoiced 1000DEBIT Purchase expenditure, un-invoiced 1000 CREDIT Purchase, accrual 1000So effectively it is:DEBIT Cost of… Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on...
Use Tax and Line Property in WBS, Forecast and actual transaction
I have encountered two separate incidents related to use tax and line property, which are totally not linked to each other. Just wanted to note this down somewhere and hence this article.Use Tax I created a vendor record and attached a Sales Tax group to it. Then i created an item and attached an Item sales tax group to it. After that i created a purchase order and clicked on the ‘submit’… Continue Reading...
AXAPTAMANIAC: WBS and Project Budget
If the WBS is defined for the project and also for the same the Budget is also defined, then tracking of project can be done from the WBS as well as Budget. However there is a very minute and important catch here, which if not taken into consideration, the WBS and the Project Budget values will not match.Whenever the WBS is created, it automatically creates the ‘Activities’. However if there… Continue Reading...