Get Job Usage and Non Billable hours

teeter · 2007-01-30

I have a client who wants non billable hours to show up on sales invoices.

They are using the Job Journal to enter hours towards a job, and the work type to determine the unit cost.

I have non billable set up to 0.00 unit cost. When they are creating their invoices they use the Function -> Get Job Usage... from the Sales invoice card. This won't pull in any of the non billable hours because they are posted as not open (must be another reason too as I've tried posting them as open as well).

I've also tried giving a unit price to the non billable work type code, then giving it a 100% line discount. After posting the invoice, however, when they get the usage for that job again, that same entry reappears.

Any recommendations on invoicing non billable hours?

Thanks,
Joel

Alex_Chow · 2007-01-30

Standard Navision uses the Total Price as an identifier when you use the Get Job Usage. You'll need to change it to use the Quantity field.

It's not a simple mod, but it's certinaly doable.

David_Singleton · 2007-01-30

Wont it work if you just set the Chargeable flag to False? If you can't do it when initially posting the job entries, you (or your NSC) can write a simple function to uncheck this field.

teeter · 2007-01-31

Thanks for the help!

David:
Setting the chargeable flag to false also sets the open flag to false when posting, so they don't show up when i get job usage.

I've done some modifications and I am now stuck in 2 different places ](*,)

1) I modify the filters in the Get Job Usage report to allow non open records if they are type non billable. This gets the jobs into the invoice, but after I post they will keep showing up each time i use get job usage for that customer.

2) I modify the job posting to post non billables as open. This also lets them show up after getting job usage, but when I post the sales-post doesn't flip the flag to false, so again they keep showing up in later get job usages.

It's looking to me like either way I'm going to have to do some changes in the sales-post codeunit (really want to avoid this). Any other suggestions?

thanks,
Joel

Alex_Chow · 2007-01-31

Like I said, you need to change the application method in the posting routine to be based on Quantity, not the Total Price.

Get Job Usage and Non Billable hours

Comments

Categories