BillsApplyCredit
Applies the vendor credits from excess vendor payments to a bill.
Execute
Import your bank/credit card feeds into your account:
INSERT INTO BillsApplyCredit#TEMP (BillPaymentsPaymentID, BillPaymentsAmountApplied) VALUES ('3255827000000150156', '600')
INSERT INTO BillsApplyCredit#TEMP (ApplyVendorCreditsVendorCreditId, ApplyVendorCreditsAmountApplied) VALUES ('3255827000000150156', '600')
EXECUTE ApplyVendorCreditsAmountApplied Id = '3255827000000150152', BillPayments = BillsApplyCredit#TEMP
EXECUTE ApplyVendorCreditsAmountApplied Id = '3255827000000150152', BillPaymentsPaymentId = '3255827000000099218', BillPaymentsAmountApplied = 900
Input
| Name | Type | Required | Description |
| Id | String | True | Id of categories like Invoices, Purchase Orders, Bills, SalesOrders. |
| BillPayments | String | False | Bill Payments |
| ApplyVendorCredits | String | False | Details of vendor credit for which credit has to be applied |
| BillPaymentsPaymentId | String | False | Id of the Payment |
| BillPaymentsAmountApplied | String | False | Amount applied to the bill. |
| ApplyVendorCreditsVendorCreditId | String | False | Id of the Vendor Credit |
| ApplyVendorCreditsAmountApplied | String | False | Amount applied to the bill. |
Result Set Columns
| Name | Type | Description |
| Status | String | Stored procedure execution status. |