Join us now. It is free, and it takes less than 1 minute to register.
Register now
Subscribe to our daily newsletter. It is free, and it comes with many benefits.


+ Reply to Thread
Page 3 of 3 FirstFirst 123
Results 31 to 41 of 41

Thread: Sage products - tips, tricks, development and improvement suggestions

  1. #31
    Super Grandmaster AirWolf's Avatar
    Join Date
    Aug 2006
    Location
    Port Shepstone, KZN, RSA, EARTH
    Posts
    20,267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorted the keyword issue. For anyone interested:

    [Name] = customer/debtor Name.
    [CompanyName] = your company name (needs to be filled in in PDF invoice setup to work, or it will show a blank)
    [AccNo] = customer/debtor account number.
    [Outstanding] = Balance outstanding.
    Hibiscus Coast Photographic Society
    (previously known as: Hibiscus Coast Camera Club)

  2. #32
    Super Grandmaster AirWolf's Avatar
    Join Date
    Aug 2006
    Location
    Port Shepstone, KZN, RSA, EARTH
    Posts
    20,267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Still waiting for a keyword list from support (a week later). Got the above by looking through the database in MSSQL.

    Note for anyone using the above: [OUTSTANDING] will give the full outstanding balance, and not the amount due as per the customers credit terms i.e.

    R100 bought last month (or older), and R50 bought this month will show R150 and not the R100 on an account with a credit terms of 30 days from statement.
    Hibiscus Coast Photographic Society
    (previously known as: Hibiscus Coast Camera Club)

  3. #33
    Member
    Join Date
    Mar 2011
    Location
    Pietermaritzburg
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Connection string

    Is it possible to connect to VIP Premier from an application using a connection string?
    I've seen hints that it might be an Access database, but I can't confirm. Even the consultant at Special Solutions wasn't sure, all he knew was that it was written in Cobol.

  4. #34
    Super Grandmaster
    Join Date
    Jun 2009
    Location
    Snorries
    Posts
    11,284
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by ShamusVW View Post
    Is it possible to connect to VIP Premier from an application using a connection string?
    I've seen hints that it might be an Access database, but I can't confirm. Even the consultant at Special Solutions wasn't sure, all he knew was that it was written in Cobol.
    It uses a proprietary db format as far as I know. Definitely not an Access db
    Yes you are able to connect, you can use the 32bit ODBC driver together with the ODBC connection string.
    It is read-only though, via the ODBC connection, so you can only query the database.

    Send me a pm and I'll send you a piece of code you can use.
    Quote Originally Posted by Rickster View Post
    Why is everyone going ape **** over this car, it looks like junk and the performance must be too.
    Quote Originally Posted by KSINGH View Post
    Oh no you didn't

  5. #35
    Super Grandmaster AirWolf's Avatar
    Join Date
    Aug 2006
    Location
    Port Shepstone, KZN, RSA, EARTH
    Posts
    20,267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The only ODBC functionality I use is the StatsSA excel report, which is painfully slow.
    Hibiscus Coast Photographic Society
    (previously known as: Hibiscus Coast Camera Club)

  6. #36
    Super Grandmaster
    Join Date
    Jun 2009
    Location
    Snorries
    Posts
    11,284
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by AirWolf View Post
    The only ODBC functionality I use is the StatsSA excel report, which is painfully slow.
    I've wished many times for a better driver, but alas...
    Quote Originally Posted by Rickster View Post
    Why is everyone going ape **** over this car, it looks like junk and the performance must be too.
    Quote Originally Posted by KSINGH View Post
    Oh no you didn't

  7. #37
    Super Grandmaster AirWolf's Avatar
    Join Date
    Aug 2006
    Location
    Port Shepstone, KZN, RSA, EARTH
    Posts
    20,267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sage Evolution:

    Have one stock item that shows different quantities at the same date on two different reports:
    - Valuation report on a particular date;
    - Movement report over say a month.

    How do you fix this as in theory any posted entry should affect both the same.

    The error actually goes all the way back to October 2013.
    Hibiscus Coast Photographic Society
    (previously known as: Hibiscus Coast Camera Club)

  8. #38
    Super Grandmaster AirWolf's Avatar
    Join Date
    Aug 2006
    Location
    Port Shepstone, KZN, RSA, EARTH
    Posts
    20,267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by AirWolf View Post
    Sage Evolution:

    Have one stock item that shows different quantities at the same date on two different reports:
    - Valuation report on a particular date;
    - Movement report over say a month.

    How do you fix this as in theory any posted entry should affect both the same.

    The error actually goes all the way back to October 2013.
    The resulting difference shows in October 2013, but I have traced the transaction to a bill of materials manufacture in January 2018 which was entered by a branch.
    Probably the result of a problematic VPN connection where the item draw was double processed somehow and posted to hell in the system.

    Call centre solution - use the enquiries valuation by date "as it gives the correct values if you have multiple warehouses and back date transactions". This was before I found the BOM transaction.
    How is it even possible for Reports-Movement Report and Reports-Valuation Report to show different values from the same data?
    They're drawing information from different tables???
    Hibiscus Coast Photographic Society
    (previously known as: Hibiscus Coast Camera Club)

  9. #39
    Member
    Join Date
    Jan 2018
    Location
    South Africa , East London
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I dnt have much to say about these guys i developed a website for a non profit organisation as a donation pr type thing. They opted to go with sage pay to assist them with they payment gateway and moreover better control of their finances using the user dashboard i could se it wa good for that purpose. What left me in shock as this is a paid service was that my client asked me to install the api on their worpress , since this is a donation site and has no cart i had to work a different method as nothing is being checked out. I then though heck these guys are getting paid for this service let them do it they would probably do it in a hear beat. they absolutely refused ad kept shoving documents for programmers down my throat until i finally caved and just wrote my own script for their "product".

  10. #40
    Super Grandmaster AirWolf's Avatar
    Join Date
    Aug 2006
    Location
    Port Shepstone, KZN, RSA, EARTH
    Posts
    20,267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sage Evolution

    Any way to disable the remove button on the pop-up login window for users that "accidentally" remove companies?
    Hibiscus Coast Photographic Society
    (previously known as: Hibiscus Coast Camera Club)

  11. #41
    Super Grandmaster AirWolf's Avatar
    Join Date
    Aug 2006
    Location
    Port Shepstone, KZN, RSA, EARTH
    Posts
    20,267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by AirWolf View Post
    Sage Evolution:

    Have one stock item that shows different quantities at the same date on two different reports:
    - Valuation report on a particular date;
    - Movement report over say a month.

    How do you fix this as in theory any posted entry should affect both the same.

    The error actually goes all the way back to October 2013.
    Quote Originally Posted by AirWolf View Post
    The resulting difference shows in October 2013, but I have traced the transaction to a bill of materials manufacture in January 2018 which was entered by a branch.
    Probably the result of a problematic VPN connection where the item draw was double processed somehow and posted to hell in the system.

    Call centre solution - use the enquiries valuation by date "as it gives the correct values if you have multiple warehouses and back date transactions". This was before I found the BOM transaction.
    How is it even possible for Reports-Movement Report and Reports-Valuation Report to show different values from the same data?
    They're drawing information from different tables???
    The January BOM entry pulled stock into WIP, but didn't complete and remains active no matter what I try it remains active.
    I can't return the draw as it shows zero quantity available (when each item does have stock).
    Also, one item has been drawn twice.
    Hibiscus Coast Photographic Society
    (previously known as: Hibiscus Coast Camera Club)

+ Reply to Thread
Page 3 of 3 FirstFirst 123

Similar Threads

  1. Tips and Tricks
    By CoolBug in forum Android
    Replies: 2
    Last Post: 23-03-2012, 11:35 AM
  2. Forum improvement suggestions
    By rpm in forum Announcements and Giveaways
    Replies: 342
    Last Post: 26-04-2010, 09:11 PM
  3. improvement suggestions to vodacom4me
    By justinlawrence in forum CPA, Telecoms Regulation and Consumerism
    Replies: 0
    Last Post: 11-07-2008, 09:55 AM
  4. Constructive improvement suggestions for vodacom4me.co.za
    By ic in forum Vodacom Broadband and Mobile Internet | LTE, HSPA+, HSDPA, 3G, EDGE, GPRS and BIS
    Replies: 38
    Last Post: 13-12-2006, 12:21 PM
  5. Tips & Tricks (add yours)
    By biometrics in forum Vodacom Broadband and Mobile Internet | LTE, HSPA+, HSDPA, 3G, EDGE, GPRS and BIS
    Replies: 3
    Last Post: 24-10-2005, 09:53 PM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •