Gross Margin Report for any period 1

[benksb]

I need help on figuring out which files maintain the line item detail on invoices. I am looking for detail line item sales price and line item cogs. I am trying to create a gross margin report using crystal. mas90 4.05

 

[BigLouie]

ARN hold the Invoice History Head and ARO holds the Invoice History Detail which holds the GL account numbers that the Sales and COGS were posted to.

 

[benksb]

Thanks for the info. I pulled the invoice line detail from aro and I am still missing the misc charge lines that are on the invoice. They do not seem to be in the aro file. I am trying to reconcile the aro amounts to the gl and I off by a misc charge that went to my sales gl acct. Any ideas?

 

[BigLouie]

They are there, trust me.

 

[Blorf]

Look at field line type, it tells you which fields to use in ARN. One line has gl field this, and another line type has gl field that, it's kind of old thinking, but it is there.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.