Announcements
No record found.
Hi,
I would like to know how to configure the service module so it show referenced invoices to it.
In SMAServiceOrderTable / Line is a field invoiceId, I can add it into my grid on services, and I should be able to move to that invoice from menu > related info > Proj invoice journal but everywhere this field is empty and there is no reference via related info.
Hi RadekM,
I would rather use ProjTransId to build a relation to the invoice. You can refer back to ProjEmplTrans, ProjCostTrans,, ProjItemTrans, ProjRevenueTrans using this field. You should be able to recover the Invoice Id based the the transaction record.
You are trying to show the invoices for a service order. Correct?
Yes, I want to to show n the grid the related invoiceid. Idk why it didn't work on standard even when there is in menu a reference greated for it that also didn't work
You can debug the executeQuery method under Datasource\ProjInvoiceJour in ProjInvoiceJournal form. It is using the ProjTransId field to look for invoices.
select * from projinvoiceunion join smaserviceorderline on projinvoiceunion.transid = smaserviceorderline.projtransid
I tried to join the tables on sql and it joined just 1 record. For all others it looked like no relation was there.
Are there other records that are invoiced? You can try processing a few transactions and invoicing them to check if you get new records in this query.
I've got over 200 project invoices they just can't joun with this view...
Are all of these invoices from service orders? Can you share a few screenshots of these service order lines?
Projtransid from order line is totally differend from projinvoiceunion.
That is weird. ProjTransId is unique for all transactions. If you are sure that the project transactions are originating from service orders, you should raise a ticket with MS to look at the issue.
Before you do that, I would suggest you process a few transactions to make sure that the transactions are not coming over with the right TransIds.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 659
André Arnaud de Cal... 465 Super User 2026 Season 1
Syed Haris Shah 304 Super User 2026 Season 1
