Epicor Discussion Forums Homepage
Forum Home Forum Home > Epicor University > Epicor ERP Financials
  New Posts New Posts
  FAQ FAQ  Forum Search   Register Register  Login Login

Detail of Periodic Posting JE

 Post Reply Post Reply
Author
Message
markbrown View Drop Down
Newbie
Newbie


Joined: 07 October 2011
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote markbrown Quote  Post ReplyReply Direct Link To This Post Topic: Detail of Periodic Posting JE
    Posted: 07 October 2011 at 07:09
I have created a Crystal Report to show the journal entries for each account. Many of the transactions are simply show "Periodic Posting" in the General Ledger Detail Journal Entry table. Does anyone know either the path (tables and links) to find the detail information for these type of entries or how to change a setting so that the detail information flows to the journal entry.
 
Thanks you very much. 
 
Mark Brown
Back to Top
MarcLivingston View Drop Down
Veteran
Veteran


Joined: 12 August 2010
Status: Offline
Points: 257
Post Options Post Options   Thanks (0) Thanks(0)   Quote MarcLivingston Quote  Post ReplyReply Direct Link To This Post Posted: 02 March 2012 at 13:29
You can link the tranglc to the journal using the company, trandate, and glaccount.
From there you can link the related to tables like parttran,labordtl,invcdtl
However this should be limited to Only Periodic Posting as it screws up and duplicates when the account has been used on the same date.
Back to Top
MarcLivingston View Drop Down
Veteran
Veteran


Joined: 12 August 2010
Status: Offline
Points: 257
Post Options Post Options   Thanks (0) Thanks(0)   Quote MarcLivingston Quote  Post ReplyReply Direct Link To This Post Posted: 02 March 2012 at 14:34
Edit to the last post. You can also add the journal number and line to the link and it works perfectly

so the link would be:

Company,
trandate,
GLAccount,
Journalnum,
Journalline


Edited by MarcLivingston - 02 March 2012 at 14:35
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.17
Copyright ©2001-2013 Web Wiz Ltd.