Re: Re: SALES ORDER COST

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