Skip to main content
Solved

Add selected images to an Invoice

  • 6 September 2021
  • 5 replies
  • 524 views

Hi all,

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

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

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

Best answer by cshaheen26

HI @MikeAndrews , I’m sure you’ve already tried this but if you haven’t, try using the “Left” join type in your relations of the build schema. I just added the expense receipt images to an AR invoice format using the left join and it worked. 

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img
  • Jr Varsity II
  • 65 replies
  • Answer
  • September 17, 2021

HI @MikeAndrews , I’m sure you’ve already tried this but if you haven’t, try using the “Left” join type in your relations of the build schema. I just added the expense receipt images to an AR invoice format using the left join and it worked. 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • September 19, 2021

Hi @MikeAndrews  Can you move the Last table join (ARTran with InventoryItem) to the 3rd position from the last.

In your report last 3 table joins should be like below and verify.


  • Author
  • Freshman I
  • 2 replies
  • September 20, 2021

Hi @cshaheen26 and @Naveen B.

Thankyou both.  The suggested change to the Table joins and moving tje position of the ARTran row has fixed the problem. 

I also changed the of thechange to thhe joins and the value in the Picturebox to =[InventoryItem.ImageUrl]

My only problem now is that the report repeats the same line over and over.  Not sure what Ive doen wrong here.  Thanks again


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • September 20, 2021

Hi @MikeAndrews  Thanks for the update.

Q: My only problem now is that the report repeats the same line over and over.  Not sure what Ive done wrong here. 

For this issue, we need to check all the joins and verify and it requires detail analyzation according to me.

 


  • Author
  • Freshman I
  • 2 replies
  • September 21, 2021

Thank you.  I’ll keep testing as suggested.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings