dsj8481
23rd July 2004, 19:00
Post integrations and/or finalization of batches is crashing with table does not exist error because Service order costs are trying to post to financial company 000 instead of 100 (of course, company 000 has no financial tables). The remaining integration transactions for the service order are correctly posting to 100.
table tfgld417.fcom tfgld418.fcom and tfgld102.tcom will have 000 in it for service order costs. Gtm these records to the correct company and they will process through integrations or finalization with no problem.
Also, it is the costs for a particular item that is causing the problem.
Have checked many, many places for the cause of this. User defaults, order series defaults, order header, dug through many tables. No customers have a default financial company of 000. Although 4-5 did and we fixed that. The orders with this problem have not been for customers that had the 000 default financial company. No suppliers have a default financial company of 000.
The default financial company of the service order series is correct.
Just found that tssma310.ncmp is also 000 for many orders - but even for orders which existed years before this became a problem for us.
Any ideas or recommendations? :confused:
table tfgld417.fcom tfgld418.fcom and tfgld102.tcom will have 000 in it for service order costs. Gtm these records to the correct company and they will process through integrations or finalization with no problem.
Also, it is the costs for a particular item that is causing the problem.
Have checked many, many places for the cause of this. User defaults, order series defaults, order header, dug through many tables. No customers have a default financial company of 000. Although 4-5 did and we fixed that. The orders with this problem have not been for customers that had the 000 default financial company. No suppliers have a default financial company of 000.
The default financial company of the service order series is correct.
Just found that tssma310.ncmp is also 000 for many orders - but even for orders which existed years before this became a problem for us.
Any ideas or recommendations? :confused: