ISTech Support Forum - Sales Order Tables

Welcome, Guest. Please Login.

	05/03/24 at 01:59:28 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›

Pages: 1

Sales Order Tables (Read 1718 times)

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Sales Order Tables 11/08/04 at 08:10:39 Hi, What's the different between these two tables? BKARINVL and BKARHIVL As I see it, when you invoice a SO Line it is moved to BARHIVL right? What happens when you partially released a line but you dont invoice it? Thank you all Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Sales Order Tables Reply #1 - 11/08/04 at 08:38:44 Posting the invoice in SO-G creates the BKARHIVL record and reduces the on order quantity of the BKARINVL record. Releasing the order moves quantities between On Order and On Backorder (PQTY and UBO) in the BKARINVL file.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: Sales Order Tables Reply #2 - 11/08/04 at 09:04:30 Thank you Lynn If you partially shipped a Sales Order Line, but you havent yet invoice it. Is there a way to find out the total quantity already shipped?
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Sales Order Tables Reply #3 - 11/08/04 at 09:51:45 Kelloggs, No. DBA only updates the released quantity to a shipped status after invoicing. Had this frustration with a previous client.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: Sales Order Tables Reply #4 - 11/08/04 at 11:06:55 Thank Aricon We are trying to create a column and a procedure (Trigger) to store that value, but I think that the tables are locked. We get a error msg when we insert a column. Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

aricon

Active Member

Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male

Re: Sales Order Tables
Reply #5 - 11/08/04 at 11:47:32

You mean in the Pervasive Table? If so, I would sure be interested if you can get it to work! We never could. As far as I can tell any command issued as a create, insert, update or delete needs to be from the TAS engine.

What I did for a client to get around this problem of when DBA considers an item shipped was to create an Access app that would bring in the items released, time and date stamp that transaction and show it as shipped not invoiced (SNI) within the Access app and would then look at the remaining balance and show it as remaining to be shipped.

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: Sales Order Tables
Reply #6 - 11/08/04 at 12:14:18

There must be a way to create a trigger that calls a procedure

The other problem we have is that we are using PS 7

I will keep you posted.

Thank you

Kelloggs

Triggers in Pervasive.SQL "break" the Btrieve-level access. Do NOT use
Triggers if you have any Btrieve-level applications.

...... Goldstar Software Inc.

Angry

should i try ms access?

Tongue

« Last Edit: 11/09/04 at 08:40:48 by Kelloggs »

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›