Recent Posts

Pages: [1] 2 3 ... 10
Prelude Support / Re: Entry Screen
« Last post by DonQuixote on November 08, 2018, 09:17:44 am »
To answer my own question...
in the screen-definition the prompt "Control/Dep/Read" was blank. It should be "R"
Since these two new prompts were the only input items, the cursor stopped at each before displaying the values that come after it.
Now that it knows to "Read & Display" after the ID everything works correctly.
Prelude Support / Entry Screen
« Last post by DonQuixote on November 06, 2018, 09:42:46 am »
On a normal entry screen you enter the ID and the record displays and you are able to make changes; from the top to the bottom.  I have an entry screen originally created to display only; each item has "N" to "input".  Now I'm requested to add two items that changes will be allowed.  I added them to the bottom of the screen.

The problem is after entering the ID only the original items are displayed and the new items are not.
The cursor stops at the first new item and displays its value.  After hitting return, the second items is displayed with the cursor. 

What did I forget to do?  I want all items to display and then the cursor to stop at the first item allowing input.

SB+ Programming Questions / Re: TUXFER.DATA files
« Last post by precisonline on October 29, 2018, 10:27:43 am »
They're created for and used by SmartQuery.  They are not automatically cleaned up.
SB+ Programming Questions / TUXFER.DATA files
« Last post by DonQuixote on October 29, 2018, 09:23:49 am »
My notes tell me that TUXFER.DATA.nnn   files are created by a SB+ process.  Since we have hundreds of these files, I would like to know what they are used for and if we can delete them?  I'm surprised they are not automatically cleaned up.
Prelude Support / Re: Prelude taxation software
« Last post by precisonline on October 27, 2018, 11:46:30 am »
A number of Prelude sites have moved to Avalara.  It's quite a difference from Vertex; everything is done through the Avalara cloud service so there's no tables to load.  It is rumored to be quite expensive, however.

I have an Avante customer that just did the Vertex O-series, I believe.  I could make an introduction if you'd like.
Prelude Support / Prelude taxation software
« Last post by DonQuixote on October 24, 2018, 11:45:31 am »
For years Prelude used taxation software through Vertex for series "L". They do have an option for Vertex series "O" but only has one customer that uses it.  In recent years they are supporting transitioning to "Avalara" software for tax calculation and filing tax returns.
Has anyone made the transition from series 'L' to anything else?   What was the impact and lessons learned?

Prelude Support / Re: User Activity
« Last post by precisonline on October 11, 2018, 03:03:51 pm »
There's an *nix command called "last" that might be useful as well.  That gives access to the user log file without being root.
Prelude Support / Re: User Activity
« Last post by DonQuixote on August 22, 2018, 08:16:47 am »
Thank you.  This is providing the information requested.
I am on a similar system as you describe.  Another suggestion someone else provided was on the AIX level.
They said all the login information is maintained in /etc/security/lastlog   file.   But, since only root has access the benefit is limited.
Thanks again.  I did have to create dictionary items since the attribute you mentioned is an undocumented feature.  lol.
Prelude Support / Re: User Activity
« Last post by Tom Pellitieri on August 22, 2018, 06:35:27 am »
Just a follow up on this:

It appears that there's only one entry per Port number.  I checked the attribute, logged off SB+, then logged back in without disconnecting my Linux account.  I rechecked, and there was not a second value for the current port.  The login time matched the new login.

We're currently using SB+ on a Red Hat Linux system with UniData.  In UniData, users are assigned the lowest available port number when they connect.  This was true when we used AIX as well.  When we were on Advanced Pick/Pick D3 under AIX (17+ years ago), port numbers were static based on physical (tty) connections.
Prelude Support / Re: User Activity
« Last post by Tom Pellitieri on August 21, 2018, 02:50:01 pm »
There isn't a standard report anywhere that I know about.  However....

Attribute 24 of the User ID Record in DMSECURITY appears to have a MV with the ten most recent SB+ login date, time, and port.  For example, my record (~TRP) has these values:


The first value shows I logged in today (Pick date 18496) at 36,387 seconds past midnight (10:06:27 am) on Port 11

There's no indication of when they log out. 

You may find additional information at the O/S level, using the O/S login.  In (Red Hat) Linux, you may use

last login-id

to get a list with login and duration.

Pages: [1] 2 3 ... 10