We extract similar data from the GL and load into an OLAP tool. Our process extracts on a YTD basis, clears the OLAP data and reloads nightly. This eliminates issues with unresolved events being posted days later and also JE's posted into prior periods. The volume of data is a consideration when extracting and loading in this manner but in our case this is not an issue.
-----Original Message-----
From: bpcs-l-bounces+christopherwynn=abmauri.us@xxxxxxxxxxxx [mailto:bpcs-l-bounces+christopherwynn=abmauri.us@xxxxxxxxxxxx] On Behalf Of Rajesh Kamath
Sent: Thursday, December 03, 2009 5:42 AM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Data flow through Night job
Dear All,
Below mentioned is the scenario and can anyone suggest how to do this. (BPCS
Ver-6.02)
Scenario: BPCS DATA transfer to web based application on daily
basis through night JOB.
Data Source: Query developed to get the GL transaction from GHH,
GLH & GCR files.
Concern & Pain Area: Above mentioned query fetches only posted
transaction and only the new transaction should post to web based
application in night job. Pain area is event get generated first and will
not get posted due to some error and status will be either "unresolved" or
"Error". These events, user will manually correct it and posts at his own
convenience. But, the transaction will get posted in to GL based on posting
date.
Illustration:
1st day ie. 01.04.09 to 01.04.09 - 2 transaction. For Example Event No:1 &
3.
2nd day ie. 01.04.09 to 02.04.09 - 5 Transaction out of this only three
are new transaction. (New Event No:2,4 & 5)
Even though the "From" date is fixed and the "To" date is present date
system should throw only new transaction in to the Web based application.
Thanks/Regards,
Rajesh Kamath
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/bpcs-l.
Delivered-To: christopherwynn@xxxxxxxxxx
midrange.com
