× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.






As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.