News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Sales Line Invoice in ...

Finance | Project Operations, Human Resources, ...

Answered

Sales Line Invoice in ax 2009

(0) Share

Report

Report

Posted on by Khoa Phan Tan

10

Dear All,

What is column of table I can get 'Cost of Sales'.

I try get from INVENTTRANS table in COSTAMOUNTOPERATIONS column, but it not correct.

Please help me for my question.

Many Thanks.

All responses Img

All responses (5)

Answers Img

Answers (1)

WillWU 22,352 on at

Like (1)

Report

RE: Sales Line Invoice in ax 2009

Hi partner,

If you have other questions, please start a new thread.

Thanks!
Khoa Phan Tan 10 on at

Like (0)

Report

RE: Sales Line Invoice in ax 2009

Dear Will WU,

Could you please show me some columns of Sales Line Invoice relationship. I link some tables but the result a lot of rows is not correct. I need to get 'invoice account', 'Cost of sales'(done), 'Customer name'.

Many thanks,
WillWU 22,352 on at

Like (0)

Report

RE: Sales Line Invoice in ax 2009

Hi partner.

Glad to hear that, please spare a little time to verified the helpful answer to close this thread.
Khoa Phan Tan 10 on at

Like (0)

Report

RE: Sales Line Invoice in ax 2009

Thanks you very much! I do it.
Verified answer

WillWU 22,352 on at

Like (1)

Report

RE: Sales Line Invoice in ax 2009

Hi Khoa Phan Tan,

It is a calculated value from CostAmountPosted+CostAmountAdjustment in the INVENTTRANS table, and you could use the method costValue on the INVENTTRANS.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,118 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans