AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Trap for Invalid (M...
 
Notifications
Clear all

Questions Trap for Invalid (Missing) Field in Report Designer

 
Acumatica Report Designer
Last Post by Tim Rodman 4 years ago
3 Posts
3 Users
0 Reactions
2,127 Views
RSS
Brian McMillin
Posts: 5
 Brian McMillin
Topic starter
November 17, 2021 5:52 pm
(@brianmcmillin)
Active Member
Joined: 5 years ago

I have added a user field to POOrder to be printed on Purchase Orders.  Works great when the customization is published but results in error when saved ran instance that does not have the customization:

Invalid field name POOrder.UsrRevisedDate has been specified.

Is there a way in Acumatica Report Designer to allow the report to run, giving that missing field a NULL value?


2 Replies
Wyatt.ERP
Posts: 128
 Wyatt.ERP
November 19, 2021 4:24 pm
(@wyatt-erp)
Estimable Member
Joined: 6 years ago

Refreshing the tables in schema editor might fix this. 

Open the Report.

Click File -> Build Schema... 

Make sure "Tables" tab is selected in the dialog.

Click "Refresh All" button near bottom right corner.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
November 20, 2021 4:58 pm
(@timrodman)
Famed Member
Joined: 10 years ago

I think the field has to exist if your report calls for it. I don't think that it will treat it as NULL.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 121 Online
  • 2,405 Members
Our newest member: Brittany Bartman
Latest Post: Importing Acumatica User Roles / User Security Permissions from Excel
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×