That's a great point to make Scott, for that reason our end of month
procedure is when and only when we close jobs that we consider eligible
for closing. We're getting to the point now that it is the exception
where the invoiced cost at shipping is different from the adjusted
invoice cost at job close.
Rob Bucek
Manufacturing Engineer
PH: 715-284-5376 ext 311
FAX: 715-284-4084
<
http://www.dsmfg.com/>
(Click the logo to view our site)
________________________________
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Thursday, April 16, 2009 4:26 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Sales Gross Margin report
Old thread but I thought I would add some information.
Over the past couple of days I have done some extensive research into
the
Sales Gross Margin report. Concentrating on Manufactured Parts with Jobs
being directly made to an Order.
Here is what I found.
There are 5 fields in the Invoice Detail table called
InvcDtl.JCLbrUnitCost,
.JCBurUnitCost, .JCMtlUnitCost, .JCSubUnitCost and .JCMtlBurUnitCost.
These
fields are populated when a Job is marked Closed but the caveat is that
at
the time the Job is marked Closed an Invoice must exist for it in order
for
those fields to populate, obviously, if there is no Invoice record how
can
you populate fields. So if the Job shipped and the shipment was not
brought
into an Invoice Group to get an Invoice record than those fields will
not
populate when Job is marked closed. For us this is not a problem since
Invoicing happens within a day from shipment and Job Closing is usually
a
few days behind. But you can uncheck and re-check the Closed checkbox
later,
after an Invoice was created, to have it either populate the Invoice
Detail
fields the first time or if you, for whatever reason, issue more
material or
apply more labor against the Job then those new costs will populate to
the
JC fields. I tested this back and forth a few times and it always
worked.
Then you can run SGM report but you need to check "Use Adjusted Cost" to
pick up the value of those fields for the SGM report comparison against
Total Price. All these cost should match with Production Detail report.
I
did not run PDR against my test Jobs I was working with but when I
looked at
Job Tracker and the Assembly Costs they matched between the Tracker and
SGM
report.
For Parts being sold from Inventory, at the time of the shipment the
Costs,
whatever the Part is setup for - Std, Avg, Last, are pulled from the
PartCost table and entered into the transaction MFG-CUS for that Part.
When
SGM report is run for these parts it uses the PArtTran table pulling
those
cost at the time of the transaction for the costs in the report.
HTH
Scott
-----Original Message-----
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Friday, August 15, 2008 2:02 PM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Sales Gross Margin vs Production Detail
I looked at this report way back in version 5.2 and it did not agree
with the PDR so I haven't used it since. I think the Sales Gross Margin
report is a snapshot of the cost at the time of the invoice. If you add
costs to a job after the invoice is created the Sales Gross Margin
report data does not get updated. Someone correct me if I am wrong.
Linda Lowney
--- In
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Can anyone explain why the numbers would be different from these two
> reports? Shouldn't they be the same?
>
> TIA!
>
>
>
> M. Manasa Reddy
> ERP / Inventory & Procurement Manager
> Welding Company of America
> manasa@...
> P: 630-806-2000
> F: 630-806-2001
[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/.
<
http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<
http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<
http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
[Non-text portions of this message have been removed]