How to Attach any kind of Document with Purchase Order

Bruce

hi
How to Attach any kind of Document with Purchase Order with Import ,Export , Delete Functionality

The Attached Document could be Doc File , Xsl File any thing.

For Example , Picture Can be Import , Export , Delete on Company Information Form.

Thanks

sendoh

you can add a blob field.

Sandeep_Prajapati

Hi Bruce,
attachment table can be used.

ImportAttachment,OpenAttachment,ExportAttachment functions.

IF (AttachmntRec.ImportAttachment(ImportFromFileName,FALSE,TRUE)) THEN 
BEGIN 
    "Attachment Id" := AttachmntRec."No.";    
    //........
End;

attachment id (a field in the source table of your form) is ID for your link for the attachment.


Show

IF AttachmntRec.GET("Attachment Id") THEN 
   AttachmntRec.OpenAttachment('Attachment  No. -  ' + FORMAT(i),FALSE) 

I hope it helps..... O:)

garak

But note, ff you store the attachment into a BLOB, it makes the DB very big.
Also if you are on SQL, the NAv client ever reads the Datalength of the BLOB Field. So, sometimes it's better, to store the Docs outside on an seperate network folder. Here in the forum are many topics and solutions about these theme.

I know, the easiest way is to store the Documents as BLOB in a separete table.

Regards

djswim

garak wrote:

But note, ff you store the attachment into a BLOB, it makes the DB very big.

Read this five times before you choose to implement the solution above. It will work, but if you're in a high-transaction environment and are attaching a document file to every PO, this can get ugly in a hurry. If you're only going to be doing it in special situations (i.e. orders over a very high threshold of dollar amount) then it could work.

Personally, I'm of the opinion that aside from your company logo, external files should stay out of the NAV DB.... that space is precious and there are easy ways to attach to something that's in another DB (preferably on another drive or machine)