Re: [U2] U2 accounting software question
A few years back a company I worked for had dealings with Stamina (and Ross directly). We interfaced to the Visage GL - all worked well and support/development requirements were always met. I have had no direct dealings with the product since and have no business relationship with Stamina but I will recommend them for the services they provided 'back in the day'. From the odd word around town in Australia the product is still alive and well. Worth considering. Brendon Leverett -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Thursday, 24 May 2012 1:24 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question Unfortunately the support organization we used to operate with in the USA is no more. If you didn't mind the fact that support would be remote (Australia), our Visage R5 General Ledger Financial Reporting packages might fit the bill. These can be deployed stand alone (ie: without our full ERP offering), though of course you would need to develop interfaces from your subsidiary ledger systems as required -- reasonably straight forward, just throw records into a file pass a select list to our POST routine. There is also scope to include additional modules that you may consider part of the General Ledger banner (eg: Asset Register, Bank Reconciliation/Treasury etc.) if appropriate, now or in the future. Our enquiries typically support drilling through to source transactions, so there may need to be some work done to provide that capability into your existing systems Multi-currency is fully supported if required, as well as multiple consolidations across within corporate boundaries if required. Beyond the basic manual journals auto-reversing accruals there are variety of ratio posting options. Whilst we offer our solution via the cloud, we can also provide on-premise, which I assume is probably what you are after? [ad] If there are any companies, or individuals looking to becomes involved in a broad spectrum ERP product that can encompass Retail/POS, Wholesale/Distribution, Warehouse automation management, Job/Project costing Engineering Services, as well as core accounting functionality, please drop us a line :-) [ad] Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, 23 May 2012 6:45 AM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 accounting software question
Thanks for the memories Brendan! I could be wrong, but I think Wreckair was THE biggest Sanyo ICON site in the world but I was VERY GLAD when you migrated to D3/AIX :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Thursday, 24 May 2012 5:13 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question A few years back a company I worked for had dealings with Stamina (and Ross directly). We interfaced to the Visage GL - all worked well and support/development requirements were always met. I have had no direct dealings with the product since and have no business relationship with Stamina but I will recommend them for the services they provided 'back in the day'. From the odd word around town in Australia the product is still alive and well. Worth considering. Brendon Leverett -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Thursday, 24 May 2012 1:24 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question Unfortunately the support organization we used to operate with in the USA is no more. If you didn't mind the fact that support would be remote (Australia), our Visage R5 General Ledger Financial Reporting packages might fit the bill. These can be deployed stand alone (ie: without our full ERP offering), though of course you would need to develop interfaces from your subsidiary ledger systems as required -- reasonably straight forward, just throw records into a file pass a select list to our POST routine. There is also scope to include additional modules that you may consider part of the General Ledger banner (eg: Asset Register, Bank Reconciliation/Treasury etc.) if appropriate, now or in the future. Our enquiries typically support drilling through to source transactions, so there may need to be some work done to provide that capability into your existing systems Multi-currency is fully supported if required, as well as multiple consolidations across within corporate boundaries if required. Beyond the basic manual journals auto-reversing accruals there are variety of ratio posting options. Whilst we offer our solution via the cloud, we can also provide on-premise, which I assume is probably what you are after? [ad] If there are any companies, or individuals looking to becomes involved in a broad spectrum ERP product that can encompass Retail/POS, Wholesale/Distribution, Warehouse automation management, Job/Project costing Engineering Services, as well as core accounting functionality, please drop us a line :-) [ad] Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, 23 May 2012 6:45 AM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SHA256 digest possible?
The Digest function looks to only allow MD5 or SHA1, SHA256 is SHA2 but digest does not appear to support that. I am not sure what the ENCRYPT function allows. The manual says there is a list of ciphers in the Unibasic Extensions manual, but I cannot find any listing of those in there Otherwise, if you are on linux you could use sha256sum e.g echo -n string to digest | sha256sum -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael McGlothlin Sent: 23 May 2012 22:04 To: U2 Users List Subject: [U2] SHA256 digest possible? Not an expert in U2 so this could be stupid.. I'm using DIGEST and OCONV to produce a hex digest of plain-text passwords as users enter them. Passwords created through external sources are SHA256 so I was wondering if there is a way to get that to happen in UniBasic? PRSLT = DIGEST('sha1',PWD,1,PDIGEST) PHASH = OCONV(PDIGEST, 'MX0C') Michael McGlothlin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/5017 - Release Date: 05/23/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] matrix dimension
So LARGE.ARRAY is 2-dimensional SMALL.ARRAY is 1 dimensional. The real value of INMAT is telling the SIZE of (each) dimension. Yes, I'm deliberately being picky. I've found it very frustrating to be hard-limited to 1- or 2-dimnsional arrays. What would be so wrong to allow: DIM BETTER.ARRAY( 23, 14, 10, 2, 3 ) Seems like it would be an easy enough feature to add, completely backward compatible. Why isn't dimension arbitrary? On 5/23/2012 3:01 PM, Wally Terhune wrote: Extracted from the UniBasic Commands Reference for INMAT() In the next example, the program segment dimensions two arrays and then prints the dimensions using the PRINT statement and INMAT function: DIM LARGE.ARRAY(23,14) DIM SMALL.ARRAY(9) PRINT INMAT(LARGE.ARRAY) PRINT INMAT(SMALL.ARRAY) This results in the following: 23}14 9 -Original Message- From: Jeffrey Butera ... is there a function to determine it's dimensions?... .. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] matrix dimension
Hi, Multiple dimensions in DIM implies that all elements in each dimension would exist, around 25000 in your example. Using dynamic arrays, even as part of a dimensioned array is much more flexible as unused elements may not need to exist. And UV allows seven dimensional dynamic arrays - more than enough for most users!! Of course, indexing into a dimensioned array would be faster. Your request is close to something we were asked for in QM, arrays of arrays. Although technically easy we have not done it as the user requesting it withdrew the request. The hardest part is how to fit it into the language syntax. Martin Phillips On 24 May 2012, at 12:46, Charles Stevenson stevenson.c...@gmail.com wrote: So LARGE.ARRAY is 2-dimensional SMALL.ARRAY is 1 dimensional. The real value of INMAT is telling the SIZE of (each) dimension. Yes, I'm deliberately being picky. I've found it very frustrating to be hard-limited to 1- or 2-dimnsional arrays. What would be so wrong to allow: DIM BETTER.ARRAY( 23, 14, 10, 2, 3 ) Seems like it would be an easy enough feature to add, completely backward compatible. Why isn't dimension arbitrary? On 5/23/2012 3:01 PM, Wally Terhune wrote: Extracted from the UniBasic Commands Reference for INMAT() In the next example, the program segment dimensions two arrays and then prints the dimensions using the PRINT statement and INMAT function: DIM LARGE.ARRAY(23,14) DIM SMALL.ARRAY(9) PRINT INMAT(LARGE.ARRAY) PRINT INMAT(SMALL.ARRAY) This results in the following: 23}14 9 -Original Message- From: Jeffrey Butera ... is there a function to determine it's dimensions?... .. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] matrix dimension
One of the things I've asked for in the past has been alternate language runtimes, for example embedding JavaScript (e.g. Google V8 engine) into U2. Then you *could* have unlimited nesting .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: 24 May 2012 13:05 To: U2 Users List Subject: Re: [U2] matrix dimension Hi, Multiple dimensions in DIM implies that all elements in each dimension would exist, around 25000 in your example. Using dynamic arrays, even as part of a dimensioned array is much more flexible as unused elements may not need to exist. And UV allows seven dimensional dynamic arrays - more than enough for most users!! Of course, indexing into a dimensioned array would be faster. Your request is close to something we were asked for in QM, arrays of arrays. Although technically easy we have not done it as the user requesting it withdrew the request. The hardest part is how to fit it into the language syntax. Martin Phillips ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 accounting software question
No problem, Dawn, I'd be happy to. We're just starting the discovery process and don't plan on implementing until 2013 at the earliest, so it may be a while. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Wednesday, May 23, 2012 10:42 AM To: U2 Users List Subject: Re: [U2] U2 accounting software question Please let us know what you decide, if you could. Thanks! --dawn On Wed, May 23, 2012 at 12:32 PM, John Hester jhes...@momtex.com wrote: Thank you to everyone who responded. I have a decent sized list of options to investigate. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Tuesday, May 22, 2012 1:45 PM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 accounting software question
Thanks, Ross. We are definitely open to cloud options, but 8-5 Pacific time telephone support is also a requirement. Vendor location isn't much of a concern if that requirement can be met. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, May 23, 2012 8:24 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question Unfortunately the support organization we used to operate with in the USA is no more. If you didn't mind the fact that support would be remote (Australia), our Visage R5 General Ledger Financial Reporting packages might fit the bill. These can be deployed stand alone (ie: without our full ERP offering), though of course you would need to develop interfaces from your subsidiary ledger systems as required -- reasonably straight forward, just throw records into a file pass a select list to our POST routine. There is also scope to include additional modules that you may consider part of the General Ledger banner (eg: Asset Register, Bank Reconciliation/Treasury etc.) if appropriate, now or in the future. Our enquiries typically support drilling through to source transactions, so there may need to be some work done to provide that capability into your existing systems Multi-currency is fully supported if required, as well as multiple consolidations across within corporate boundaries if required. Beyond the basic manual journals auto-reversing accruals there are variety of ratio posting options. Whilst we offer our solution via the cloud, we can also provide on-premise, which I assume is probably what you are after? [ad] If there are any companies, or individuals looking to becomes involved in a broad spectrum ERP product that can encompass Retail/POS, Wholesale/Distribution, Warehouse automation management, Job/Project costing Engineering Services, as well as core accounting functionality, please drop us a line :-) [ad] Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, 23 May 2012 6:45 AM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 accounting software question
Hi John, Keep us in mind then, as we offer 24x7 support for clients now :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Friday, 25 May 2012 3:10 AM To: U2 Users List Subject: Re: [U2] U2 accounting software question Thanks, Ross. We are definitely open to cloud options, but 8-5 Pacific time telephone support is also a requirement. Vendor location isn't much of a concern if that requirement can be met. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, May 23, 2012 8:24 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question Unfortunately the support organization we used to operate with in the USA is no more. If you didn't mind the fact that support would be remote (Australia), our Visage R5 General Ledger Financial Reporting packages might fit the bill. These can be deployed stand alone (ie: without our full ERP offering), though of course you would need to develop interfaces from your subsidiary ledger systems as required -- reasonably straight forward, just throw records into a file pass a select list to our POST routine. There is also scope to include additional modules that you may consider part of the General Ledger banner (eg: Asset Register, Bank Reconciliation/Treasury etc.) if appropriate, now or in the future. Our enquiries typically support drilling through to source transactions, so there may need to be some work done to provide that capability into your existing systems Multi-currency is fully supported if required, as well as multiple consolidations across within corporate boundaries if required. Beyond the basic manual journals auto-reversing accruals there are variety of ratio posting options. Whilst we offer our solution via the cloud, we can also provide on-premise, which I assume is probably what you are after? [ad] If there are any companies, or individuals looking to becomes involved in a broad spectrum ERP product that can encompass Retail/POS, Wholesale/Distribution, Warehouse automation management, Job/Project costing Engineering Services, as well as core accounting functionality, please drop us a line :-) [ad] Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, 23 May 2012 6:45 AM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users