Job ledger entries from sales invoice
MrTE
Member Posts: 4
Hi all,
I want to create job ledger entries (usage) when raising a sales invoice. In the Nav5 version, it's only possible to create a sales invoice from a planning or task line on the job. When creating a 'normal' sales invoice, Navision does not automatically generate job ledger entries, as there is no function which updates the job journal lines. When booking purchase lines and a job number is filled, Navision creates job entries and the job Usage total Cost (LCY) field in the Job Task Line table is updated. I want to create the same situation for sales invoices. Is there any possibility to create job ledger entries and update the calculated field Usage Total Price (LCY) in the Job Task table without creating too much code in the database?
To be short: how to update the Usage Total Price (LCY) in the Job Task Line table when creating a sales invoice, without using the 'create sales invoice from job' function?
Thanks,
Tom
I want to create job ledger entries (usage) when raising a sales invoice. In the Nav5 version, it's only possible to create a sales invoice from a planning or task line on the job. When creating a 'normal' sales invoice, Navision does not automatically generate job ledger entries, as there is no function which updates the job journal lines. When booking purchase lines and a job number is filled, Navision creates job entries and the job Usage total Cost (LCY) field in the Job Task Line table is updated. I want to create the same situation for sales invoices. Is there any possibility to create job ledger entries and update the calculated field Usage Total Price (LCY) in the Job Task table without creating too much code in the database?
To be short: how to update the Usage Total Price (LCY) in the Job Task Line table when creating a sales invoice, without using the 'create sales invoice from job' function?
Thanks,
Tom
0
Comments
-
MrTE wrote:Hi all,
I want to create job ledger entries (usage) when raising a sales invoice. In the Nav5 version, it's only possible to create a sales invoice from a planning or task line on the job. When creating a 'normal' sales invoice, Navision does not automatically generate job ledger entries, as there is no function which updates the job journal lines. When booking purchase lines and a job number is filled, Navision creates job entries and the job Usage total Cost (LCY) field in the Job Task Line table is updated. I want to create the same situation for sales invoices. Is there any possibility to create job ledger entries and update the calculated field Usage Total Price (LCY) in the Job Task table without creating too much code in the database?
To be short: how to update the Usage Total Price (LCY) in the Job Task Line table when creating a sales invoice, without using the 'create sales invoice from job' function?
Thanks,
Tom
Have you tried manually updating the sales line job fields prior to posting?David Singleton0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
