ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> What is the BKAR_INV_INVCD field for??
http://www.istechforum.com/YaBB.pl?num=1060974999

Message started by kevind on 08/15/03 at 13:16:39

Title: What is the BKAR_INV_INVCD field for??
Post by kevind on 08/15/03 at 13:16:39

It looks like this field is to flag complete (or closed) and incomplete (or open) sales orders.

If the flag is 'X', then it is an open order.
If the flag is 'Y', then it is a closed order.

However, if you view a closed order through SO-A, and then exit the order without saving changes, it leaves this flag with a ' ' in it.

On the other hand, If while looking at an existing order, you get the message 'This customer has exceded their credit limit, do you wish to continue' and you answer 'No', then this field is left with a ' ' in it also.

So the ' ' value could flag an open, or closed order.

I have two Questions:
1. Is ' ' a valid value for this field?
2. What does a ' ' value flag?

-------------
Lynn - Can you shed some light on this??

Title: Re: What is the BKAR_INV_INVCD field for??
Post by kevind on 08/26/03 at 15:09:54

Does anyone Know what values are valid for BKAR_INV_INVCD in BKARINV??

Should it ever get set to blank as I indicated in the first post??

Title: Re: What is the BKAR_INV_INVCD field for??
Post by aricon on 08/27/03 at 12:44:44

The valid values for this field are:

blank
X
Y

Blank indicates that the SO had an invoice but the SO was re-opened and the user that opened it just exited without saving and responding to the "close" question; X indicates an order that had an invoice created but the order is not closed yet; and Y indicates an invoiced and closed order.

Title: Re: What is the BKAR_INV_INVCD field for??
Post by Lynn_Pantic on 08/27/03 at 14:05:30

I also have some newly created orders, never invoiced, that are blank, while others have "X" in the field. Not sure what causes the difference.

Title: Re: What is the BKAR_INV_INVCD field for??
Post by kevind on 08/28/03 at 16:37:45

Quote:

On the other hand, If while looking at an existing order, you get the message 'This customer has exceded their credit limit, do you wish to continue' and you answer 'No', then this field is left with a ' ' in it also.

So the ' ' value could flag an open, or closed order.

As I indicated in my first post ... Blank can flag open or closed. This flag should not be changed to blank when you get the 'This customer has exceded ...' message.

I do not see any reason for a value of Blank. Further, I do not see any reason for leaving an order in the "open" state (with a blank in this field) if you choose to not save changes when exiting a previously closed order.

The reason I am asking about this field is because I have written a PHP application that allows our customers to view their open order status directly from the DBA datafiles. I was going to use this field to filter only the open orders. Instead, I am going to have to use a aggregate function to sum the QTY remaining to ship.

Title: Re: What is the BKAR_INV_INVCD field for??
Post by Lynn_Pantic on 08/28/03 at 18:29:02

If you look in the SO-A opening list, orders that are closed have a "C" next to them. You should be able to look at the SRC for BKSOA and see what criteria is used to make that determination.