/// <summary>
/// A payment made to a supplier needs to be reversed.
/// It's done by creating and posting a set of matching "negatives" -
/// In the simplest case this is a single credit note matching an invoice
/// but it could be more complex. These negative documents are payed using
/// a standard call to PostAPPayments.
///
/// After the reversal, I'll also create and post new copies of all
/// the invoices / credit notes that made up the original payment.
/// </summary>
/// <param name="ALedgerNumber"></param>
/// <param name="APaymentNumber"></param>
public void ReversePayment(Int32 ALedgerNumber, Int32 APaymentNumber)
{
AccountsPayableTDS TempDS = TRemote.MFinance.AP.WebConnectors.LoadAPPayment(ALedgerNumber, APaymentNumber);
if (TempDS.AApPayment.Rows.Count == 0) // Invalid Payment number?
{
MessageBox.Show(Catalog.GetString("The referenced payment Connot be loaded."), Catalog.GetString("Error"));
return;
}
TempDS.AApDocument.DefaultView.Sort = AApDocumentTable.GetApDocumentIdDBName();
//
// First I'll check that the amounts add up:
//
Decimal PaidDocumentsTotal = 0.0m;
foreach (AApDocumentPaymentRow PaymentRow in TempDS.AApDocumentPayment.Rows)
{
Int32 DocIdx = TempDS.AApDocument.DefaultView.Find(PaymentRow.ApDocumentId);
AApDocumentRow DocumentRow = TempDS.AApDocument[DocIdx];
if (DocumentRow.CreditNoteFlag)
{
PaidDocumentsTotal -= DocumentRow.TotalAmount;
}
else
{
PaidDocumentsTotal += DocumentRow.TotalAmount;
}
}
//
// If this is a partial payment, I can't deal with that here...
//
if (PaidDocumentsTotal != TempDS.AApPayment[0].Amount)
{
String ErrorMsg =
String.Format(Catalog.GetString(
"This Payment cannot be reversed automatically because the total amount of the referenced documents ({0:n2} {1}) differs from the amount in the payment ({2:n2} {3})."),
PaidDocumentsTotal, TempDS.AApSupplier[0].CurrencyCode, TempDS.AApPayment[0].Amount, TempDS.AApSupplier[0].CurrencyCode);
MessageBox.Show(ErrorMsg, Catalog.GetString("Reverse Payment"), MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// Find out if this payment was already reversed,
// because if it was, perhaps the user doesn't really want to
// reverse it again?
this.Cursor = Cursors.WaitCursor;
if (TRemote.MFinance.AP.WebConnectors.WasThisPaymentReversed(ALedgerNumber, APaymentNumber))
{
this.Cursor = Cursors.Default;
MessageBox.Show(Catalog.GetString("Cannot reverse Payment - there is already a matching reverse transaction."),
Catalog.GetString("Reverse Payment"), MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
this.Cursor = Cursors.Default;
//
// Ask the user to confirm reversal of this payment
//
String PaymentMsg = Catalog.GetString("Do you want to reverse this payment?");
PaymentMsg += ("\r\n" + String.Format("Payment made {0} to {1}\r\n\r\nRelated invoices:",
TDate.DateTimeToLongDateString2(TempDS.AApPayment[0].PaymentDate.Value), TempDS.PPartner[0].PartnerShortName));
foreach (AApDocumentPaymentRow PaymentRow in TempDS.AApDocumentPayment.Rows)
{
Int32 DocIdx = TempDS.AApDocument.DefaultView.Find(PaymentRow.ApDocumentId);
AApDocumentRow DocumentRow = TempDS.AApDocument[DocIdx];
PaymentMsg += ("\r\n" + String.Format(" {2} ({3}) {0:n2} {1}",
DocumentRow.TotalAmount, TempDS.AApSupplier[0].CurrencyCode, DocumentRow.DocumentCode, DocumentRow.Reference));
}
PaymentMsg += ("\r\n\r\n" + String.Format("Total payment {0:n2} {1}", TempDS.AApPayment[0].Amount, TempDS.AApSupplier[0].CurrencyCode));
DialogResult YesNo = MessageBox.Show(PaymentMsg, Catalog.GetString("Reverse Payment"), MessageBoxButtons.YesNo);
if (YesNo == DialogResult.No)
{
return;
}
TDlgGLEnterDateEffective dateEffectiveDialog = new TDlgGLEnterDateEffective(
ALedgerNumber,
Catalog.GetString("Select posting date"),
Catalog.GetString("The date effective for the reversal") + ":");
if (dateEffectiveDialog.ShowDialog() != DialogResult.OK)
{
MessageBox.Show(Catalog.GetString("Reversal was cancelled."), Catalog.GetString("Reverse Payment"),
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DateTime PostingDate = dateEffectiveDialog.SelectedDate;
TVerificationResultCollection Verifications;
this.Cursor = Cursors.WaitCursor;
if (TRemote.MFinance.AP.WebConnectors.ReversePayment(ALedgerNumber, APaymentNumber, PostingDate, out Verifications))
{
this.Cursor = Cursors.Default;
// TODO: print reports on successfully posted batch
MessageBox.Show(Catalog.GetString("The AP payment has been reversed."), Catalog.GetString("Reverse Payment"));
TFormsMessage broadcastMessage = new TFormsMessage(TFormsMessageClassEnum.mcAPTransactionChanged);
broadcastMessage.SetMessageDataAPTransaction(String.Empty);
TFormsList.GFormsList.BroadcastFormMessage(broadcastMessage);
}
else
{
this.Cursor = Cursors.Default;
string ErrorMessages = String.Empty;
foreach (TVerificationResult verif in Verifications)
{
ErrorMessages += "[" + verif.ResultContext + "] " +
verif.ResultTextCaption + ": " +
verif.ResultText + Environment.NewLine;
}
System.Windows.Forms.MessageBox.Show(ErrorMessages, Catalog.GetString("Reverse Payment Failed"));
}
}
private void MakePayment(object sender, EventArgs e)
{
FSelectedDocumentRow.Amount = Decimal.Parse(txtAmountToPay.Text);
FSelectedPaymentRow.BankAccount = cmbBankAccount.GetSelectedString();
AccountsPayableTDSAApPaymentTable AApPayment = FMainDS.AApPayment;
//
// I want to check whether the user is paying more than the due amount on any of these payments...
//
foreach (AccountsPayableTDSAApPaymentRow PaymentRow in AApPayment.Rows)
{
FMainDS.AApDocumentPayment.DefaultView.RowFilter = String.Format("{0}={1}",
AApDocumentPaymentTable.GetPaymentNumberDBName(), PaymentRow.PaymentNumber);
foreach (DataRowView rv in FMainDS.AApDocumentPayment.DefaultView)
{
AccountsPayableTDSAApDocumentPaymentRow DocPaymentRow = (AccountsPayableTDSAApDocumentPaymentRow)rv.Row;
Boolean overPayment = (DocPaymentRow.DocType == "INVOICE") ?
(DocPaymentRow.Amount > DocPaymentRow.InvoiceTotal) : (DocPaymentRow.Amount < DocPaymentRow.InvoiceTotal);
if (overPayment)
{
String strMessage =
String.Format(Catalog.GetString(
"Payment of {0} {1} to {2}: Payment cannot be more than the due amount."),
StringHelper.FormatUsingCurrencyCode(DocPaymentRow.Amount, PaymentRow.CurrencyCode),
PaymentRow.CurrencyCode, PaymentRow.SupplierName);
System.Windows.Forms.MessageBox.Show(strMessage, Catalog.GetString("OverPayment"));
return;
}
}
}
TDlgGLEnterDateEffective dateEffectiveDialog = new TDlgGLEnterDateEffective(
FMainDS.AApDocument[0].LedgerNumber,
Catalog.GetString("Select payment date"),
Catalog.GetString("The date effective for the payment") + ":");
if (dateEffectiveDialog.ShowDialog() != DialogResult.OK)
{
MessageBox.Show(Catalog.GetString("The payment was cancelled."), Catalog.GetString(
"No Success"), MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DateTime PaymentDate = dateEffectiveDialog.SelectedDate;
TVerificationResultCollection Verifications;
this.Cursor = Cursors.WaitCursor;
if (!TRemote.MFinance.AP.WebConnectors.PostAPPayments(
ref FMainDS,
PaymentDate,
out Verifications))
{
this.Cursor = Cursors.Default;
string ErrorMessages = String.Empty;
foreach (TVerificationResult verif in Verifications)
{
ErrorMessages += "[" + verif.ResultContext + "] " +
verif.ResultTextCaption + ": " +
verif.ResultText + Environment.NewLine;
}
System.Windows.Forms.MessageBox.Show(ErrorMessages, Catalog.GetString("Payment failed"));
}
else
{
this.Cursor = Cursors.Default;
PrintPaymentReport(sender, e);
PrintRemittanceAdvice();
// TODO: show posting register of GL Batch?
// After the payments screen, The status of this document may have changed.
TFormsMessage broadcastMessage = new TFormsMessage(TFormsMessageClassEnum.mcAPTransactionChanged);
broadcastMessage.SetMessageDataAPTransaction(String.Empty);
TFormsList.GFormsList.BroadcastFormMessage(broadcastMessage);
Close();
}
}
/// <summary>
/// When this document is saved in the database, I can check whether
/// my calling form should be updated.
/// </summary>
/// <param name="Sender"></param>
/// <param name="e"></param>
private void OnDataSaved(object Sender, TDataSavedEventArgs e)
{
if (e.Success)
{
TFormsMessage broadcastMessage = new TFormsMessage(TFormsMessageClassEnum.mcAPTransactionChanged);
broadcastMessage.SetMessageDataAPTransaction(txtSupplierName.Text);
TFormsList.GFormsList.BroadcastFormMessage(broadcastMessage);
}
}
/// <summary>
/// Approve Document for posting.
/// See very similar function in TFrmAPSupplierTransactions
/// </summary>
///
private void ApproveDocument(object sender, EventArgs e)
{
if (FPetraUtilsObject.HasChanges)
{
MessageBox.Show(Catalog.GetString("Document should be saved before approving."), Catalog.GetString(
"Approve Document"), MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
List <Int32>DocsList = new List <int>();
DocsList.Add(FMainDS.AApDocument[0].ApDocumentId);
this.Cursor = Cursors.WaitCursor;
TVerificationResultCollection verificationResult;
string MsgTitle = Catalog.GetString("Document Approval");
if (TRemote.MFinance.AP.WebConnectors.ApproveAPDocuments(FMainDS.AApDocument[0].LedgerNumber, DocsList, out verificationResult))
{
this.Cursor = Cursors.Default;
MessageBox.Show(Catalog.GetString("Document has been approved."), MsgTitle);
FMainDS.AApDocument[0].DocumentStatus = MFinanceConstants.AP_DOCUMENT_APPROVED; // The "changed" light isn't lit by this, because the change
// already took place on the server.
EnableControls();
//
// Also refresh the opener
TFormsMessage broadcastMessage = new TFormsMessage(TFormsMessageClassEnum.mcAPTransactionChanged);
broadcastMessage.SetMessageDataAPTransaction(lblSupplierName.Text);
TFormsList.GFormsList.BroadcastFormMessage(broadcastMessage);
}
else
{
this.Cursor = Cursors.Default;
MessageBox.Show(verificationResult.BuildVerificationResultString(), MsgTitle);
}
}
/// <summary>
/// Post document as a GL Batch
/// See very similar function in TFrmAPSupplierTransactions
/// </summary>
private void PostDocument(object sender, EventArgs e)
{
if (FPetraUtilsObject.HasChanges)
{
MessageBox.Show(Catalog.GetString("Document should be saved before posting."), Catalog.GetString(
"Post Document"), MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
GetDataFromControls(FMainDS.AApDocument[0]);
// TODO: make sure that there are uptodate exchange rates
if (!ApDocumentCanPost(FMainDS, FMainDS.AApDocument[0]))
{
return;
}
List <Int32>TaggedDocuments = new List <Int32>();
TaggedDocuments.Add(FMainDS.AApDocument[0].ApDocumentId);
if (PostApDocumentList(FMainDS, FMainDS.AApDocument[0].LedgerNumber, TaggedDocuments, this))
{
// TODO: print reports on successfully posted batch
MessageBox.Show(Catalog.GetString("The AP document has been posted successfully!"));
//
// Refresh by re-loading the document from the server
Int32 DocumentId = FMainDS.AApDocument[0].ApDocumentId;
FMainDS.Clear();
FPreviouslySelectedDetailRow = null;
LoadAApDocument(FDocumentLedgerNumber, DocumentId);
//
// Also refresh the opener?
TFormsMessage broadcastMessage = new TFormsMessage(TFormsMessageClassEnum.mcAPTransactionChanged);
broadcastMessage.SetMessageDataAPTransaction(lblSupplierName.Text);
TFormsList.GFormsList.BroadcastFormMessage(broadcastMessage);
}
}
