Hi,

I touched on this in an earlier thread but I feel obliged to mention it again.

Does anybody else suffer from poor performance in Maintain Purchase Invoices session tfacp1110s000.

The problem is related to the number of records in tdpur045 which causes the entry of the Packing Slip to take about approximately 30 seconds as there is no index on packing slip in the table tdpur045.

We have approx 100000 records in tdpur045 and we have now archived up to the beginning of this year. So we are really running out of options.

Does anybody know if is there an index on packing slip in later releases of the software ?

Thanks
Neal Matthews

Have you also archived your general ledger integration transactions? That table becomes huge and is usually the first to be archived. You may be experiencing delays as the session tries to post.

Stephen Ruger
Lodestar Consulting
215-785-6756
sr@mylodestar.com

Funnily enough we're currently archiving the integration transactions.

However the performance problem is very specific and is related to the packing slip field where the user has to wait for approx 30 secs.

We have performed various traces on this session and the problem is definately related to the number of records in tdpur045.

We have proved this beyond all doubt by clearing tdpur045 in our test company and unsurprisingly enough the session then flies.

Thanks for your input.
Neal

In BaanERP the session tfacp1110s000 now uses table tfacp200 for posting. The seven keys are:
Document
Business Partner - Document
Business Partner - Invoice number
Fiscal Year Batch
Business partner - Document Date
Payments
Batch number

Hope this helps.

Stephen Ruger
Lodestar Consulting
215-785-6756
sr@mylodestar.com

We are also posting into tfacp200 but the problem is on the lookup of tdpur045.

How many keys are there on tdpur045 in Baan ERP.

Regards
Neal Matthews
MSS Project Leader

probably by tdpur405, that table has only 2 indexes.

Did you already investigate the query? If you know how the sql statement looks and if you are using a level II driver you can probably add an additional index in your database.

Regards,
Han

Thanks for that,

How does the Maintain Purchase Invoices session work in Baan ERP with regards to entering the packing slip on the first screen and subsequenting matching.

Would I need a development licence to add an extra index ?

Regards
Neal Matthews
MSS Project Leader

I don't know how it works in ERP, sorry don't have the time to investigate.

For the add. index: you can create it directly in your db, not within Baan but as stated before you have to use a level II driver in that case.

Hope it helps,
Han

Hi Han. Good to hear from you again.

Would adding the additional key in the DB and not in Baan actually help? I assumed that when Baan does the query it would ignore any keys it did not know about.

Stephen Ruger
Lodrstar Consulting
+1.215.785.6756
sr@mylodestar.com