Skip to main content
Question

Last Date from File Section

  • October 16, 2026
  • 1 reply
  • 16 views
  • Translate All
Semi-Pro I
Forum|alt.badge.img

Hi, how do I get the last date of the attached signature file? Attached is the rpx.

 

1 reply

Naveen Boga
Captain II
Forum|alt.badge.img+20

​@MarkD  You should join the NoteDoc table with UploadFileRevision to retrieve the file upload date. Please refer to the SQL script below and make the necessary changes to your report accordingly.

 

SELECT
    SO.OrderType,
    SO.OrderNbr,
    UF.FileID,
    UF.Name AS FileName
FROM SOOrder SO
INNER JOIN NoteDoc ND
    ON ND.NoteID = SO.NoteID
INNER JOIN UploadFile UF
    ON UF.FileID = ND.FileID;

 

Translate
Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    Terms & ConditionsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved