2 topics: INV310 Query / Query data clarity problems

     First:  Thorough response to Mike's INV310 Query question
Second:  Data clarity headaches in Query400 reports
                caused by vanilla BPCS problems


~~~ First Topic ~~~~~
    Mike -- for the cycle count worksheet by warehouse, the
    sequence number comes from the Item Master field ITSEQ and is
    stored in the Location Inventory (ILI) file in the LTSEQ field. If the
    LTSEQ already has a sequence number it means it is already open
    for a cycle count and the item will therefore print on an error report.

    For the cycle count worksheet by item, if the warehouse
    being processed is a managed warehouse, the sequence number
    will come from the Pallet Inventory (IPI) file field PISEQ.

    Take care on the column heading that appears for the PISEQ
    field. Vanilla BPCS produces the column heading that appears
    on the left below; the correct column heading is on the right.

                 Next                            Palt          (pallet)
                  Pay                             Loc      (location)
                 Line                             Seq     (sequence)


~~~ Second Topic ~~~~
    PISEQ is one of many thousands of column headings that are
    incorrect in vanilla BPCS v6/v8. Furthermore, about 25% of the
    field edit codes and edit words are wrong. The consequences? Unless
    you instruct Query400 how to overcome these errors every time you
    design a report, BPCS data will be misrepresented on reports.

    Here's a Bells & Whistles® for BPCS product designed to
    clarify the presentation of BPCS data:  Decipher (tm)
        http://www.unbeatenpathintl.com/decipher/source/1.html

    Clearly presented data is appluaded by Sarbanes-Oxley auditors.
    If your company is looking for other clever SOX compliance
    ideas, check our  "Stocking Stuffers for SOX" page:
        http://www.unbeatenpathintl.com/SOXstuffers/source/1.html

Warm regards and God bless,

Milt Habeck
Unbeaten Path International

North America toll free: (888) 874-8008
International calls:  (262) 681-3151
mhabeck@xxxxxxxxxx
www.unbeatenpathintl.com



++++++++    ++++++++    ++++++++    ++++++++    ++++++

----- Original Message ----- 
From: Moy, Bill
To: bpcs-l@xxxxxxxxxxxx
Sent: Monday, March 08, 2004 9:56 AM
Subject: RE: INV310 Query question.

We are on 6102, LTSEQ in ILI


++++++++    ++++++++    ++++++++    ++++++++    ++++++

From: Higgins, Shaun
Sent: Friday, March 05, 2004 2:52 PM
To: bpcs-l@xxxxxxxxxxxx'
Subject: INV310 Query question.

My facilities are asking me to build them a query to pull out information
similar to that of an INV310 for doing their cycle counts. I do not need it
broken down by intermediate class, I just need one big list I can sort by
warehouse. All I need to pull out is the Seq#, warehouse, item #,
description and the UOM. Where I am getting snagged up is the sequence
number. How are these generated and in what files to they reside in ?

Mike