Re: JBA ML - Consolidated Invoices SA Refresh

[Jeff_Klipa/Harvard@xxxxxxxxxxxxxx]

Gary, What version and Service Pack are you running...?
And are you using the Vanilla Invoicing Module from JBA or some variant...?
Thanks.







Gary.Brown@appliedchemicals.com on 01/14/2002 02:01:11 AM

Please respond to jbausers-l@midrange.com



  To:          JBAUSERS-L@midrange.com

  cc:          (bcc: Jeff Klipa/Harvard)



  Subject      JBA ML - Consolidated Invoices SA Refresh
  :









Our consolidated invoices sometimes have all blanks in DSEQ70 on OEP70 (I am
aware that they always have all blanks in DSEQ65 on OEP65), as a result we have
ended up with SAP20 records that have all blanks in DSEQ20.

When the Sales Analysis refresh program runs it does a chain on OEP20 (Sales
details file) using the customer number and delivery sequence number of SAP20,
this chain fails in the case of the blank DSEQ20 records and so the value from
the last successful chain are used instead resulting in incorrect values being
refreshed.

I have fixed this problem by SQLing DSEQ20 in SAP20 to have '000' if the value
was blanks. I have also modified the Sales Analysis update program (SA025) to
check if DSEQ70 is blanks and if it is put '000' into DSEQ20.



_______________________________________________
This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
To post a message email: JBAUSERS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
or email: JBAUSERS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/jbausers-l.