Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Good Day All,
Here is a fun one. I am working with the Jobs module in a NAV 2017 install. I create my job, including Billable and Budget line. To simplify, I create one of each and I completely consume the hours on the job so that it is as if everything on the job is completed. I then go to create a Sales Invoice from the Billable line item and I am getting a total that is only 77.06% of the total billable amount.
See the job configuration screen below.
Below you will see that this is entered correctly on the job planning line item:
However, when I click on Create Sales Invoice, it simply creates the invoice with an incorrect amount.
This is indeed a Canadian company and I am trying to book against a US customer and US contractor. I have my invoice currency and division code set to US. Is there somewhere on the master job setup where I can specify this is a US job even though it's in Canada so that when I budget I am able to be budgeting in US Dollars?
Thank you ahead of time.
Here's the actual invoice screen. Total on invoice is only showing at 11558.90 for a 15,000 billable line item. I don't quite see why this is happening.
Can you check the Sales(LCY) column at statistic page(F7), in LCY it should still be the same. the Currency Code generated at sales invoice will follow "Currency Code" field at job card , if it's blank it will then take from "Invoice Currency Code" . If both blank , it will follow currency code at customer card.
SOLVED! You are correct I Gusti Made Ari Permadi. The sales $ amount is 14,999.98 even though price is set to 15,000. I now understand, however, this is due to the rounding. You are correct that the currency was being pulled form the customer. Canadian company with US customer using US currency.
For anyone curious where these codes are set up, they are under Financial Management > Setup > General. I only have USD set up with an exchange rate of 1.2977 so this conversion doesn't quite make sense because the total including tax for this invoice is $11,558.90.
$11,558.90 * 1.2977 = 14999.98453 (or $14999.98)
This is an effective load factor of 0.770594
TEST your rounding settings. Make sure your tax professional is okay with the rounding. In my specific example, I'm two pennies off depending on which way I round so you need to make sure this is OK.
Quick note: I will say that LCY for anyone new to NAV refers to the local currency assigned to anything (customer, invoice, etc). FCY is the Foreign currency. So for this invoice the local currency was Canadian dollars. The foreign currency on the invoice was US. Therefore it had to translate.
Good Stuff! Send me your paypal as a direct message and I'll send you a beer! :)
No Problem man :) , glad to be able to help
Business Applications communities