E9: MFG-CUS job cost timing

I think the default for every costing method except Standard cost – will take the job variance and post to the cost of Sales. I actually like this –

 

In company maintenance under Modules > Production > Jobs – If you are Standard Cost you can post choose to post the direct ship variance to the COS or use the Product Group variance account.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 2:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: MFG-CUS job cost timing

 

 

Hello,

I am reviewing some part transactions and I noticed that when we ship from a job in Customer Shipment Entry, there is a transaction amount.
I would assume that this transaction amount would come from the job but in an example that I am reviewing, the time when the job was shipped the material was not issued so the actual cost on the job would have been $0.

This job has two materials and no labor is capture against it.
The estimate unit cost for the job was $157.41.
The job shipped on 2/25/2015 but the material for the job was not issued until 2/27/2015.
That would mean that the actual cost for the job was zero at the time of the shipment.
The unit cost on the part transaction from 2/25 is $168.50, which is what the actual cost of the job was on 2/27/2015.

I feel like I’m missing something. Is there a trigger that goes back and updates the cost on the transaction?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ceccca.png@37dd5edf.41bc729a]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



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

Hello,

I am reviewing some part transactions and I noticed that when we ship from a job in Customer Shipment Entry, there is a transaction amount.
I would assume that this transaction amount would come from the job but in an example that I am reviewing, the time when the job was shipped the material was not issued so the actual cost on the job would have been $0.

This job has two materials and no labor is capture against it.
The estimate unit cost for the job was $157.41.
The job shipped on 2/25/2015 but the material for the job was not issued until 2/27/2015.
That would mean that the actual cost for the job was zero at the time of the shipment.
The unit cost on the part transaction from 2/25 is $168.50, which is what the actual cost of the job was on 2/27/2015.

I feel like I’m missing something. Is there a trigger that goes back and updates the cost on the transaction?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ceccca.png@37dd5edf.41bc729a]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




[Non-text portions of this message have been removed]
I believe running WIP/Rec should update it

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: MFG-CUS job cost timing



Hello,

I am reviewing some part transactions and I noticed that when we ship from a job in Customer Shipment Entry, there is a transaction amount.
I would assume that this transaction amount would come from the job but in an example that I am reviewing, the time when the job was shipped the material was not issued so the actual cost on the job would have been $0.

This job has two materials and no labor is capture against it.
The estimate unit cost for the job was $157.41.
The job shipped on 2/25/2015 but the material for the job was not issued until 2/27/2015.
That would mean that the actual cost for the job was zero at the time of the shipment.
The unit cost on the part transaction from 2/25 is $168.50, which is what the actual cost of the job was on 2/27/2015.

I feel like I’m missing something. Is there a trigger that goes back and updates the cost on the transaction?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ceccca.png@37dd5edf.41bc729a]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



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



[Non-text portions of this message have been removed]
What type of costing are you using?

Josh Serwe
Wisconsin Converting Inc.
Production Planning & Logistics
(920)437-6400 x 327

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: MFG-CUS job cost timing



Hello,

I am reviewing some part transactions and I noticed that when we ship from a job in Customer Shipment Entry, there is a transaction amount.
I would assume that this transaction amount would come from the job but in an example that I am reviewing, the time when the job was shipped the material was not issued so the actual cost on the job would have been $0.

This job has two materials and no labor is capture against it.
The estimate unit cost for the job was $157.41.
The job shipped on 2/25/2015 but the material for the job was not issued until 2/27/2015.
That would mean that the actual cost for the job was zero at the time of the shipment.
The unit cost on the part transaction from 2/25 is $168.50, which is what the actual cost of the job was on 2/27/2015.

I feel like I’m missing something. Is there a trigger that goes back and updates the cost on the transaction?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ceccca.png@37dd5edf.41bc729a]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



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



[Non-text portions of this message have been removed]
Hi Josh, we use FIFO/Lot FIFO

Thanks Rob. I did not know about that. That would certain make sense.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:4ea673.png@73a6bfe4.49bf4e40]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 4:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: MFG-CUS job cost timing



What type of costing are you using?

Josh Serwe
Wisconsin Converting Inc.
Production Planning & Logistics
(920)437-6400 x 327

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: MFG-CUS job cost timing



Hello,

I am reviewing some part transactions and I noticed that when we ship from a job in Customer Shipment Entry, there is a transaction amount.
I would assume that this transaction amount would come from the job but in an example that I am reviewing, the time when the job was shipped the material was not issued so the actual cost on the job would have been $0.

This job has two materials and no labor is capture against it.
The estimate unit cost for the job was $157.41.
The job shipped on 2/25/2015 but the material for the job was not issued until 2/27/2015.
That would mean that the actual cost for the job was zero at the time of the shipment.
The unit cost on the part transaction from 2/25 is $168.50, which is what the actual cost of the job was on 2/27/2015.

I feel like I’m missing something. Is there a trigger that goes back and updates the cost on the transaction?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ceccca.png@37dd5edf.41bc729a]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



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


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



[Non-text portions of this message have been removed]
Interesting… would have thought it would be $0. What does the WIP rec show?

Josh Serwe
Wisconsin Converting Inc.
Production Planning & Logistics
(920)437-6400 x 327

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: MFG-CUS job cost timing



Hi Josh, we use FIFO/Lot FIFO

Thanks Rob. I did not know about that. That would certain make sense.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:4ea673.png@73a6bfe4.49bf4e40]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 4:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: MFG-CUS job cost timing



What type of costing are you using?

Josh Serwe
Wisconsin Converting Inc.
Production Planning & Logistics
(920)437-6400 x 327

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: MFG-CUS job cost timing



Hello,

I am reviewing some part transactions and I noticed that when we ship from a job in Customer Shipment Entry, there is a transaction amount.
I would assume that this transaction amount would come from the job but in an example that I am reviewing, the time when the job was shipped the material was not issued so the actual cost on the job would have been $0.

This job has two materials and no labor is capture against it.
The estimate unit cost for the job was $157.41.
The job shipped on 2/25/2015 but the material for the job was not issued until 2/27/2015.
That would mean that the actual cost for the job was zero at the time of the shipment.
The unit cost on the part transaction from 2/25 is $168.50, which is what the actual cost of the job was on 2/27/2015.

I feel like I’m missing something. Is there a trigger that goes back and updates the cost on the transaction?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ceccca.png@37dd5edf.41bc729a]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



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


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


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



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

Actually it is all about timing….if you ship before things are issued, then all issues after the shipment hit your variance account.  WIP/Rec will only pull the labor over to your GL.  If you did not define a variance account you screwed yourself royally!

 

FIFO is THE biggest PITA in the system.  It is very picky and if you do not do the transactions in the proper order your reports always look off!

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 4:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: MFG-CUS job cost timing

 

 

Hi Josh, we use FIFO/Lot FIFO

Thanks Rob. I did not know about that. That would certain make sense.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:4ea673.png@73a6bfe4.49bf4e40]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 4:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: MFG-CUS job cost timing



What type of costing are you using?

Josh Serwe
Wisconsin Converting Inc.
Production Planning & Logistics
(920)437-6400 x 327

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 04, 2015 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: MFG-CUS job cost timing



Hello,

I am reviewing some part transactions and I noticed that when we ship from a job in Customer Shipment Entry, there is a transaction amount.
I would assume that this transaction amount would come from the job but in an example that I am reviewing, the time when the job was shipped the material was not issued so the actual cost on the job would have been $0.

This job has two materials and no labor is capture against it.
The estimate unit cost for the job was $157.41.
The job shipped on 2/25/2015 but the material for the job was not issued until 2/27/2015.
That would mean that the actual cost for the job was zero at the time of the shipment.
The unit cost on the part transaction from 2/25 is $168.50, which is what the actual cost of the job was on 2/27/2015.

I feel like I’m missing something. Is there a trigger that goes back and updates the cost on the transaction?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ceccca.png@37dd5edf.41bc729a]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



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


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


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

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.