Sage 100

 View Only

  • 1.  Crystal and Work Order. A customer needs a critica

    Posted 01-29-2016 12:04
    Crystal and Work Order. A customer needs a critical report based on work order transaction entry. The data they need is in WOS: Transaction Entry Detail and WOU: Transaction Entry Tier Distribution. I can't find a way to link these two tables. WOU has a LineIndex field. WOS only has fields for PreviousIndexNumber and LinkToNextLine. Does anyone know how to accomplish this?


  • 2.  RE: Crystal and Work Order. A customer needs a critica

    Posted 01-29-2016 13:56
    The LineIndex in WOU links back to the Providex Record Number in WOS. Unfortunately, the record number's value is not stored in the record nor is it available to ODBC. Just checking VI Export... and I don't see a connection there either


  • 3.  RE: Crystal and Work Order. A customer needs a critica

    Posted 01-29-2016 14:12
    Thank you, Doug. This is very irritating.


  • 4.  RE: Crystal and Work Order. A customer needs a critica

    Posted 01-29-2016 14:31
    Yes, the old LineLinking system in Sage has aged me considerably. A Master Developer could write a custom program and export to a CSV file or UDT.


Related Content