Sage 100

Upgrade to Sage 100 2015.02, when printing the AP aging, if the exclude future transactions box is checked (which it is by default), getting error 46 CI_VendorAging.pvc statement 438. KB returned nothing (surprise surprise). Anyone seen this before and/or have any better answer than telling the users to uncheck the box every print run?

Hi - this is reading the AP_TrransPaymentHistory file... so either 1) one of the settings for the length of the fields is wrong, or 2) the file did not convert properly. Assuming you were upgrading from a version where the invoice number length was smaller, my guess would be the data file... and if this is the case, you may get errors if you enter an invoice # greater than 10 characters..... if you break out of the error, you can print: cDivNoLength (should be 2), cVendnoLength (should be 7) and cINVNoLength (should be 20 ?) Jeff

Error 46 is a length of string invalid error. Generally means the KEY it is using is too long, but it can be other things, mostly not though. I cannot remember getting this error with the string too short. I agree with @JeffFiddelman about changing your criteria to see if the report can run for other ranges. That would indicate a data problem and not a program problem.

Those lengths match up. If you uncheck ""exclude future transactions"" it works... Rebuild of AP_TransactionPaymentHistory.M4T yields The current file's data dictionary definitions do not match those of the new file. Conversion logs show no errors, but the problem happens in both companies. Looking at their file in DFDM and our system in DFDM fields look the same...

I get the same message from rebuild key file on my system as well, but the report run with no errors

I am beginning to wonder if your providex data dictionaries did not get updated properly during the upgrade... Or, heaven forbid, somebody made a mistake at Sage!

It looks like your file did NOT properly expand the invoice number from 10 to 20. you can test this by copying the company, and entering an invoice in A/P invoice entry with >15 characters, and see if you get any errors during entry, journal printing or posting. (in the copy company)

Yup, get an error on entry. How to fix?

The problem is knowing how many files are bad, as well as why this happened - do they only have the one company ?

2 companies

does it happen in both ?

yes

call me 914-834-5222 ?

DFDM MAS90/providex.dde file. Look at rec 000179INVOICENO field 5 is the length. For 2015 it s/b 20..

Any prior mods?

Or backup file. Re-Init, then VI the data in. But if that happened during conversion, there could be others.

I had done a prior test conversion, so for live I just copied the company folders over. Looks like that is not good shortcut anymore...remigration fixed the problem.

I have a issue last week. Remigration fixed my issue too!!

Yikes... Remigration???