Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Intercompany posting and document no.
dkone
Member Posts: 59
Hi all,
I made a custom intercompany timesheet posting that allow user to post job & resource usage and post it in the right companies.
Jobs are per company and resources are shared.
I made :
A replication of resource between company (in a mibuso/Alex show/Nav way http://mibuso.com/blogs/alexchow/page/3/) with a slave/master logic
A "journal like" table with datapercomany = no. that show job records from all company,and resource from the company
Basically, you just put a job, a resource and a quantity in this shared table.
After that the user log into a company and launch a posting routine that import record from my shared journal table in the job/resource journal line and post it line after line (i'll maybe improve it later with NAS).
It works fine but i have a problem with the "Document No." in job/resource journal line : I don't know what is the best way to handle it.
Should i :
- Put a No. series in a setup table use it in my shared table and copy it in the journal lines (IMHO the best way because we just manage one serie).
- Put a template batch name in a setup table and fill the "No. Series" parameter, and use this journal in my posting routine.
- Just make my own "Doc No." like 'TS 2010-31-01-xx'
- No matter, those options are equal
I hope it's clear
Feel free to correct my poor english or to answer something like this : http://mibuso.com/forum/viewtopic.php?f ... 55&start=0
Regards,
dkone.
I made a custom intercompany timesheet posting that allow user to post job & resource usage and post it in the right companies.
Jobs are per company and resources are shared.
I made :
A replication of resource between company (in a mibuso/Alex show/Nav way http://mibuso.com/blogs/alexchow/page/3/) with a slave/master logic
A "journal like" table with datapercomany = no. that show job records from all company,and resource from the company
Basically, you just put a job, a resource and a quantity in this shared table.
After that the user log into a company and launch a posting routine that import record from my shared journal table in the job/resource journal line and post it line after line (i'll maybe improve it later with NAS).
It works fine but i have a problem with the "Document No." in job/resource journal line : I don't know what is the best way to handle it.
Should i :
- Put a No. series in a setup table use it in my shared table and copy it in the journal lines (IMHO the best way because we just manage one serie).
- Put a template batch name in a setup table and fill the "No. Series" parameter, and use this journal in my posting routine.
- Just make my own "Doc No." like 'TS 2010-31-01-xx'
- No matter, those options are equal
I hope it's clear
Feel free to correct my poor english or to answer something like this : http://mibuso.com/forum/viewtopic.php?f ... 55&start=0
Regards,
dkone.
0