Re: set up costing simulation in Powerlink

Hello Laura,

I did something similar as what you explained.

The way I went about it, is to use Micorsoft Access, connected via ODBC to =
the Mapics AMFLIBX library, created a Bill of materials view,  and a query =
in the AS400 to get the routing operations, and their cost
Then created a few queries in Microsoft Access to create the cost for the p=
arts.
We use this to view variable overhead in a gross profit query, but this can=
 be used in any query requires costing.

If this you would like more details on this, please let me know and I can s=
end all the information on how I built it and how it works.

Best Regards,

Edgar Villanueva
edgarv-fk3Up2JSVTvoDDlPyiZBswC/[email protected]


-----Original Message-----
From: MAPICS-L <mapics-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> On Behalf Of Vojtech M=
r=E1zek
Sent: Sunday, May 4, 2025 12:15 PM
To: MAPICS ERP System Discussion <[email protected]>
Subject: Re: [MAPICS-L] set up costing simulation in Powerlink

Hello Laura,

first create your simulation site in Power-Link - use the function Copy to =
copy your production site to simulation site.
Then make all desired changes (change facility rates, overhead rates etc.).=
 You can use SQL or RPG program to modify your rates in simulation site (be=
 carefull as usually :o) The submit Costing for your simulation site.
Create a query to compare costs in production site and simulation site.
I usually delete the simulation site immediately, because it is confusing f=
or Engineering to have two records for each item, faclity, BOM, routing.
Works fine.

Vojtech Mrazek
________________________________
Od: MAPICS-L <mapics-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> za u=BEivatele ubelhor@s=
bcglobal.net <[email protected]>
Odesl=E1no: p=E1tek 2. kv=ECtna 2025 17:53
Komu: MAPICS ERP System Discussion <[email protected]>
P=F8edm=ECt: [MAPICS-L] set up costing simulation in Powerlink

Hello:
Has anyone successfully set up costing simulation in Powerlink?  There is a=
 KB and documentation referencing costing simulation but not very detailed =
instructions.  We have fiddled but it simply just does not work.
Can you share any advice or recommendations please.
Regards,Laura
Laura A. UbelhorPresidentConsultech Services, Inc.http://www.consultechserv=
icesinc.com/
phone 248-701-7410
--
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a =
message email: [email protected] To subscribe, unsubscribe, or ch=
ange list options,
visit: https://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives at https://arch=
ive.midrange.com/mapics-l.

--
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a =
message email: [email protected] To subscribe, unsubscribe, or ch=
ange list options,
visit: https://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives at https://arch=
ive.midrange.com/mapics-l.

-- =

This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/mapics-l.