Sage 100

 View Only
  • 1.  Has anyone had the experience where a client has m

    Posted 04-07-2015 12:42
    Has anyone had the experience where a client has made a change through Commission Edit Maintenance and then the invoice drops completely off the Commission Edit Register? I can see the records in AR_SalespersonCommission and they are identical to the records that are still appearing on the report. I've rebuilt everything I can think of. Any other ideas?


  • 2.  RE: Has anyone had the experience where a client has m

    Posted 04-07-2015 12:46
    And I finally got smart enough to check the actual Crystal report file. Sure enough, someone had modified the file to include PO number from Invoice History Header with an inner join and these particular invoices did not have PO numbers. Changed to left outer join and life is good again.