ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Inventory Files IN-A
http://www.istechforum.com/YaBB.pl?num=1165416856

Message started by hbacct on 12/06/06 at 06:54:16

Title: Inventory Files IN-A
Post by hbacct on 12/06/06 at 06:54:16

I am having problems with my inventory on some part numbers not all of them. Inventory received through PO's is not posting to inventory files IN-A or IN-E, also adjustments made in IN-C are also not posting to any of the inventory files. This is just happening on some part numbers not all of them. Is anyone having this problem?

Title: Re: Inventory Files IN-A
Post by RAGINE on 12/06/06 at 07:14:19

Check your conversion factors on the items, they may be set at 0.

Title: Re: Inventory Files IN-A
Post by hbacct on 12/11/06 at 05:57:16

This is not problem. Conversion is set to 1.

Title: Re: Inventory Files IN-A
Post by GasGiant on 12/11/06 at 06:03:10

What is the item Type? R, A, L, N?

Title: Re: Inventory Files IN-A
Post by hbacct on 12/11/06 at 09:54:34

On the items I have found so far, they are Type R and A

Title: Re: Inventory Files IN-A
Post by dameng on 12/11/06 at 20:42:17

i've had some strange reports of something similiar from my other customers, and like yourself, we can't find the culprit.

what version of EVO or DBA are you using?
what version of Pervasive?
do you have a single wharehouse inventory location or multiple locations?
are you recieving into inventory for these items? or QC and then buying off?
is the PO being modified after someone did a partial reciept?
do other transactions for today show up in IN-E?

thanks

Title: Re: Inventory Files IN-A
Post by hbacct on 12/12/06 at 06:10:55

We are using DBA Version 2002.4 update 11-4-03
Pervasive SQL2000
We use a single warehouse location
We are receiving these items into inventory
I don't know if the PO was modified
Some tranactions show up in IN-E and some don't, I don't see any single thing that is being done differently

Title: Re: Inventory Files IN-A
Post by hbacct on 12/26/06 at 09:43:01

We are still having problems with inventory. We are now getting an error message when we do adjustments. BTRIEVE ERROR-F:\DBAMFG\DEFAULT\INVTXN.B-2

Title: Re: Inventory Files IN-A
Post by Lynn_Pantic on 12/29/06 at 17:50:01

Error 2 means you need to back up the INVTXN file and then reindex it at UT-C.

Title: Re: Inventory Files IN-A
Post by hbacct on 02/02/07 at 07:04:36

I did a back up of the INVTXN file and then did a reindex at UT-C and I got a error message - An error occured while attempting to rename the original file.

Title: Re: Inventory Files IN-A
Post by JNAPIER on 02/02/07 at 08:19:04

hbacct wrote:

I did a back up of the INVTXN file and then did a reindex at UT-C and I got a error message - An error occured while attempting to rename the original file.

Be certain that that file is not still open with pervasive monitor on the server. You can use pervasive to rebuild that file also.

John

Title: Re: Inventory Files IN-A
Post by Laura Oliver on 06/22/15 at 14:52:27

How do you know if a file is open with Pervasive Monitor?
Thanks
Laura

Title: Re: Inventory Files IN-A
Post by David Waldmann on 06/23/15 at 05:28:11

Microkernal > Active Files

Note that you have to either by on the server, or log into the server from the Monitor if on a remote workstation.

Title: Re: Inventory Files IN-A
Post by Kelloggs on 06/24/15 at 13:37:14

David Waldmann wrote:

Note that you have to either by on the server, or log into the server from the Monitor if on a remote workstation.

You can login from any workstation.
Options > Connect

Server Name: YOUR_DBA_SERVER
User Name: YOUR_DOMAIN\Administrator
Password: YOUR_ADMINISTRATOR_PASSWORD

You are in.....

:P

Kelloggs

Title: Re: Inventory Files IN-A
Post by David Waldmann on 06/24/15 at 14:02:27

Yes, that's what I meant.

Title: Re: Inventory Files IN-A
Post by Laura Oliver on 06/25/15 at 06:06:08

Thanks!
Blessings