assasafras / git_tutorial

Tutorial
0 stars 0 forks source link

TRLInvoicer2 - incorrect path name written to FCM #40

Closed assasafras closed 8 years ago

assasafras commented 8 years ago

Issue

Email from Jasper: "The TRL invoices pdf seems to be named differently. From the server, the actual name is Invoice 16101202678.pdf but on the link when viewing it via FCM General Enquiry, it shows \PRODAKL010v\TRLInvoices\16101202678.pdf instead of \PRODAKL010v\TRLInvoices\Invoice 16101202678.pdf" image

Solution

Update stored procedure that writes the note (sp_TRLInvoiceInsertFCMComment) to prepend "Invoice " before the invoice.