Project management Accounting in D365 live-4

he

uh

for

okay uh welcome back again uh we'll start with uh few other things in

project management accounting uh let's get started uh

so previously we have discussed about uh entries how the bookings will be posted

how what is the invoice entry at the time of for the h Journal expense

Journal as well as uh item Journal fee

journals okay these are the things we have discussed in the previous

sessions what happened to this

so now we are going by uh Journal name creation which we

already discuss but I want to show you once again how the journal names will be

created from where the journal names will be created for the h Journal expense item as well as fee

journals let's start

this

okay let's start with the journal names from where and how to create this

we already created I'll just show you from where our Journal it will be created from the project management

accounting our Journal will be created from the project management accounting Journal

names

so Journal

names so this is the place for hover Journal when you create a journal name

for the HS you need to select the journal type as

for then it will appear in the uh Journal name uh then it will appear in

the uh form in the form how Journal creation otherwise it won't create so

same way fee Journal also it will be created from the project management account uh types should be uh

F otherwise it won't appear while creating in the while creating the

particular journals okay that's the

thing so same thing I have mentioned here

and expense J Journal next is expense Journal expense

Journal will be create Journal name will be created from the uh General General

leder so when you go to the journaler journal

names see here project expense type should be

project expense this is the only thing you need to make sure otherwise it won't

appear while creating the expense Journal okay next is

this FAL I just uh told you in the project management accounting we'll

create the uh FAL type should be Fe Journal

type

so item

Journal let me explain few other points here how Journal is basically used for

posting the H uh time uh spent for that particular

project

okay then item J it will be created from the inventory

management module so basically how fee and

beginning balance Journal it will be from project management accounting uh uh

expense Journal it will be from General H and uh item Journal it will be from

Inventory management see this is the one you supposed to take type as a project

otherwise it won't appear in the journal form then beginning balance Journal uh

in the project management uh Journal name form type should be beginning

balance

okay and project approval Journal project approval Journal we can create

from the project approval a project management Journal approval here we'll

select what is required at the time of that particular status for example

approv status uh when the journal is in approved status uh just check the

journal only that is allowed uh not able to edit anything and we next is post

next step is post enter while entering the journal check the journal editing

also allowed then next step is approved so first is enter check the journal

editing also possible and then it is approve stage when it went to approve

State checking the journal only post it then post uh thing you can uh ready for posting

check the journal that's it

approvals okay next stage next topic is

that project

adjustments what happened to this I have added few other

things okay project adjustment uh we can do

from the periodic adjust transactions or from the specific project main step uh

adjust transactions we can do from the posted transactions adjust transactions

as well uh then we'll get the top one screen

will'll receive and uh original transactions bottom change category uh

multiple adjustments we can do from the periodic

session okay [Music]

then you can adjust the project transactions

individually or you can select the multiple transactions at the time at at a time in the list of all projects

transactions project adjustments are used for ex used for example to mass

update of billable status recalculate cost after configuration chain or uh

update funding sources

so these are some of the examples if you want to update the building status or if

you want to uh once uh configuration changed and if you want to do the

changes then you can do the adjustments and how we can do adjustment is that by

using the adjust transaction space can access the project adjust transaction

form

so so let me go to d365 and

show project

management ad just transactions and transactions

click here and select you can give the criteria what

type of uh transactions need to be include and what type of uh projects

need to be

included okay these are the uh this is original transaction and

uh okay this is one place you can

adjust for example if you want to adjust this transaction adjust it you want want

to change the line property you can change from here otherwise uh if you want to change any other details click

okay and if you want to change the category you can do that and uh here if

you want to change the quantity uh any details if you want to change it

you can change it and line property if you want to change it you can change it for

example uh I'll go with cost price of uh 100

rupees and post

it so so this is the journal updated for transaction ID

this is the one so the entry has been uh

new transactions are created P 001 so that is the uh new transaction was

created of after adjustment you can check in the project transactions as

well okay and next stage is that that

um next is that you can uh adjust the transaction from the specific project as

well from all projects you have

uh manage tab under manage tab we will

have manage T we have adjust transactions from this screen also you can do that as well select and you'll

get uh you'll you can provide the parameters that you want to get

transactions and select it it will come here and you can adjust it in the same

way as I explained previously okay this is one more way of

doing it and uh all projects transactions also

you have this option if you go to uh posted transactions

you [Music] have under process you have adjust

transactions this is already adjusted so it's not coming here you can adjust from

this screen as well so how when this adjustments are

allow me it is from the parameters you need to enable the uh adjustments

setups so if you go to

parameters so in the parameter level uh when you want to adjust it allow adjust

of transaction status when it is posted invoice proposal invoice after inv

estimated so you can uh provide when you want to

adjust if you want to create always adjust transaction adjustment

transactions you can enable this as

[Music]

well right this is

uh example of the transaction status include posted transactions invo

eliminated transaction any transaction status that is said to know will have

transactions in the status that won't appear in the adjustment uh process okay

that is okay a configuration option that is uh named always create adjust

transactions is currently available in the project management accounting parameters you can disable this option

to update the original transaction instead of creating uh new transactions

during the adjustment in the subset of scenarios it is it has been announced so

if you want to adjust to the original transaction uh this disable this option to update

the original transaction instead of creating new so it will update the original transaction only if you disable

that option so that's why it won't create any uh other transaction it just

update the original transaction if you enable it you'll um get the transactions

that is uh depreciated by March 23rd after system always behave as if the

option is enabled that means every time it will create the new

transactions adjustment process flow open project adjustment pH select the

transactions and provide the criteria that you want to adjust and post

it so this is the process select uh you'll get the transactions

select the transactions then adjust it then post

it so this is from the parameter level if uh for what type of uh stages you

want to enable this adjustment

feature so this is the same thing updated

adjustment parameters so we have uh description

here always create adjustment transactions this is any way we just discussed uh if this parameter is

enabled the adjust transaction will always create a new reversing transaction and new adjustment

transaction when there is a final Financial or reporting impact if the parameter is disabled the adjust process

will be updated to the original transaction instead of creating is reversal and new transaction for the

scenario such as updated of the transaction

test auto update field if this parameter enable the system will always

recalculate the cost price and sales price use adjustment date as new date

new project this parameter is used to move the transactions into a future uh

physical period uh before the uh system supported this

function before the system supported this function we won't recommend that

you to use it because it changes the business date of transactions and will

depreciate it in future releases so they want to they are going to depreciate

it so allow closing activities usually transactions cannot be created for

closed activities if the parameter is enabled that behavior is overridden therefore adjustments can be created for

closing activity closed

activity so next is periodic multiple adjustments specific project select

project adjust transactions this is one way and uh

project poster transaction adust transactions so this is another way

then adjustment setups we have parameters we already discussed about

this in the parameters we have option to enable the project adjustment

functionality and project validation used to control the recording uh project

transactions uh like V workers uh hours expenses items Etc user

to control recording uh by using the

validations so first is that this is the place where you want to enable the

validation uh in the project management parameter we have three types of

validations uh project category project uh

resources category resources so project category resource project uh Resource as

well as category these are the three combinations uh where you need to

uh enable the validation so these parameters determine

the restriction for entry into the journals and time sheets uh for any validation connection that you set up

for the workers projects and categories you must choose the following three

options uh any one of the three options we have none all projects or

categories uh project workers and category workers are shown you

can so we we look up look up a filter uh

filtered list of project category or project resources and category worker is

shown so here if you select the none all it will show all combinations if you

select look up it will filter the list of project categories project workers

and category workers is shown a filtered list okay valid options that are not in

the list can be entered

mandatory a specific list of projects categories project of workus and

category of workus is shown only options that appeared in the list can be

selected here this one and look up and mandatory difference is that we have

filtered option but filter list of project uh Cate project categories

project local and category vocals but it will shown we can select the different

one as well in the mandatory a specific list of project categories uh category

workers and uh workers projects uh are shown only those can be

selected so example you can create group of junior sales Personnel in the worker

category form and add to the all junior sales uh people and all categories for

transactions that are that can be entered by the sales personnal next in

the project management accounting parameters general area in the category worker field you need to select the

mandatory as a result when the junior salesperson enter the transaction line

in the expense Journal form only the categories that that are defined for the

sales junior sales personal group are available in connection to the categories that are

specified for the junior sales personal group you can add extra categories for

the worker in the group these workers can be selected from the additional uh

categories when they uh when they record expense transactions so validation

connections so from how to validate the connections you can associate a worker

and project from either from the worker form or from the project form however

the result of adding the validation group from worker form or project form

uh differs depending on the form that you use to add the

group either a project is made available for the group of workers or a group

group of projects is made available for one worker so from the project screen

you have a plan tab here you have validations uh assign resources and

assign

categories so project validation work assignments

once you click the validation of resources or categories you'll get the

resources here and you can move the remaining resources to selected

resources in the project validation worker assignments form select the worker tab uh select the legal entity

from which you want to assign the workers project project validation

categories assignment form this is category validation you you can select

the categories no note the legal entity field is available only if the inter

company time sheet suppose has been enabled for the legal

entity note uh this control is available only in the installed for worker from

from the worker form you can go to the worker project tab uh assign projects or

assign resources we have option assign projects and assign categories we have

option uh you can select any one and assign the pro select the projects and

if you select the category assign the categories to the

project and for a category level you have

category setup and there you can assign the uh projects

select the validation groups so these are the validation groups uh project

category validation groups resource project validation group and

uh uh resource category validation group three uh project category project

resource and resource category so these are the three validation groups resource

project validation groups will have the resource uh all the resources available

here and you can select the resources whatever required and projects and

selected project these are the projects uh will be available with these

resources so that's that is the uh meaning behind that enable

validation uh parameters so in the Pro project all projects go to

that project and uh edit it if you edit the project

you'll have a setup option called enable category

validation so validation setup of project category validation group from

now applies to the current project click param uh project management and accounting set of validations uh project

category validation [Music]

group so worker from how to uh map the project project setup once you click on

that you need to map the uh you need to enable the validation project validation

enable category validation from here

it about project

periods uh so

we maybe so testings we need to do we'll stop till

here uh in the after half an hour or 1 hour I'll start with testing these

validations uh maybe otherwise we'll complete this things validation topic

and we'll come up with the testing that will be good I

think this is something three types of

Elations okay okay till here we will read it

once remaining pending things then we'll come up with the testing how it will

behave and3

64 so where we are we are here and

uh and the worker from resource setup we have validations here enable project

validation category valid parameter combination

overview what to select here and about SE about project

periods project periods are used uh primarily with the project time sheets

but they are also used when you work with estimates and invoice subscriptions

period project periods for the time time sheets project periods are used to define the length of the time sheet

period they also used to generate the time sheet reports including missing time sheet reports and calculate the H

utilization workers are a required to submit the time sheet at the end of the

period it is mandatory to assign the periods to the workers but we recommend

that you to create and assign the project periods uh to worker who

registered how transactions these project periods make easy to track the over transactions that

are entered for the same period you must assign the period type and period

frequency to each project um period that you created for example if you if hours

are reported weekly create uh period type and assign period frequency week to

it so the this is the place where we can create the period organization

Administration uh so here period type employee weekly and we have selected

frequency weekly and starting of the day is starting of the week is

month so we have these many types of frequencies uh Ledger period week

biweekly semi semi monthly monthly so these are the options we have available

uh project periods for estimates are used to estimate system to

recognize revenue for for an estimate period in the fixed price project the

project period that you assign to an estimate is used to specify the estimate

frequency so this estimates and all anyway we'll discuss

compl setting up periods uh so this is the way to setting up the

periods create period types and generate the uh you can split the periods as

required for example a week that extends across two months can be splitted into

two periods you can do that those things

from here so have split option here

manage workus in projects create new

worker project setup so these things we

test and uh we'll come to know how it is

behaving so then creating the time sheet those

things we'll discuss in the next session by uh testing it

together okay this are the validation things

okay we'll complete this one today I'll stop here just it's overview

session anyway we'll come to know uh in the testing

session how it is

behaving