ISTech Support Forum - Min Ord Qty

tcook Member Posts: 71 Gender:	Min Ord Qty 02/16/07 at 05:51:59 I am writing a report and need the Min Ord Qty field. Does anyone know what the field name is? Also, I need the usage, preferrably last year's usage.
Back to top	Tara Cook APA, Inc. EVO-ERP2005.1(40 users) w/IS Tech update 12/21/08 Windows 2003 Pervasive V9.0 IP Logged

kkmfg Senior Member Ghost of the code Posts: 375 Gender:	Re: Min Ord Qty Reply #1 - 02/16/07 at 06:36:56 You might want to checkout http://www.istechsupport.com/dl/dbafile.zip It's a list of the fields in all of the tables along with descriptions of many fields. I think that the info you are looking for could be found in bkicmstr This sort of question would be a great addition to the wiki I think. I'll be sure that happens.
Back to top	Collin K & K Manufacturing, Inc EvoERP Version 1-22-10 SP3 5 User Workgroup Pervasive 10 IP Logged

tcook Member Posts: 71 Gender:	Re: Min Ord Qty Reply #2 - 02/16/07 at 07:42:43 Unfortunately, I have checked this spreadsheet, but I still do not see where the Min Ord Qty is, nor the month by month usage is.
Back to top	Tara Cook APA, Inc. EVO-ERP2005.1(40 users) w/IS Tech update 12/21/08 Windows 2003 Pervasive V9.0 IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male

Re: Min Ord Qty
Reply #3 - 02/16/07 at 08:20:26

The table is BKICMSTR, the field is BKIC_PROD_RAMT (Reorder Amount).

I thought the monthly usage was calculated each time you looked at that screen. In my Crystal reports, if the items only appear on invoices (not issued to WO), then I use the BKARHIVL table to calculate qty shipped. If the Items are also issued to WO's, I use the INVTXN table to calculate usage.

Back to top

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

tcook Member Posts: 71 Gender:	Re: Min Ord Qty Reply #4 - 02/20/07 at 13:33:09 Thanks for the Min Order Level field! On the usage, there are fields in MTICMSTR that show YTD, MTD, Last year info, but when I look at Maintain Database, our data shows all zero's. Do I need to calculate? How do I access this info?
Back to top	Tara Cook APA, Inc. EVO-ERP2005.1(40 users) w/IS Tech update 12/21/08 Windows 2003 Pervasive V9.0 IP Logged

Tim Keating Senior Member DBA CLASSIC WIN 2000 C/S Posts: 298	Re: Min Ord Qty Reply #5 - 02/21/07 at 11:40:40 As far as I know, the usage fields are not supported in DBA. You need to calculate from transaction files.
Back to top	Tim Keating Motor Guard Corporation IP Logged

tcook Member Posts: 71 Gender:	Re: Min Ord Qty Reply #6 - 02/21/07 at 14:13:17 I'm still new to Crystal Reports. Can anyone help with a formula to calculate annual or monthly usage for Type R parts?
Back to top	Tara Cook APA, Inc. EVO-ERP2005.1(40 users) w/IS Tech update 12/21/08 Windows 2003 Pervasive V9.0 IP Logged

Tim Keating Senior Member DBA CLASSIC WIN 2000 C/S Posts: 298	Re: Min Ord Qty Reply #7 - 02/21/07 at 15:15:17 Tara: The INVTXN File is the best place to get transactional data on parts. MTIT_TYPE Field contains transaction code per the following: MTIT_DATA is Transaction Date MTIT_CODE is Part Number Link to BKICMSTR File to pick up part description and type, etc... and you're off to the races.
Back to top	Tim Keating Motor Guard Corporation IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male

Re: Min Ord Qty
Reply #8 - 02/23/07 at 08:17:58

If you want to take into account adjustments, it is a little more involved.

When you adjust items out of inventory, the adjustement ('A' type) record is a negative quantity. Issued ('I' type) to WO and shipped ('S' type) records are positive quantities. You have to negate 'A' type records to have a correct usage quantity.

Here is a simple sample of a YTD calculation that includes 'A' transactions.
http://spectronics.com/dba/sample_YTD_usage.zip
(simple, not pretty report) Roll Eyes

Back to top

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: Min Ord Qty Reply #9 - 02/23/07 at 12:09:25 Cool, another one to post on the Wiki
Back to top	IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 634 Gender:	Re: Min Ord Qty Reply #10 - 02/23/07 at 13:33:53 I am Wiki impared I would if someone would give me some guidance.
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

dameng

Senior Member

DBA / EVO Software
Consultant

Posts: 275
Gender: male

Re: Min Ord Qty
Reply #11 - 06/26/07 at 22:42:24

i use a Stored Procedure for my Crystal Report for Inventory Usage. basically it sums the qty by transaction type on the INVTXN file for (J,I,M,S) types grouped by Item Code for the past 12 months.

here is a segment of the SP, becuase i also return other values useful for that type of report. i have it linked with the BKICMSTR and MTICMSTR
SELECT
SUM(IV.MTIT_QTY)
FROM INVTXN IV
WHERE IV.MTIT_TYPE IN ('J','I','M','S') AND (IV.MTIT_DATE > CURDATE() - 365)
AND (IV.MTIT_CODE = IC.BKIC_PROD_CODE)
GROUP BY IV.MTIT_CODE

the Usage Report that one views in IN-A is calculated everytime you clik on that Usage button using the similiar logic.

hth

Back to top

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net

IP Logged