Sage 100

 View Only

  • 1.  No data appears on S/O & S/O invoices after activating S/O module

    Posted 01-23-2020 15:09

    We are in the process of implementing Avatax for a client, which includes implementing the Sales Order module.  They don't use the inventory module, so we enabled the Miscellaneous Charge and Item codes for use in S/O.  Avatax is the only enhancement on their system.

     When I print either Sales Orders or Sales Order invoices, no data appears on the document – using unmodified Sage templates; no tables other than the workfile.

     To troubleshoot, I made a copy company, activated the Inventory module and added items, but get the same results.  When I DFDM the document printing workfile, records are present for each line on the document.

     Anyone have ideas why the forms won't display data?

    No data appears


    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: No data appears on S/O & S/O invoices after activating S/O module

    Posted 01-23-2020 15:15
    Any ODBC security in place?

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 3.  RE: No data appears on S/O & S/O invoices after activating S/O module

    Posted 01-23-2020 15:28
    Ditto re: Therese's question ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: No data appears on S/O & S/O invoices after activating S/O module

    Posted 01-23-2020 15:38
    If no ODBC security in place, you might preview the form then use DFDM to look into the temp work file to see if it's populating. If so, then it's the form and not the data.

    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 5.  RE: No data appears on S/O & S/O invoices after activating S/O module

    Posted 01-23-2020 15:58
    Do SO standard reports run??

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 6.  RE: No data appears on S/O & S/O invoices after activating S/O module

    Posted 01-23-2020 16:07
    It was ODBC security not being enabled for the SO module.  What a difference a checkbox makes!  Thanks Therese.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 7.  RE: No data appears on S/O & S/O invoices after activating S/O module

    Posted 01-23-2020 16:05
    Is the Sage ODBC print service installed?  If so, stop and re-start the service.  Is the box checked to use the odbc print service either for the system or for the user?

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



Related Content