Open Forum

 View Only
  • 1.  Invoce Reprint Not working suddenly

    Posted Oct 20, 2021 01:44 PM
    I recently became aware of an issue that started a few months ago.
    Currently I cannot reprint invoices out or Flexible Billings.
    I open BI.INV.00 amd select reprint, Enter my invoice number I want to reprint and it does not matter if I select Print to Directory, Print to Printer or Print Preview  I get a Box PC Message Number 0153 and it says Print 0 invoices/drafts.

    Has anyone else experienced this?
    Could it be a sudden permissions change when we added the service packs earlier in the year?

    any thoughts are appreciated.

    Nathan Hammersley
    Hammersley Stone CO

  • 2.  RE: Invoce Reprint Not working suddenly

    Posted Oct 20, 2021 05:50 PM
    Edited by Marc DeLozier Oct 20, 2021 05:50 PM

    Hi Nathan,
    Which version of SL are you running?  I'm still on SL2015 and the code (in my environment) that populates the count for REPRINTS in that message runs stored procedure: pjinvhdr_spk3rin2

    I would look into this proc to see if anyone has recently altered it:
           select name, create_date, modify_date from sys.procedures where name = 'pjinvhdr_spk3rin2' and type = 'P'

    I would also run a trace via profiler to see what values are being passed from the SL screen to the proc;  and execute that directly in SSMS to see if you get a count; that should hopefully give you something to start with in your investigation.  


    Marc DeLozier
    Finance SysAdmin
    David Evans and Associates Inc.
    Portland OR