(V8) - Job Adjustments

We just went live on 8.0 January 1st (from version 6.1). To load WIP,
there were only 3 transactions necessary per job so I never tried the
cut&paste method. This might not be the easiest way but it's what the
Epicor consultant recommended and it worked for us.

We took the WIP report from the old system to get the values that we
wanted to enter into the new system. For each job, we processed 3 job
adjustment transactions, one transaction for labor and burden, one
transaction for material, and one for material burden. You don't want
the transaction to hit GL so we set it up so it credited and debited the
same account (wash transaction). No care was taken to select any
particular employee, material or operation because for this exercise, it
doesn't matter.

For each job, look at the WIP accounts in the Product Group then set the
Control Accounts (in Company Config) to the WIP accounts (Applied Labor
= WIP Labor, Applied Overhead = WIP Burden, Inventory Adjustment to WIP
Material and then Inventory Adjustment to WIP Material Burden) . For
job adjustments, the material and material burden both hit the same
inventory adjustment control account so you have to do two separate
transactions. Labor and Labor burden can be processed at the same time.
Check your new system WIP report to see if it matches. You have to
process Capture COS/WIP Activity in between the material and material
burden transactions because the unposted WIP costs will follow which
ever account is currently in the control account. When you're all done,
just change the control accounts back to normal.

We also loaded inventory in a similar fashion, using Inventory
Adjustments with the Inventory Adjustment control account temporarily
changed to the Inventory Raw Material account.

All of this had to be carefully orchestrated or else you'll be doing a
lot of negative transactions to fix. Just take it slow, carefully
checking the Inventory/WIP reconciliation and WIP reports before capture
and you'll be fine.

Best of luck.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, December 19, 2006 12:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] (V8) - Job Adjustments



Hello,

In preparation for our go-live data conversion, we are testing out our
Open Shop Order conversion procedure. We will be converting these
manually.

I was hoping to take advantage of the Paste Insert feature on the list
tab for Job Adjustments in order to automate some of this task but every
time I do, Vantage crashes.

Has anyone got the paste update or paste insert to work on Job
Adjustments in the past? If so, maybe you can help me figure out how to
get it to work.

Alternatively, is there a way I can "push" this data into Vantage and
avoid the manual entries using Job Adjustment?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

[Non-text portions of this message have been removed]




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
Hello,



In preparation for our go-live data conversion, we are testing out our
Open Shop Order conversion procedure. We will be converting these
manually.



I was hoping to take advantage of the Paste Insert feature on the list
tab for Job Adjustments in order to automate some of this task but every
time I do, Vantage crashes.



Has anyone got the paste update or paste insert to work on Job
Adjustments in the past? If so, maybe you can help me figure out how to
get it to work.

Alternatively, is there a way I can "push" this data into Vantage and
avoid the manual entries using Job Adjustment?



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



[Non-text portions of this message have been removed]