relation between GeneralJournalEntryTable and VendPackigSlipJour table

(2) Share

Report

Posted on by @rp@n

Dear All,

Can you please let me know the relation between GeneralJournalEntryTable and VendPackigSlipJour table. I put relation GeneralJournalEntryTable.DocumentNumber == VendPackigSlipJour .PackingSlipId.
Is there any other relation that can return me exact record form VendInvouce Jour table ?

Please give me more shed on this,

Thanks!

Arpan Sen

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Zain Bokhari 3,208 Moderator on at

Like (0)

Report
Copy link

Link copied!

Why are you looking for this relation? What is your actual requirement? can you please tell us a little more?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!
Hi,

There is no other relation except

GeneralJournalEntry.DocumentNumber == VendPackigSlipJour .PackingSlipId.

But you can join these two table using other table. If possible explain your explain your issue.

Thanks

Suresh

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Zain,

Actually i did report for ledger analysis. It's contain PO,Vend account ,name,voucher,Journal,Invoice ID, GRN no and date.

For some journal no it's showing me wrong PO,Vend,name

Then i found that in VendInvoicejour table same packing slip id is exist for different PO and Vendor account.

for example : VendInvoiceJour table

Purchid Vend Packingslip ID

PO001 V001 859

PO002 V002 859

PO003 V003 112

i need POO2 for packingslip id 859 but it's select POO1.

Please give me more shed on this.

Thanks!

Arpan Sen

Was this reply helpful? Yes No
tgudwanski 33 on at

Like (0)

Report
Copy link

Link copied!
As far as it seemed in our team's work, the following X++ code fragment could be helpful:

GeneralJournalEntry gje; SubledgerVoucherGeneralJournalEntry svgje; VendPackingSlipTrans vpst; VendPackingSlipJour vpsj; select gje JOIN svgje WHERE gje.RecId == svgje.GeneralJournalEntry JOIN vpst WHERE svgje.Voucher == vpst.CostLedgerVoucher && svgje.AccountingDate == vpst.AccountingDate && svgje.VoucherDataAreaId == vpst.DataAreaId join vpsj WHERE vpst.DataAreaId == vpsj.DataAreaId && vpst.VendPackingSlipJour == vpsj.RecId

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi All,

I have used this query ang get the voucher details of product receipt.

SELECT * FROM GeneralJournalEntry

inner JOIN GeneralJournalAccountEntry ON GeneralJournalEntry.RecId = GeneralJournalAccountEntry.GeneralJournalEntry

inner JOIN DimensionAttributeValueCombination ON GeneralJournalAccountEntry.LedgerDimension = DimensionAttributeValueCombination.RecId

inner JOIN MainAccount ON DimensionAttributeValueCombination.MainAccount = MainAccount.RecId

full OUTER JOIN ExchangeRateType ON MainAccount.ReportingExchangeAdjustmentRateType = ExchangeRateType.RecId

full OUTER JOIN FiscalCalendarPeriod ON GeneralJournalEntry.FiscalCalendarPeriod = FiscalCalendarPeriod.RecId

inner join SubledgerVoucherGeneralJournalEntry on GeneralJournalEntry.RecId = SubledgerVoucherGeneralJournalEntry.GeneralJournalEntry

inner JOIN VendPackingSlipVersion ON SubledgerVoucherGeneralJournalEntry.AccountingDate = VendPackingSlipVersion.AccountingDate

AND SubledgerVoucherGeneralJournalEntry.Voucher = VendPackingSlipVersion.LedgerVoucher

or SubledgerVoucherGeneralJournalEntry.Voucher = VendPackingSlipVersion.CostLedgerVoucher

inner join VENDPACKINGSLIPJOUR on VendPackingSlipVersion.VENDPACKINGSLIPJOUR = VENDPACKINGSLIPJOUR.RECID

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

community.dynamics.com/.../680674

Was this reply helpful? Yes No