06-16-2008 9:27 PM
Hi,
does anyone know of a way to retreive all billing documents for a specific contract without going through all bills of the contract account ?
When we go through the contract account we must retrieve all bills to check if they are associated to that contract or not. This causes performance problems for contract accounts that have many contracts (and many bills). We have certain cases where a contract has 30 bills but the contract account has over 350 bills.
Thanks
Thierry
06-17-2008 9:09 AM
Hi,
Check in the table DBERLDB.
Entry the Contract number in the field vertrag
and look for the field billdoc.
This will display all the billing documents for that particular contract.
Regards,
Vinay
06-17-2008 9:09 AM
Hi,
Check in the table DBERLDB.
Entry the Contract number in the field vertrag
and look for the field billdoc.
This will display all the billing documents for that particular contract.
Regards,
Vinay
06-17-2008 6:45 PM
Thanks,
I'm just wondering about this table , I have much (3 000 000) less contracts than in table EVER and I'm sure that all contracts were at least billed once.
Thierry