Related Parties Elimination

I am trying to create a report from GL Account Transaction explorer so I can pick the related parties I need to eliminate.  However, I could not add a column where it gives me the Vendor name and Client name.  All I can drill down are the invoice and voucher numbers.  Please assist.  Thanks..

  • 0

    The standard Explorer task GL Transactions does not provide vendor or customer name. However you can create a new SQL view from the existing GL Transactions view and add vendor and customer related tables. Once your view shows the required data (vendor and/or customer name) you will need to create a new Explorer task. If you need further assistance you can contact either your Sage 500 VAR or Sage 500 ERP technical support.