You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

IDR INVOICES FIELD "IMAGE_DOCUMENT_NUM " IS BLANK

in Payables, Payments & Cash Management 4 comments

Summary:

Hi,

our user sometimes have the needs to reupload manually some invoices via spreadsheet, when the invoices have previously uploaded via IDR ( but for some reason they discard them). We already did this several times and to have the PDF linked with the correct invoice from the spreadsheet procedure, we do a sql to download the the pdf key from the table ap_invoices_all - field : IMAGE_DOCUMENT_NUM.

Sometimes happen that the filed IMAGE_DOCUMENT_NUM for some invoices it's blank but If i inquiry the invoice from the UI can see correctly the attachement. Can you explain this behaviour ? Why in some cases the field is blank and how i can retrieve the key for the attachement in this case.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!