We use Company Bill Statement which allows each corporate card line to create a single report each month per card holder. The statement report populates into the card holder's user profile. For Feb statement, one in particular saw all our flight travel for company offsite, so hundreds of line items plus the associated booking fee (additional lines). The card holder has waited until end of month to use Bulk Edit feature to select Expense Type and fill out Business Purpose. This is crashing their page and the server cannot handle the request.

Per Support: While I know the system should accept editing 200 entries at a time, it seems the issue is due to the increased number of transactions in the report. The report has around 500 entries and more than 300+ alerts, which can lead to a performance degradation.

While there isn't a strict limit on the number of transactions, based on our experience, when a single report approaches 150 entries, it can lead to system performance and slowness issues. 

For this scenario, I suggest either splitting the number of expenses in the report, which I believe would help in improving the process of mass editing the reports or mass-edit a lower number of entries at a time, instead of 200.

The report already self-bifurcated and created a second report automatically. So now I have two reports that are limping along. I actually will have to delete them because we have to close the period and I manually entered the summarized statement in our ERP from a pivot. It was simply flights so it summarized into 5 simple airline lines!! 

Questions:

• How have others handled credit card reports that have tremendously high volume?
• How do you bulk edit when the system keeps choking, even by selecting 10 at a time (would take days to complete)
• Since we have to abandon this report, will the system crash if I try to delete it?
• Will create a different thread asking about filtering for bulk editing, bc currently when you make selections it's "edit all" or "one by one" (too limited)

The card charges are auto feeding overnight. It is not reasonable to ask the card holder to go in each day and code just to stay on top of the feed so it doesn't error out due to excessive lines. Or am I just being unreasonable? 🙂