Hi,
We have a report that is used to create a batch report for remittance advice in our accounts department.
The report gets certain customers from our Navision database, and then create an autopilot command line instruction to run another report for that specific customer.
this runs fine normally, but when run today, autopilot does not get past the first remittance, and nothing is ever emailed out to that customer.
Looking at the report, it seems that something is causing most cells to display the returned value from the DB, but the formula bar still shows the NL or NF function.
I think that means that the autopilot program is trying to use the NL function as the email address.
Does anyone have any idea if there is an option that affects this, or possibly something in the report itself?
I should mention that this is in report view, and not design view.
Many thanks,
Eds
Date
Votes
4 comments
-
Jet Reports Historic Posts I don't understand completely but does the report have "Auto+Hide+Values" in cell A1?
"+Values" turns all Jet formula into values. -
Jet Reports Historic Posts Hi,
Thanks for the reply.
As this is not my report, I hasn't thought of checking that.
As it turns out, +Values had not been added, hence the formula display issue.
Unfortunately though, this hasn't solved the issue.
Running the report to create the batch runs fine manually, and you can use the output to run multiple reports in a batch using the below:"C:\Program Files (x86)\JetReports\autopilot.exe" /m "PDF" /I "T:\Finance\Everyday Finance\Purchase Ledger\JET PL\Remittance Advice\CBSA\JET AGENCY REMITTANCE.xlsx" /o "T:\Finance\Everyday Finance\Purchase Ledger\JET PL\Remittance Advice\CBSA\SENT REMITTANCE\CBBACS0000416910 V.1280449 MARINE SERVICES (EASTERN) LTD .pdf" /e "msl.ltd@btinternet.com" /u "CORY BROTHERS REMITTANCE ADVICE 25/07/2013 MARINE SERVICES (EASTERN) LTD " /b "Dear Supplier, Please find attached your supplier remittance advice. Kind Regards Purchase Ledger Team, Tilbury" /P "VEND" "1280449" "DOCNO" "CBBACS0000416910"
If I were to run this from the command line, after copying it directly from the report, it updates a separate report no problem.
It only seems to be on scheduled jobs, where we have told it to generate a batch.
Cheers
Eds -
Jet Reports Historic Posts Hi Eds,
You may need to turn on AutoPilot logging or possibly even Jet logging to figure out what is really going on. This sounds like a problem where you should create a ticket with Jet Reports Support. Then someone can actually examine the issue more closely with you and figure out what is going on.
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes,
I have raised a ticket, and i'm in talks with Joel.
I will turn on Jet Logging, and see if there is something a bit more detailed there that can shed some light.
Many thanks
Eds
Please sign in to leave a comment.