Sage 100

Getting this error in Bank Rec (nothing on Sage) - Error 41 in BR_COMMONENTRY_UI-PVC line 808. Have rebuilt file, rebuilt sorts. Exported out using VI, no errors. Anyone?

what version & PU?

2016.1

Are there any mods or third party? I looked at the code for my BR_CommonEntry_UI.pvc and it only has 586 lines so there is no line 808, Mine is version 2016.3 but seems unlikely there would be less lines in a newer version.

No mods. :-(

There is a line 808 on that version. Looks like a bad check date.

Dang it, that's what I would have guessed, but Crystal Reports doesn't choke on it. I have an export in Excel - I'll go over it again.

I found a blank date - hoping that's it. Thanks, @NicoleRonchetti !

I had the same issue last week. I exported the entire BR_Transaction file to Excel and found a date field formatted with 2180228. Once I changed it to 20180228, the error went away. The source was from AP, so I had to change the date field from the source record in the AP_CheckHistoryHeader, AP_OpenInvoice and AP_TransactionPaymentHistory. This customer is on Sage 100 2017 Standard with PU3.

Oh now this is really interesting, @LewWeiner - mine was the exact same thing! Like the EXACT SAME DATE. Maybe it's a 02/28 issue with Sage!

Did your error originate from AP like my customer's did?

Yep, sure did.