web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / The Dynamics Troubleshooter / Override the Cost or Revenu...

Override the Cost or Revenue Main account at line level in Dynamics 365

Views (1)
Paolo Cecchelli Profile Picture Paolo Cecchelli 225
The posting on Sales and Purchase Orders for the various posting types is tipically determined by the Posting setup under Inventory management--> Setup --> Posting --> Posting:

Sometimes it happens that is needed to change the posting account on a single line of a single order. If the posting type of the account is a Revenue account on a Sales order or a Purchase expenditure for expenses is possible to select it directly on the Order lines, with some limitations…

Changing Cost Main Account on Purchase order lines
On the Purchase order lines is possible to change the posting account in two ways, but it depends on the line type you are inserting. The following two methods work only for procurement categories and service-type item:
  1. Go to the “Financial --> Distribute amount” menu on the line:


The account coming from the “Purchase expenditure for expenses” Posting setup

The account after having changed it manually

Here we can select the Main account that will be posted in the “Purchase expenditure for expenses”, as can be seen from the Purchase invoice:


  1. On the line details of the PO, select the account for the “Purchase expenditure for expenses” posting, this will override what is set in the Posting profile:

However as mentioned this possible only if the line contains a Service item or a Procurement category, if it contains a Product stocked item, is not possible to change the Account on the Financials à Distribute amount pane and neither on the line details:

The account cannot be changed for stocked Items from the Distribute amount

The account cannot be changed for stocked Items from the line details, as it is greyed-out

The only option in this case is to momentarily change the posting profile and hit the “Correct” button to have the line fetch the new setup in Inventory management à Setup à Posting à Posting:
  1. Change the main account

Main account before change, the one retrieved on the line

Main account after change

Now if we go on the line and click on “Reset” the line will fetch the new account we setup:

Be careful that this change will affect all the lines created during the change.


Changing Revenue Main Account on Sales order lines
On the Sales order line there is not a similar functionality as the “Distribute amount”, however there is a field called “Main account” on the line details that can be used to override the one selected in the posting. This is the posting situation for the ITEM and the Service item and one category that we have on the Sales order:


The sales order lines look like this:


If we generate the invoice we will have that the posted accounts are the ones setup in the posting:

Now, if we copy the three lines but this time before posting we fill the “Main account” and input for all three lines a main account t different from the posting:


This is the voucher of the invoice: instead of the Main account setup on the posting, the revenue account was overridden by the Main account we specified on the line:

Important Note: in some localization like the Italian one, where the Sales posting for credit notes is specified on a different posting account than the Revenues from Sales, the input of the MainAccount on the Sales Order line in case of line with negative quantities (credit note) does not change the posting account to the one specified on the line.

That’s all folks, see you next time!

Comments