ISTech Support Forum - MRP Planner Codes

Welcome, Guest. Please Login.

	11/01/24 at 09:24:47 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Suggestions for Updates

‹ Previous topic | Next topic ›

Pages: 1 2

MRP Planner Codes (Read 1521 times)

sharon krewson

Ex Member

MRP Planner Codes
04/21/04 at 06:36:19

Our Material Manager would like to add Planner Codes to our inventory components and link it to the MRP function. The planner code would then be used as a sorting parameter in the Order Action Report and Material Requirements Report.

Is this possible? If not, is there another field that can be used? We are already using category. The planner code would allow our purchasing department to sort even further.

Thanks for your help!
Sharon

IP Logged

Tim Keating Senior Member DBA CLASSIC WIN 2000 C/S Posts: 298	Re: MRP Planner Codes Reply #1 - 04/21/04 at 07:57:12 There is a 'User Defined Sort Field' in IN-B if you aren't using it already. The data is held in the MTICMSTR File MTIC_PROC_SUBST[1] Field.
Back to top	Tim Keating Motor Guard Corporation IP Logged

sharon krewson

Ex Member

Re: MRP Planner Codes
Reply #2 - 04/21/04 at 09:48:39

We are using the User defined sort field already. Also, this field is not available as a sort parameter when running the Order Action Report or Material Requirements report.

We basically would like to assign parts to a buyer. In our case, we may have more than one buyer working within a category.

We don't use many of the fields in Inventory such as weight and foot factor. We thought about using one of those fields but we still can't pick it as a sort field in MRP.

IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: MRP Planner Codes Reply #3 - 04/21/04 at 10:19:56 Have you considered using a custom report in Access or Crystal or some such that would allow the flexability to use whatever YOU wanted/needed?
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

Tim Keating

Senior Member

DBA CLASSIC WIN 2000
C/S

Posts: 298

Re: MRP Planner Codes
Reply #4 - 04/21/04 at 10:24:59

Sounds like a worthwhile request to me. In the meantime, it could be accomplished through customization, or through Access or Crystal if you have in-house capability or a consultant.

One out-of-the-box thought; assuming your Buyers correlate to Vendors, could you add a suffix to the vendor code for sorting? Vendor #23556 would become Vendor#1-23556 and would be handled by Buyer #1?

Tim Keating
Motor Guard Corporation

IP Logged

Tim Keating Senior Member DBA CLASSIC WIN 2000 C/S Posts: 298	Re: MRP Planner Codes Reply #5 - 04/21/04 at 10:26:08 Sorry, didn't see Lorne's post til mine went up.
Back to top	Tim Keating Motor Guard Corporation IP Logged

sharon krewson

Ex Member

Re: MRP Planner Codes
Reply #6 - 04/21/04 at 10:52:17

Thanks for your input. We already use Crystal Reports quite a bit. But, we were hoping to stay within the DBA/EVO module. If there is an add on program out there then we would definitely be interested in looking at it.

If Lynn can't incorporate this into the MRP then I will start working on a Crystal Report.

Lynn (programming Goddess kiss

) - What is your 2 cents before I start working on Crystal?

IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5681

Re: MRP Planner Codes
Reply #7 - 04/21/04 at 16:32:07

Anything is possible, it is simply a matter of priorities. There are some database fields in the inventory tables that are currently unused and could store the Planner - how many characters do you want? And what reports do you want it to be available in? I would think MR-G, H, J, K and IN-D could all potentially be filtered by planner so each planner could get a report of only their items. Maybe PO-I-A as well.

How much interest is there in something like this? Anybody else interested?

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

Karen Mason Active Member Ain't life grand!?! Posts: 728 Gender:	Re: MRP Planner Codes Reply #8 - 04/22/04 at 05:09:57 I can see a future need for planner codes. At a minimum, 2 digits, alpha-numeric, would offer a large number of planner codes. It's too early in the morning to calculate how many.
Back to top	Karen Mason, Vice President Bula Forge & Machine, Inc. 1-60# forgings, machining, & assembly Cleveland, OH Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com EVO-ERP 09/16/09 SP2 IP Logged

sharon krewson Ex Member	Re: MRP Planner Codes Reply #9 - 04/22/04 at 05:44:40 I'm glad to see there is interest out there. 2 or 3 digits would work for us.
Back to top	IP Logged

Tim Keating Senior Member DBA CLASSIC WIN 2000 C/S Posts: 298	Re: MRP Planner Codes Reply #10 - 04/22/04 at 07:42:42 Me too.
Back to top	Tim Keating Motor Guard Corporation IP Logged

tcook Member Posts: 71 Gender:	Re: MRP Planner Codes Reply #11 - 04/23/04 at 04:46:06 We definately have an interest in this. 4 digits would be good for us.
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

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: MRP Planner Codes Reply #12 - 08/28/04 at 05:51:40 Finally got this one into programming - should see it in the next update.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

sharon krewson Ex Member	Re: MRP Planner Codes Reply #13 - 09/01/04 at 08:29:18 Very cool. Thanks, Lynn!! So.... when is the next update?
Back to top	IP Logged

elizabeth Browser I love YaBB 1G - SP1! Posts: 2	Re: MRP Planner Codes Reply #14 - 01/21/05 at 12:00:09 We are a new subscriber to IS Tech as of 12/14. Where can we update the Planner Code?
Back to top	IP Logged

Pages: 1 2

ISTech Support Forum › Evo-ERP and DBA Classic › Suggestions for Updates

‹ Previous topic | Next topic ›