Skip to main content

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

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. 

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.

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

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.

 

Thank you.  I’ll keep testing as suggested.

Reply


Terms & ConditionsCookie settings