Results 1 to 5 of 5

Thread: Which table store invoice

  1. #1
    Bronze Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    189
    Thanks
    4
    Thanked 10 Times in 7 Posts

    Which table store invoice

    I am busy working on a delivery manager front end application that uses odbc to connect to Pastel database. Can anyone tell me
    which table store the sales orders and sales orders details?

    Thanx
    BJ
    EARN UP TO 50c PER MINUTE FROM YOUR BUSINESS LANDLINE
    Monetize your business landline! Visit www.itbserved.paytel.co.za to find out more!


    OR Need a Free Fax2Email number! Get it here www.itbserved.faxmachine.co.za!

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    All document headers are stored in the acchisth.dat (History Header) table and all document line details are stored in the acchistl.dat (History Lines) table.

    You will need to filter out Sales Orders from the other documents, using the DocumentType field.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Bronze Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    189
    Thanks
    4
    Thanked 10 Times in 7 Posts
    Quote Originally Posted by Neville Bailey View Post
    All document headers are stored in the acchisth.dat (History Header) table and all document line details are stored in the acchistl.dat (History Lines) table.

    You will need to filter out Sales Orders from the other documents, using the DocumentType field.
    Thanx Neville, i presume the DocumentNumber is the unique primary field for (History Header), which is the unique for History Details or does it use multiple fields?
    And what should the DocumentType filter be?

    Thanx
    EARN UP TO 50c PER MINUTE FROM YOUR BUSINESS LANDLINE
    Monetize your business landline! Visit www.itbserved.paytel.co.za to find out more!


    OR Need a Free Fax2Email number! Get it here www.itbserved.faxmachine.co.za!

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    The DocumentNumber is the unique primary field for HistoryHeader as well as for HistoryLines.

    The DocumentType for Sales Orders is 102.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    Bronze Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    189
    Thanks
    4
    Thanked 10 Times in 7 Posts
    Thanx Neville, came right. Only the DocumentType was 3 or 103 on the sample pastel database i tested on.

    Below is idee i have for the delivery manager. It will pull all new invoices from the pastel system and assign them a default delivery method and date, as configured in the system settings which can be changed. I am wanting to add configurable rules for assigning delivery dates and methods based on areas, customers etc.
    Eg Rule 1. Queenstown Orders to be delivered every second week Thursday.
    eg Rule 2. Cambridge, Vincent, Berea (Areas in East London) delivered same day for orders captured before 10:00AM
    eg.Rule 3. Beacon Bay, Gonubie (Areas just outside East London) delivered every Thursday

    The only thing for the rules to work correct, the areas need to saved correctly under PostAddress fields eg. PostAddress2 = Suburb, PostAddress3 = City

    Also wanting to add functionality that comments/notes can be made if something was short delivered etc. or if there was a problem with the delivery, also save who signed for the delivery and what time it was delivered.

    Any idees from other TFSA members that they believe will be usefull in such a program.

    Below is a pic of the basic idee i have.

    Click image for larger version. 

Name:	test.jpg 
Views:	98 
Size:	46.0 KB 
ID:	2879
    EARN UP TO 50c PER MINUTE FROM YOUR BUSINESS LANDLINE
    Monetize your business landline! Visit www.itbserved.paytel.co.za to find out more!


    OR Need a Free Fax2Email number! Get it here www.itbserved.faxmachine.co.za!

Similar Threads

  1. Need a laser to project an image on a steel table
    By Justloadit in forum General Business Forum
    Replies: 6
    Last Post: 14-Aug-12, 09:22 PM
  2. Small business has to get real representation to the table.
    By Dave A in forum General Business Forum
    Replies: 2
    Last Post: 16-Feb-07, 01:03 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
  •