web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) PO Invoice - Pass Cust...

Microsoft Dynamics AX (Archived)

PO Invoice - Pass Custom field values from PurchLine to DataDictionary\Tables\InventPosting\findByRelations?

(0) Share

Report

Report

Posted on by Hossein.K

6,648

Hi,

I have a custom field in PurchLine table.

I need to pass this value to DataDictionary\Tables\InventPosting\findByRelations function when clicking on 'Invoice' button in purchase order.

Infact this function is responsible of invoking posting profile from 'InventPosting' table.

I want to add more condition for invoking posting profile from this table.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Hossein.K 6,648 on at

Like (0)

Report
Copy link

Link copied!

Hi,

For Invoice PO , DAX uses 'Vendinvoiceinfotable' and 'Vendinvoiceinfoline' Tables.

I find out this method used for access these tables when we invoicie. (\Forms\VendEditInvoice\Methods\SaveInvoiceAndClose) .

'Purchline' Table is related 'Vendinvoiceinfoline' Table with(Vendinvoiceinfoline.PurchLineRecID==PurchLine.RecID).

select* from VendInvoiceInfoline
inner join purchline on vendinvoiceinfoline.purchlinerecid=purchline.recid
where VendInvoiceInfoLine.recid=*** order by recid desc

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans