Wip Report

Yahoo Archive
1
Greg,

I don't have a report like this because we sometimes have more than one SO
and customer for the same job. However, if you have a one customer to one
job relationship, you should be able to create this.

Customer to OrderHead by Company and CustomerNum
OrderHead to OrderDtl by Company and Ordernum
OrderDtl to OrderRel by Company, OrderNum, and OrderLine
OrderRel to JobProd by Company, OrderNum, OrderLine, OrderRelNum
JobProd to JobHead by Company and JobNum
JobHead to JobAssmb by Company and JobNum

Filter Assembly = 0

Pull Customer name from Customer Table
Pull JobNum from JobHead
Pull PartNum from JobHead
Pull ProdQty from JobHead
Pull ShipQty from JobHead


HTH-Sarah
2
Has anyone ever attempted to re-create the wip report. I can get to the job
totals but I can't think of the logic to get the wip balances. Thanks to
any help.

Rhonda
3
It does not tie exactly to the Vantage report but pretty close - I had to
allocate a portion of the cost for job qty that had shipped (by %) and
subtract the costs allocated to shipped qty from the total costs (on
JobAsmbl seq 0 in TLA + TLE costs). Rounding on the allocated cost
calculation gets things a few cents off. Also, I was not trying to
duplicate the WIP report but rather create a profitability forecast to give
a heads up as in... we hold stuff valued at X and this remaining amount will
bill Y if Y < X its time to call the customer and raise the price. ;) So i
doe snot look anything like a wip report. The report is also quirky due to
what we call KanBan Qty where we make it but don't have a SO linked yet,
pending customer OK to ship, but still need to factor it into the forecasted
profitability. It was a 6.5 on the migraine scale.

-Todd Caughey
Harvey Vogel Mfg. Co.

-----Original Message-----
From: Reilly, Rhonda [mailto:rreilly@...]
Sent: Wednesday, February 14, 2001 11:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Wip Report


Has anyone ever attempted to re-create the wip report. I can get to the job
totals but I can't think of the logic to get the wip balances. Thanks to
any help.

Rhonda


Yahoo! Groups Sponsor



<http://rd.yahoo.com/M=176325.1307934.2900314.1248726/D=egroupmail/S=1700007
183:N/A=567136/R=1/*http://domains.yahoo.com>
<http://rd.yahoo.com/M=176325.1307934.2900314.1248726/D=egroupmail/S=1700007
183:N/A=567136/R=2/*http://domains.yahoo.com>


www.

<http://us.adserver.yahoo.com/l?M=176325.1307934.2900314.1248726/D=egroupmai
l/S=1700007183:N/A=567136/rand=320976562>

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com






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

If you have a total cost for the job and divide that by the quantity
completed that will be your unit cost. Then take the unit cost times the
parts still on the job. The quantity that is still on the job is going to be
quantity completed less quantity shipped and quantity received to stock.
This should get you pretty close to what the wip should be for the job. HTH.

Jim Frice
-----Original Message-----
From: Reilly, Rhonda [mailto:rreilly@...]
Sent: Wednesday, February 14, 2001 11:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Wip Report

Has anyone ever attempted to re-create the wip report. I can get to the job
totals but I can't think of the logic to get the wip balances. Thanks to
any help.

Rhonda


To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
5
Has anyone created a Wip report by Customer?

The fields I am trying to put together are
Customer Name
JobNum
PartNum
ProdQty
ShipQty

I have calculations from the job assembly table for Burden, Labor, Matl,
Sub, and hours.

I dont think my joins are functioning properly however. If anyone already
has this done please let me know.

Thank You.
Greg