Split Invoice Line Posting

chadwicke
Member Posts: 10
I need to find a way to post one line on an invoice to mutiple GL revenue codes.
For instance, I need to enter one item on an invoice for £1000, and have it post to two GL revenue codes, £500 to 6120 and £500 to 6130.
It would be preferable to enter GL codes that the invoice line posted to at the time the invoice line was entered.
Any help would be much apreciated.
Reagrds
Edward
For instance, I need to enter one item on an invoice for £1000, and have it post to two GL revenue codes, £500 to 6120 and £500 to 6130.
It would be preferable to enter GL codes that the invoice line posted to at the time the invoice line was entered.
Any help would be much apreciated.
Reagrds
Edward
0
Comments
-
One of our clients had a similar situation. Since automatically splitting up invoice lines to different GL account is not possible, we changed the report (206) in such a way that when the GL account (in your case 6120 and 6130) occurred, only one line was printed with the total amount of these lines. Calculating these lines must take place in the sales invoice header.
I know, not very pretty, but it works.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 320 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