ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> New Utility to Correct Transactions
http://www.istechforum.com/YaBB.pl?num=1256821574

Message started by Vman on 10/29/09 at 06:06:14

Title: New Utility to Correct Transactions
Post by Vman on 10/29/09 at 06:06:14

A utility that would compare WO issues, PO receipts, and SO shipments(after invoicing) to the transactions to see if the proper transactions were created. The utility would have a report-only mode, and would have filters for WO, PO, SO and part number ranges.
I had an issue with a circuit board yesterday, where I thought that O/H quanity was wrong (it wasn't, 4 were being conformally coated). I was looking at transactions and noticed that a WO for three of the boards was not showing up. I checked the WO and it was closed, and showed 3 being made. I know that SM-J-C can make a transaction that would balance the O/H with transactions, but this would sort of a brute-force approach.
As a minimum this utility would insure that transactions, based on what had been done in the system were made, which would clear up some of the out of synch inventory file issues, as well as helping to idenitfy where things went wrong.

Title: Re: New Utility to Correct Transactions
Post by Lynn_Pantic on 10/29/09 at 08:03:42

Assuming you are on the September 2009 update, we just wrote a utility to compare Work Order Receipt records (as seen in JC-Q) with type "W" Inventory transactions (as seen in IN-E or the Transactions button in IN-A) and create any missing "W" Inventory transactions. Download from www.istechsupport.com/dl/worecvfx.zip and unzip to DBAMFG and UT-A, program WOROCVFX. Enter a start date for how far back you want to go and click process. It will create the transaction records and present a report of what it did. It will not change on hand quantity - you can use SM-J-C Transaction level method B to reset on-hand to match transactions if needed.

Title: Re: New Utility to Correct Transactions
Post by RPCAdmin on 10/29/09 at 08:40:11

Lynn - tried running the utility - set the date to 06/01/09, click on process and the system seems to lock up (at least at that workstation) - it is looking at WORECV but it doesn't start counting any of the 13000 or so records.

Title: Re: New Utility to Correct Transactions
Post by Kelloggs on 10/29/09 at 09:00:38

I tried also, it seems to lock up

By the way what other "undocumented" utilities are out there?

Search for F:\DBAMFG\*X.RUN and there are lots

:P

Kelloggs

Title: Re: New Utility to Correct Transactions
Post by RPCAdmin on 10/29/09 at 09:12:12

We let it run, and eventually, it did finish - but the lack of feedback was a bit worrying. OH well.

Title: Re: New Utility to Correct Transactions
Post by Vman on 10/29/09 at 10:11:17

Of course, if you run this utility after you have run SM-J-C (transactional) in the past, then the transactions and UOH can be out of synch, as SM-J-C can create a transaction to balance the files. Not being able to put a range on the items or WO is problematic, especially if your archived WO's and consolidated transactions aren't in the same date range

Title: Re: New Utility to Correct Transactions
Post by Lynn_Pantic on 10/29/09 at 17:44:16

Actually the utility does look at the WO Archive file as well as the active Work Order file.

Title: Re: New Utility to Correct Transactions
Post by Vman on 10/30/09 at 07:27:11

Fine, but here's the underlying thing. It seems that the inventory files get out of wack very easily- too easily. When they do, you have to decide what data is right and what is not. In some instances, the transactions are correct, but the inventory location and master files are off. Other times, its the opposite. To have to investigate each SM-J-C correction to really see what is out of whack is very time-consuming. I was thinking that being able to make sure that transactions were all there would help simplify things.
What would be even better would be for the files to say in sync, but I think that's a Bitreive thing.