Skip to main content
Microsoft Dynamics GP forum
Answered

Complete list of values for SY00500.BCHSOURC

editSubscribe (0) ShareShare
ReportReport
Posted on by 75,730

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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Complete list of values for SY00500.BCHSOURC

    You are never wrong Cheryl.

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

  • RE: Complete list of values for SY00500.BCHSOURC

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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Complete list of values for SY00500.BCHSOURC

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

  • Verified answer
    RE: Complete list of values for SY00500.BCHSOURC

    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)

    pastedimage1665421601768v1.png

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Complete list of values for SY00500.BCHSOURC

    Yes, but what about SY00500.BCHSOURC?

  • Suggested answer
    sbasye Profile Picture
    sbasye 191 on at
    RE: Complete list of values for SY00500.BCHSOURC

    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans