When using the item number combiner feature of the PSTL, you might encounter an error indicating that there is an invalid object name which is DYNAMICS..syscolumns . As a result, the process is interrupted and will fail to deliver the required results. The encountered errors are included below:
 |
| Dynamics..syscolumns |
 |
| Procedure TACallItemCombine |
The stored procedure that is designed to manage the whole combine task is "TACallItemCombine", it is encrypted and can not be checked. The error is primarily due to having a static "SQL statement" within the code checking DYNAMICS..Syscolumns. Although, in certain environment the DYNAMICS db itself could have a different name due to the new feature of changing its name. As a result, this process will break up in the middle achieving no results at all.
 |
| Item Number Combiner |
In my environment, I had Dynamics GP 2015 and the database names are as follows:
- GP Company : GP15R
- Dynamics Company: DYN15
Therefore, the procedure failed to find an object in a database which name is DYNAMICS, and eventually fail.
In order to work this out, I have created a dummy database with the name 'DYNAMICS', just to force the procedure to proceed since it is encrypted and can not be altered.
Best Regards,
Mahmoud M. AlSaadi
Mahmoud M. AlSaadi
Thanks Mahmoud,
ReplyDeleteThis shows once more that sometimes Microsoft itself shoots in the stars when adding new functions to GP (i.e. named system databases other than DYNAMICS) and doesn't back-test properly all their tools :-)
Hello Beat
DeleteUnfortunately, sometimes yes :)
Best Regards,
Mahmoud M. AlSaadi
Mahmoud
ReplyDeleteThank you for the explanation it was driving me crazy. Have you determined any other way to run the function other than create a dummy database?
Helly Gary
DeleteUnfortunately, no. This needs to be reported to Microsoft Support team in order to sort it out. Meanwhile, creating a dummy database seems the most effective solution.
Best Regards,
Mahmoud M. AlSaadi
BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast
ReplyDeleteyou can be to get the new PROGRAMMED blank ATM card that is capable of
hacking into any ATM machine,anywhere in the world. I got to know about
this BLANK ATM CARD when I was searching for job online about a month
ago..It has really changed my life for good and now I can say I'm rich and
I can never be poor again. The least money I get in a day with it is about
$50,000.(fifty thousand USD) Every now and then I keeping pumping money
into my account. Though is illegal,there is no risk of being caught
,because it has been programmed in such a way that it is not traceable,it
also has a technique that makes it impossible for the CCTVs to detect
you..For details on how to get yours today, email the hackers on : (
atmmachinehackers1@gmail.com ). Tell your
loved once too, and start to live large. That's the simple testimony of how
my life changed for good...Love you all ...the email address again is ;
atmmachinehackers1@gmail.com