Open in Excel v/s Export to Excel
Nov05

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

Read More
Was “Hit Refresh” by “Microsoft Future Decoded 2018” – Part 1
Nov03

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

Read More
Was “Hit Refresh” by “Microsoft Future Decoded 2018” – Part 2
Nov03

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

Read More
New book on Microsoft Dynamics 365 FinOps – “Microsoft Dynamics 365 FinOps – Fixed Price Projects Revenue Recognition In-depth”
Oct02

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

Read More
Split the On-account invoice transaction for Credit note
Sep17

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

Read More
Reverting the SAME project transaction which is in ‘Selected for credit note’ back to ‘Invoiced’
Sep14

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

Read More
Calculation Method and Balancing Fee Journal
Sep14

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

Read More
Quick Post – Fixed Price project eliminate button and invoice posting date
Sep04

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

Read More
Recognizing the remaining “On-account” on T&M project by dimension
Aug31

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

Read More
AXAPTAMANIAC: Dynamics 365 FinOps workflow
Aug22

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

Read More
AXAPTAMANIAC: Workflow not kicking in
Aug16

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

Read More
AXAPTAMANIAC: Sales price on a project PO
Aug10

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

Read More
Sales price on a PO when the cost is to be consumed on the project
Aug10

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

Read More
AXAPTAMANIAC: Revenue Recognition – Jumping months in Straight Line Rev Rec.
Aug06

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

Read More
AXAPTAMANIAC: Straight Line Revenue Recognition
Jul31

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

Read More
AXAPTAMANIAC: Resource Scheduling in Dynamics 365 FinOps
Jul10

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

Read More
AXAPTAMANIAC: Sales Order, Item requirements and Project PO (& auto created Item requirement)
May16

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

Read More
WBS and the display of Sales (Procurement) Category
May15

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

Read More

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

Read More
Max Hours Calendar and Maximum Working Time
Feb07

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

Read More
AXAPTAMANIAC: VLOOKUP – Quick Reference
Jan07

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

Read More
Reverting the transaction status from ‘Selected for credit note’ back to ‘Invoiced’
Dec13

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

Read More
AXAPTAMANIAC: Two IMP things to remember before a presentation
Nov30

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

Read More
Accounting distributions VERSUS Source document
Oct22

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

Read More
Item requirements, Chargeable categories and No project transaction voucher
Jun09

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 record When 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...

Read More
Product receipt postings with and without Item Requirement on the Project
May16

Product receipt postings with and without Item Requirement on the Project

Item requirements NOT used on the project When 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 postings Dr Cost of purchase material received 4000          Cr Purchase… Continue Reading noreply@blogger.com...

Read More
Item setup with respect to Procurement category and Project Category.
May16

Item setup with respect to Procurement category and Project Category.

Item to Procurement category relation Many 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...

Read More
Project postings with Billing Rule
May15

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 Rule Blog Syndicated with...

Read More

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 PNL Blog Syndicated with noreply@blogger.com (Sarang Kusare)’s...

Read More
Item requirement and Project PO receipt postings on project
May08

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

Read More
Dimensions on Project and Project Contract
Apr27

Dimensions on Project and Project Contract

Dimensions on the Project: Department – 001 Cost Center – 002 Dimensions on the Project contract: Department – 001Cost Center – 003 Dimensions on the Hours, Expense, Fee, On-account transaction posted (from Project): Department – 001Cost Center – 002 Dimensions on the Project Purchase order (from Project): Department – 001Cost Center – 002 When the invoice is raised: Dimensions on the...

Read More
Budget and Billing rule Contract value changes and its impacts
Apr21

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-only Edits in the Cost Budget  In the example below: Cost Budget = 10,000Contract value = 100,000Hours transaction… Continue Reading noreply@blogger.com...

Read More
AXAPTAMANIAC: Fee Billing Rule – Strange Behaviour
Apr19

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

Read More
AXAPTAMANIAC: Progress Billing Rule – Strange Behaviour
Apr19

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

Read More

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                                     1000 So effectively it is: DEBIT Cost of… Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on...

Read More

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

Read More
AXAPTAMANIAC: WBS and Project Budget
Mar03

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

Read More
Importance of ‘Active in Journals’ and ‘Stocked Product’ control WRT Project Supplier Invoice
Feb11

Importance of ‘Active in Journals’ and ‘Stocked Product’ control WRT Project Supplier Invoice

Direct Supplier invoice (without a PO) that is to be created for the project can make use of items as well as procurement categories. In that case, items as well as the procurement categories should be linked to a project category. To setup and link a procurement category to a project category, refer the post Procurement Categories and related setup. Please refer below for the two main… Continue Reading noreply@blogger.com...

Read More
Intercompany Vendor / Customer creation
Nov29

Intercompany Vendor / Customer creation

Intercompany Vendor and Customer can be created by creating a relationship between the two intercompany records. Whenever the intercompany vendor and customer is created, the ‘Active’ checkbox should be checked in the ‘Miscellaneous details’ tab of the Vendor / Customer record. However, this is a non-editable field and hence cannot be checked manually by the user. To check that ‘Active’…...

Read More

Two IMP parameters from Procurement and Sourcing

There are two parameters worth noting from the Procurement and Sourcing module (under Parameters > Update) . They are: Safety level of invoiced orders Check for product receipt number used “Safety level of invoiced orders” drop down has three values. They are as follows: None – User can change the value on the fully invoiced PO Warning – User will receive a warning, if the user tries to… Continue Reading...

Read More