Dimension "same code" problem

amc
Member Posts: 4
Hello everyone
I'm trying to solve a problem with dimensions, but the more I search the more lost I get! I am trying to post invoices where the accounts have all been set up with a linked dimension value which is different for each account (corporate account) and is set as "same code". Each time I try to post the invoice I have to retype in a value for the group account (customer posting group account).
Has anyone else seen this - can anyone help me solve it please
Thanks
Andy
I'm trying to solve a problem with dimensions, but the more I search the more lost I get! I am trying to post invoices where the accounts have all been set up with a linked dimension value which is different for each account (corporate account) and is set as "same code". Each time I try to post the invoice I have to retype in a value for the group account (customer posting group account).
Has anyone else seen this - can anyone help me solve it please
Thanks
Andy
0
Comments
-
Retype? You mean add? Is this dimension set on the customer card as default dim?0
-
Hi - I mean retype. The dimensions are already set in the chart of accounts for all accounts - each account is linked to a "corporate account" dimension, and has a specific dimension value with the "same code" value posting.
When I post the invoice, either the value from the sales header (if existing) is taken across (default functionality), or the dimension value of the specific G/L account entered on the sales line is the one used.
The problem comes with the accounts that are not added onto the sales line, but are posted by "posting group" setup - customer group etc.
I don't know if it can be done without a change in code, or if it is feasible at all.
Thanks for any help
Andy0 -
I see the problem in the setup of the dimensions. You cannot set it in this way and asume that it will work. Dimensions are inherited from the documents, not from the accounts on which the result is posted. You can use priorities to set from which source the dimension will be used if there are more sources with different value for same dimension, but it will never solve the dimensions on the g/l accounts from PG setup. Me personally will never advice to use G/L account no. as dimension (or corporate G/L account no.) and NEVER as "Same code". Dimensions are not there to map G/L accounts to some other nos. For that you can use Consolidation if I am not wrong...0
-
Thanks - I'll run it as that. I think then if I set the default dimension in the customer to the same as the collective account, I can respect the document dim hierachy.
thanks again0
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