Where are G/L transactions stored?

system · October 25, 2005, 2:02pm

Sorry, never mind. I think I have it in PartTran.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Todd Caughey
Sent: Tuesday, October 25, 2005 12:50 PM
To: Vantage@...
Subject: [Vantage] Where are G/L transactions stored?

Help! IT guy needs accountant expertise....

We have an infrequent situation where a job will close unexpectedly prior the anticipated run. Like if a job for 5,000 pieces was flowing through the plant and 1,000 had shipped then the plug is pulled on the job. All the WIP at various operations is scrapped (I think) and the job absorbs all that cost. But the 1,000 that shipped and invoiced shows only the costs per peice on what was completed. From a sales point iof view the part looks like a winner but when the rest of the costs are included it's really a loser. I need to generate a sales report that captures that excess job cost and distributes it to the 1,000 that shipped so we can see the "true" margin performance of that part. Even over many subsequent jobs for the same part which complete normally. Over the life of a part the aborted job can still have a big impact on the part's performance.

The CEO of the company is asking because the amount shows up on the Inventory/Wip Account Reconcilliation report as a MFG-VAR entry which includes the job number and a G/L account number. When he compares job based performance to invoiced performance there can be a substantial difference.

I want to try to link the existing invoice based part sales report to wherever this transation is stored (via the job number and the G/L account) and add a column to the report for this phantom cost so that I can incorporate it into the part performance analysis. But what table (or tables) would this be in?

Any pointers in the right direction to look would be much appreciated.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

_____

YAHOO! GROUPS LINKS

* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

_____

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

system · October 25, 2005, 1:51pm

Help! IT guy needs accountant expertise....

We have an infrequent situation where a job will close unexpectedly prior the anticipated run. Like if a job for 5,000 pieces was flowing through the plant and 1,000 had shipped then the plug is pulled on the job. All the WIP at various operations is scrapped (I think) and the job absorbs all that cost. But the 1,000 that shipped and invoiced shows only the costs per peice on what was completed. From a sales point iof view the part looks like a winner but when the rest of the costs are included it's really a loser. I need to generate a sales report that captures that excess job cost and distributes it to the 1,000 that shipped so we can see the "true" margin performance of that part. Even over many subsequent jobs for the same part which complete normally. Over the life of a part the aborted job can still have a big impact on the part's performance.

The CEO of the company is asking because the amount shows up on the Inventory/Wip Account Reconcilliation report as a MFG-VAR entry which includes the job number and a G/L account number. When he compares job based performance to invoiced performance there can be a substantial difference.

I want to try to link the existing invoice based part sales report to wherever this transation is stored (via the job number and the G/L account) and add a column to the report for this phantom cost so that I can incorporate it into the part performance analysis. But what table (or tables) would this be in?

Any pointers in the right direction to look would be much appreciated.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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