PdcMaterialFile.WriteOff - Revision history

TC at 08:13, 20 June 2014

2014-06-20T08:13:58Z

← Older revision		Revision as of 08:13, 20 June 2014
Line 22:		Line 22:

	== Code example ==		== Code example ==
	~~Adjust a~~ material~~'s sourcing strategy~~.		Write off 10 m of material "BU.050.050.RVS309" on calculation "01483".

	<source lang="vb">		<source lang="vb">
Line 34:		Line 34:
	strCalcNo = "01483"		strCalcNo = "01483"
	strMatPos = "0001"		strMatPos = "0001"
	lngMatID = ~~2118~~		lngMatID = 0
	strMatNo = "BU.050.050.RVS309"		strMatNo = "BU.050.050.RVS309"
	strStockID = 7		strStockID = 7
	dblQnty = 10		dblQnty = 10
	if pdc.MasterData.MaterialFile.WriteOff(strCalcNo, strMatPos, lngMatID, strMatNo, strStockID, dblQnty) then		if pdc.MasterData.MaterialFile.WriteOff(strCalcNo, strMatPos, lngMatID, strMatNo, strStockID, dblQnty) then
	msgbox "~~Het is gelukt~~."		msgbox "Write off completed."
	else		else
	msgbox pdc.LastError		msgbox pdc.LastError

TC at 08:12, 20 June 2014

2014-06-20T08:12:19Z

← Older revision		Revision as of 08:12, 20 June 2014
Line 25:		Line 25:

	<source lang="vb">		<source lang="vb">
	~~Sub btn_SelectMatNrClick(Sender)~~		dim strCalcNo
	~~edt_MatNr.Text = pdc.ChooseRecord(36, "", "")~~		dim strMatPos
	~~End Sub~~		dim lngMatID
			dim strMatNo
			dim strStockID
			dim dblQnty

	~~Sub btn_CheckSourcesClick(Sender)~~		strCalcNo = "01483"
	~~dim booResult~~		strMatPos = "0001"
	~~dim booStock~~		lngMatID = 2118
	~~booStock~~ = ~~(GetAnyField(~~"~~LM_MAT~~", "~~LM_MATN", edt_MatNr~~.~~Text,~~ "~~LM_VR")~~ = ~~"J")~~		strMatNo = "BU.050.050.RVS309"
	~~booResult~~ = pdc.MasterData.MaterialFile.~~CheckSourceFPart~~(~~edt_MatNr.Text~~, ~~booStock~~)		strStockID = 7
	msgbox "~~CheckSourceFPart =~~ " ~~& booResult~~		dblQnty = 10
	~~End Sub~~		if pdc.MasterData.MaterialFile.WriteOff(strCalcNo, strMatPos, lngMatID, strMatNo, strStockID, dblQnty) then
			msgbox "Het is gelukt."
			else
			msgbox pdc.LastError
			end if
	</source>		</source>

	== Availability ==		== Availability ==
	Available since 20 June 2014 (4.3 and 5.1). 5.1 onwards, this function is removed, because other functionality is build with other methods.		Available since 20 June 2014 (4.3 and 5.1). 5.1 onwards, this function is removed, because other functionality is build with other methods.

TC at 07:53, 20 June 2014

2014-06-20T07:53:55Z

← Older revision		Revision as of 07:53, 20 June 2014
Line 39:		Line 39:

	== Availability ==		== Availability ==
	Available since ~~Jsnuary 2013~~ (4.3).		Available since 20 June 2014 (4.3 and 5.1). 5.1 onwards, this function is removed, because other functionality is build with other methods.

TC at 07:38, 20 June 2014

2014-06-20T07:38:22Z

← Older revision		Revision as of 07:38, 20 June 2014
Line 7:		Line 7:
	== Notes ==		== Notes ==
	CalcNo = Calculation number (DO_ORDNR).<br/>		CalcNo = Calculation number (DO_ORDNR).<br/>
	MatPos = Material position (DM_POS).<br/>		MatPos = Material position in the calculation (DM_POS).<br/>
	MatID = Material ID (DM_ID).<br/>		MatID = Material ID in the calculation (DM_ID).<br/>
	MatNo = Material number (~~DM_MATN~~).<br/>		MatNo = Material number (LM_MATN).<br/>
	StockID = The stockline ID (LMV_ID.<br/>		StockID = The stockline ID (LMV_ID).<br/>
	Quantity = The quantity to write off.<br/>		Quantity = The quantity to write off.<br/>

TC at 07:37, 20 June 2014

2014-06-20T07:37:12Z

← Older revision		Revision as of 07:37, 20 June 2014
Line 3:		Line 3:

	== Description ==		== Description ==
			This method writes off a stock line (with certificate) for a specific material number on a calculation.

			== Notes ==
	CalcNo = Calculation number (DO_ORDNR).<br/>		CalcNo = Calculation number (DO_ORDNR).<br/>
	MatPos = Material position (DM_POS).<br/>		MatPos = Material position (DM_POS).<br/>
Line 17:		Line 20:
	Write off a material with a different number than the forecast is possible.<br/>		Write off a material with a different number than the forecast is possible.<br/>
	A stock history line is also created with this method.<br/>		A stock history line is also created with this method.<br/>

	~~== Notes ==~~
	~~When changing a material's stock strategy in PdC, user is presented with the option to adjust all Fparts the material is incorporated in. This function executes that functionality from vbScript.~~
	~~Note that any checks required for setting a material to non-stocked (outstanding reservation, purchase order lines and existing stock position) need to be carried out in the script it self!~~

	== Code example ==		== Code example ==

TC at 07:34, 20 June 2014

2014-06-20T07:34:10Z

← Older revision		Revision as of 07:34, 20 June 2014
Line 13:		Line 13:
	1. You have to apply the parameters CalcNo, MatPos, MatNo, StockID and Quantity.<br/>		1. You have to apply the parameters CalcNo, MatPos, MatNo, StockID and Quantity.<br/>
	2. You have to apply the parameters MatID, MatNo, StockID and Quantity.<br/>		2. You have to apply the parameters MatID, MatNo, StockID and Quantity.<br/>
			<br/>
	This method writes off the quantity and deduct the existing reservation. The reservation is removed when the remaining quantity is zero.		This method writes off the quantity and deduct the existing reservation. The reservation is removed when the remaining quantity is zero.<br/>
	Write off a material with a different number than the forecast is possible.		Write off a material with a different number than the forecast is possible.<br/>
	A stock history line is also created with this method.		A stock history line is also created with this method.<br/>

	== Notes ==		== Notes ==

TC at 07:33, 20 June 2014

2014-06-20T07:33:41Z

← Older revision		Revision as of 07:33, 20 June 2014
Line 10:		Line 10:
	Quantity = The quantity to write off.<br/>		Quantity = The quantity to write off.<br/>

	This ~~set~~ of parameters writes off a quantity on a calculation:		This sets of parameters writes off a quantity on a calculation:<br/>
	1. You have to apply the parameters CalcNo, MatPos, MatNo, StockID and Quantity~~) or (DM_ID~~ and ~~DM_MATN)~~.		1. You have to apply the parameters CalcNo, MatPos, MatNo, StockID and Quantity.<br/>
			2. You have to apply the parameters MatID, MatNo, StockID and Quantity.<br/>

			This method writes off the quantity and deduct the existing reservation. The reservation is removed when the remaining quantity is zero.
			Write off a material with a different number than the forecast is possible.
			A stock history line is also created with this method.

	~~a. DO_ORDNR, DM_POS or DM_ID are required to define the position in a calculation.~~
	b. A material number is required, because on 1 position in a calculation, you can write off several different materials (numbers). This call only change stock lines and reservations for 1 material number for 1 position in a calculation.
	~~When more reservations are created for one position (With a different material number), only 1 is changed (and removed). The second one you have to remove in your script.~~
	~~2. You have to apply always LMV_ID and Quantity. The script must change a certificate number into a stock line ID.~~
	~~This command does:~~
	~~1. Write off the stock line and if remaining quantity is zero, the stock line is removed. Only for one material number.~~
	~~This function adjusts the sourcing strategy for materials in Fparts according to the input paramater booStock (preferably the value of LM_MAT.LM_VR).~~
	~~Reduce the reservation and if remaining quantity is zero, the~~
	~~reservation is removed. Only for one material number.~~
	~~3. Create a stock history line like standard PdC do. This line is the post calculation for the quantity and the value of that position in the calculation.~~
	== Notes ==		== Notes ==
	When changing a material's stock strategy in PdC, user is presented with the option to adjust all Fparts the material is incorporated in. This function executes that functionality from vbScript.		When changing a material's stock strategy in PdC, user is presented with the option to adjust all Fparts the material is incorporated in. This function executes that functionality from vbScript.

TC at 07:12, 20 June 2014

2014-06-20T07:12:27Z

← Older revision		Revision as of 07:12, 20 June 2014
Line 3:		Line 3:

	== Description ==		== Description ==
	CalcNo = ~~The calculation's~~ number (DO_ORDNR) ~~to write off a reservation~~.<br/>		CalcNo = Calculation number (DO_ORDNR).<br/>
	MatPos = ~~as String,~~ MatID ~~as long,~~ MatNo ~~as string,~~ StockID ~~as long,~~ Quantity		MatPos = Material position (DM_POS).<br/>
			MatID = Material ID (DM_ID).<br/>
			MatNo = Material number (DM_MATN).<br/>
			StockID = The stockline ID (LMV_ID.<br/>
			Quantity = The quantity to write off.<br/>

	~~These~~ parameters ~~are required~~:		This set of parameters writes off a quantity on a calculation:
	1. You have to apply ~~(DO_ORDNR~~, ~~DM_POS~~ and ~~DM_MATN~~) or (DM_ID and DM_MATN).		1. You have to apply the parameters CalcNo, MatPos, MatNo, StockID and Quantity) or (DM_ID and DM_MATN).

	a. DO_ORDNR, DM_POS or DM_ID are required to define the position in a calculation.		a. DO_ORDNR, DM_POS or DM_ID are required to define the position in a calculation.

TC: Created page with "== Declaration == WriteOff(CalcNo as String, MatPos as String, MatID as long, MatNo as string, StockID as long, Quantity as double) as Boolean == Description == CalcNo = The ..."

2014-06-20T07:04:45Z

Created page with "== Declaration == WriteOff(CalcNo as String, MatPos as String, MatID as long, MatNo as string, StockID as long, Quantity as double) as Boolean == Description == CalcNo = The ..."

New page

== Declaration ==
WriteOff(CalcNo as String, MatPos as String, MatID as long, MatNo as string, StockID as long, Quantity as double) as Boolean

== Description ==
CalcNo = The calculation's number (DO_ORDNR) to write off a reservation.<br/>
MatPos = as String, MatID as long, MatNo as string, StockID as long, Quantity

These parameters are required:
1. You have to apply (DO_ORDNR, DM_POS and DM_MATN) or (DM_ID and DM_MATN).

a. DO_ORDNR, DM_POS or DM_ID are required to define the position in a calculation.
b. A material number is required, because on 1 position in a calculation, you can write off several different materials (numbers). This call only change stock lines and reservations for 1 material number for 1 position in a calculation.
When more reservations are created for one position (With a different material number), only 1 is changed (and removed). The second one you have to remove in your script.
2. You have to apply always LMV_ID and Quantity. The script must change a certificate number into a stock line ID.
This command does:
1. Write off the stock line and if remaining quantity is zero, the stock line is removed. Only for one material number.
This function adjusts the sourcing strategy for materials in Fparts according to the input paramater booStock (preferably the value of LM_MAT.LM_VR).
Reduce the reservation and if remaining quantity is zero, the
reservation is removed. Only for one material number.
3. Create a stock history line like standard PdC do. This line is the post calculation for the quantity and the value of that position in the calculation.
== Notes ==
When changing a material's stock strategy in PdC, user is presented with the option to adjust all Fparts the material is incorporated in. This function executes that functionality from vbScript.
Note that any checks required for setting a material to non-stocked (outstanding reservation, purchase order lines and existing stock position) need to be carried out in the script it self!

== Code example ==
Adjust a material's sourcing strategy.

<source lang="vb">
Sub btn_SelectMatNrClick(Sender)
edt_MatNr.Text = pdc.ChooseRecord(36, "", "")
End Sub

Sub btn_CheckSourcesClick(Sender)
dim booResult
dim booStock
booStock = (GetAnyField("LM_MAT", "LM_MATN", edt_MatNr.Text, "LM_VR") = "J")
booResult = pdc.MasterData.MaterialFile.CheckSourceFPart(edt_MatNr.Text, booStock)
msgbox "CheckSourceFPart = " & booResult
End Sub
</source>

== Availability ==
Available since Jsnuary 2013 (4.3).