2

I am working on SSRS Report that show the accrual in AX for purchase order.

When going to purchase>Product Receipt->Voucher, I can't find relation between purchase order line and Voucher. Note that Product receipt in VendPackingSlipJour contain purchId and GeneralJournalEntry contain number of voucher.

Kindly, can anyone help me how I can find the relation between the two tables to get the accrual of purchase order.

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
khaled el omar
  • 149
  • 1
  • 4
  • 13

1 Answers1

3

It goes from VendPackingSlipJour -> VendPackingSlipVersion -> SubledgerVoucherGeneralJournalEntry -> GeneralJournalEntry

It seems there may be more than one VendPackingSlipVersion record per VendPackingSlipJour, then use the VendPackingSlipVersion.findLatest method to find the relevant one.

This paper may be of help regarding the ledger rubbish in AX 2012.

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50