Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form

Posted on by 28
Dear All 
 
User wants to see Sales invoice amount in Invoice journal Form . i couldnt find it in the add fields . 
there is finanacial cost amount field in the transaction screen . but this does not match the invoice amount from Sales invoice amount from invoice journal from . 
 
1. How can we add the invoice amount from Invoice journal Form to transaction form ?
2. Whats the difference between financial cost amount in transaction screen to that of Sales invoice amount in Invoice journal Form ?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Hi Mohamed,
     
    My bad. This field is used in case at the moment of packing slip also a the revenue is posted. It could be indeed empty in your environment. To be able to get the sales line amount, it would require a customization to lookup a sales amount value from the sales journal lines.
  • Mohamed Shuhaib Profile Picture
    Mohamed Shuhaib 28 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Hi Andre 
     
    Physical Revenue Showing Zero .
     
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Hi Mohamed,
     
    Thanks. So, you are talking about the inventory transactions and not the invoice journal.
     
    On the inventory transactions grid, you can include the column Physical revenue to get the sales amount for the order line. This will not give a total invoice amount for the whole order, only the line level.
    The financial cost amount on inventory transactions is the cost of goods sold known at the moment of posting the invoice. This is not the revenue. In case you have an actual costing method, like FIFO, LIFO, or Weighted average, there can be a corrected cost amount when recalculating or closing the inventory. That settlement will be visible in the Adjustment column.
  • Mohamed Shuhaib Profile Picture
    Mohamed Shuhaib 28 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    HI Andre , 
     
    User Wants to see the invoice amount in transaction Form . 
     
    Inventory managment -> Inquires -> Transactions . 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Hi Mohamed,
     
    You are confusing me. The user wants to have the invoice amount on the invoice journal, but it looks like you agree the field is already there. What exactly do you mean by a transaction form?
  • Mohamed Shuhaib Profile Picture
    Mohamed Shuhaib 28 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Hi Andre 
     
    Am referening to Invoice amount field in the Invoice Journals inquiry form (Accounts receivable ) and Financial cost amount in the transaction form(inventory managment ) . am not refering to the lines.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Thanks Mohamed,

    This form already has a column Invoice amount in the standard application. Is there a difference between the Sales invoice amount and this column? E.g. the Sales invoice amount is excluding Sales Tax/VAT? Note that there are some columns available with a description starting with "The" instead of a field label. Maybe this could include the field you are looking for.
     
     
  • Mohamed Shuhaib Profile Picture
    Mohamed Shuhaib 28 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Hi Andre,
     
    Menu Path 
    Accounts Receivable -> Inquireis -> Invoice Journals , [ Overview ,invoice amount field]
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Invoice Amount in Invoice journal form Vs Finanacial cost amount in Transaction Form
    Hi Mohamed,
     
    Are you referring to journal lines for an invoice journal or an inquiry form? Can you share the menu path, so we know exactly what form your question is referring to? 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans