Complete list of values for SY00500.BCHSOURC

(0) Share

Report

Posted on by Richard Wheeler

75,848 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)

Suggested answer

sbasye 191 on at

Like (0)

Report

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,848 Moderator on at

Like (0)

Report

Yes, but what about SY00500.BCHSOURC?

Was this reply helpful? Yes No
Verified answer

Cheryl Waswick on at

Like (0)

Report

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,848 Moderator on at

Like (0)

Report

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 on at

Like (0)

Report

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,848 Moderator on at

Like (1)

Report

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