Skip to main content

Hello,

I am stock at the CSAnswer table join. i attached the report file so you can take a peek. first it doesnt do what i intended to do, second, there is a duplication and each receipt prints 170+ pages.

Thank you!

 

Hi @arjan ! The link on POReceipt to CSAnswers should be on NoteID to RefNoteID, respectively.


@arjan Did that resolve the issue?


@BenjaminCrisman . yes finally! seems like the answer to this question residing in UsrinventoryLotSerialContainer table.

i also attached relations below .

 

 


@Arjan Excellent, glad you got the answer. Any table which starts with Usr is typically going to be a custom table and not something provided out of the box (though I think there can be a couple exceptions).


Reply