RE: RMA History

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
BPCS 405 CD

1) RMA do not go to sales history unless you copy an RMA to a Post Ship
Bill.(BIL600)

2) Since RMA are returns to inventory I would say Post Ship Bill's would RMA
have negative quantities.
Depending on the order type it would go to an inventory location.

3) In the SIH there is a field SIRMA#.  In the SIL there is a field ILRMA#.
If this field is non zero then It would be a post ship bill copied from an
RMA.

4) In the ECL there is a field LRLINE this is the RMA line number copied.
In the ECH there is a field HRMA# which is the RMA number the post ship bill
was copied from.

5) Post Ship Bills depending on the Order Type will effect Sales.  The same
as regular Invoices.


> -----Original Message-----
> From: MacWheel99@aol.com [SMTP:MacWheel99@aol.com]
> Sent: Thursday, January 03, 2002 2:47 AM
> To:   bpcs-l@midrange.com
> Subject:      RMA History
>
> BPCS 405 CD on AS/400 mixed mode
>
> Trying to answer some questions today I discovered that I know entirely
> too
> little about what is normal for RMA processing.  Looking into some of the
> BPCS files, I find that I am coming away with more confusion than clarity.
>
> Does anyone know off hand if RMAs make it into sales history?
> Are RMAs supposed to get into sales history looking like negative sales?
>
> If they do, is there any easy way to isolate RMA totals so as to eliminate
> them from reports to only show what we sold / shipped, excluding
> involvement
> of customer returns?
>
> If I was looking at this before year end, I could have got it from SSH MTD
> totals, but that door has now been closed on me.  Is there some other door
> that is still open?
>
> We supposedly use one warehouse for customer returns & another for
> customer
> sales, but looking in the ECL file / RETURN member I can see that the data
> is
> not there consistently according to my understanding of the company rules.
> So I do not know what gets messed up when ECL / RETURN has the wrong
> warehouse.
>
> Evidently ECL file layout does not show a date that the RMA occurred.
> Like ECL *FIRST, it shows when it was supposed to happen, and whether or
> not
> it did happen, but not if it happened this month or whenever.
>
> I can look at invoice line item history to find out when a regular
> customer
> order shipment occurred, or at the ITH "B" transaction to see price &
> standard cost & actual cost at time of shipment.  I am somewhat at a loss
> where to find equivalent information when a customer return occurred.
>
> I noticed that 100% of our activity in warehouses not used for shipping
> has
> zero in all YTD fields of SSH.  I had thought that the YTD of SSH was a
> perpetual last 12 months ... or is that zeroed during year end?  I should
> have remembered to check YTD of SSH for shipment warehouses before I left
> the
> office ... I will do that Thursday to see if perhaps some activity never
> populates SSH, other than creating records with zero fields.
>
> Our warehouse # system is 2 digits
> 1st digit is the facility
> 2nd digit is the type of item stored there
> That is the system we now use ... there have been exceptions in the past
>
> Examples using facility 2
> 21 is end items about to be shipped from facility 2
> 22 is manufacturing work in process not finished yet
> 27 is raw materials warehouse ... I am assuming all the SSH stuff that is
> 27
> 47 etc. is related to DRP resupply order fulfillment
> 29 is for QC returns to facility 2 ... I am assuming all the SSH stuff
> that
> is 29 49 etc. are RMA returns
> However, I found a lot of ECL_RETURN records with warehouse 21 that I
> thought
> should be warehouse 29, but many many more than the discrepancies would
> account for.
>
> I had thought that billing adjustments need line item #s & customer PO#s
> to
> negate totals on original orders, so that adjustments without item# would
> not
> make it into SSH or SSD.  Meanwhile RMAs appear to be stored in member
> RETURN
> of the various customer order & shipment detail files (EC* & ES*).
>
> Should the grand total of what ends up in SSD on any given item be the
> same
> as what goes into SSH?
>
> We store List Price for reference in item master & try to catch shipments
> on
> customer orders with missing price or miskeyed price, but sometimes
> something
> slips by us, so to try to catch any mishaps in need of correction, I wrote
> a
> query SSD_OVRIDE to computer pricing average last month SSD.SDSL01 /
> SSD/SDQT01 (excluding SDQT01 EQ 0) & compare result to IIM.ILIST to
> identify
> discrepancies.
> With page break on RCM.CNME customer name, totals only on SSD.SDPROD to
> chart
> one line per item sold that customer: total shipped; average selling price
> in
> the overall month's billing; item list price; difference.
>
> There are some items that look like we shipped some quantity at zero
> price,
> but I have been told by my co-workers that this did not happen, so that
> raised the question of whether RMAs contaminating my report, or something
> else going wrong.
>
> Analysing history files (ITH SLH etc.) on those items show shipments were
> at
> correct price, but then I had a hard time with how the RMAs came back in
> ...
> is it even possible to link some info in history of customer return
> inventory
> with the customer order (e.g. ECL file RETURN member) which does not seem
> to
> be showing WHEN the transaction occurred.
>
> In one case I was told that we shipped 1000 for the month (and I found in
> the
> history where it was two shipments of 500 each correctly priced), and also
> got a customer return of the 1000 (and I found in the history where the
> 1000
> came in as an inventory adjustment with no $ values associated with it).
> The
> total of the SSD shows we shipped 1000 with no price ... if I am doing
> this
> right it would stand to reason it would be the other way round ... 0
> shipped
> but price there.
>
> While running queries various different ways against SSH data, I found
> that
> we had info in the SSH file on warehouses we have not shipped out of in
> over
> a year (such as facility 3 which we closed Dec 1999).
> What controls what customer/item/warehouse goes into SSH?  Some of those
> warehouses took a couple months to get all the stuff cleaned out of BPCS
> after we quit using them for real.
>
> Perhaps my problem is excluding SDQT01 EQ 0 for two reasons ...
> 1. 01 is last month 02 prior month etc & I only wanted to get at last
> month
> data
> 2. I am not fond of asking computer to divide by zero
>
> On a hunch, I selected how many records have SDQT01 (Quantity for the
> month)
> zero and SDSL01 (Sales dollars for the month) not zero, or the other way
> around SDQT01 not zero and SDSL01 zero ... I found a few of these
> scenarios,
> but they did not explain all the weirdness on my query that my co-workers
> questioning that perhaps RMA ends up in sales history but does not go in
> consistently.
>
> MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
> _______________________________________________
>