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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: COOLIGHT
  • Content: Threads
  • Order by date
  1. COOLIGHT

    need help to exclude two items when calculating total

    hi, i want to calculate the total cases of the shipment for one invoice, excluding two items TAX and SHIP. I also want to add text "Cases" behind sum qty. My formula is below and it does not work. can anyone help me here? thanks if {SO_InvoiceWrk.ItemCode}<>"TAX" and...
  2. COOLIGHT

    print old aged AR statement

    Hi, I need a help here. I need to print old aged AR statement of by month for 12 consecutive months. How can I print 12 reports? Thanks
  3. COOLIGHT

    two connections setting through Netgear switch

    I hope this is the right place to ask a question. Our office has two connections: integrated T1 line (carry 14 phone# and internet access) and cable connections. T1 line is connected to CISCO router#IAD2400 Series with phone connections before connecting Fortinet firewall. Both connections go...
  4. COOLIGHT

    help on importing from General Ledger Exchange

    Hi I tried to import transaction data via General Ledger Exchange, but the system kept telling me that file can not be opened. I used Standard Exchange format. Can anyone help me here? the details are below. thanks Account# Date Source Journal# Module Reference Amount 5550-1000...
  5. COOLIGHT

    AR invoice due date

    original AR invoice has due date of 30 days, but for some reason we want to give customer 120 days term for one invoice that was posted already. How do I change invoice due date for posted AR invoice? thanks
  6. COOLIGHT

    import contacts in several groups

    Hi Guys, I have a contact list in Excel file and some contacts belong to different groups. How can I import the contact list? Do we need import twice for difference group? Thank your help

Part and Inventory Search

Back
Top