Skip to main content
Answer

Add VendorLot#(attribute&value) and MfgDate(attribute&value) to a PO Receipt report.

  • April 13, 2022
  • 4 replies
  • 217 views

Forum|alt.badge.img

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!

 

Best answer by arjan

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

i also attached relations below .

 

 

4 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • April 13, 2022

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


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • April 19, 2022

@arjan Did that resolve the issue?


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Answer
  • April 20, 2022

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

i also attached relations below .

 

 


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • April 20, 2022

@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).