Welcome, Guest. Please Login.
05/03/25 at 01:12:36
News:
Home Help Search Login


1  Evo-ERP and DBA Classic / Manufacturing / DBA Classic inventory transactions
 on: 12/16/24 at 14:58:33 
Started by uds38 | Post by uds38
We just ran Consolidate Inventory Transactions for one part number.  We have never used that utility before.  Now when we try to print transactions for that part we only get the consolidated listing so we have lost the detail transactions list for that part number.  Is there a way we can rebuild the transactions for that part so we can again access the full transaction history listing for that part?
Reply Quote Notify of replies  

2  Evo-ERP and DBA Classic / Sales / Restrictions on using SLSP2 field in DBA?
 on: 10/24/24 at 05:36:41 
Started by JeffH | Post by JeffH
We have recently started using the SLSP fields in DBA to try to track mapping Sales to salespersons....not for automatic commissions as we handle that elsewhere but just for simple reporting. One thing that was recently experienced was that under SO-A the SLSP1 field works under DBA & EVO but the SLSP2 only works in EVO. You cannot tab/select the field so that you can select a secondary salesperson.
Any ideas on why?
 
If it matters our standard CS-A setup is just
Salesperson Number XX
Class E
Vendor Code <blank>
First name JOHN
Last name DOE
Rate 0.000%
How Gross Sales
When Invoice posting
SLSP GL <blank>
 
Thanks for any assistance in advance
Reply Quote Notify of replies  

3  Evo-ERP and DBA Classic / Manufacturing / Re: PO-I-F
 on: 10/10/24 at 12:33:26 
Started by jo | Post by Laura  D. Oliver
For future reference. (historical reference)
I had a PO stuck in PO-I-F.  It appeared that I needed ap-c. and then pick and pay the invoice this, but it had already been innvoiced in AP-C and paid. The PO was closed,So PO-K did nothing.  BKAPHPO had the PO closed.
 
Here is what i did to fix it.
BKAPHPOL > BKAP.POL.Invnum was blank so I typed in 3333 as a fake invoice number just to fill the blank.  It worked.  
 
tag: vendor invoice shows up in PO-I-F but it has been paid.
Reply Quote Notify of replies  

4  Evo-ERP and DBA Classic / Items / Re: DE-S Import Image Links
 on: 09/09/24 at 10:49:32 
Started by Missy Burke | Post by JeffH
Lynn responded with the answer...
for anyone else it is "TAS-E in Evo.  Enter the file name and extension and the rest of the fields will populate."
Reply Quote Notify of replies  

5  Evo-ERP and DBA Classic / Items / Re: DE-S Import Images part 2
 on: 09/09/24 at 10:49:11 
Started by JeffH | Post by JeffH
Lynn responded with the answer...
for anyone else it is "TAS-E in Evo.  Enter the file name and extension and the rest of the fields will populate."
Reply Quote Notify of replies  

6  Evo-ERP and DBA Classic / Suggestions for Updates / mouse click in un-editable field box
 on: 09/05/24 at 12:09:45 
Started by Laura  D. Oliver | Post by Laura  D. Oliver
I am training a new helper and realize there are some clunkly things that i normally just defaulted thru. For example in AR-C customer payments you can put your mouse in fields (boxes) that are not editable. I can put my mouse in customer name, telephone #,  last payment etc.  This is confusing to my new helper.  I normally just use the enter button and return and return, But my new helper is a mouse person and she doesnt know where to put her mouse next.   This has never occured to me.  And I see these uneditable fields boxes  are in other modules also.  
 
Is there anyway these uneditable fields can be fixed so that you cant choose them with your mouse?
Thanks
Laura
 
 mouse click in un-editable field box
Santa Christmas Wish List
Reply Quote Notify of replies  

7  Evo-ERP and DBA Classic / Items / DE-S Import Images part 2
 on: 09/05/24 at 06:57:22 
Started by JeffH | Post by JeffH
Trying to tag on to a separate post but I am not sure how people find/stumble across new replies so I am posting at the top level (sorry if breaking the rules)
In the other post I saw a reference to "initialize the BKQTTEMP file" to clear it out and start over with the DE-S process to update the item image links.
My issue is that I cannot find any reference in the documentation how to "initialize" a specific file?  
Any help is appreciated
Reply Quote Notify of replies  

8  Evo-ERP and DBA Classic / Items / Re: DE-S Import Image Links
 on: 08/29/24 at 09:01:26 
Started by Missy Burke | Post by JeffH
More replies to myself... I was able to get DE-S to work(upload all the multiple lines) using Evo instead of DBA....had to the find the program/menu for the program and add it to my ID.  
 
Now back to my original questions
1) how to "initialize the BKQTTEMP file to delete all links and start over with a new import."  
2) any other concerns or gotcha's that I need to look out for - want to ensure there is not a way for me to initialize/delete a critical file
 
 
 
Reply Quote Notify of replies  

9  Evo-ERP and DBA Classic / Items / Re: DE-S Import Image Links
 on: 08/29/24 at 07:44:07 
Started by Missy Burke | Post by JeffH
Additional question now that I am playing with DE-S... when I run the pgm it will upload the information correctly for only the first line item...anything else is ignored...any help is appreciated
 
Example contents of CSV
,503370,Files\503370y.pdf,Y,1
,503370,Files\503370n.pdf,Y,2
 
output
08/29/24                                      
09:41:53                                      Imported Item Links Report
                                                                                                           Page #     1
 
  Item            Link                                                                    Action
--------------------------------------------------------------------------------
----------------------------------------
 503370           Files\503370y.pdf                                                       Imported
Reply Quote Notify of replies  

10  Evo-ERP and DBA Classic / Items / Re: DE-S Import Image Links
 on: 08/28/24 at 05:49:27 
Started by Missy Burke | Post by JeffH
First let me say thanks for whoever created this and all the people that contributed to it over the years. The fact that I am reading through posts from almost 20 years ago (that still apply) is a testament to the application as well as the current support! I have only been working with DBA for a couple of years and most of my knowledge is gleaned from this site ...so I am extremely apprehensive about doing anything that might break the app or cause a loss of data. That being said, we recently move our image files from one drive to another and now I need to update the links in all the Item references.  
I used this query in the SQL Editor to obtain a list of all the items that contained links
SELECT BKQTTEMP.BK_DESC_CODE, BKQTTEMP.BK_DESC_DESC, BKQTTEMP.BK_DESC_LINE,  
      BKQTTEMP.BK_DESC_NOTES, BKQTTEMP.BK_DESC_NUM
FROM   BKQTTEMP
Through this log, I found the DE-S option in DBA (but not EVO) and was able to test updating one of our entries successfully. My questions now are
1) how to "initialize the BKQTTEMP file to delete all links and start over with a new import."  
2) any other concerns or gotcha's that I need to look out for
Thanks in advance for any help from the newbie
Reply Quote Notify of replies