D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Sales Line Invoiced but not showing as invoiced

  • 1.  Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted Apr 03, 2018 04:27 PM
    Hello everyone.  We are on AX 2012 RTM.

    We have a Sales Order that had one line for a qty of 10 pcs.
    We shipped and invoiced 3 out of 10 pcs.
    The item number changed - so we added a new line with the new item number for a qty of 7 pcs, then changed the original line from 10 pcs to 3 pcs.

    The original line is now not showing as invoiced for the 3 pieces which were shipped against it.  The line shows open for 3 pieces.  The invoice is in the Invoice journal on the Sales Order.  How can we get the line to show as invoiced again so this Sales Order can be reflected properly.

    Thank you,
    Lori

    ------------------------------
    Lori Holmes
    Bridgewater, NJ
    LHOLMES@hamamatsu.com
    ------------------------------


  • 2.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted Apr 04, 2018 02:47 PM
    Edited by Rudy Salcedo Apr 04, 2018 02:53 PM
    ​We're on AX 2012 R2, and sometimes an SO line will get invoiced and for some reason will get stuck at Open or Delivered status.  We haven't found a way to change the line to Invoiced via any AX UIs, so when this happens, the user gives us the SO# and SO line# and tells us the line needs to be flipped from Open/Delivered to Invoiced.  Then we run a SQL statement in SQL Server Management Studio like the following:

    UPDATE SALESLINE
    SET SALESSTATUS = 3    -- 3=Invoiced
    WHERE SALESID = '12345678SO'
    AND LINENUM = 1.00000

    ​Maybe this will work for AX 2012 RTM too.



    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



  • 3.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted Apr 06, 2018 10:48 AM
    Rudy, thank you.  We may need to go this route - this will help.

    Lori

    ------------------------------
    Lori Holmes
    IT Operations Manager
    (responsible for Business Applications)
    Hamamatsu Corporation
    Bridgewater, NJ
    LHOLMES@hamamatsu.com
    732-537-3619
    ------------------------------



  • 4.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted Apr 09, 2018 01:33 AM
    ​If your order is not invoiced, first check all your lines...

    Top reason in my experience will be a line sitting in open status that still has a deliver remainder for some reason.

    However, there can be many reasons....We'll need particulars on the line...

    The order status is simply a rollup of the lines - so if all your lines are invoiced and your order is not, I would highly suspect a poorly written mod is the problem...

    ------------------------------
    Tony Zeigler
    Strategic Solutions NW, LLC
    Beaverton OR
    ------------------------------



  • 5.  RE: Sales Line Invoiced but not showing as invoiced

    Posted Apr 06, 2018 10:57 AM

    Rudy,

    SalesLine.LineNum and PurchLine.LineNum ARE NOT UNIQUE within an order.

    Given a large enough order and enough edits, you will find duplicated line numbers.  Depending on whether the user uses a down arrow or control-n to add lines, they can create line 1.0, then 0.5, 0.25, 0.12, 0.06, 0.03, 0.02, 0.01, 0.01, 0.01, etc.  It's rare, but it will happen sooner or later.

    You should be keying off LotID (InventTransID) as it is kept unique for the table by index.

    Never use LineNum in a where clause: been there, got burned, still have the scars 8^)




    ------------------------------
    Andrew Ford
    Lead AX Developer
    Nivel Parts & Manufacturing Co., LLC
    Jacksonville FL
    ------------------------------



  • 6.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted Apr 06, 2018 02:29 PM
    ​Thanks Andrew, now that you mention it, we actually HAVE seen duplicate line numbers on a sales order 2 or 3 times already.  I'm not sure if we've seen it on POs yet, but good to know that it's a possibility.  So we'll take your advice and will run the update statement based on the InventTransID of the line instead of the line number.  Thanks!

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



  • 7.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted Apr 10, 2018 10:00 AM
    ​Rudy...we were able to fix our issue based on your post - thank you!!!

    ------------------------------
    Lori Holmes
    IT Operations Manager
    (responsible for Business Applications)
    Hamamatsu Corporation
    Bridgewater, NJ
    LHOLMES@hamamatsu.com
    732-537-3619
    ------------------------------



  • 8.  RE: Sales Line Invoiced but not showing as invoiced

    Posted Apr 11, 2018 11:57 AM

    I've seen same problem and find that using the Cancel Deliver remainder fixes the orphaned invent trans record. Suggest trying this first.

    Also, I would suggest using an AOT job when manipulating records to ensure that AX logic is employed. Deleting an InventTrans record in SQL will not flow the corrected values in InventSum, for example.  



    ------------------------------
    Mark Prouty
    Programmer / Analyst
    ANGI Energy Systems
    Janesville WI
    ------------------------------



  • 9.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted Apr 23, 2018 12:05 PM
    Looks like a handful of us have seen this issue.  Anyone know of a related hotfix?

    ------------------------------
    Lori Holmes
    Bridgewater, NJ
    LHOLMES@hamamatsu.com
    732-537-3619
    ------------------------------



  • 10.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted May 25, 2018 05:12 AM
    Hello Lori,

    You can use the Delivery Reminder Option to Cancel the Qty (Sales Order --> General Action Tab --> Related Information --> Line Qty --> Update --> Delivery Reminder).

    When you cancel the Qty, the Remaining Qty will become Zero and based on the Qty Invoiced, the Status of Sales line will change.

    ------------------------------
    Nirav Modi
    Project Manager - Ax
    Indusa Infotech Services Pvt Ltd.
    Ahmedabad
    ------------------------------



  • 11.  RE: Sales Line Invoiced but not showing as invoiced

    TOP CONTRIBUTOR
    Posted May 29, 2018 09:38 AM
    ​Nirav...thanks for your reply.

    Best regards,
    Lori

    ------------------------------
    Lori Holmes
    Bridgewater, NJ
    LHOLMES@hamamatsu.com
    ------------------------------



  • 12.  RE: Sales Line Invoiced but not showing as invoiced

    Posted 11 days ago
    Edited by Laisa Beck 10 days ago
    I have an eCommerce store selling watersports, fishing, and outdoor gear products. What are the top shipping container companies in the USA?
    I'm giving 10% Off Everything + Free Shipping on Overtons coupons.
    ------------------------------
    Laisa Beck
    KRKC & CO
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role