NAV 2016 Sales order is giving me an error message when trying to invoice it.

Bifa1Bifa1 Posts: 9Member
When i try to invoice the last portion of partially shipped (shipped in more than two phases) sales orders in NAV 2016 ,it is giving me "Amount must be posetive in Gen. Journal line....." error, which i attached the screen shot here with.

Any idea what is causing this problem, i need help ASAP.

imbgdbxdetwb.png

Answers

  • lubostlubost Posts: 492Member
    Wahat is your Qty. to Invoice value?
  • Bifa1Bifa1 Posts: 9Member
    nfkfcu3l878k.png

    as you can see from the above screen shot, order quantity is 2000 we shipped this quantity in to phases with two separate sales shipments each with a quantity of 1000, totally we shipped all the ordered quantity 2000 pieces.

    However, when we try to invoice the order after the second shipment, it gives us the error message i mentioned before , we guessed the issue could be a rounding problem caused by hidden after point decimal numbers so as a temporary solution we deducted 1 piece from the second shipment of 1000 and give it in the quantity to invoice field 1999 and when we try to invoice it invoiced the 1999 with out and issue but still we are left with 1 piece outstanding in the quantity to invoice field.

    Any solution please?
  • krikikriki Posts: 8,581Member, Moderator
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
  • Bifa1Bifa1 Posts: 9Member
    e5uqs91eti7i.png

    To make it more clear ,the above is the screen shot of the debugging i made. the underlined line is where the validation error is happening. When i hover in to the line the pop up comment shows the Amount field has a value of -0.01, even if i have no idea what it means and where it gets its value from.

    6040wmpq0rtk.png
  • krikikriki Posts: 8,581Member, Moderator
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
  • lubostlubost Posts: 492Member
    I think that negative amount comes from rounding:
    Sales invoice must be rounded according to Amount rounding precision in G/L setting. System wants to post 48.70 and tries to post -0.01 to set the overall amount to 48.69 (48.6965 rounded down).
    Check function CheckDocType in CU11 - what document type comes to post
  • Bifa1Bifa1 Posts: 9Member
    b21tacqegk6b.png

    faw0obya0uaa.png

    As you can see from the above screen shot the document type comes to the function is "Invoice".

    Below the screen shot is the general ledger setup

    b39c6y17n9k5.png
  • Bifa1Bifa1 Posts: 9Member
    Dear All,

    When i change the inv. Rounding precision(LCY) to 0.1 instead on 0.01, my invoice posted fine. Even if , i couldn't understand the logic behind, what matters the most is my invoice is posting.
Sign In or Register to comment.