A question on po_distribution_id matching to reference_3 in gl_je_lines table in a SQL statement

  Hi there,

I have a question on matching po_distribution_id with gl_je_lines-reference_3 column in SQL statement. 

 

Our po_distribution_id is imported to GL as reference_3 in gl_je_lines.  When there is a modification in po distribution amount, PO still keeps it as a single line, but GL adds an additional line.  For instance, I first enter $100 for a line in PO and send it to GL.  GL has one line for credit $100.  Later on, I changed PO amount to $90 and sent it to GL again.  PO still has one line but amount is $90.  But GL adds second line for $10 as debit.  The total balance from both sides is fine.