Results 1 to 3 of 3

Thread: Pastel ODBC

  1. #1
    Email problem
    Join Date
    Jul 2009
    Location
    Jhb
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel ODBC

    Hi,
    I recently joined a company using Pastel, a lot of there reporting is done by running exports or other reports and then punch that into Excel. I want to write macros to automate this, but don't understand the structure of the tables. I can't seem to get the qty on hand from the multistore or inventory tables. Does Pastel calculate the qty on hand from transactions tables or by some other means?

    I basically need the qty on hand, sales order qty and PO qty's. Where can I find these figures or how must they be calculated?

  2. #2
    Platinum Member Marq's Avatar
    Join Date
    May 2006
    Posts
    1,296
    Thanks
    73
    Thanked 283 Times in 216 Posts
    Sorry cannot help you with Pastel - don't use it because it always seems to be bitty.

    But I would imagine that the numbers you are looking are within the basic reports that pastel must produce. They are after all basics of an accounting system. Then save those across to excel. I do not know whether pastel holds the basic transaction data and recalculates everytime it runs a report or not. Again this seems to be an old way of doing things - besides being slow and resource intensive.
    The cost of living hasn't affected its popularity.
    Sponsored By: http://www.honeycombhouse.com

  3. #3
    Email problem
    Join Date
    Jul 2009
    Location
    Jhb
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, I think I might need to run an export for now and use macro's to manipulate that data into what I need.

Similar Threads

  1. pastel
    By murdock in forum Accounting Forum
    Replies: 13
    Last Post: 06-Nov-10, 08:43 AM
  2. [Question] Pastel Payroll Reports cannot display my requirements
    By Zapphire in forum Technology Forum
    Replies: 2
    Last Post: 07-Oct-09, 10:25 AM
  3. [Question] Help with Pastel Payroll Partner
    By celly007 in forum Tax Forum
    Replies: 3
    Last Post: 17-Sep-09, 10:25 AM
  4. Pastel Difficulties ?
    By Martinco in forum Accounting Forum
    Replies: 0
    Last Post: 20-Oct-08, 09:40 AM
  5. Pastel reconciling itself
    By paulnel in forum Accounting Forum
    Replies: 4
    Last Post: 25-Sep-08, 01:17 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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