wsiJobCostInvoiceOPEN

Table: JC20501

Description: Creates a record in JC20501. Performs validations on input parameters and defaults in values as necessary when the user provided value is null. Stored procedures in "PROCEDURES CALLED" are used to create Dynamics GP records and update Job Cost records as necessary.

Element Name	Data Type	Length
@I_vAccountAmount	numeric	19,5
@I_vActEquipmentCostTTDMarkup	numeric	19,5
@I_vActLaborCostTTDMarkup	numeric	19,5
@I_vActMaterialsCostTTDMarkup	numeric	19,5
@I_vActMiscOtherCostTTDMarkup	numeric	19,5
@I_vActSubsCostTTDMarkup	numeric	19,5
@I_vActUserDefined1TTDMarkup	numeric	19,5
@I_vActUserDefined2TTDMarkup	numeric	19,5
@I_vActUserDefined3TTDMarkup	numeric	19,5
@I_vActUserDefined4TTDMarkup	numeric	19,5
@I_vAddressCode	char	15
@I_vAmountReceived	numeric	19,5
@I_vBatchNumber	char	15
@I_vBatchSource	char	15
@I_vBill	tinyint
@I_vBilledAmountTTD	numeric	19,5
@I_vBilledEquipmentCostTTDMarkup	numeric	19,5
@I_vBilledLaborCostTTDMarkup	numeric	19,5
@I_vBilledMaterialsCostTTDMarkup	numeric	19,5
@I_vBilledMisc1TTD	numeric	19,5
@I_vBilledMisc2TTD	numeric	19,5
@I_vBilledMisc3TTD	numeric	19,5
@I_vBilledMisc4TTD	numeric	19,5
@I_vBilledMisc5TTD	numeric	19,5
@I_vBilledMiscOtherCostTTDMarkup	numeric	19,5
@I_vBilledSubsCostTTDMarkup	numeric	19,5
@I_vBilledUserDefined1TTDMarkup	numeric	19,5
@I_vBilledUserDefined2TTDMarkup	numeric	19,5
@I_vBilledUserDefined3TTDMarkup	numeric	19,5
@I_vBilledUserDefined4TTDMarkup	numeric	19,5
@I_vCashAmount	numeric	19,5
@I_vCashRemainingAmount	numeric	19,5
@I_vChangedSincePrintingFlag	tinyint
@I_vCommentID	char	15
@I_vCommissionEarnings	numeric	19,5
@I_vCommissionPercent	smallint
@I_vCurrencyID	char	15
@I_vCurrentBillEquipment	numeric	19,5
@I_vCurrentBillLabor	numeric	19,5
@I_vCurrentBillMaterials	numeric	19,5
@I_vCurrentBillMiscOther	numeric	19,5
@I_vCurrentBillSubs	numeric	19,5
@I_vCurrentBillUserDefined1	numeric	19,5
@I_vCurrentBillUserDefined2	numeric	19,5
@I_vCurrentBillUserDefined3	numeric	19,5
@I_vCurrentBillUserDefined4	numeric	19,5
@I_vCurrentDueEquipment	numeric	19,5
@I_vCurrentDueLabor	numeric	19,5
@I_vCurrentDueMaterials	numeric	19,5
@I_vCurrentDueMiscOther	numeric	19,5
@I_vCurrentDueSubs	numeric	19,5
@I_vCurrentDueUserDefined1	numeric	19,5
@I_vCurrentDueUserDefined2	numeric	19,5
@I_vCurrentDueUserDefined3	numeric	19,5
@I_vCurrentDueUserDefined4	numeric	19,5
@I_vCustomerNumber	char	15
@I_vCustomerPONumber	char	21
@I_vDatePaid	datetime
@I_vDiscountDate	datetime
@I_vDocumentAmount	numeric	19,5
@I_vDocumentDate	datetime
@I_vDocumentNumber	char	21
@I_vDocumentType	smallint
@I_vDueDate	datetime
@I_vDynamicsStatus	char	5
@I_vFreightTaxAmount	numeric	19,5
@I_vGLPostingDate	datetime
@I_vInvoiceDescription	text
@I_vInvoiceStyle	smallint
@I_vMiscTaxAmount	numeric	19,5
@I_vNoTimesPrinted	smallint
@I_vOnlyValidate	tinyint
@I_vOriginatingBilledAmountTTD	numeric	19,5
@I_vOriginatingDocumentAmount	numeric	19,5
@I_vOriginatingMiscTaxAmount	numeric	19,5
@I_vOriginatingRetentionAmountTTD	numeric	19,5
@I_vOriginatingRetentionBilledTTD	numeric	19,5
@I_vOriginatingSubtotal	numeric	19,5
@I_vOriginatingTaxAmount	numeric	19,5
@I_vOriginatingTradeDiscountAmount	numeric	19,5
@I_vPaymentTermsID	char	21
@I_vPostDate	datetime
@I_vPostingStatus	smallint
@I_vPostUserID	char	15
@I_vPrintedDate	datetime
@I_vReimbursable	tinyint
@I_vRetentionAmountTTD	numeric	19,5
@I_vRetentionBilledTTD	numeric	19,5
@I_vReturnErrorText	tinyint
@I_vRMDocumentNumberWORK	char	17
@I_vRMDocumentTypeAll	smallint
@I_vSalespersonID	char	15
@I_vSalesTerritory	char	15
@I_vSubtotal	numeric	19,5
@I_vSVLanguageID	smallint
@I_vTaxAmount	numeric	19,5
@I_vTaxAmount1	numeric	19,5
@I_vTaxAmount2	numeric	19,5
@I_vTaxAmount3	numeric	19,5
@I_vTaxAmount4	numeric	19,5
@I_vTaxDate	datetime
@I_vTaxDetailID	char	15
@I_vTaxDetailID1	char	15
@I_vTaxDetailID2	char	15
@I_vTaxDetailID3	char	15
@I_vTaxDetailID4	char	15
@I_vTaxScheduleID	char	15
@I_vTimeZone	char	3
@I_vTradeDiscountAmount	numeric	19,5
@I_vTRXSource	char	13
@I_vUpdateIfExists	tinyint
@I_vUserDefine1	char	31
@I_vUserDefine2	char	31
@I_vUserDefined1	char	21
@I_vUserDefined2	char	21
@I_vUserDefinedCB1	tinyint
@I_vUserDefinedCB2	tinyint
@I_vUserDefinedCB3	tinyint
@I_vUserDefinedCB4	tinyint
@I_vUserDefinedDate1	datetime
@I_vUserDefinedDate2	datetime
@I_vUserDefinedDollar1	numeric	19,5
@I_vUserDefinedDollar2	numeric	19,5
@I_vUserDefinedDollar3	numeric	19,5
@I_vUserDefinedDollar4	numeric	19,5
@I_vUserDefinedInteger1	int
@I_vUserDefinedInteger2	int
@I_vUserDefinedInteger3	int
@I_vUserDefinedInteger4	int
@I_vUserID	char	15
@I_vUSRDEFND1	char	50
@I_vUSRDEFND2	char	50
@I_vUSRDEFND3	char	50
@I_vUSRDEFND4	varchar	8000
@I_vUSRDEFND5	varchar	8000
@I_vWennsoftAffiliate	char	15
@I_vWennsoftBranch	char	15
@I_vWennsoftRegion	char	15
@I_vWennSoftTablesOnly	tinyint
@I_vWSApplicationNumber	char	5
@I_vWSJobNumber	char	17
@I_vWSProjectNumber	char	17
@I_vWSReservedCB1	tinyint
@I_vWSReservedCB2	tinyint
@I_vWSReservedCB3	tinyint
@I_vWSReservedCB4	tinyint
@I_vWSReservedCB5	tinyint
@I_vWSReservedSTR1	char	11
@I_vWSReservedSTR2	char	11
@I_vWSUserDefinedDate3	datetime
@I_vWSUserDefinedDate4	datetime
@O_iErrorState	int
@oErrString	varchar	255

Error Codes

Error Code	Description
1	The document number exists in table RM_Sales_WORK (RM10301).
51017	The Job does not exist in Signature.
51094	Job is inactive.
52279	The project number is not assigned to the job.
52322	The batch source must be RM_Sales.
52338	The customer number does not exist.
52339	The customer address does not exist.
52343	The sales person does not exist.
52345	Tax detail id 1 does not exist.
52346	Tax detail id 2 does not exist.
52347	Tax detail id 3 does not exist.
52348	Tax detail id 4 does not exist.
52432	'Tax Schedule ID does not exists in TX00101 (TX_Schedule_MSTR_HDR).'
52434	Payment Terms ID does not exists in SY03300 (SY_Payment_Terms_MSTR).
52435	Sales Territory does not exists in RM00303 (RM_Sales_Territory_MSTR).
52445	The project standard billing type cannot be used for job invoices.
52446	The sop billing type cannot be used for job invoices.
52447	The project bill code billing type cannot be used for job invoices.
52448	The project transaction level billing type cannot be used for job invoices.
52449	The project allocated revenue billing type cannot be used for job invoices.
52450	The project type of project standard billing can only be used on project invoices.
52451	The project type of project bill code can only be used on project invoices.
52452	The project type of cost plus billing can only be used on project invoices.
52453	The project type of project allocated revenue can only be used on project invoices.
52454	The parameter @I_vRMDocumentNumberWORK exists in table JC_Invoice_WORK (JC10501).
52455	The parameter @I_vRMDocumentNumberWORK exists in table JC_Invoice_OPEN (JC20501).
52456	The parameter @I_vRMDocumentNumberWORK exists in table JC_Invoice_HIST (JC30501).
52457	The parameter @I_vWSApplicationNumber (WS Application Number) exists for the job in table JC_Invoice_WORK (JC10501).
52458	The parameter @I_vWSApplicationNumber (WS Application Number) exists for the job in table JC_Invoice_OPEN (JC20501).
52459	The parameter @I_vWSApplicationNumber (WS Application Number) exists for the job in table JC_Invoice_HIST (JC30501).
52460	Parameter @I_vBilledAmountTTD is not equal to the sum of the current bill amounts.
52461	Parameter @I_vBilledAmountTTD is not equal to the @I_vSubtotal minus @I_vRetentionBilledTTD plus @I_vRetentionAmountTTD.
52464	The @I_vBilledAmountTTD is not equal to the sum of the current bill amounts.
52465	@I_vCurrentBillLabor exceeds @I_vCurrentDueLabor.
52466	@I_vCurrentBillMaterials exceeds @I_vCurrentDueMaterials.
52467	@I_vCurrentBillEquipment exceeds @I_vCurrentDueEquipment.
52468	@I_vCurrentBillSubs exceeds @I_vCurrentDueSubs.
52469	@I_vCurrentBillMiscOther exceeds @I_vCurrentDueMiscOther.
52470	@I_vCurrentBillUserDefined1 exceeds @I_vCurrentDueUserDefined1.
52471	@I_vCurrentBillUserDefined2 exceeds @I_vCurrentDueUserDefined2.
52472	@I_vCurrentBillUserDefined3 exceeds @I_vCurrentDueUserDefined3.
52473	@I_vCurrentBillUserDefined4 exceeds @I_vCurrentDueUserDefined4.
52474	Error updating record in table JC_Invoice_OPEN (JC20501).
52475	Error inserting record in table JC_Invoice_OPEN (JC20501).
52476	Parameter @I_vRetentionBilledTTD (Retention Due) exceeds the retention withheld on the job.
52477	The net billing plus the current document amount exceeds the expected contract on the job.
52559	'Parameter @I_vDocumentNumber must equal parameter @I_vRMDocumentNumberWORK.'
52561	Parameter @I_vRMDocumentTypeAll must be 1 (Invoice) or 7 (Credit Memo).
52562	Parameter @I_vDocumentType must be 1 (invoice) or 2 (credit memo).
52563	Parameter @I_vAccountAmount does not equal parameter @I_vDocumentAmount.
52564	(@I_vFreightTaxAmount + @I_vMiscTaxAmount + @I_vTaxAmount) <> (@I_vDocumentAmount - @I_vSubtotal)
52565	Currency ID does not exist in table DYNAMICS..MC40200 (MC_Currency_Setup).
52566	Parameter @I_vOriginatingTaxAmount is not equal to parameter @I_vTaxAmount.
52567	Parameter @I_vOriginatingDocumentAmount does not equal parameter @I_vDocumentAmount.
52572	Parameter @I_vRMDocumentNumberWORK is empty and must contain a value.
52573	'Parameter @I_vTRXSource must contain a non-empty string value.'
52574	'Parameter @I_vDynamicsStatus must contain the string value P.'
52575	Parameter @I_vBatchNumber must contain a non-empty string value.
52576	Parameter @I_vTRXSource does not equal the transaction source assigned to the invoice in receivables management.
52577	Parameter @I_vBatchNumber does not equal the batch number assigned to the invoice in receivables management.
52578	Parameter @I_vBatchSource does not equal the batch source assigned to the invoice in receivables management.
52579	Parameter @I_vAccountAmount does not equal the current transaction amount assigned to the invoice in receivables management.
52580	Parameter @I_vPaymentTermsID does not equal the current payment terms id assigned to the invoice in receivables management.
52581	Parameter @I_vPaymentTermsID must be a non-empty string value.
52582	Parameter @I_vTaxScheduleID does not equal the current tax schedule id assigned to the invoice in receivables management.
52583	Parameter @I_vCashAmount does not equal the current cash amount assigned to the invoice in receivables management.
52584	Parameter @I_vDocumentDate does not equal the current document date assigned to the invoice in receivables management.
52585	Parameter @I_vDocumentDate must contain a non-empty date value.
52587	Parameter @I_vPostUserID does not equal the current post user id assigned to the invoice in receivables management.
52588	Parameter @I_vGLPostingDate does not equal the current GL posting date assigned to the invoice in receivables management.
52589	Parameter @I_vCustomerNumber does not equal the current customer number assigned to the invoice in receivables management.
52590	Parameter @I_vCustomerNumber must contain a non-empty string value.
52591	The @I_vAddressCode must contain a non-empty string value.
52592	Parameter @I_vAddressCode does not equal the current address code assigned to the invoice in receivables management.
52593	Parameter @I_vSalespersonID does not equal the current sales person assigned to the invoice in receivables management.
52594	Parameter @I_vSalesTerritory does not equal the current sales territory assigned to the invoice in receivables management.
52595	Parameter @I_vSalesTerritory contains a value but @I_vSalesPersonID is empty.
52596	Parameter @I_vCustomerPONumber does not equal the current customer purchase order number assigned to the invoice in receivables management.
52597	Parameter @I_vTradeDiscountAmount does not equal the current trade discount amount assigned to the invoice in receivables management.
52598	Parameter @I_vDiscountDate does not equal the current trade discount date assigned to the invoice in receivables management.
52599	Parameter @I_vDueDate does not equal the current due date assigned to the invoice in receivables management.
52600	Parameter @I_vFreightTaxAmount does not equal the current freight tax amount assigned to the invoice in receivables management.
52601	Parameter @I_vMiscTaxAmount does not equal the current miscellaneous tax amount assigned to the invoice in receivables management.
52602	Parameter @I_vTaxAmount does not equal the current tax amount assigned to the invoice in receivables management.
52603	Parameter @I_vTaxAmount1 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52604	Parameter @I_vTaxAmount2 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52605	Parameter @I_vTaxAmount3 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52606	Parameter @I_vTaxAmount4 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52607	Parameter @I_vTaxDetailID1 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52608	Parameter @I_vTaxDetailID2 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52609	Parameter @I_vTaxDetailID3 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52610	Parameter @I_vTaxDetailID4 does not equal the current tax amount assigned to the invoice in RM10301 or RM30601.
52611	Parameter @I_vDocumentAmount does not equal the current transaction amount assigned to the invoice in receivables management.
52612	Parameter @I_vSubtotal does not equal the current sales amount assigned to the invoice in receivables management.
52613	Parameter @I_vCurrencyID does not equal the current currency id assigned to the invoice in receivables management.
52614	Parameter @I_vPostDate does not equal the current post date assigned to the invoice in receivables management.