Sales Commission Report 1

[dardartektips]

In MAS 90, I am trying to print a sales commission report for the entire year and April isn't being included, presumably because the detail got cleared when we ran it the first time. How do I get EVERYTHING ? I have a crystal report set up but I can't figure out what table to pull from in order to get everything I want.

My report includes:
SalesPerson#, Customer#, Invoice#, InvoiceDate, SalesSubjToCommission, and Invoice Total

Thank You,
Laura

 

[BigLouie]

The canned Sales Commission report pulls from the ARE file. If April was cleared out of that file you are out of luck.

To build a Crystal report with the fields you indicated you would use the ARN, invoice history header, if you are on 4.05 or less. If you are on 4.10 it is some long name which I can't remember at the moment.

 

[dardartektips]

Thanks BigLouie, I'll try that tomorrow, we are on 4.0 so don't worry about the other name. I thought I tried that one and got even less data but maybe I had something messed up. It's been a little while since I've done a Crystal Report.

Thanks Again,
Laura

 

[dardartektips]

That worked except that well over half my invoices (probably the majority) don't have an amount in SalesSubjectToComm.

Also, do I use NonTaxableSalesAmount for invoice total it seems to work on the ones that have an amount in SalesSubjectToComm but of course not the ones that don't.

Please excuse me if this is a dumb question but I am new to MAS 90 and Crystal Reports.

Thanks,
Laura

 

[BigLouie]

In the ARN there is no invoice total. In a report you have to add the NonTaxableSalesAmount+TaxableSalesAmount+Frieght+SalesTax to get an invoice total.

The SalesSubjectToComm comes from totally all the line items that have Comm set to Y. If there is no amount in SalesSujectToComm then there are no line items that are commissionable.

You can reach me directly at bglouie@sbcglobal.net if you like.