Welcome, Guest. Please Login.
01/23/18 at 14:22:18
News:
Home Help Search Login


1  Evo-ERP and DBA Classic / RTM Reports & Editing / Re: Print a # of characters of a field.
 on: 01/17/18 at 08:37:41 
Started by AndyOB | Post by Lynn_Pantic
There is not a way the RTM editor can define a substring of a field.  That has to be defined within the program.  The Inventory User Defined fields defined in SM-P-E have field names UDFI1 through UDFI30 based on the UDF number but not every report has these fields defined.  Sales documents such as acknowledgements and invoices do but not every report.  If you need it in some other report email me and we can add it.
Reply Quote Notify of replies  

2  Evo-ERP and DBA Classic / RTM Reports & Editing / Print a # of characters of a field.
 on: 01/16/18 at 16:16:25 
Started by AndyOB | Post by AndyOB
Is there a way in a report to print part of a field. I'm printing out bits of our userdefined fields (MTIC.PROD.SUBST[2] or 3, 4, 5, etc) and some of the fields contain more than one data field. Is there a way to print for example characters 4-6 out of the 100 characters of the field?
 
I should also ask, is there documentation for the Report designer? I feel this question should be answered somewhere already.
 
Thanks much...
-A.
Reply Quote Notify of replies  

3  Evo-ERP and DBA Classic / General DBA Topics / Meltdown/Spectre Server Patches and Evo Work Load
 on: 01/09/18 at 07:18:53 
Started by gtladmin | Post by gtladmin
Anyone apply kernel and microcode Meltdown and Spectre patches and have any noticeable impact with Evo workloads?  If so, what is your environment and # of Evo users?
 
Supposedly there should be minimal performance impacts but the impact will be based on I/O workloads.
 
Just wondering, before I have to patch my servers next week.
 
Val
Reply Quote Notify of replies  

4  Evo-ERP and DBA Classic / Accounting / Re: Bank Reconcile
 on: 01/07/18 at 20:00:09 
Started by JereC | Post by AllanMac
Check the GL transactions through running a detailed trial balance of the account - some transactions may have gone through as GJ (general journal) rather than CD (Cash Disbursements) or CR (Cash Receipts)
Reply Quote Notify of replies  

5  Evo-ERP and DBA Classic / Accounting / Bank Reconcile
 on: 01/05/18 at 14:53:36 
Started by JereC | Post by JereC
I have a bank account that I need to reconcile for Dec. 2017.  Never had an issue but for December I get this message "There are no items to load for this bank account."  But there are items.  There is a balance and activity applied to the account. I have the date range as 12/31/17.  How did this happen and how do I fix this.
 
Thanks  
Reply Quote Notify of replies  

6  Evo-ERP and DBA Classic / Items / Re: IN-A Transactions do not add up to On-Hand qty
 on: 01/02/18 at 12:42:21 
Started by Prier Products | Post by btaylor
I'm pretty sure it is BKICMSTR but it has been a while since I have personally seen it.
Reply Quote Notify of replies  

7  Evo-ERP and DBA Classic / Items / Re: IN-A Transactions do not add up to On-Hand qty
 on: 12/29/17 at 08:45:18 
Started by Prier Products | Post by Lynn_Pantic
What specific file is the record lock on?
Reply Quote Notify of replies  

8  Evo-ERP and DBA Classic / Items / Re: IN-A Transactions do not add up to On-Hand qty
 on: 12/28/17 at 08:59:17 
Started by Prier Products | Post by btaylor
Quote from GasGiant on 06/30/11 at 13:48:15:
One thing that happens to us (too often) is people killing a process in the middle of a WO-I transaction. We use Lot or Serial numbers on nearly every finished good. If the user tries to run WO-I and then  get's to the Lot/Serial entry section and does not have the information, we have had issue with people using CTRL-ALT-DELETE and ending the task. At that point in the process the UOH has been updated with the full quantity entered as completed, but the transaction has not been posted. We have trained our users, over and over, never to end task in the middle of a transaction, but it keeps happening.

If you have duplicate entries in MTICMSTR then you need to use Maintain Database to remove the superfluous entry. The system cannot tell which one is erroneous.

 
Resurrecting an old thread as this is still haunting me. After years of trying to figure it out we eventually did find a repeatable issue. If we go to produce a work order and someone else has that item open in another screen we get a message that the record is locked by another user with the option to cancel or retry. Even if we hit cancel, it adds the amount the work order is for to the master level but not the transaction level. If we try again later and still get the record locked error, cancelling will again add that amount to master but not transaction.
 
I have to run SM-J-C often on items which is time consuming. My predecessor once accidentally ran it on everything which created a bunch of other issues so I like to only run it on single items (unless I'm only doing report mode).
 
I end up in here for hours on a Saturday or firing it up in the evening and walking away, having someone close it out when they get in in the morning.
 
Anyone know if there is a way to fix it through maintain database or is it touching so many tables that doing this would make things worse?
 
Even if it would stop creating the master level quantity when we get the message and cancel out would solve a lot of the problems.
Reply Quote Notify of replies  

9  Evo-ERP and DBA Classic / Suggestions for Updates / Re: Increase Font Size on Printed Forms
 on: 12/21/17 at 11:00:10 
Started by JeffF | Post by prophet
Make sure when you make the changes you are back in the main tab before you save it.
Reply Quote Notify of replies  

10  Evo-ERP and DBA Classic / Suggestions for Updates / Re: Increase Font Size on Printed Forms
 on: 12/21/17 at 10:47:11 
Started by JeffF | Post by JeffF
Quote from Lynn_Pantic on 12/20/17 at 16:09:18:
Yes, in both DBA Classic and Evo you can use the RTM editor to make those changes yourself.

 
I have been using the RTM Editor and making the changes, however every time I make the change and run the program, it will not print. I get an error. Is there a trick to making the changes execute properly.
Reply Quote Notify of replies