Complete list of values for SY00500.BCHSOURC

(0) Share

Report

Posted on by Richard Wheeler

75,852 Moderator

Does anyone know where to find a complete list of the values for SY00500.BCHSOURC? I tried looking in the SDK but could not find a complete list.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

sbasye 191 on at

Like
a
(0)

Report
Copy link

Link copied!

Official list of BCHSTTUS (Batch Status) in SY00500:
0 – Available
1 – Marked to Post
2 – Available / Delete
3 – Marked / Receive
4 – Marked
5 – Marked / Print
6 – Marked / Update
7 – Posting Interrupted
8 – Journal Printing Interrupted
9 – Table Updates Interrupted
10 – Recurring Batch Error – Edit Required
11 – Single Use Error – Edit Required
15 – Computer Check Posting Error
110 – Checks Printing (this is the status you will see for a computer check batch after the checks are printed)
130 – Remittance Processing

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, but what about SY00500.BCHSOURC?

Was this reply helpful? Yes No
Verified answer

Cheryl Waswick Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Richard,

I don't have a complete list available to send to you, but typically these are common for GL, purchasing and sales: (But they will need to check their data)

You can look to see what you have with a script such as this against the company database: Key different types of transactions in the modules they use and look to see how it updates the SY00500 table.

select distinct (BCHSOURC), SERIES from SY00500

SERIES (NOTE: 0 or blank is invalid values).
1 - all
2 - GL
3 - Sales
4 - Purchasing
5 - Inventory
6 - Payroll
7 - Project Accounting
10 - 3r'd party

I hope that helps. Let me know if any questions, or 'mark as answer' if this helps you. Thank you in advance.

Cheryl
Microsoft Dynamics GP Support - Applications team

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Cheryl. I was build a SQL CASE statement and I was try to account for all the possibilities.

Was this reply helpful? Yes No
Cheryl Waswick Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I agree, it would be best to look at their data to make sure you get them all.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

You are never wrong Cheryl.

Did you know that Uruguay country has the highest cow-to-person ratio in the world?

Was this reply helpful? Yes No