|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: |
ALTER PROCEDURE [dbo].[usp_ATFT_FIN_setTransactionsPaid]
-- Add the parameters for the stored procedure here
@companyID INT
,@accountparentID INT
,@accountsubID INT
,@checkvalue DECIMAL(18,2)
,@strInvoiceIDs VARCHAR(100)
,@description VARCHAR(250)
,@documentID INT
,@TransactionNumber INT
,@TransactionDate DATETIME
AS
SET NOCOUNT ON;
BEGIN TRANSACTION
DECLARE @err INT
SET @err = @@ERROR
-- insert bank account debit transaction
INSERT INTO
dbo.tbl_FIN_Transaction
(
companyID
,ClientID
,TransactionNumber
,TransactionName
,TransactionDate
,AccountParentNumber
,AccountSubNumber
,DocumentID
,DocumentType
,Debit
,Credit
)
VALUES
(
@companyID
,0
,@TransactionNumber
,@description
,@TransactionDate
,@AccountParentID
,@AccountSubID
,@DocumentID
,'JNL'
,@checkvalue
,0
)
-- insert individual A/R transactions per invoice
-- set invoices to isPaid = 1
-- comma separated string with invoiceID's
DECLARE @values TABLE (id INT)
DECLARE @id INT
INSERT INTO @values (id ) SELECT VALUE FROM ufn_ParmsToList(@strInvoiceIDs)
WHILE @@rowcount > 0
BEGIN
SELECT TOP 1 @id = id FROM @values
IF @@rowcount > 0
BEGIN
EXEC usp_ATFT_FIN_setInvoicesPaid @id ,@TransactionNumber,@description, @accountsubID, @checkvalue, @companyID
END
DELETE @values WHERE id = @id
END
IF @err <> 0
BEGIN
ROLLBACK TRANSACTION
END
SELECT @err AS intError
COMMIT TRANSACTION
|
Advertisement
| Hall of Fame |