Skip to main content
Solved

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


Forum|alt.badge.img
  • Jr Varsity II
  • 24 replies

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 .

 

 

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

4 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 712 replies
  • 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
  • 712 replies
  • April 19, 2022

@arjan Did that resolve the issue?


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • 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
  • 712 replies
  • 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).


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