Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Qty in invoice journal differs from qty in free text invoice

(3) ShareShare
ReportReport
Posted on by 92
Hello
 
When I create and post free text invoice and put whatever qty other then 1, later in invoice journal I get qty = 1.
Why that happens? I assume because of some setup but do you know which one?
I tried debugging (every class that has a reference to that field) to see where it gets updated but what I only saw is that it gets correct qty on inserting into CustInvoiceTrans table, I cant find out where it gets updated since update method is not called anywhere (for that field). So maybe it gets updated somewhere by calling update_recordset or something like that.
 
Do you have some idea how can I debug it?
 
Thanks in advance
Categories:
  • devgirlX Profile Picture
    devgirlX 92 on at
    Qty in invoice journal differs from qty in free text invoice
    I was debugging the issue and couldn't find where it gets updated to 1. 
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    Qty in invoice journal differs from qty in free text invoice
    Hi,
    Can you reproduce this issue in standard environments? If not, I recommend involving a developer to debug the issue. The quantity on CustInvoiceTrans should match the quantity on CustInvoiceLines, so a closer investigation might be necessary to identify the root cause.
  • devgirlX Profile Picture
    devgirlX 92 on at
    Qty in invoice journal differs from qty in free text invoice
    This is qty on free text invoice line
     
     
    And this is then on Invoice journal line (CustInvoiceTrans).
     
     
     
    It gets 1 by default. It is not like that in all environments. So I assume then that it is something with the setup.
     
    Any advice how to find the cause?
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,074 Super User 2025 Season 1 on at
    Qty in invoice journal differs from qty in free text invoice
    Hi devgirlX,
     
    Can you confirm if you entered a quantity on the free text invoice lines and now you added the quantity field on he Invoice journal form from the table Customer invoice journal (CustINvoiceJour)? 

    If so, this is not the correct quantity field. The line quantities are not summed in the invoice journal. The quantity is copied to the individual CustInvoiceTrans table records.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans