I need some help understanding how D365 is designed to handle the posting and what accounts should be used. First lets take an Item that I order for resale that will be part of a Job. I am using the Average cost Method.
Inventory Posting Setup: What is the Inventory Account (Interim)? How is this account used?
When I post an Invoice for items received it put the value of the items in the Inventory Account (Interim), when or how are the values transferred to the Inventory account?
Second, what is the proper procedure to Invoice lines from Job. I need some detailed information on how this works and should be configured.
Hi Ezra,
Thank you for the questions.
You mentioned that you are using the Average Cost Method in Dynamics 365 for Financials. However, unless you have some super-secret method for setting up your items, Dynamics 365 for Financials will always use the FIFO cost method. Let me know if you are doing something special in order to change the costing method.
The Inventory Account (Interim) is not typically expected to be used on Dynamics 365 for Financials. It is typically used to account for the cost of the item in the Item Ledger for purchases and sales where the Receipt/Shipment of the items has been recorded but the invoice has not yet been posted. However, even in this situation, the Expected Cost Posting to G/L checkbox, in the Inventory Setup page, would need to be marked. But Dynamics 365 for Financials does not serve up that checkbox on that page. This means that we would expect that the processing of a Receipt/Shipment of the items would not have an effect on the G/L. Then when the related Invoice is subsequently posted, the Inventory Account--not the Inventory Account (Interim)--would be used. Here is a link to a page that explains the expected usage of the Inventory Account (Interim) for the handling of the Expected Costs in NAV: [View:https://msdn.microsoft.com/en-us/library/hh997370(v=nav.90).aspx:750:50]. Is there some additional method that you are using or Extension that you have in place in Dynamics 365 for Financials which has enabled this Expected Cost Posting to G/L?
Finally, you are asking for information on Invoicing the Lines from Jobs. Yes, this is rather involved. The Manage Projects help page has a number of links which will be helpful for dealing with the lines--creating, recording transactions, and subsequently invoicing: [View:https://madeira.microsoft.com/en-us/documentation/projects-manage-projects/:750:50].
Similarly, this MSDN page contains many of the same categories of information, but with a bit more detail than the above help: [View:https://msdn.microsoft.com/en-us/library/hh172378(v=nav.90).aspx:750:50].