ISTech Support Forum - RMA Module 9/21/07 Update

Theran Member I'm not a browser, I'm a low end Bronze member... Posts: 70 Gender:	RMA Module 9/21/07 Update 09/25/07 at 15:08:37 I get the following error message when I try to open RM-A An error has occurred while trying to open file - DEFAULT\ISRMAC.B - 12 Press okay An error has occurred while trying to open file - DEFAULT\ISRMAI.B - 12 Press okay Module opens. Closes without any errors.
Back to top	Teres Heran Armature Coil Equipment, Inc DBA Classic, Ver 2004.1 with IS Tech 9/21/07 IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: RMA Module 9/21/07 Update Reply #1 - 09/25/07 at 15:10:26 Error 12 is File not Found. Since these are new files that the update should have created, go to UT-A (in Classic), make sure you are in the Default (B) company and run program NEWINIT. This will create the empty files.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Theran

Member

I'm not a browser,
I'm a low end Bronze
member...

Posts: 70
Gender: female

Re: RMA Module 9/21/07 Update
Reply #2 - 09/26/07 at 17:53:25

Running NEWINIT caused me to get a warning error on every file in the data base

"An error has occurred while creating file AS\BKABCUST.BAS - 11"
click OK
next error...........................................................................
..................
and so on all the way down the list of files.
I pressed OK too many times to record here.

A better suggestion would have been to run DBAIF on the two files mentioned in my previous posting.

Back to top

Teres Heran
Armature Coil Equipment, Inc
DBA Classic, Ver 2004.1 with IS Tech 9/21/07

IP Logged

kkmfg

Senior Member

Ghost of the code

Posts: 375
Gender: male

Re: RMA Module 9/21/07 Update
Reply #3 - 09/27/07 at 06:15:36

Quote from Theran on 09/26/07 at 17:53:25:

Running NEWINIT caused me to get a warning error on every file in the data base

"An error has occurred while creating file AS\BKABCUST.BAS - 11"
click OK
next error...........................................................................
..................
and so on all the way down the list of files.
I pressed OK too many times to record here.

A better suggestion would have been to run DBAIF on the two files mentioned in my previous posting.

Yup... Same thing happens to me when I run newinit. Apparently some update of theirs caused a lot of bogus company records. DBAIF really is the best bet.

Back to top

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10

IP Logged

GasGiant

Administrator

How can I help?

Posts: 1517
Gender: male

Re: RMA Module 9/21/07 Update
Reply #4 - 10/03/07 at 13:04:07

So, we're happily using the new RMA module. Seems to be doing fine so far with serial numbers, etc. But we noticed something that does not work the way we would expect.

When entering the RMA it asks for the original invoice number. However, when dispositioning items to return to stock, the line items pull their prices from the Base price, not from the invoiced price. It doesn't even ask for the price when dispositioning, it just makes the return-to-stock SO with the system base price. This means that we have to do the extra step of opening the SO and changing the prices. I can hardly wait to see what it does for replacement SOs. Is it possible that it makes out the replacement SO at $0.00, as it should, or does that pull the base price, too?

Or maybe I'm doing something wrong. I don't see any SD-Q settings for this.

Back to top

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: RMA Module 9/21/07 Update Reply #5 - 10/03/07 at 19:11:33 Already observed & sent to programming - if you can link to the original invoice then it should pull in the original price and COGS for the return.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: RMA Module 9/21/07 Update Reply #6 - 10/04/07 at 05:06:33 How about the notes? Shouldn't they pull into the SO or SR?
Back to top	IP Logged

JCL Browser Posts: 36 Gender:	Re: RMA Module 9/21/07 Update Reply #7 - 10/04/07 at 07:41:19 My RM menu is shaded, I can't even click on it! What am I missing?
Back to top	IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: RMA Module 9/21/07 Update Reply #8 - 10/04/07 at 18:13:05 Any time an update with new programs or modules is installed, you need to go to the password security and enable the new options. In DBA Classic, they will be greyed out until you go to PS-B and turn them on. In Evo-ERP, they will only be available on the ADMIN menu until you use TAS-G and add them to other user menus.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: RMA Module 9/21/07 Update Reply #9 - 10/10/07 at 06:44:56 Any chance of getting a quick run down of the tables that are used to store RMA info? At least... Header Lines Notes and are there any "gotcha" differences or do they follow BKARINV, etc. exactly? I'm going to start writing to these tables from my web app.
Back to top	IP Logged

JEMM Administrator In two days from now, tomorrow will be yesterday. Posts: 225 Gender:	Re: RMA Module 9/21/07 Update Reply #10 - 10/10/07 at 08:16:29 RMA uses the same Header, Lines and Notes files as SR. ISSRINV, ISSRINVL and ISSRDESC respectively. RMA also uses ISRMAI for the RMA info, which is tied to ISSRINVL lines, and ISRMAC for the RMA Reason Codes.
Back to top	Mike ISTechSupport IP Logged

GasGiant

Administrator

How can I help?

Posts: 1517
Gender: male

Re: RMA Module 9/21/07 Update
Reply #11 - 10/10/07 at 08:25:53

Minimal data will be entered at the time of the call. Looks like, for ISRMAI, I can write "In transit" in the status block, leave reason blank and then just copy in the line info for RMA #, part #, line ID and RMA date.

Will that be enough to create a valid RMA?

Another quick question... what makes a header show up in one or the other module? Just the status? Then how come "C" is a valid status in each, but in the table "C" only shows up for RMAs?

Back to top

IP Logged

JEMM Administrator In two days from now, tomorrow will be yesterday. Posts: 225 Gender:	Re: RMA Module 9/21/07 Update Reply #12 - 10/10/07 at 21:02:13 The SR is actually using 'Y' for closed SR but SR-A converts to an on-screen 'C'. As for the data, it appears to be enough information in the RMAI file.
Back to top	Mike ISTechSupport IP Logged

GasGiant

Administrator

How can I help?

Posts: 1517
Gender: male

Re: RMA Module 9/21/07 Update
Reply #13 - 10/12/07 at 10:32:51

So, after writing the whole thing and working around the undocumented differences (for instance, BKARINV, et al Sales Order numbers are numbers, but ISSRINV et al want an alpha data type), now I can't write to the ISRMAI table because it is new and not in our ODBC DDFs. Running the ODBCDDF.run throws an error and says to call IS Tech. I suppose that it might have something to do with the fact that three other programs have open ODBC connections, eh?

Not complaining, just reporting on my progress. I'll try it again after hours with all of the ODBC connections removed.

Back to top

IP Logged

kevind

Active Member

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

Posts: 634
Gender: male

Re: RMA Module 9/21/07 Update
Reply #14 - 10/12/07 at 13:09:28

Colin,
You are right ... You can't write to the .DDF files if there are ODBC connections open.

I also wanted to mention to you that if you have added views or security to the ODBC data source, running
ODBCDDF will remove all of them.

I keep my views and security stuff in a SQL script so that if I refresh my .DDF files, I can re-enable all the
other stuff that makes all my ODBC stuff work.

Just an FYI!!

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