Sage 100

Has anyone ever dealt with an Error #43? Specifically, our customer is getting this error when running finance charges as part of the month end procedures. This system has been in place and stable for over a decade and the error has only been occurring the past 3 months. This is how the error reads: Erro #43: Format mask invalid Program AR_FinanceChargeJournal_upd.pvc Line 632 General Information: File AR_CustomerSalesHistory.M4T Nothing in the Knowledgebase helps directly although it does look like error #43 points toward a database issue. I rebuilt all custom panels and ran an update on all UDFs. The other strange error that I get that might shed some light is the error I get when I try to run a report of the User Defined Fields. The error is ""Missing selection table for column $."" The Sage 100 version is 4.40.0.6 running on an Applianz server

Create a Crystal Report to look at AR_CustomerSalesHistory records. 43 often means the data is too big for the format - so look for either a huge positive or huge negative number.

Thanks @BethBowers , I'm running that right now. It's a very long report because they have a lot of history.

The only other thing could be that the Finance Charge generation has created a whacko number - but does the Finance Charge print OK before it tries to update? Then probably not that.

@BethBowers , the customer says that the report printed in January but not for February. I'm looking at the AR Account in GL and see that January did have a FC journal but February did not.

Checked code in 2015. L: 632 is trying to create a finance invoice # using a sequence-counter that should not exceed 4 digits. DFDM the AR_Options.M4T file and look at field 63 SeqNoForFC it's probably 9999 or close. Re-set this to zero. They've issued a lot of finance charges and seq # hit the limit.

Thank you, @LeeGraham . That is EXACTLY the problem! I just did dump of the AR_Open file listing all of the FC invoices and I see some strange occurrences for the last few months. I've changed the SeqNoForFC (actually field 59) back to 0000. Does anyone have any idea why that doesn't reset automatically?

No idea but suggest you post this to Sage

Does anyone know if this problem has been fixed in more recent versions? As I said, the customer's version is 4.4 but limiting the system to only 10,000 FC type invoices and then forcing a fix through DFDM seems very strange. Certainly there is another way to fix this!