AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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...
Add an Image of inv...
 
Notifications
Clear all

Questions Add an Image of invoiced Inventory item to the Invoice

 
Acumatica Report Designer
Last Post by Tim Rodman 4 years ago
4 Posts
3 Users
1 Reactions
2,217 Views
RSS
Mike A
Posts: 5
 Mike A
Topic starter
September 2, 2021 12:21 am
(@mike-a)
Active Member
Joined: 5 years ago

Hi,

I'm trying to include an uploaded jpeg image of an item to be invoiced on the standard AR641000 form. 

I've carefully followed an example in the Acumatica S150 Reports Designer document - (pages 30-34.  See attached Training Doc1 & Doc 2). 

I have checked and rechecked,  but continue to get the following error (See Trace 1 attached).

The problem seems to be with the table / table join of the Inventory Item.  See attached schema build.

Any assistance would be very much appreciated.

Thanks

 

Training Doc P1
Training Doc P2
Trace 1
Schema Build 1

 


3 Replies
Carl Brooks
Posts: 121
 Carl Brooks
September 2, 2021 5:38 pm
(@kingcarlos)
Estimable Member
Joined: 6 years ago

Not exactly what you are doing but does this help? http://myobexo.custhelp.com/app/answers/detail/a_id/37763/kw/image/session/L3RpbWUvMTYzMDYyMjE1My9zaWQvcEJrUGk2a3A%3D


Reply
Mike A
 Mike A
(@mike-a)
Joined: 5 years ago

Active Member
Posts: 5
September 2, 2021 10:45 pm
Reply toCarl BrooksCarl Brooks

@kingcarlos

Hi Carl, thanks for your response. Appreciate your time.

I actually have this KB doc but it doesnt address the specific issue I have.  It seems to me there is a table and or a relationship join mismatch, but I've not been able to find it.  I'll keep testing, thanks


Reply
Tim Rodman reacted
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
October 13, 2021 3:46 pm
(@timrodman)
Famed Member
Joined: 10 years ago

I think you need to move your ARTran -> InventoryItem join above your InventoryItem -> NoteDoc join because you're currently trying to use InventoryItem in a join to NoteDoc before it's available.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 21 Online
  • 2,414 Members
Our newest member: Megan Pawlowski
Latest Post: Credit Reference Report Needed
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 © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×