Microsoft Dynamics NAV

Home » Microsoft Dynamics NAV » Microsoft Dynamics NAV Forum » All Tags » sql

Browse by Tags

Tags
Related Posts

  • Forum Post: The [Lead Time Calculation] field within the "Item" database table

    Nathan Lykken
    I have a calculated field in Microsoft Dynamics NAV that I need to display via a website for lead time for Parts in one of our databases. This particular field is the [Lead Time Calculation] field within our "Item" database table. In Navision, this field displays as a number followed by either...
    on 20 Oct 2010

  • Forum Post: migration to SQL server - czech, russian and latvian companies in one DB

    Martin Bokuvka
    Hello. Our customer needs to migrate from native to SQL server. There is one problem - multiple codepages in database. Customer has companies in czech, russian, latvian, polish, slovak and hungarian language. czech, slovak, polish and magyar are no problem, but russian azbuka and latvian letters are...
    on 22 Mar 2012

  • Forum Post: SQL-Error 15138 by Adding a NAV-User

    Frank Zettelmeyer
    The following error occures by adding a Window-user in Dynamics NAV. 15138, "42000" The database principal owns a schema object in the database and can not be deleted . SQL: {CALL [sp_revokedbaccess](?)} Last weekend we executed all server-updates! Thank you Frank
    on 20 Mar 2012

  • Forum Post: SQL for last date where inventory was counted for an item

    Martin Andersen
    I need the date where an item was last counted in inventory. I can see the field inside dynamics on the "item card"'s "inventory" tab. I've found the table "Item Journal Line" to contain information about inventory counts but the information doesn't completely...
    on 20 Feb 2013