Open Forum

Expand all | Collapse all

C/AL function error

  • 1.  C/AL function error

    SILVER CONTRIBUTOR
    Posted 29 days ago
    Hello,

    I am in the middle of placing a sales order, but I see this error below, Can someone please advise on how to fix it in NAV client.. Thank you.

    .



    ------------------------------
    Archana Kulla
    Business Systems Analyst
    American Labelmark Company (Labelmaster)
    Chicago IL
    ------------------------------


  • 2.  RE: C/AL function error

    TOP CONTRIBUTOR
    Posted 29 days ago
    ​This looks like a programming error, do you have any custom code or add-ons maybe?

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



  • 3.  RE: C/AL function error

    SILVER CONTRIBUTOR
    Posted 29 days ago
    Hi Sam.

    I do not work with the code but my NAV partner does.

    Yes, we have around 12-13 add-ons to NAV.

    ------------------------------
    Archana Kulla
    Business Systems Analyst
    American Labelmark Company (Labelmaster)
    Chicago IL
    ------------------------------



  • 4.  RE: C/AL function error

    TOP CONTRIBUTOR
    Posted 29 days ago
    You will almost certainly have to get a developer to look at this. It's what I call "the big ugly error". In short, it means the system is trying to ask you for a response while it has tables locked. It can't just sit there with tables locked all day (if you had left your computer for example). That would keep everyone else from working. It could be all kinds of things causing the issue as it is a system generated error. It would just be a guessing game without debugging the issue.

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------



  • 5.  RE: C/AL function error

    SILVER CONTRIBUTOR
    Posted 29 days ago
    Looking at your screenshot, your Unit of Measure is Kit so I suspect may be an Assembly Item (Assemble-to-Order).  We have this issue on NAV 2013 R2 if any one of the components' availability will not satisfy the Due Date. If so, then to check, find out what the components are for that Item and try adding them to the order directly, using the same Planned Shipment Date. One or more of them should bring up NAV's standard Availability Warning window.  It will be sufficient then to at least raise a Purchase Order to bring that component in to the Location in time for the demand or, if components are already on order you may be able to just push back the Planned Shipment Date to later.

    My investigations have found that this is a bug; NAV is calculating that the availability will not be sufficient but has a problem opening the Availability Warning window for some reason and it's at that point that it triggers the C/AL error.


    ------------------------------
    Paul Simpson
    Business Analyst
    Vado
    Cheddar
    ------------------------------



  • 6.  RE: C/AL function error

    TOP CONTRIBUTOR
    Posted 25 days ago
    this is because of a customization, dev. error.
    look in the page "sales order subform" and table "sales line". there in trigger no.-onvalidate. a custom code contains maybe something like codeunit.run(...
    a developer from your nav partner should check that.
    tell them they should test a little bit more before publishing the code into the prod. db.

    ------------------------------
    Franz Kalchmair
    Microsoft MVP
    Senior Consultant
    Austria, Europe
    ------------------------------



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