Which table store invoice

[bjsteyn]

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

[Neville Bailey]

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.

[bjsteyn]

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

[Neville Bailey]

The DocumentNumber is the unique primary field for HistoryHeader as well as for HistoryLines.

The DocumentType for Sales Orders is 102.

[bjsteyn]

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.