Returns Order Description Fields

Business Central/NAV User Forum
1

Hi All

I’m pretty new to NAV and am using a very old version (Ver 5.0). My question is:

We have a user who has added several lines of text to a Return Order, this has been processed and a Sales Credit memo produced. However I now cannot find this text that was added to the Return Order. I’m searching the back-end tables using SQL.

Any suggestions as to where I can find this text would be appreciated.

Thanks

Steve

2

Hi Steve,

Not quite sure I understand the question. You have a return order, with text lines (and regular lines I assume?). Now you have posted it and produced a posted sales credit memo. But the text lines are gone when you use SQL to search for them?

Question 1: Exactly how did you use SQL to search for them? Which table did you search? When NAV posts a RO, then just as when posting a SO, then if complete all it’s lines in table 37 (sales line table) are removed.

Question 2: Are the “regular lines” still there?

Question 3: Why did you use SQL to search for it? Why not just running the table in the object/table designer?

PS: I’ve moved your question from the generic Dynamics 365 group/forum into the Business Central/NAV user group.

3

Thanks for your response, to answer your questions.

  1. I looked in Sales Cr_Memo Line (I thought this was logical)

  2. Yes the regular (transaction) lines are still there

  3. I used SQL because I’m very new to NAV, but I do understand SQL.

So your statement in 1. regarding a posted SO suggests that only the Transaction lines are retained when a SO or RO are posted (these appear to be line type 2 in the Sales Cr_Memo Line table). However I do have other credit memo lines, created at the same time, that have also retained line types ‘Zero’ & 1, that look like text lines. I just confused why this appears to have not happened for the credit memo in question.

Thanks