TI - Voucher & Adjustment Entry
Jon
want to prevent possible duplicate invoices from being accepted through the
TI. Can anyone tell me I can reject the possible duplicate invoices from
being accepted into the system.
Barry Flynn
It may be possible.
I suggest that you proceed with caution & make sure you have a backup of
your Messages,csv file!
There is a Messages table in the system database.
But, my opinion is that in normal running, that table is ignored, and
messages come from a flat file called Messages.csv in the Solomon root
directory.
On the rare occasions I play with that file, I edit in in Notepad rather
than Excel, because I want to be sure that Excel dpesn't add any "Excel
stuff" to the file.
I did play with this sort of thing a wee bit a long time ago, but my memory
is a bit vague.
I think there is some info in Help - I suggest you search in there before
doing anything.
I think there are two possibilities inthe Messages.csv file.
One is to change the "unattended" value in that file (which I think is the
field immediately prior to the text.)
Changing it from 0 to to one of the following
1 = the OK button is to be the default
2 = Cancel
3 = Abort
4 = Retry
5 = Ignore
6 = Yes
7 = No
I think that will cause the nominated button to be used as the default by TI
only.
(Possibly Object Model too??)
Another possibility is to change the "default value" used in normal use of
the screens.
I think this is the 5th field (the one immediately prior to the field that
mostly contains "A".)
I believe that it can have the following values (I have a note that I found
these searching for "unattended" in 6.5 Help.)\
Box Type Value Icon Buttons Default Button
0 None OK OK
16 Stop OK OK
48 Exclamation OK OK
64 Information OK OK
36 Question Yes / No Yes
292 Question Yes / No No
33 Question OK / Cancel OK
I have a note that I changed message 15074 from 292 to 36, and the default
changed from NO to YES.
A different approach altogether is to write some BSL code in the TI Control
File - where you can detect duplicates yourself.
Although causing the system to reject them might be interesting...
As I said, make sure you have a backup of anything that you change!
I suspect also that lots of testing will be required.
Hopefully that, superficial that it is, may point you in some interesting
directions :)
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:210F0E39-2298-44F7...@microsoft.com...
Jon
Thanks for the info. I have since written a program that will do the
checking for Duplicate Invoice Numbers in the system. I also check to make
sure that the VendorId exists in the system. If any of these fail the test, I
don't create a TI record.
The problem I'm having now is trying to run the TI from the program. I keep
getting and AccessDenied error message.
Any idea how to get around this? I want to try and automate the entire
process.
Thanks
Jon
"Barry Flynn" wrote:
> .
>
Barry Flynn
> keep
> getting and AccessDenied error message.
Is it a VBTools screen?
If so, I can paste the code that I use.
Access denied sounds like an odd sort of an error to get though if it is a
VBTools screen...
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:8A269559-7680-49DC...@microsoft.com...
Jon
Thanks for your reply. It's not a VBTools screen. It's a separate program
that I wrote to extract data from another database and create the TI data
file. After I create the data file I want to run the TI from within that
program. I've tried everything but nothing seems to work when I try to run
from the program. The program is a .Net program and I'm using the Shell
command to try and execute the TI.
I've set up a command file and that runs when I run it from the server in
the AP directory but if I try to execute it from the program it doesn't run.
Any ideas would be helpful.
Thanks
Jon
"Barry Flynn" wrote:
> .
>
Barry Flynn
Almost all of my VB code is in VBTools rather than "normal VB", so I
probably can't offer much help.
One question though.
>> > The problem I'm having now is trying to run the TI from the program. I
>> > keep
>> > getting and AccessDenied error message.
Is the "Access Denied" a Solomon error or a Windows error?
I assume that the PC is already logged in to Solomon, with a User who has
Solomon Rights to run 03.010.
If so, I think that should cover the "Solomon Rights" side of things.
And I assume that the Windows User has sufficient Windows Rights to be able
to run 03.010.
So I'm curious about where that error message is coming from.
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:C898E21B-9D0D-4EE0...@microsoft.com...
Mike Lee
Michael Lee, CITP.CPA
Partner
KB Technologies
Office: 314.812.1125 | Cell: 314.276.3728 | Fax: 314.812.1126
mr...@kb-tech.com | www.kb-tech.com
701 Emerson Road | Suite 201
St. Louis | Missouri | USA | 63141-6741
Jon
So does Solomon have to be already running under an id that has the proper
rights before the TI will start?
I think the Access Denied message was because I was going across the
network. I copied the program to the server where Solomon is installed and I
don't get the AccessDenied error any more.
I still can't get the TI to run successfully from the program though. Is
there a certain place where the program has to be run from and a certain
place where the Control File and Data File have to be located?
I run the program now and when it gets to the Shell command, Solomon starts
then I get an error stating that it encountered a problem and has to close.
Then I get another message stating that Voucher and Adjustment encountered an
error and has to close.
Jon
"Mike Lee" wrote:
> .
>
Barry Flynn
> So does Solomon have to be already running under an id that has the proper
> rights before the TI will start?
Yes
Your TI will be running 03.010, and that program can run only if Solomon is
running.
If you try to fire it up when Solomon is not running, it will attempt to
start Solomon.
As best I recall, if, in your installation, that requires entry of a userId
& password, then the login screen will appear.
You can possibly tell if this is an issue by:-
- Make sure Solomon is not running
- Browse to 0301000.exe & fire it up.
- Does Solomon / 03.010 fire up successfully? Can you enter data into
03.010? Can you use the TI screen to fire up a TI into 03.010?
> I copied the program to the server where Solomon is installed and I
> don't get the AccessDenied error any more.
I think that sounds like a dot net Trust (CASPOL) issue.
> Solomon starts
> then I get an error stating that it encountered a problem and has to
> close.
That does suggest that there is an issue firing up a Solomon screen when
Solomon is not running.
The test that I suggested above may (or may not :) shed some light on this.
> I still can't get the TI to run successfully from the program though. Is
> there a certain place where the program has to be run from
Normally 03.010 will be running from the AP folder.
I have known programs to fail if they are run "from somewhere unusual".
I guess you could experiment with copying it to other places, then
double-clicking it to see if it runs.
Is there a problem in running it from AP though?
> place where the Control File and Data File have to be located?
Not to my knowledge - they just have to be somewhere where the Solomon User
has sufficient Rights to access them.
------------------
I have fired up TI only from VBTools code, which uses the Solomon API.
So that code is not much use to you.
I've just had a scan around varuious postings and seen a comment that
someone has failed to fire up TI from a Shell.
The same command issued from the command line apparently worked.
So there may be a problem in doing it from a Shell.
I don't think it mentioned what version was in use.
An alternative may be for your code to use Solomon's Object Model to fire up
the TI screen, and start the TI that way.
I haven't done too much with Solomon's object model, and I have not tried to
fire up TI using it.
So I don't know if there may be any difficulties in that approach.
I do recall comments that there could be problems using the Object Model
from a .Net program with Solomon versions 6.5 and earlier.
But again, I haven't tried that.
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:4C49B799-3F47-46A8...@microsoft.com...
Jon
Thanks for the info. The problem was that Dynamics was not running. I
thought I had tried executing it from a command line after starting Dynamics
but I guess not.
I changed the program to execute MSDynamicsSL.Exe then wait for 15 seconds
and then execute the 0301000.exe with the TI parameters and it worked fine. A
couple of notes here though, I put the program in the AP directory and the
Control File, Data File, and TI Log file are also in the AP directory. Not
the way I wanted to do it but it seems that TI has an issue with long
directory names for the files.
Thanks again Barry.
Jon
One more question, is there any way to programmatically shutdown Dynamics SL
after the TI has completed?
Jon
Another problem. as long as I'm logged on the TI runs fine from the program.
If I log off and have the scheduled task run, the TI doesn't run.
Any ideas, suggestions would be helpful.
Thanks
Jon
Barry Flynn
I don't know if that can be done.
Might SendKeys offer a possibility?
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:2C8C1673-8DC2-4824...@microsoft.com...
Barry Flynn
Logged in to Solomon?
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:3DE8F26A-507D-4567...@microsoft.com...
Jon
I have to be physically logged on to the server where the TI will be running
for it to work. Dynamics is set up to use Windows authentication so if no one
is logged on then it has no Windows credentials to use and Dynamics never
starts.
Jon
Barry Flynn
I don't know any way around that.
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:29670FDF-BB4E-4DFA...@microsoft.com...
Jon
Thanks for all of the info. I've been doing some research and it looks like
the Solomon Object model will do what I want. I tried to download the
Developers Guide for 6.0 but I get an i/o error. Any idea where I can get
that manual?
Barry Flynn
The only documentation I know of is a file called siv_ob.pdf on the second
CD.
Unlike most other "help" I don't think it gets installed when you install
Solomon.
Barry
--
Barry Flynn
Complete Solutions DG
"Jon" <J...@discussions.microsoft.com> wrote in message
news:BF0CFC17-E504-4430...@microsoft.com...
Jon
Thanks for you help. I did find a copy of the Developer's Guide on one of my
old Solomon CD's.
I've changed the program to use the Solomon Object Model to start the
application and the TI but it still doesn't work unless there is a valid user
session on the server.
If you or anyone else has any ideas they would be greatly appreciated.
Barry, again, thanks for all of the help on this matter.