ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> Sales Order Tables
http://www.istechforum.com/YaBB.pl?num=1099930239

Message started by Kelloggs on 11/08/04 at 08:10:39

Title: Sales Order Tables
Post by Kelloggs on 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

Title: Re: Sales Order Tables
Post by Lynn Pantic on 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.

Title: Re: Sales Order Tables
Post by Kelloggs on 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?

Title: Re: Sales Order Tables
Post by aricon on 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.

Title: Re: Sales Order Tables
Post by Kelloggs on 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

Title: Re: Sales Order Tables
Post by aricon on 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.

Title: Re: Sales Order Tables
Post by Kelloggs on 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.

>:( :-[ :-X

should i try ms access?

:P