Resource Priced in Currency problem

Business Central/NAV Developers Forum
1

V3 & 4

The Resource Price is in USD, the LCY is GBP.

How or where is the Currency price used for Resources?

The Job journal is used to enter the usage (timesheets) using the Resources, these are then invoiced using the Get Job Usage. All OK for LCY priced Resources BUT I cannot see how to post entries to a Job for this resource with anything other than LCY.

The Job journal does not recognise the Currency Price so LCY prices are calculated manually at an exchange rate for the usage posting date (that can be made automatic with code unless the whole concept fails).

When invoicing the Job usage, the LCY is converted to USD at the invoice Posting Date rate.

If the invoice line is changed to reflect the quoted USD price, a line discount is created.

If the invoice line is simply entered against the Job, any difference in the exchange rate is shown as an outstanding amount when applied to the open Job ledger entries.

Am I missing the point? How do I bill the customer in USD at the quoted Resource Price in USD?

2

You can specify the prices for different currencies for a resource, for doing so :

Resource Card>> Prices (button on bottom, right side)>> Prices

3

I think you missed the point.

I know how to set up a price.

I set up a currency price in USD for example.

The Questions are:

  1. WHERE in Navision is there an opportunity to use this currency price? or HOW is that currency price used?

  2. How do I get a quoted USD price to the sales invoice without going via an estimated LCY price in the job journal?

If you try it you will see that the Job journal will not use a currency price.

Cheers,

Colin

4

Hi,

Regarding your 2nd point, I think there is no such option in navision. For getting the Quoted price (for a particular job) one need to use Job Jornal.

Let me give you an example:

I have a resoucrce LIFT in Cronus DB, my local currency is USD and customer 10000 has RUR as local currency. The unit price for LIFT in USD is 450, I haven’t setup unit price in RUR (Customer’s currency).

Now when I use LIFT in job journal or Sales Invoice, its unit price is calculated based upon Currency Exchange Rate on date, in this case (450* 100/ 3.5225=12775.01).

Had I specified Unit Price in RUR also (as mentioned in my previous post), then system will take the Unit Price from that table.

Now coming to your 2nd question, For example you have negotiated Unit Price as 5000 RUR, then this price comes properly in Job Journal, whereas if you create Sales Invoice (directly without using Job Journal) Then this negotiated price doesn’t populate.

5

Like I said, I have a price in currency for the resource (in this case a person, I am billing time against a job).

I raise a job journal but as the job journal does not allow currency prices, there is just the option to use an LCY price.

When the invoice is raised (in currency), the LCY price from the job ledger entry is used to calculate a value in currency for the invoice line.

So say I am installing some equipment to your site.

I have a Job No. for the work, JOB1. I assign a consultant to do the work, Resource = JBLOGGS, and as you are a USD customer you want the prices to be expressed in USD.

The price is USD 106.00.

When posting JBLOGGS time in the Job journal, the only option I have is to calculate 106 * 0.6179 to get an LCY price of 65.50.

When creating the sales invoice and getting the Job Usage, it picks up the 65.50 and calculates the USD value 65.50 * 1.6669 = 109.32

There is now a difference from the quoted price of 106.00 of 3.32.

The customer will not accept this difference (up or down) so what to do. You have to change the 109.32 to 106.00 and get a line discount, that is then passed back to the Job.

So it would appear that having the currency code available for setting up Resources when using the job journal is not possible unless some extensive modification is made to the system?

I hope the example above clears up the misunderstandings.

Still looking for an answer from someone who has come across this and has a solution or simply a confirmation that it is not possible without a lot of code changes.

Cheers,

Colin

6

Colin,

IFin SO/SI header FCY is set;
and if Resource is put on SO/SI directly (not involving any Jobs);
and if SO/SI currency matches available Resource price in that FCY

THEN Navision uses this price in that FCY as set on Resource card, instead of recalculating the LCY price.

Its rather common to use Resources as “non-stockable” goods for sale, say, something intangible, some service etc etc. (This can be done in BE edition, containing only basic Resource granule and no Jobs at all)

7

Thanks but I need to use the Job module.

Some of the time booked is non-chargeable and part of the Job. It is more like a service situation and quite complex.

I have started to work on a solution to use an exchange rate in the job journal and record that, then use the same rate when invoicing, the main thing is to not have any differences when the invoice is posted (leaving roundings as the Remaining Amount).

Cheers,

Colin