Reporting Invoice Date with GL Trans

You can join GLTRANS (OBJ_ID) to APDISTRIB (GLT_OBJ_ID) and APDISTRIB (API_OBJ_ID) to APINVOICE (OBJ_ID).

ACHISTDTL & ACHISTHDR are for invoicing customer receivables (i.e. AR, not AP).
APINVOICE & APDISTRIB are for invoicing vendor payables (i.e. AP, not AR).

You want to go from GLTRANS to APDISTRIB to APINVOICE to get the invoice date.

Thank you.

Next question - for these joins, this would only give one record back for one invoice, or do I need to know how to deal with a one-to-many relationship here? If so, how do I make sure I only have one invoice accounted for?

Thanks!

GLTRANS to APDISTRIB has a one to many relationship. Again APDISTRIB to APINVOICE has a many to one relationship.

On one invoice you may have multiple lines of items you are ordering that may hit diffrent GL Accounts. So there is a many to one relationship between APDITRIB to APINVOICE.

Again if you run the GL190 depending on whether you summarize your subsystem entries there may be one journal entry with multiple transactions on it. This explains a ONE to MANY relationship between GLTRANS and APDISTRIB.

Posted By muffntuf on 07/09/2009 09:03 AM

HI,

What is the best way to get Invoice Date added to a report with GLTrans?  I have looked at APInvoice and HCHISTDTL with ACHISTHDR.

They just want a basic listing of GLTrans, but with the Invoice date in the same Accounting Period.

I am pretty new to this stuff.

Thanks!

Just buy this report

www.lawsonguru.com/Store/p/Crystal-...ID/16.aspx

So you have multiple lines of items for one invoice, but you just want the summary of the invoice, or do you mean the GL will bring in line item details as well?

"GLTRANS to APDISTRIB has a one to many relationship. Again APDISTRIB to APINVOICE has a many to one relationship.

On one invoice you may have multiple lines of items you are ordering that may hit diffrent GL Accounts. So there is a many to one relationship between APDITRIB to APINVOICE.

Again if you run the GL190 depending on whether you summarize your subsystem entries there may be one journal entry with multiple transactions on it. This explains a ONE to MANY relationship between GLTRANS and APDISTRIB."