By Sheila Zhang

It is a convenient function in Sage 300 ERP that you can drill down to the original sub-ledger transactions on the G/L entry.

After I worked on many reports with drill down requirements, I have my own list of drill down links between G/L entries and its original transactions. To be able to link a G/L entry to its original transaction, you need to combine three fields in GLJEH table together. They are DRILAPP, DRILSRCTY and DRILLDWNLK.

To link to transactions in Accounts Receivables module:

- A/R Invoice, Credit Note and Debit Note
DRILAPP = AR
 DRILSRCTY = 0
 DRILLDWNLK has tricky values for all A/R transactions. You will see long values like this, 222435000000000001. It is the drilldown link number of the G/L entry showing in my previous screen shot. The meaning of each number is:

A/R Receipt
DRILAPP = AR
 DRILSRCTY = 1
 DRILLDWNLK is the same as above.

A/R Adjustment
DRILAPP = AR
 DRILSRCTY = 2
 DRILLDWNLK is the same as above.

To link to transactions in Accounts Payable module,

A/P Invoice, Credit Note and Debit Note
DRILAPP = AP
 DRILSRCTY = 0
DRILLDWNLK is the same as above.

A/P Payment
DRILAPP = AP
 DRILSRCTY = 1
 DRILLDWNLK is the same as above.

A/P Adjustment
DRILAPP = AP
 DRILSRCTY = 2
 DRILLDWNLK is the same as above.

I will explain how to do the links for all other modules in a future blog post.