RE: Bookings reports

Hello Lloyd

On our system the bookings figure appears to be following the 'correct'
logic - I'd advise you to check with the Q&A website if you think the
calcualtion is being performed as described.

A few pointers to help you get round the problem:

1) Clarification on 'Order Book' terminology. If your company (i.e. bosses)
is anything like mine then you need to be specific in stating the various
ways to present 'Customer Order Value' information. Some of these ways
include:

a) Order Intake: The value of those Customer Orders taken in a particular
time bucket. This is the report you have requested in your question.

b) Open Order Book value: The value, at a specific point in time, of all
open (unshipped), Customer Orders currently on the system. This is the other
report that you have identified

c) Orders by Request/ Promise date/ Planned Shipment date:  might be useful
for a top-level comparson with forecast demand, or the value of Customer
Orders planned to be despatched in a particular time bucket (may be useful
for some rough customer payment projections, if customers pay on time!)

d) Shipment Value: The value of those Customer Orders shipped, i.e.
transacted off stock, in a certain time bucket. Very useful as a guide to
value going out and as an integrity check with inventory movements.

e) Invoice Value: If your company has deferred invoicing then this might be
more relevant than the 'Shipment Value' report.

2) This could be added as point 'f' above but I believe it warrents a
separate line: CREDIT MEMOS. These little devils have the potential to
distort the 'Order Intake' figure in the daily recap figure. Two important
points:

a) Credit memos decrease the Order Value figure and are included in the
Daily Recap figure. The time phasing appears to be based on the Credit Memos
'shipment date' (not too sure?).
b) If someone mucks up a Credit memo and tries to perform rebalancing
transactions using a Customer Order for a 'value only' then an inflated
Order Intake figure is given. Therefore.......

3) There is a need, I believe, to have a set of Customer Order & Credit Memo
reports which give a complete picture of what is happening and has happened
and which can help to explain any anomolies.

4) A few things can happen which would appear to upset the integrity of the
reports, notably price changes and Request/ Promise date movements.

5) A Method to extract the figures you need. I use queries to do reports -
you may have spare programmers who can do the equivalent:

a) get the Open Customer Order values using MBC6REP (Placement Date) ,
MBADREP (Open Qty), and MBCDREP (value) - dump according to the key fields
you wish to report on. Only select records where the shipment quantity is
greater than zero (ADAQQT in MBADREP). This will give you the value of those
orders still open in a certain Order Intake time bucket.

b) Extract the shipped quantities from linking MBDHREP (shipment header),
MBDDREP (shipment detail to give item quantites and values), and MBBWCPP
(Order Placement Date)

c) Append both files and summate by Placement Date to derive Order Intake
figure. If using query then you may take a few steps to do this.

d) take care to differentiate between Customer Orders and Credit Memos (and
other order types if you use them!). Also, on the shipment files you may
have to filter out those people/ transactions which perform Credit Memo
rebalancing as described above.


I have found the above useful when one wishes to classify Order Intake, etc
by customers/ zones etc. Once you get used to the files and anomolies then
they are relatively straightforward.

Hope this helps

Paul


-----Original Message-----
From: LDEGNON@AMPRO.COM [mailto:LDEGNON@AMPRO.COM]
Sent: 05 July 2001 18:18
To: MAPICS-L@midrange.com
Subject: Bookings reports




We are new to MAPICS, (only since April 2, 2001), and I am attempting to
figure
out how to keep history of bookings data.  

I have discovered that The MAPICS daily recap Figure for Bookings calculates
the
Bookings dollars for a given time period minus the shipments against the
bookings for that particular period, causing, in my humble opinion, false
numbers! (for example, day 1 I sell 100 widgets for five dollars each, My
bookings, when I run said report for day one are 500 dollars  Day two I sell
nothing, but ship 250 of said widgets, run report for day one, and reported
bookings are down to 250 dollars! 
 
I'm not looking for OPEN BOOKINGS, rather the number of dollars that I did
for
the particular time period!  Am I asking for something extraordinary?  I
have
NEVER worked with a system that could not, off the shelf, do this!

I am currently using IWP against MTHACTV to give me this info, but it
appears
that this info goes away after each month close.  Will MMA solve this
problem? 
I KNOW others out there have had this same problem, just what have you done?

Thanks in advance for any and all suggestions,

Lloyd H. Degnon
Ampro Computers Inc.
WWW.AMPRO.COM
408.360.4365
ldegnon@ampro.com


LHD
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
daveshaw@bellsouth.net
+---
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
|daveshaw@bellsouth.net
+---