Module P/R not on file

Question

Hi Forum, 
 
 I have a script that is updating a AR_Salesperson table UDF when a UDT field is updated. 
 The process fails when updating the AR_Salesperson table. 
 I am getting a "Module P?R not in file" message. 
 I've seen this message before but I don't recall the fix for it. Went thru my notes and couldn't find anything on it. 
 Any ideas in what can be causing this error. The Customer doesn't have P/R and they have no enhancements that required the Payroll module. 
 
 Regards, 
 Manuel Roman

mroman · Accepted Answer

What I did was to set Post Write event... update the Salesperson Table when the accept button is clicked... that worked. 
 Thanks for the info... 
 
 Regards, 
 Manuel Roman

David Speck · Answer

Verify that is not just a false positive. Check the LastErrorMsg of the object calling the methods after each method. You may even want to check The LastErrorMsg after first getting the object handle and if not blank or is the same "Module P/R is not on file", then that is just a warning set when the object handle was created and assuming your subsequent methods leading up to the Write method don't cause any warnings and you only check LastErrorMsg, then you will end up seeing it as a false positive. You can set the property to a blank value and carry on with your script. the important thing is to be checking the returned value from the methods you are calling and if they aren't what you expect, then check LastErrorMsg. Don't forget to reset LastErrorMsg between methods as needed, since in my experience, it does not reset itself. 
 If on version 2018+, make sure to have copied and renamed the pvxwin32.exe.config file from MAS90\Home to pvxcom.exe.config in C:\Program Files (x86)\Common Files\Sage\Common Components. This may not be related to your exact issue but is required if you plan to access any report from an external script that uses the pvxcom.exe process. 
 https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=86083

Sage 100

Module P/R not on file

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING