RE: JBA ML - Sales Analysis update -- SYSTEM21

Data is posted to Sales Analysis via pgm SA025 which uses the invoice date
(DTIN65) in OEP65 to determine which period to use.
6/SAU clears the records by period in Sales Analysis
4/SAU resets the invoice posted flag (ACTF70) in SAP70 by date

I wrote the program below, many years ago, to reset ACTF70 by period,
instead of from/to date, to coincide with 6/SAU while we were testing Sales
Analysis.  OEPO65L5 is keyed by CONO65, PERN65, and DTIN65.

Hope this helps.


 F*****************************************************************

 FOEP65L5 IF  E           K        DISK

 FINVLINESUF  E           K        DISK

 E*

 I           UDS

 I                                      970 9740PERD

 C*

 C*****************************************************************

 C*

 C           KL65      KLIST

 C                     KFLD           CONO

 C                     KFLD           PERD

 C*

 C* Key list for Sales Summary File SAP70.

 C* Key list for Sales Summary File SAP70.
 C*
 C           KL70      KLIST
 C                          KFLD           CONO
 C                          KFLD           INVN65
 C*
 C*****************************************************************
 C*  Read all INVOICES for this period/year
 C*
 C                          MOVE 'RX'      CONO    2
 C*
 C           KL65      SETLLOEP65L5
 C*
 C           *INLR     DOWEQ'0'
 C*
 C           KL65      READEOEP65L5                  LR
 C*
 C           *INLR     IFEQ *OFF
 C*
 C                          SETOF                     99
 C           KL70      SETLLINVLINES
 C*
 C           *IN99     DOWEQ'0'
 C*
 C           KL70      READEINVLINES                 99
 C*
 C           *IN99     IFEQ *OFF
 C                          MOVE *BLANK    ACTF70
 C                          UPDATOER70
 C                          END
 C                          END
 C*
 C                          END
 C                          END

Steve Prill
mailto:sprill@RexairInc.com



-----Original Message-----
From: DAhKow@ibl.intnet.mu [mailto:DAhKow@ibl.intnet.mu]
Sent: Thursday, November 08, 2001 7:04 AM
To: jbausers-l@midrange.com
Subject: JBA ML - Sales Analysis update



Hello everyone,
,
     we have a particular situation whereby we are implementing the
distribution & financials applications of system 21 for 1 particular
company. There is a backlog of 3 months invoices being input in SOP .
Would anyone know
1) how does the system determine to which period in Sales Analysis the SOP
transactions are being summarised to?
(on one side, in SOP,  we  have a) document date b) invoice date) c)
inventory period  and on the other side in SA we have a calendar)
2) We have already run a sales history update for that company and the
period updated is now what we expected. We would therefore like to delete
the SA records and re-run the update.
The questions therefore are:
a)Is SAP20 the only file in SS from which records for that company is to be
deleted?
b) Which flag in which SOP files (OEP65?, OEP70?) must be reset so that a
SA history update re-run will process these records again?

Note: on our system, there are many other companies which have been setup,
which are already on-line and are also happily using the Sales Analysis
application


Regards

_______________________________________________
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.