TranGLC in 9.05

Yahoo Archive
1
The TRANGLC records still exist. BA's work good to tie them together.
To get to them, you need to use the TranGLC 'relatedtoFile' - take that 'relatedtofile' and link to that file/table based on the primary index of the file (primary index found in data dictionary) .

Tranglc Parttran
Company Company
Key1 SysDate
Key2 SysTime
Key3 TranNum



--- In vantage@yahoogroups.com, bebright@... wrote:
>
> I need to create a report using the PartTran table and the GL tied to the transaction. I thought I could get this data from the TranGLC table, however, i have not been able to. I have found out from support that the TranGLC table only holds the records prior to posting. Does anyone have an idea as to where the records go after posting?
>
> This would help me out a great deal. Thank you in advance...
>
2
I need to create a report using the PartTran table and the GL tied to the transaction. I thought I could get this data from the TranGLC table, however, i have not been able to. I have found out from support that the TranGLC table only holds the records prior to posting. Does anyone have an idea as to where the records go after posting?

This would help me out a great deal. Thank you in advance...
3
The other way around... Inventory transactions are created in PartTran
only during the month. When you run the Capture COS/WIP process it
creates the required GL entries for those part transactions, in TranGLC.
The PartTran record still remains forever, it just now has Posted=1.
Some part transactions never get posted if there is no money involved.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bebright@...
Sent: Thursday, January 26, 2012 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] TranGLC in 9.05





I need to create a report using the PartTran table and the GL tied to
the transaction. I thought I could get this data from the TranGLC table,
however, i have not been able to. I have found out from support that the
TranGLC table only holds the records prior to posting. Does anyone have
an idea as to where the records go after posting?

This would help me out a great deal. Thank you in advance...





[Non-text portions of this message have been removed]