Welcome, Guest. Please Login.
05/11/25 at 16:49:54
News:
Home Help Search Login


Pages: 1
Send Topic Print
Inventory Screen vs Inventory Transaction Report (Read 1102 times)
podell
Full Member
***


No act of kindess is
ever wasted.

Posts: 107
Gender: female
Inventory Screen vs Inventory Transaction Report
07/01/15 at 07:12:57
 
OK - the on hand inventory shown on the screen states 26 pieces(which is incorrect)....run the inventory transaction report - states quantity 8 pieces (correct count).  We had to void an invoice for 4 pieces which would bring the correct on hand inventory to 12 - the inventory screen still shows 26...We have run rebuild stock status report - what else can we do to correct.
 
thank you
 
 
 
 
DBA Version 2004.1 with IS Tech Support Update 2015.1
Pervasive PSQL 11.3
EVO Version 2015.1  Build 2/9/15
Back to top
 
 

Penny O'Dell, Office Manager
CEM Machine
Carthage, New York
Evo-ERP Update 2018.2 Pervasive v 11.30
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Inventory Screen vs Inventory Transaction Repo
Reply #1 - 07/02/15 at 15:09:45
 
What about IN-K? It will create a Inv Tran........
 
You can use T7JSQL.RWN to adjust the UOH with a  sql script
but there is a number of tables involved
 
MTICMSTR
BKICMSTR
 
Do you use location?  
Because you will have to change the quantities on BKICLOC as well.
 
Easier to contact isthechsupport
 
have fun....
Happy 4 of July,  
 
Tongue
 
Kelloggs
 
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
ddlong
Full Member
***




Posts: 205
Gender: female
Re: Inventory Screen vs Inventory Transaction Repo
Reply #2 - 07/07/15 at 07:28:36
 
When we have a mismatch between units on hand and inventory transaction balance, we run SMJ-C (Reconcile Inventory On-Hand) and choose whether to make UOH match current UOH or net units calculated from inventory transactions.  You do have to have other users out of DBA/EVO to run SMJ-C, but it can be run in report mode at any time.
 
Darla Long
Back to top
 
 

Darla Long
Catalytic Industrial Group, Inc.
Independence Ks
dba 2004.1 client/server EVO Version 2020.0 08/07/20 Build Pervasive 11.3
  IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: Inventory Screen vs Inventory Transaction Repo
Reply #3 - 07/09/15 at 14:00:31
 
Because EVO uses two different database files for inventory, they do get out of synch.  SMJ-C can be used to fix this most of the time.  The master level recon is similar to running Rebuild Stock Status, but does more.  The transaction level one only allows you change O/H to match transactions or transactions to match O/H.   This is nice if all your inventory mismatches are the same, but that's not always the case.  I usually run both in report only first and see what the programs want to do.  In the case of the transaction level, you can run it for one part.
In my case, there are few people who use EVO, so we don't get a lot of mismatches.
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Pages: 1
Send Topic Print