Thanks Jen i'll give it a shot
Jose C Gomez
Software Engineer
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 vantage@yahoogroups.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.
Quis custodiet ipsos custodes?On 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 vantage@yahoogroups.com, <vantage@yahoogroups.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.
Quis custodiet ipsos custodes?</div> <div style="color:rgb(255,255,255);"></div></div> <div style="color:#fff;min-height:0;"></div>
