Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

ProjInvoiceOnAcc and tax trans

Posted on by 304

Hi,

Is there any link between the ProjInvoiceOnAcc and TaxTrans table?

  • Verified answer
    KareemTaima Profile Picture
    KareemTaima 304 on at
    RE: ProjInvoiceOnAcc and tax trans

    Hi all,

    I have found a solution, you use both the ledger voucher field from ProjInvoiceJour and  the RecId from ProjInvoiceOnAcc against voucher and SourceRecId in TaxTrans

    This way you'll be able to track each line taxes from the project invoice

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: ProjInvoiceOnAcc and tax trans

    Hi Kareem,

    Has your issue been resolved or do you need any other help/support?

    Best regards,

    Ludwig

  • Suggested answer
    NataliaLeal Profile Picture
    NataliaLeal on at
    RE: ProjInvoiceOnAcc and tax trans

    Hello Kareem Taima,

    I think you could use voucher stored in taxtrans to search project invoice (ProjInvoiceJour_LedgerVoucher). Then take project invoice number (ProjInvoiceJour_ProjInvoiceId) to search register in ProjInvoiceOnAcc.

    Regards,

    Natalia

  • KareemTaima Profile Picture
    KareemTaima 304 on at
    RE: ProjInvoiceOnAcc and tax trans

    I can't really track down what you're referring to

    Maybe to be clear more, Is TransId or SourceRecId fields in ProjInvoiceOnAcc  table linked with anything to get the taxes associated?

    because those the only unique fields I found in the ProjInvoiceOnAcc for the same ProjInvoiceId

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: ProjInvoiceOnAcc and tax trans

    Hello Kareem,

    Not directly but through the sales tax group and item sales tax group that are used to post the invoice in the projinvoicejour table.

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans