Do u have a Idea about Navision DB?

  • Am developing SOH report for ERP Navison for Retail company..

    Here I have written TSQL for sku,stock on hand,vendor,lot_no, sell price,

    but i need to find out the landed cost for every sku..

    If any one having experience on navision Db please help me,...

    I tried lot of table but i cant find that solution for fixing the landed cost for [Item no_]

  • Duplicate post, replies here please.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • Sorry Network problem unfortunately i made two times...

  • No worries, it happens. We just try to pick one before everything gets fragmented.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • Garadin (4/8/2010)


    Duplicate post, replies here please.

    Link not working for me.

  • Oops, had an extra HTTP in there. Fixed.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • lol the redirect thread has more posts than the thread we should reply to.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • I was thinking that as I was replying last time =). But it's screwy either way, because all the replies reference the whole not replying here thing, so if I switched it now and people read it, it'd be confusing.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply