• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

back end JDE question regarding GL

Scott430

Member
So when I do some work on the front end of JDE in the GL what occurs as a result in the back end? Regarding the tables for example.
 

Rauf

VIP Member
Scott,

Welcome to JDE List :)!

If you just query about table triggers, it just use B0000198-GetCurrencyCodeAndDecimals based on document type.

If you query about the functional things, the G/L application creates batch header in F0011 table and inserts the records to F0911. Based on the approval set up, the batch status will be 'pending' or 'approved.'

After doing some journal entries, you can check the above tables to see how the data are stored.

While posting, it will update one more table: F0902 - Account Balance table, and the status of F0011 and F0911 records will be changed to 'posted'.

Hope this helps :cool:!
 
Last edited:

adeel

VIP Member
Rauf.
How JDE know which version to call for "post by batch" from row exit.
I guess there is somewhere setup based on the Batch Type example for "G" it is R09801 ZJDE0001 in our case. But don't know where?
 

Rauf

VIP Member
Adeel,

It is hard coded inside the code based on batch type.
Couple of lines from the Row exit...
Code:
0038       If GC BatchType is equal to "G"
0039          VA evt_cPostVersionFound_EV01 = "1"
0040          CALL( UBE:R09801 , Ver: ZJDE0001 )
                 GC Batch Type <> RI BatchType
                 GC Batch Number -> RI BatchNumber
0041       End If
0042       If GC BatchType is equal to "D"
0043          VA evt_cPostVersionFound_EV01 = "1"
0044          CALL( UBE:R09801 , Ver: ZJDE0010 )
                 GC Batch Type <> RI BatchType
                 GC Batch Number -> RI BatchNumber
0045       End If
0046       If GC BatchType is equal to "V"
0047          VA evt_cPostVersionFound_EV01 = "1"
0048          CALL( UBE:R09801 , Ver: ZJDE0002 )
                 GC Batch Type <> RI BatchType
                 GC Batch Number -> RI BatchNumber
0049       End If
0050       If GC BatchType is equal to "K"
0051          VA evt_cPostVersionFound_EV01 = "1"
0052          CALL( UBE:R09801 , Ver: ZJDE0003 )
                 GC Batch Type <> RI BatchType
                 GC Batch Number -> RI BatchNumber
0053       End If
0054       If GC BatchType is equal to "M"
0055          VA evt_cPostVersionFound_EV01 = "1"
0056          CALL( UBE:R09801 , Ver: ZJDE0004 )
                 GC Batch Type <> RI BatchType
                 GC Batch Number -> RI BatchNumber
0057       End If
0058       If GC BatchType is equal to "W"
0059          VA evt_cPostVersionFound_EV01 = "1"
0060          CALL( UBE:R09801 , Ver: ZJDE0005 )
                 GC Batch Type <> RI BatchType
                 GC Batch Number -> RI BatchNumber
0061       End If
0062       If GC BatchType is equal to "IB"
0063          VA evt_cPostVersionFound_EV01 = "1"
0064          CALL( UBE:R09801 , Ver: ZJDE0006 )
                 GC Batch Type <> RI BatchType
                 GC Batch Number -> RI BatchNumber
0065       End If
 
Top