Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I have setup a Job with tasks and job planning lines including resources and Items. I want to use the completed job wip method. I have created an sales invoice from the job planning lines and I created Job Journal Lines from the job planning lines. I then closed the job and posted the wip. All of the costs from the job were posted to the to the Job Costs Applied Account from the Job Posting Group that I used. The items that were used in this job did not change the inventory account however the item counts were adjusted appropriately. It does not appear that any of the accounts in the Product Posting groups were used. How can I configure the system to adjust the inventory account for the inventory items? Here are links to some screen shots:
Thank you for the explanation of your steps and the supporting screen shots. Your main question is around the usage of the Items and the manner in which they are (or are not) being accounted for in the G/L.
The reduction of the cost and quantity for the Items (out of Inventory) should have occurred when the Job Journal for these Item-type lines was posted. There are probably a ton of different ways to view this information, but let's try starting with the item. Let's try clicking on the 2010 item in the Items list. Click on the Navigate tab in the ribbon, and there click on the Entries button and choose Ledger Entries.
In this list, I have an Entry Type of Negative Adjmt. that was created by the posting of my Job Journal. This line shows the negative quantity and cost signifying the reduction out of Inventory. Highlight that line and click on the Navigate button in the ribbon. In the Navigate page, we want to drill down on the G/L Entry. What do you see here? What accounts were used on these Entries?
The accounts used are these:
-The Inventory Account from Inventory Posting Setup for the Inventory Posting Group on the item.
-The Inventory Adjmt. Account on the General Posting Setup where the values for Gen. Bus. Posting Group and Gen. Product Posting Group coincide. Cause these additional columns to be displayed in the Job Planning Lines page in order to see the values.
Please let me know if you have further questions on this topic or my explanation.
I do not understand where this is not configured correctly. Please see:
It appears that at the time that Job Journal was posted, there was 0 or negative quantities for these items. Since there was not an On Hand quantity which this negative entry could draw from, there was not a cost that could be used for the G/L Entry.
What is the current quantity for this item? What if you post an increase (receipt) in quantity for the item(s)? That should update the Item Ledger Entry record, in your video, so that they are no longer flagged as Open. You should also follow it up with the Adjust Cost - Item Entries job and post the resulting changes through the G/L. Do you now see the G/L Entries for the cost of the items transacted on this Job Journal?
I posted a purchase invoice for the items and the inventory account shows $12651.38 and the items list shows an inventor of 22 ea of 2011 and 1 ea of 2010. I created a new job with the same Job Planning Lines and I copied these two lines to a Job Journal then I posted the journal. the items quantity on-hand was adjusted but no General Ledger entries were posted. the drill down from the previous looks identical previous screen shots.
Can you please capture the Item Ledger Entries for items 2010 and 2011 again? The prior capture of Item Ledger Entries for 2010 (below) shows that the on hand quantity is negative at the time of these two Negative Adjmt. transactions.
I'm interested to see how this information looks now too.
After it did not adjust the GL Balances I entered another job journal line with a -1 quantity so the items inventory quantity would match the GL
Ok. So I have a couple of questions. Was there a set of G/L Entries for that Job Journal with the -1 quantity? It is Entry No. 53 in the Item Ledger Entries.
How about the Negative Adjmt. Job Journals on these Entry No. lines:
Do any of those three above have G/L Entries when you drill down on them via the Entries button on the Navigate tab?
No GL Entries for any of these Entry No.'s.
Creating a Sales Invoice from the Job creates the appropriate GL entries. For items consumed in the job the item quantity is adjusted but no GL entries.
I tried this same setup in Cronus company and it worked correctly...On the item ledger entries it lists another related entry called G/L Entry. see www.screencast.com/.../0Pv1WCWmF
I still cannot find out why mine does not post the G/L Entry.
In your live (not Cronus) company, can you test the posting of a Sales Invoice? Make this a standalone Invoice--one that is not associated with a Job. Enter one line which is an Inventory Item that has on hand quantities and post. Then let's review the G/L Entries that result from this posting. Do you have Direct Cost entries like my first and second below?
Are you seeing updates to the Inventory account for any decreases in this company? After this test, we will have tested Job Journals and the posting of Sales Invoices. We will have an idea of the results for different kinds of transactions which decrease the quantity and value of the Inventory Items.
Are different Items giving different results? So far in your live company the 2010 and 2011 items have both exhibited this behavior. Have you seen any items properly create a G/L Entry upon posting of the Job Journal?
No selling the item on a sales invoice did not adjust the inventory value. I have not seen any job items post correctly as I am still trying to get it setup. This is the first sales invoice I have printed with an item on it.
I'm sorry for the long delay on my response here. I am guessing that when creating and setting up your company, you did not use the Assisted Setup. I was speculating that this could affect the posting of your cost entries to the G/L, but had not been able to validate this thought until recently. More details about this situation can be found in this forum post: community.dynamics.com/.../225549.
It is going to be necessary for you to run the 'Post Inventory Cost to G/L' utility in order to affect the G/L with the Inventory Cost values. Can you verify that running this routine does update the G/L?
I ran the Post Inventory Cost to G/L utility and it did NOT adjust the inventory account values.
Is there some way that this hidden field can be set for me?
Since the Post Inventory Cost to G/L is not adjusting the Inventory values in the G/L, then I feel that we need to drill down further to see if the Inventory Setup field values is contributing to your issue, or if there is something else involved. Can you work with your CSP to open a support incident so that we can troubleshoot this issue further?
Business Applications communities