Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by murderface

  1. murderface

    Custom Aged Payables Query

    To help give an idea of what I am looking to do, the following query produces a report in crystal reports which is almost what we need - only with vendors instead of customers - an aged payables report for all vendors under a specific account. SELECT DISTINCT "RM20101"."CUSTNMBR"...
  2. murderface

    Custom Aged Payables Query

    Hello everyone. I did some search around, both on the forum and in the database, but still need help. I am trying to generate a custom aged payables report - the only custom part being a where clause on the account number (gl00100.actnumbr2). The report that runs in great plains shows every...

Part and Inventory Search

Back
Top