x Want to participate? Join the group to interact

Sage 300cloud Africa and Middle East

Welcome to the Sage 300cloud Africa and Middle East Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

General Discussion Sage300 AP Status

State Verified Answer
Replies 2 replies
Subscribers 12 subscribers
Views 315 views
Users 0 members are here

Browse Forums

262

topics

29

replies

General Discussion

441

topics

875

replies

Sage300 AP Status

SOLVED

Posted By Mimi Lepissier 8 months ago

Hi all,

I was wondering if anyone knew what database fieldname the Status column in AP corresponds to ?

Thanks in advance

Top Replies

Zakariyya Carrim 8 months ago +1 verified

Hi

The table name is "APIBC". Column is BTCHSTTS which shows the Status of the Batch. Value of 1 is Open and 3 Posted.

+1 Zakariyya Carrim 8 months ago

verified answer

Hi

The table name is "APIBC". Column is BTCHSTTS which shows the Status of the Batch. Value of 1 is Open and 3 Posted.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel
+1 Zakariyya Carrim 8 months ago

verified answer

The column name BTCHSTTS has the following values below:

1 - Open

3 - Posted

4 - Deleted

5 - Post in Progress

7 - Ready to Post
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel