Jobs Invoice Creation Creating Totals Lower than the Billable Price - No Discount Applied

(0) Share

Report

Posted on by Community Member Microsoft Employee

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.

Cheers!

Matt

*This post is locked for comments

All responses (4)

Answers (1)

I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: Jobs Invoice Creation Creating Totals Lower than the Billable Price - No Discount Applied

No Problem man :) , glad to be able to help
Community Member Microsoft Employee on at

Like (0)

Report

RE: Jobs Invoice Creation Creating Totals Lower than the Billable Price - No Discount Applied

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! :)

Cheers

Matt
Verified answer

I Gusti Made Ari 3,594 on at

Like (1)

Report

RE: Jobs Invoice Creation Creating Totals Lower than the Billable Price - No Discount Applied

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Jobs Invoice Creation Creating Totals Lower than the Billable Price - No Discount Applied

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.