Welcome to The Forum SA. As a visitor you have read only access to the public content areas of this website. You will have to register as a member to access all content, post messages and network with our members. Membership is free and registering is quick and easy. You can click here to register now and become a member within minutes.
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?
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.
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, 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.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Tweet
Comment