Intercompany posting and document no.

dkone

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.