Intercompany Transaction error

amanpreet.singh
Member Posts: 23
Hi All,
I have posted a transaction from Company A to Company B.
while posting the transaction from Company A the system completed the transaction....when i tried to COMPLETE LINE ACTION in Company B's INBOX the system says IC G/L ACCOUNT NO. "DOESNOT EXIST.
Please let me know ...where is thw missing link ....I have checked the Partner Card in the FM SETUP (Inetrcompany---> Parttner)
regards
I have posted a transaction from Company A to Company B.
while posting the transaction from Company A the system completed the transaction....when i tried to COMPLETE LINE ACTION in Company B's INBOX the system says IC G/L ACCOUNT NO. "DOESNOT EXIST.
Please let me know ...where is thw missing link ....I have checked the Partner Card in the FM SETUP (Inetrcompany---> Parttner)
regards
0
Comments
-
have you transfered G/L Account information from A to B ?
you did not set CHANGECOMPANY for the table in question to point to destination company and luckily the record you looking for in destination company does not exist there and is present only in the source company hence the error message revealing programming logic error.
what you did was you WHILE BEING IN SOURCE COMPANY A were reading data from company A (source company) and writing data to company B (destination company). It is not good idea because when writing data to other company you need to set manually for every record type variable CHANGECOMPANY. Some of those variables will be unavailable for you to set (for example you try to write to master table and have no access to details table defined and handled in the master's table OnInsert trigger).
It is much better idea WHILE BEING IN DESTINATION COMPANY B to import data from source company A. This is because you only need to set CHANGECOMPANY for tables you are reading from and it does not involve cascaded triggers code execution in other (not currently opened) company0
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