|
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.
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
