Share
Report
24Hi!
I am trying to combine two GL accounts in GP 18.5 using PSTL and receive this error: /Conversion failed when converting the nvarchar value '04-0155-005-5022' to data type int/. That account is not one of the accounts I am trying to combine. After receiving the error, the combine process runs a little longer, I receive a message saying it is completed and a report prints showing the accounts are combined. But both accounts still exist in the GL and both still have the original transactions.
When I try to modify an account number it locks up the entire app server on /The Account Modifier is complete on the System DB/3rd party tables/ message.
The PSTL version is 18.2.5. I have clicked on /RebuildProcs/ in PSTL. I also ran checklinks on all financial and ran reconcile on the GL.
The third party products we have are SmartView, SmartFill, SmartList Builder, Auditor, and Nolan Intercompany. I have used PSTL account combiner with all of those except SmartView in the past on other systems and had no issue with them. We do not use FRx or Management Reporter although we did use both at one time. Neither of those programs are installed on our current server.
Can anyone tell me how to track down where this error is originating?
Thanks,
Marilyn
Categories:
All responses (
Answers (
