ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> RTM Reports & Editing >> Help on editing RTM's
http://www.istechforum.com/YaBB.pl?num=1233689205

Message started by lizod1 on 02/03/09 at 12:26:45

Title: Help on editing RTM's
Post by lizod1 on 02/03/09 at 12:26:45

Hi
Where can I get help on editing and changing RTM's? I want to customize the labels created from PO-C by creating a new label with fields of data specific to our needs. When I call on the About Help I get a message that I do not have the ISTS\TP7DOCS.HLP file. I'm not sure why. Can someone tell me how I get the data fields into the report? I'm familiar with Crystal Reports. I just did the 12/15/08 update with the 1/16/09 patches.
Liz

Title: Re: Help on editing RTM's
Post by tgoodson on 02/10/09 at 10:26:19

I am looking for help also. I need to edit the T6BMB1.RTM form. Specifically I would like to change the QTY REQD field to eliminate the decimal places in the components fields. We do not use decimals in our qtys. Anyone have any ideas? I just do not want to mess up any other forms that may use the same data field.

Thanks

Title: Re: Help on editing RTM's
Post by EMI Ann on 02/27/09 at 08:17:31

If none of your items are ever sold, returned, etc. in quantities that are anything other than whole numbers, your fix is not in the RTM's. Go to SM-SD-M, and set "Decimalized quantities on forms" to "N."

Title: Re: Help on editing RTM's
Post by EMI Ann on 02/27/09 at 09:02:26

tgoodson wrote:

I think I misunderstood your initial question. When you are printing BOM's in I-BM-B, you can tell it to print "0" decimal places. Is that what you are looking for?

Title: Re: Help on editing RTM's
Post by tgoodson on 03/03/09 at 06:57:43

That was it! Thank you! I looked but couldn't seemt o find it. I appreciate your help.

Title: Re: Help on editing RTM's
Post by rdparent on 05/04/09 at 04:40:44

I'm also having trouble with report editor. I've added a note to the middle of form T6SOB4.rtm saying who to remit payment to. For some reason it looks fine in the preview, but when we print the actual form it puts it on there twice. Any ideas?

Title: Re: Help on editing RTM's
Post by GRMFG on 06/08/09 at 09:07:17

Interesting issue that I would like to chat about.

I've created about 25 custom reports (mostly in work center schedules) for Microsoft Access, normally all the information that we like to have on a work center schedule is not included in the standard reports in SH-I.

I would like to add the part weight to the shop traveler T6WOC1.RTM. but the MTICMSTR table is not part of the query that generates the report. anybody have any input as to how I can overcome this? I can create yet another Access report but it would be great not to have to.

Title: Re: Help on editing RTM's
Post by NovaZyg on 06/08/09 at 09:24:31

Mticmstr is open and sitting on the part # in the header section, and On BOM components when in the BOM section.

;)

Title: Re: Help on editing RTM's
Post by cathyh on 06/08/09 at 09:50:50

I also have quite a few Access reports for various modules, but not too many for workorders. However my RTM Traveler that we use is very modified! If I can modify an RTM to have the information that I want I much prefer it, as it is easier on the users.

I did successfully add the weight to the traveler.
To do this, in the traveler you are trying to modify, add a "DB TEXT" field for the data and a "LABEL" field for the data label. Over on the left hand side, in the properties section, double click on the datafield under Data. Using the Data Files arrow, scroll to MTICMSTR, and choose MTIC.PROD.WT.

Figuring out what fields are available in a RTM is a great challenge, one I have already complained about.
Usually I just plow ahead and add a field to the RTM that I want and see if it works.
Sometimes you can look at the fields already there and see some that are in the data file you are looking for. In this case I see some fields in the traveler header that begin with MTIC (Drawing, Rev) so I assume that the MTICMSTR table is available.

Hope this helps you.

Title: Re: Help on editing RTM's
Post by GRMFG on 06/08/09 at 11:16:37

Thanks! that just the information I was looking for. my travelers now have a part weight.

hopefully I can return the favor one day!

Title: Re: Help on editing RTM's
Post by GRMFG on 06/08/09 at 12:46:10

ok, I'm struggling again, the RTM editor for DBA reports is a little different then for Evo. and I'll need both for a while, still weening folks off of DBA.

if I edit the BKWOC1.rtm file with the Evo report editor. the format of the report is totally shot, even if I only rename the file it becomes unusable in DBA.

any help as to accessing the tables with the old editor? I can get a DBtext box up just cant get to the MTICMSTR table.

or can I use the Evo editor and fix the formatting for a DBA report?

Title: Re: Help on editing RTM's
Post by cathyh on 06/08/09 at 14:34:24

If you are using DBA classic, you cannot add fields to the RTM. Since you are editing T6 versions in Evo, not BK versions, and using BK versions in Classic, the added field does not show in Classic. Best to move everyone to Evo.

VERY Important -- Make sure that you always save the report while on the main page tab. If you go to a subreport tab, and save while on that tab, the whole report is hosed.

Title: Re: Help on editing RTM's
Post by Lynn_Pantic on 06/08/09 at 18:58:45

Cathy is correct and to add to her post, while you can open the DBA Classic RTMs with the Evo editor, DON'T save them. They are not THAT compatible.

Title: Re: Help on editing RTM's
Post by Mark Daley on 09/18/20 at 12:10:28

Nothing I love more than necro-ing an 11 year old thread...

I am learning most of my RTM editing through trial and error. We are on EVO 2020.1, just in case that's relevant. I read here that the data field drop-down menu will show you what tables and fields are available. Mine doesn't do that. My drop-down is empty. I've just been searching existing reports to find relevant field names and hoping they're part of the query. This has been mostly successful, but now I'm trying to add something that I'm pretty sure wasn't intended to be used in reports.

We have been using the Notes (and Alerts) functionality more and more to trigger actions on orders, but we'd also like to include any notes from a certain category on our pick lists. I've created a view that collects this data, but I don't have the first idea how to incorporate this information into the report. I'm concerned I may not have the requisite tools available to complete this task. Can anyone provide any information on either of these scenarios? It would definitely be helpful to be able to see the tables related to a report when I open it in the editor. Thanks in advance for your help!

Title: Re: Help on editing RTM's
Post by Lynn_Pantic on 09/19/20 at 10:21:39

Notes can only be printed if there is a Notes subreport on the RTM (which we have to add, not something you can do with the RTM Editor) and if the "Use Evo Notes System?" default is turned on at SD-A. If an RTM has Note subreport(s) and Evo Notes are turned on the RTM name will begin with EN rather than T6. The Pick List does not have a Notes subreport at this time.

Title: Re: Help on editing RTM's
Post by Laura Oliver on 10/02/20 at 13:40:06

When I try use reports editor /forms editor on EVO. I can not call up the rtms. I can't type in the field of call anything up. Nothing!
I logged in under admin. I remember one time Lynn said i had old rtms and needed to copy from rtx. Maybe that has something to do with it.
I have been cheating and edit EVO rtms in DBA;s form editor.

Thanks
Laura

Title: Re: Help on editing RTM's
Post by Lynn_Pantic on 10/03/20 at 08:54:35

You can't edit Evo RTMs in the DBA editor, it will mess them up. In Evo, after the editor opens, click File - Open RTM and select the one you want to edit.

Title: Re: Help on editing RTM's
Post by Laura Oliver on 10/05/20 at 06:08:05

I don't think my editor ever opens. Or at least I never see a list of rtm to select from. F2 produces nothing. There is no magnifying glass. I can mouse click in the field but when i type it does not show in the field.
see https://flic.kr/p/2jPHwPR
Thanks
Laura

p.s Since 2015 I have probably copied and edited 30 evo rtms in the DBA forms editor with no problems. It has been working for us. But I want to do it in the EVO RTM editor.

Title: Re: Help on editing RTM's
Post by Lynn_Pantic on 10/05/20 at 06:37:24

You may be able to edit Evo RTMs in the DBA Editor but it is very limited in what it can do compared to the Evo editor. You certainly can't edit DBA RTMs in the Evo editor. As I said in the previous post, after the Evo editor opens to the first screen, click File - Open RTM to get to the browser to select the one you want to edit.

Title: Re: Help on editing RTM's
Post by Laura Oliver on 10/05/20 at 07:29:21

Duh.... For some reason I didnt see File on that screen the first 100 times i tried it. SORRY!

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Looking for Report builder Help.
I have logged into several of my workstations and they show errors when clicking on the Help file in report builder such as:
Can not open the file M:\tp71help.chm
Can not open the file\\XXServer\dbamfg\tp71help.chm

What do I do to stop getting these errors and actually see HELP.

Thanks
Laura

I read where I can find help from Digital Metaphors Report builder http://www.digital-metaphors.com/ as it it the same as TASPremier 7i Help in 7i Addsum Tas Premier (7i{C:\ISTS\}-
tag: report editor form rtms rtm

Title: Re: Help on editing RTM's
Post by Laura Oliver on 08/23/21 at 15:07:50

Every time i go into report editor I have to look for " file". It is in the far top left corner. I think it is odd to click on the word FILE so high in the left top corner. Especially when there is what looks like a box to be typed in.

So I had my two young helpers go in and try to figure it out and neither of them could. When I told then to click on FILE they thought it was a little clunky too.

I dont know of anywhere else in DBA or EVO this happens. I just find it a little clunky.