ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> SO Line Item Notes
http://www.istechforum.com/YaBB.pl?num=1373383939

Message started by BethanyW on 07/09/13 at 08:32:19

Title: SO Line Item Notes
Post by BethanyW on 07/09/13 at 08:32:19

How are these stored in ISNOTES? We've been analyzing the entries we have, but there doesn't seem to be any consistent pattern for matching the note ID to a line item. We're working on our own Crystal version of Pick Tickets.

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/09/13 at 10:32:52

Bethany,

If you are talking about parts (SKU)

SELECT * FROM ISNOTES
WHERE LEFT(IS_NOTE_ID,5) = 'BKICM'
AND IS_NOTE_ID LIKE '%my_part_id%'

:P

Kelloggs

Title: Re: SO Line Item Notes
Post by BethanyW on 07/09/13 at 10:44:07

Thanks Kelloggs, but I'm looking for notes on the SO line, not notes for the item on the SO line. That's slightly confusing, but I can't figure out a better way to say it...

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/09/13 at 10:48:45

Bethany,

I must be missing something here.....

There is not such a thing as "Line Notes" there is only SO Notes.

Lines have descriptions.....

:-[

Kelloggs

Title: Re: SO Line Item Notes
Post by BethanyW on 07/09/13 at 11:07:17

Perhaps you haven't noticed it because it's kind of a pain to enter them since you can't do it while you're creating the line. After you create it, when you go back into the line from the list screen there is a Notes button (and a Links button) in the bottom left (at the same level as the list, add line, insert line, delete line, and copy line buttons at the bottom right). But it's ONLY visible when you first enter the line and the active field is Ref.

When printing via SO-B or SO-C, the note types to print are controlled by the SO Lines section in the Evo Notes Selection dialog that pops up.

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/09/13 at 11:22:47

Bethany,

You are right, sorry about that

:)

let me do some testing

Kelloggs

PD: In MS Access it is very easy to isolate the SO ID and the Line ID with the MID function.
Unfortunately I don't use crystal reports.
I just posted a question on the pervasive forum to see if there is an equivalent

Title: Re: SO Line Item Notes
Post by BethanyW on 07/09/13 at 11:43:21

Thanks Kelloggs,
The IDs for the SO line notes look something like this: BKARINVL<SO number>-0.00<some number>

The <some number> sometimes seems to correlate to the Ref (BKARINVL.UM_LN_1), but only if the Ref is a number and even then only occasionally. We haven't seen any sort of pattern when Ref isn't a number.

Title: Re: SO Line Item Notes
Post by BethanyW on 07/09/13 at 12:21:17

Thanks Kelloggs, but we're good with separating the ID into its separate parts. The problem is that we don't know how to select all the ISNOTE record(s) corresponding to a specific BKARINVL record since there doesn't appear to be any obvious correlation between the tables. Here are a couple examples:

########################
BKARINVL87674-0.0033 <- this is for line with Ref 13 and Line No 51

BKARINVL87685-0.0035 <- Ref K (one of many), Line No 20. Interestingly, this is the 3rd "component" line for Ref 5

BKARINVL87096-0.0002 <- Ref 2, Line No 1
BKARINVL87096-0.0007 <- Ref 4, Line No 9
BKARINVL87096-0.0012 <- non-existent in SO

BKARINVL86619-0.0003 <- Ref 3, Line No 5
BKARINVL86619-0.0008 <- Ref 8, Line No 15

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/09/13 at 12:22:57

Bethany,

This sql will isolate the SO and SO LINE.
As I said I don't use crystal, so I don't know how join it with the SO tables

Quote:

SELECT
*
FROM ISNOTES
WHERE LEFT(IS_NOTE_ID,8) = 'BKARINVL'
AND
CONVERT (SUBSTRING (RTRIM(IS_NOTE_ID), 10, 5), SQL_DOUBLE) = 12345
AND
(CONVERT (SUBSTRING (RTRIM(IS_NOTE_ID), 16, 6), SQL_DOUBLE)* 10000) = 1

this should do....

:P

Kelloggs

Title: Re: SO Line Item Notes
Post by BethanyW on 07/09/13 at 12:42:47

Unfortunately that doesn't work because the decimal after the dash IS NOT the line number. It's not a Crystal question, it's a database question.

Here's what we're trying to do: We have some line items, and we need to get the notes that are attached to them. Given a specific line item, how do we get the note(s) that correspond(s) to it? For example, say the line item has Ref 5 and is on line number 8. From our research, there's no obvious way to tell what the "suffix" of the note id will be - it could be .0005, or .0009, or .0026 or who knows what. Do you know how to figure out what the last part of the note id will be based on the line item?

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/09/13 at 12:45:14

Bethany,

I think you are looking at fields: BKAR_INVL_UM_LN_1 and BKAR_INVL_UM_LN_2
Don't use them. They are fill in by the user, you can enter anything there 1, A, 10, Null

Use the BKAR_INVL_CNTR and what ISTECH does is divide it by 10,000.

:)

Kelloggs

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/09/13 at 14:51:43

Use BKAR_INVL_SCCOG

:P

Kelloggs

Title: Re: SO Line Item Notes
Post by BethanyW on 07/10/13 at 05:21:28

Thanks so much! I've looked at that field before but never realized it had anything in it since it's automatically rounded to 2 places when I put it in the report - once expanded I see that it matches!!! Thanks again.

Title: Re: SO Line Item Notes
Post by Lynn_Pantic on 07/10/13 at 07:49:32

The BKAR_INVL_SCCOG is a ""behind the scenes" unique line identifier that is used as the link to notes, work orders and anything else. It will never change even if lines are inserted. The BKAR_INVL_CNTR on the other hand controls the order in which lines print so it will change if lines are inserted.

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/16/13 at 13:06:16

We are testing the line notes. There are two things that we don't like

While on the Sales Order Window (per example), you can not see the line notes, and there is nothing to warn you if it has one.
One more window when printing a document (there are plenty of steps already).

:-X

Kelloggs

Title: Re: SO Line Item Notes
Post by Lynn_Pantic on 07/16/13 at 17:29:33

Line notes doesn't add a screen to the printing function. It is just another choice on the Notes screen, not another screen.

Title: Re: SO Line Item Notes
Post by Kelloggs on 07/17/13 at 07:32:40

screens, windows, options, choices, buttons, call them anything you want.

To many steps to print a document. And that, ladies and gentlemen, is the bottom line.

:)

Kelloggs