Feature Requests Incident #16604

 


Summary
Project
INCDT - xTuple ERP
Incident Category
Features
Incident Number
16604
Visibility
public


Product Version
None
Fixed In Version
4.0.0Alpha


Summary
Add Purchase-to-Job and automatic issue capability for purchased items


Description

The Sponsoring customer purchases many materials that are thought of generically such as “STEEL” to a specific job such that every purchase order for that item is different. In order that they may reuse common item numbers to purchase to specific work orders (rather than creating new item numbers for every single purchase), item site setup should be modified to allow purchase items to be set to job costing. Engineers would enter common item numbers such as “STEEL” into a bill of materials or work order with job specific notes about dimensions and other attributes particular to the project, then those items would be purchased to the job (work order).

When job costing is selected for purchased or outside process items the following setting would be selected and enforced by disabling the controls:

Site can purchase this item = Yes

Users would be able to manually link and unlink purchase order line items to work order materials for items of any cost type. In the case of purchase or outside process items that are set to job costing the work order link will be mandatory. Upon receipt linked purchased items will be automatically issued to their respective work order and purchase costs and Lot/Serial tracking (where applicable) will automatically flow directly to the order.

This enhancement will also take advantage of the pre-existing functionality in purchase request that links purchase order line items to work orders. If purchase requests have been generated from a work order, then links to work order materials will automatically be created on the purchase order item. Note however that logic creating these links will have to be modified from the current behavior of linking to the the work order header, to a link on the work order material item.


Details
Reporter
jrogelstad
CRM Account
Advance Mold and Mfg.
Status
Closed
Assigned
reddog


Priority
Very High
Severity
Normal
Updated
04-18-12 06:51
Resolution
Fixed



Comments

DateUsernameComment
04/18/12 06:51vinaysingu

Tested in xTuple 4.0.0 Alpha.
Closing the issue

01/11/12 15:06reddog

change window itemSite to allow the setup of Job costed purchased items.

change windows purchaseOrder and purchaseOrderItem to handle the PR release associated with a W/O material requirement.

change window enterPOReceipt to issue Job costed purchased items to originating W/O.

change function issueWoMaterial to accept invhist_id and pass to postInvTrans for automatic processing of location/lot information captured by by receipt.

altered poitem table and replaced columns poitem_wohead_id and poitem_soitem_id with standard columns poitem_order_type and poitem_order_id. changed references to altered columns in xtuple and xtupleserver repositories.

01/11/12 14:54svn

Revision: 13145
http://postbooks.svn.sourceforge.net/postbooks/?rev=13145&view=rev
Author: sunsetsolutions
Date: 2012-01-11 19:54:04 +0000 (Wed, 11 Jan 2012)
Log Message:
-----------
Issue #16604:purchase-to-job

Modified Paths:
--------------
xtupleserver/trunk/dbscripts/api/views/purchaseline.sql
xtupleserver/trunk/dbscripts/functions/createpurchasetosale.sql
xtupleserver/trunk/dbscripts/functions/issuewomaterial.sql
xtupleserver/trunk/dbscripts/metasql/poItems-list.mql
xtupleserver/trunk/dbscripts/metasql/purchaseOrderItems-detail.mql

Added Paths:
-----------
xtupleserver/trunk/updatescripts/from_380/alterPoitem.sql

01/11/12 14:53svn

Revision: 13144
http://postbooks.svn.sourceforge.net/postbooks/?rev=13144&view=rev
Author: sunsetsolutions
Date: 2012-01-11 19:53:06 +0000 (Wed, 11 Jan 2012)
Log Message:
-----------
Issue #16604:purchase-to-job

Modified Paths:
--------------
xtuple/trunk/common/errorReporter.cpp
xtuple/trunk/guiclient/enterPoReceipt.cpp
xtuple/trunk/guiclient/itemSite.cpp
xtuple/trunk/guiclient/poitemTableModel.h
xtuple/trunk/guiclient/purchaseOrder.cpp
xtuple/trunk/guiclient/purchaseOrderItem.cpp
xtuple/trunk/guiclient/unpostedPoReceipts.cpp

12/30/11 09:49rcharbonneau

This is a very good new!

Since will be able to use the same part for many use.

Will we be able to change the item description ;
1. in the PO Item Line?
2. in the WO Materiel?

Thanks,

12/23/11 15:40jrogelstad

The Sponsoring customer purchases many materials that are thought of generically such as “STEEL” to a specific job such that every purchase order for that item is different. In order that they may reuse common item numbers to purchase to specific work orders (rather than creating new item numbers for every single purchase), item site setup should be modified to allow purchase items to be set to job costing. Engineers would enter common item numbers such as “STEEL” into a bill of materials or work order with job specific notes about dimensions and other attributes particular to the project, then those items would be purchased to the job (work order).

When job costing is selected for purchased or outside process items the following setting would be selected and enforced by disabling the controls:

Site can purchase this item = Yes

Users would be able to manually link and unlink purchase order line items to work order materials for items of any cost type. In the case of purchase or outside process items that are set to job costing the work order link will be mandatory. Upon receipt linked purchased items will be automatically issued to their respective work order and purchase costs and Lot/Serial tracking (where applicable) will automatically flow directly to the order.

This enhancement will also take advantage of the pre-existing functionality in purchase request that links purchase order line items to work orders. If purchase requests have been generated from a work order, then links to work order materials will automatically be created on the purchase order item. Note however that logic creating these links will have to be modified from the current behavior of linking to the the work order header, to a link on the work order material item.



Files

No Files

Related Documents

TypeNumberDescriptionRelationshipRemove
ProjectXTUPLEAPPSPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
12/23/11 16:22jrogelstadStatusStatus Changed: New -> Confirmed
12/23/11 15:40jrogelstadNewIncident Added
04/18/12 06:51vinaysinguCharacteristic Copyright Assigned Added: "Yes"
04/18/12 06:51vinaysinguContact Changed: "Rick Lees" -> "John Rogelstad"
04/18/12 06:51vinaysinguCharacteristic Backport Added: "No"
04/18/12 06:51vinaysinguCharacteristic Estimated Hours Added: ""
04/18/12 06:51vinaysinguCharacteristic Operating System Added: "Windows XP"
04/18/12 06:51vinaysinguStatusStatus Changed: Resolved -> Closed
04/18/12 06:51vinaysinguCharacteristic Regression Added: "No"
04/18/12 06:51vinaysinguDescription Updated: "The Sponsoring custo..." -> "The Sponsoring custo..."
04/18/12 06:51vinaysinguCharacteristic haxTuple Added: "No"
04/05/12 08:56ptylerCharacteristic Doc Flag Added: "True"
03/28/12 15:44ptylerFixed In: -> 4.0.0Alpha
01/11/12 15:06reddogResolutionResolution Changed: Open -> Fixed
01/11/12 15:06reddogCharacteristic CodeReview Added: "Needed"
01/11/12 15:06reddogStatusStatus Changed: Assigned -> Resolved
01/06/12 17:32gmoskowitzStatusStatus Changed: Confirmed -> Assigned
01/06/12 17:32gmoskowitzAssignedAssigned to: "" -> "reddog"