I have a database with head office common cost, this needs to be allocated to oversea offices. the allocation is based on total cost in department for the month x some specific rule.
However, I have more than 4000 cost objects (ie department code and project code) for it to allocate to more than 300 oversea branches.
is this too crazy to be done via notes or i should use other third party software?
any real life experience is appreciated.
regards
Will
Subject: Allocation script - no problem
As long as you keep it in 3rd normal form as far as possible, this scale of information is not a problem in Notes at all.
Just make sure to design it sensibly with Head Office main documents, cost item response documents etc, rather than try at fit 4000 fields like “myItem3999” into a single un-maintainable form
A once-a-month Notes agent to compute the totals for each department each month would be trivial to write.