Re: Re: SALES ORDER COST

[DaleGindlesperger@xxxxxxxxxxx]

Paula,

Good suggestion!  We use the MTHACT files extensively for accountant
reporting.  We also archive the MTHACT files monthly, and they have proved
invaluable when the auditors come a-knocking and asking for reports.  The
information Candy wants is available in them, they are FAR better organized
than the *%@#$% way that COM history is organized, so it'd be easy to do an
extract query and send it to a spreadsheet.

Man, I like this thread!

Dale @ Fleetwood



                                                                                
                                                        
                      <pgroeber@xxxxxxxx                                        
                                                        
                      h.net>                    To:       MAPICS ERP System 
Discussion <mapics-l@xxxxxxxxxxxx>                          
                      Sent by:                  cc:                             
                                                        
                      mapics-l-bounces@x        Subject:  Re: Re: SALES ORDER 
COST                                                      
                      idrange.com                                               
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      04/02/2003 10:39                                          
                                                        
                      AM                                                        
                                                        
                      Please respond to                                         
                                                        
                      MAPICS ERP System                                         
                                                        
                      Discussion                                                
                                                        
                                                                                
                                                        
                                                                                
                                                        




Candy,

Does your company have the MTHACT file offering that was made available
with Rel 1 or 2 of XA?  If you do have MTHACTY files and are updating that
file every day from Invoice runs you may have a solution.  It will not
change your history displayed under the inquiry functions, but would
provide a method for your accountant to have reports written to generate
the "margins" he is looking for.

You will need to provide a file a user can populate by item for cost
changes for the month.  As a before end of month procedure is executed,
have another program scan your override cost file and change the MTHACTY
cost for each item in the file.  Then generate the reports he is looking
for as part of your end of month procedures.  I would also strongly
recommend that as part of that pre-end of month process that you copy the
MTHACTY revised file to a HSTACTY file (create a new file each time nameing
it HSTmmyyyyY, HSTmmyyyyX)and MTHACTX, MTHACTY.  This way the reports could
be regenerated if needed or additional analysis could be performed later.
The company I worked for in the '90's had this similar requirement and this
is how we handled it.  The accountant got what he needed and the rest of
the application history was not messed up then.

If you don't have these files, go to e:Info and look for them.  I believe
they are offered free now or there is a minimum charge of $1000.00 or so.
There are instructions on how to add them to your environment and I believe
there is a system tailoring question that would need to be turned on in COM
if I remember correctly.

Just a thought and hope this is helpful.

Paola Groeber
MAPICS Consultant
770-490-3297 (cell)

>
> From: Candy.Hein@xxxxxxxxxxxx
> Date: 2003/04/02 Wed AM 10:19:12 EST
> To: mapics-l@xxxxxxxxxxxx
> Subject: Re: SALES ORDER COST
>
> Actually he wants to be able to correct the stock unit cost/extended item
> cost in the sales history detail file (MBDDREP).  We use this information
to
> determine margins and so forth.
>
> He would be the 1st one to tell me not to correct historical information,
> and why he wants to do this on cost is beyond me.   He is unable to
correct
> the costs on items prior to shipping so therefore he wants to do after he
> invoices.  As a former accountant myself I don't change files, I want the
> audit trail - credit / re-bills seems to be the cleanest method.
>
> Thanks for all of your input.
> Candy
>
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>
>

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.