ISTech Support Forum - SO Line Item Notes

BethanyW Browser Posts: 46	SO Line Item Notes 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.
Back to top	Bethany Waldmann Vermont Hardwoods Chester, VT Evo-Erp 2013.1, 5 user IST Update: 7/26/13 SP1 Pervasive 11 Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1 Crystal Reports v11 IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: SO Line Item Notes Reply #1 - 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%' Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

BethanyW Browser Posts: 46	Re: SO Line Item Notes Reply #2 - 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...
Back to top	Bethany Waldmann Vermont Hardwoods Chester, VT Evo-Erp 2013.1, 5 user IST Update: 7/26/13 SP1 Pervasive 11 Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1 Crystal Reports v11 IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: SO Line Item Notes Reply #3 - 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
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

BethanyW

Browser

Posts: 46

Re: SO Line Item Notes
Reply #4 - 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.

Back to top

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: SO Line Item Notes Reply #5 - 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
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

BethanyW Browser Posts: 46	Re: SO Line Item Notes Reply #6 - 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.
Back to top	Bethany Waldmann Vermont Hardwoods Chester, VT Evo-Erp 2013.1, 5 user IST Update: 7/26/13 SP1 Pervasive 11 Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1 Crystal Reports v11 IP Logged

BethanyW

Browser

Posts: 46

Re: SO Line Item Notes
Reply #7 - 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

Back to top

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: SO Line Item Notes
Reply #8 - 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....

Tongue

Kelloggs

Back to top

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

BethanyW

Browser

Posts: 46

Re: SO Line Item Notes
Reply #9 - 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?

Back to top

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: SO Line Item Notes Reply #10 - 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
Back to top	« Last Edit: 07/09/13 at 14:43:43 by Kelloggs » Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: SO Line Item Notes Reply #11 - 07/09/13 at 14:51:43 Use BKAR_INVL_SCCOG Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

BethanyW Browser Posts: 46	Re: SO Line Item Notes Reply #12 - 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.
Back to top	Bethany Waldmann Vermont Hardwoods Chester, VT Evo-Erp 2013.1, 5 user IST Update: 7/26/13 SP1 Pervasive 11 Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1 Crystal Reports v11 IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: SO Line Item Notes Reply #13 - 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.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: SO Line Item Notes Reply #14 - 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). Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged