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
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
Please support us--> https://thundafund.com/project/6716626611208846
More info about Timeless.
www.facebook.com/atimelessnation
www.facebook.com/atnmagazine
www.facebook.com/timelessaction
www.facebook.com/timelessrehab
www.facebook.com/godisstaying
www.facebook.com/groups/howbigisourgod
www.facebook.com/timelessessentials2020
www.facebook.com/timelesscsm2019
My Business Card
https://imgur.com/N3PFn00
https://imgur.com/qlYNGST
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 - Sage Pastel Accounting Consultant
www.accountingsoftwaresupport.co.za
neville@accountingsoftwaresupport.co.za
IronTree Online Solutions
"Give every person more in use value than you take from them in cash value."
WALLACE WATTLES (1860-1911)
Please support us--> https://thundafund.com/project/6716626611208846
More info about Timeless.
www.facebook.com/atimelessnation
www.facebook.com/atnmagazine
www.facebook.com/timelessaction
www.facebook.com/timelessrehab
www.facebook.com/godisstaying
www.facebook.com/groups/howbigisourgod
www.facebook.com/timelessessentials2020
www.facebook.com/timelesscsm2019
My Business Card
https://imgur.com/N3PFn00
https://imgur.com/qlYNGST
The DocumentNumber is the unique primary field for HistoryHeader as well as for HistoryLines.
The DocumentType for Sales Orders is 102.
Neville Bailey - Sage Pastel Accounting Consultant
www.accountingsoftwaresupport.co.za
neville@accountingsoftwaresupport.co.za
IronTree Online Solutions
"Give every person more in use value than you take from them in cash value."
WALLACE WATTLES (1860-1911)
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.
Please support us--> https://thundafund.com/project/6716626611208846
More info about Timeless.
www.facebook.com/atimelessnation
www.facebook.com/atnmagazine
www.facebook.com/timelessaction
www.facebook.com/timelessrehab
www.facebook.com/godisstaying
www.facebook.com/groups/howbigisourgod
www.facebook.com/timelessessentials2020
www.facebook.com/timelesscsm2019
My Business Card
https://imgur.com/N3PFn00
https://imgur.com/qlYNGST
Did you like this article? Share it with your favourite social network.