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!

Register Log in
  • Congratulations Chriss Miller 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: kyariexcel
  • Content: Threads
  • Order by date
  1. kyariexcel

    LASTINVNUM in OEORDH oddities

    Hello all! :) I have been working on a web report that pulls from our SAGE 300 database and I have run into a weird situation. We have an order 0272122 that shows a LASTINVNUM of 20240201. But, if you go to the last invoice shown in Order Entry, the date shows 20240117. This report pulls all...
  2. kyariexcel

    Tables in Service Manager

    One of our departments is looking for a way to manage job tickets more efficiently. They would like a four-column table with Job #, Location, Job Status, and Job Notes (underneath "Phases" on the report). They use Service Manager - specifically, Document Entry - to manage them currently, but...
  3. kyariexcel

    OEINVD item cost in different fields / MSSQL

    So I'm trying to make a gross profit report for my boss, and to do that we want to compare all items on all invoices per order with their unit price against their unit cost. So all's going well, until I start noticing that the cost of each item displayed in Order Entry doesn't always match the...

Part and Inventory Search

Back
Top