Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Mon, Sep 30, 2013 at 1:44 PM, <jlisser@...> wrote:Â
<div> <p></p><p>You would need GLJrnDtl, GLOpnBal, GLPerBal.Â The GLJrnSrc will give you a tran date - in your situation the transaction version posted dates could make a difference.Â You can also use the GLJrnSrc to link out to all the supporting tables like you would TranGLC in 9 (LaborDtl, APInvDtl, PartTran).<var></var></p>
---In email@example.com, <jose@...> wrote:
I have but they need a custom report for very specific reasons. One of them being they sold the company mid way through a period so we can't take money from X Day to X day and the begining balance has to be a certain number etc.
Jose C GomezSoftware Engineer
T: 904.469.1524 mobileOn Mon, Sep 30, 2013 at 1:27 PM, <cathy@...> wrote:Â
<div> <p>Have you looked at the General Ledger Report? <br></p><p style="font-family:arial, helvetica, clean, sans-serif;font-size:13px;font-style:normal;background-color:transparent;"><br></p><p style="font-family:arial, helvetica, clean, sans-serif;font-size:13px;font-style:normal;background-color:transparent;">
It gives detail GL Entries.
The shortcoming is the "Periodic Posting Process" which are your Inventory, WIP, DMR, etc accounts and are created through the Capture COS/WIP activity.Â You could modify this report to tie these transactions to the TranGLC table to give you more detail.
It is a one liner report which could easily be exported to Excel.
—In firstname.lastname@example.org, <email@example.com> wrote:
Hey guysI need to create a GL Details report that can be run by period (and no i can’t use the system one) with each detail transaction per account with the end balanceÂI am not much of a finance guy so my GL knowledge is a bit limited
I foundÂ GLJrnDtl which contains the Dtl for the Journal Entries… are there any other tables I need to look at to get the transactions per account? In 9.05 there is TranGLC Â but that doesn’t exist in 8x.
</div> <div style="color:rgb(255,255,255);"></div>
</div> <div style="color:#fff;min-height:0;"></div>