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

Linking TranGLC to PartTran for Periodic Post Dtl

 Post Reply Post Reply
Author
Message Reverse Sort Order
mbtaylor View Drop Down
Employee
Employee


Joined: 24 July 2007
Location: China
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote mbtaylor Quote  Post ReplyReply Direct Link To This Post Topic: Linking TranGLC to PartTran for Periodic Post Dtl
    Posted: 04 August 2015 at 19:20
Look in the Trackers. For example to see the resultant GL postings for a posted AP invoice, open the AP Invoice Tracker, select your posted invoice, and then click on Header > GL Transactions and finally click the Retrieve button.

if the transaction is not yet posted, and it is a transaction that supports Edit lists, then you can run that from the transaction entry function (usually on the Actions menu) and it will show the GL summary by account at bottom the page, per transaction.
Back to Top
Parag View Drop Down
Newbie
Newbie


Joined: 31 July 2015
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Parag Quote  Post ReplyReply Direct Link To This Post Posted: 03 August 2015 at 06:51
Thank you for prompt response. Smile

My question, if I extend, is how can I view/print this posting so that I can understand thoroughly where or to which GL it is posted.
Back to Top
mbtaylor View Drop Down
Employee
Employee


Joined: 24 July 2007
Location: China
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote mbtaylor Quote  Post ReplyReply Direct Link To This Post Posted: 01 August 2015 at 21:05
Hello,
The Periodic Posting Process is basically all the processes where the posting is handled by the system. Example with AP invoices you have to manually print and edit list, and then manually select to Post. With Inventory transactions such as an Adjustment you save the transaction, and the post happens in the background - this is the 'periodic post'.
Back to Top
Parag View Drop Down
Newbie
Newbie


Joined: 31 July 2015
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Parag Quote  Post ReplyReply Direct Link To This Post Posted: 31 July 2015 at 11:05
Hi,

I am very new to Vantage. Being an Accountant, I have used various other systems.

We are still using Vantage 8.03.409A Version.
I am also having problems is viewing this so called "Periodic Posting Process".

How do I see beyond this? - I want to see how, from where and what is include in that amount.

Is there anyway a non-technical guy can view it. Or is it that I have to hire some specialist to prepare some kind of report which will give me all the details included in Periodic Posting Process...

Please help.
Back to Top
mbtaylor View Drop Down
Employee
Employee


Joined: 24 July 2007
Location: China
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote mbtaylor Quote  Post ReplyReply Direct Link To This Post Posted: 12 May 2015 at 22:23
When using a BAQ sometimes is helpful to use table aliases. So when using TranGLC use a table alias for it like TranGLC_PartTran and then link PartTran to that. So the same for TranGLC_Invoice and so on.  This keeps the table relations much easier to read and the logic simpler.

And also remember to set the item to being FIRST if you  know you are only getting one record e.g. there is only one invoice header so doing have "Each" on the Invched table. 

In all the joins generally make sure they are OUTER joins so that results are returned even if the 'child' table not present.
Back to Top
eamurphy9059 View Drop Down
Newbie
Newbie


Joined: 26 June 2014
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote eamurphy9059 Quote  Post ReplyReply Direct Link To This Post Posted: 26 June 2014 at 06:12
Can you use both of these in the same baq?
eamurphy9059
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: 08 October 2013 at 12:01
I have used this:
company,journalnum,journalline,key1,fiscalyear  on the TranGLC table
 company, journalnum , journalline , groupid , fiscalyear  on the GLJrnDTL table
also Part tran is :
company, sysdate, systime ,trannum Parttran table
company, key1,key2,key3 TranGLC Table

Back to Top
althomas View Drop Down
Veteran
Veteran


Joined: 27 August 2009
Status: Offline
Points: 247
Post Options Post Options   Thanks (0) Thanks(0)   Quote althomas Quote  Post ReplyReply Direct Link To This Post Posted: 08 October 2013 at 06:48
What fields did you use to link GLJrnDtl table to the TranGLC table? I couldnt find a common link. i wanted to analyze my WIP account to see what all transaction went into it and where it came from. The GLJrnDtl gives me the account number and Dr/Cr Amount. I need to know what Job they came from. Is the TranGLC the right table to link? or is there another table to link to GLJrnDtl to get that detail.

Thanks
AL 
Back to Top
rwelling View Drop Down
Employee
Employee


Joined: 18 March 2009
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote rwelling Quote  Post ReplyReply Direct Link To This Post Posted: 25 September 2012 at 08:08
The trick to linking PartTran to TranGLC is that PartTran.TranNum joins to TranGLC.Key3 when the journal is 'IJ' 
Back to Top
bridgettsimmons View Drop Down
Newbie
Newbie


Joined: 14 August 2012
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote bridgettsimmons Quote  Post ReplyReply Direct Link To This Post Posted: 14 August 2012 at 13:17
I want to be able to pull a GL activity report that includes all GL transactions regardless of Source Module.  I've successfully been able to link the GLJrnDtl table to the TranGLC table.  I read a post that said you should go through the TranGLC table to the parttran, labordtl, and invcdtl tables.  Now I cannot link the TranGLC to the PartTran table.  I've tried linking the TranGLC fields Key1, Key2, Key3 to the PartTran fields PONum, POLine, and PORelNum fields, but it doesn't work.  Can someone help me link these fields so i can get a job number for the Periodic Posting Process GL Transactions?  Thanks
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.