tag:blogger.com,1999:blog-3309255261537841213.post5952981759348517879..comments2024-02-16T22:53:57.594+00:00Comments on IT Help and Advice: Oracle EBS: Linking GL Lines to AP Invoice Distributions in R12Andy Pellewhttp://www.blogger.com/profile/10003917534384582892noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3309255261537841213.post-90752448170055885312013-04-29T18:50:30.359+01:002013-04-29T18:50:30.359+01:00Thanks, Thanks, Thanks!Thanks, Thanks, Thanks!Anonymoushttps://www.blogger.com/profile/05189284274666685541noreply@blogger.comtag:blogger.com,1999:blog-3309255261537841213.post-55013555802592955792013-01-30T11:55:18.619+00:002013-01-30T11:55:18.619+00:00That's a helpful post, thanks.That's a helpful post, thanks.ja_nhttps://www.blogger.com/profile/12113393673145514776noreply@blogger.comtag:blogger.com,1999:blog-3309255261537841213.post-79756170578445710822012-09-26T08:38:44.743+01:002012-09-26T08:38:44.743+01:00We created a number flexfields on the GL Line (GL....We created a number flexfields on the GL Line (GL.GL_JE_LINES) into which we stored the linking information (Invoice_ID, Invoice_Distribution_ID, PO_Header_ID, Transaction_Id, etc) for where the line was linked to outside the GL.<br /><br />For invoices we followed the rule that we would record as much information as we could. For example if a line in the GL directly linked to an invoice distribution we would record that, if the line linked to multiple invocie distributions (i.e. tax) then we'd just record the invoice_id and leave the distributions blank.<br /><br />It's not perfect but it works for us.<br /><br />Of course there is a process running every couple of hours to keep this up to date.Andy Pellewhttps://www.blogger.com/profile/10003917534384582892noreply@blogger.comtag:blogger.com,1999:blog-3309255261537841213.post-12163920220628704222012-09-24T19:15:23.253+01:002012-09-24T19:15:23.253+01:00I am interested to know how did you solve the link...I am interested to know how did you solve the link to be 1:1<br /><br />Thanks,<br />KassemKassem Nasserhttps://www.blogger.com/profile/04594656736231796611noreply@blogger.com