ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> Updating QOH before reviewing odbc data
http://www.istechforum.com/YaBB.pl?num=1069180141

Message started by Mike_Vader on 11/18/03 at 10:29:01

Title: Updating QOH before reviewing odbc data
Post by Mike_Vader on 11/18/03 at 10:29:01

Just a quick question that probably has a simple answer... I am wondering if there is a utility I need to run before reviewing my ODBC data. I notice that when I print a report I've created from linked tables that the information does not jive for new POs I've created,for example. When I later go into that item in Item Inquiry (IN-A) the information updates and then the right details will occur on the report , but for that item only.

Question: do I need to go into every item in IN-A before reviewing the report? Do I need to wait a set amount of time for an update? or is there a simple utility?

Thanks,

Mike

Title: Re: Updating QOH before reviewing odbc data
Post by aricon on 11/18/03 at 10:32:12

Re-build the stock status fields before you use the ODBC data.

Title: Re: Updating QOH before reviewing odbc data
Post by Mike_Vader on 11/18/03 at 10:38:46

I know there is a flag to rebuild on some of the screens, such as the work order, but is there a specific utility to rebuild the stock status?

Title: Re: Updating QOH before reviewing odbc data
Post by kevind on 11/18/03 at 12:12:04

Mike,
Exactly which fields are you using that don't seem to be updated? ??? The QOH is one that is NOT changed by Rebuilding the stock status fields. :(

When I do any reports that need current ON SO info or any of those other fields, I link to the appropriate subsidiary file. In the case of ON SO, that would be BKARINVL.

I know this makes the report take longer, but with the proper SQL request, (along with use of SQL Functions in Crystal) the Server will do all the processing resulting in live and current data. ( in most cases, I am supprised how fast these requests execute! ) :D

Title: Re: Updating QOH before reviewing odbc data
Post by aricon on 11/18/03 at 16:05:41

Sorry, I should have been more specific. Reconcile Inventory On-Hand will update all of your UOH based upon the type of reconcilliation you choose in that utility.

Title: Re: Updating QOH before reviewing odbc data
Post by Mike_Vader on 11/20/03 at 14:32:14

That looks like it should do it. Thanks Lorne.

Title: Re: Updating QOH before reviewing odbc data
Post by aricon on 11/20/03 at 15:38:06

S'alright.... ;D