web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Receipt and General le...
Microsoft Dynamics AX (Archived)

Receipt and General ledger

(0) ShareShare
ReportReport
Posted on by Michael Chukwunyere 165

Hi All,

I have a reporting requirement that needs VendPackingSlipTrans/Jour and GENERALJOURNALACCOUNTENTRY in the same query.

Is there any way of joining these two tables directly or indirectly via a bridging table?

Thanks in advance for you answers

Mike

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Maybe you can find the information you need if you use the vendTrans table.

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    You can use below code/job to get the details from tables vendPackingSlipJour, vendpackingslipTrans and GeneralJournalAccountEntry tables.

    static void VendPackingSlipTransaction(Args _args)
{
    GeneralJournalAccountEntry          journalAccountEntry;
    GeneralJournalEntry                 generalJournalEntry;
    VendTable                           vendTable;
    VendPackingslipTrans                vendPackingSlipTrans;
    VendPackingSlipJour                 vendPackingSlipJour;
    DataAreaId                          companyId;
    
    companyId = curext();
    
    while select journalAccountEntry
    join generalJournalEntry
        where ((generalJournalEntry.RecId == journalAccountEntry.GeneralJournalEntry)
            && (generalJournalEntry.SubledgerVoucherDataAreaId == companyId))
        join vendPackingSlipTrans
            where ((vendPackingSlipTrans.Voucher   == generalJournalEntry.SubledgerVoucher)
                && (vendPackingSlipTrans.AccountingDate == generalJournalEntry.AccountingDate))
            join vendPackingSlipJour
		where vendPackingSlipTrans.vendPackingSlipJour == vendPackingSlipJour.RecId   
            join AccountNum, Party from vendTable
                where (vendTable.AccountNum == vendPackingSlipJour.InvoiceAccount)
   {
       info(strfmt("PackingSlipId: %1", vendPackingSlipJour.PackingSlipId));
   }
}


  • Michael Chukwunyere Profile Picture
    Michael Chukwunyere 165 on at

    thanks  a lot Chaitanya, Appreciate this. Resolved my issue

  • Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    NP...can you mark the useful answer(s) as verified to close the thread.

  • Michael Chukwunyere Profile Picture
    Michael Chukwunyere 165 on at

    Hi, Just check, VendPackingSlipTrans doesn't have a column/field named Voucher

  • Michael Chukwunyere Profile Picture
    Michael Chukwunyere 165 on at

    Hi, Just check, VendPackingSlipTrans doesn't have a column/field named Voucher.

  • Verified answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    Sorry..its CostLedgerVoucher

  • Michael Chukwunyere Profile Picture
    Michael Chukwunyere 165 on at

    thanks..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans