AR Received Payment v2

From AutoCount Resource Center
Jump to navigation Jump to search

Rules in AR Payment

  1. Payment Knockoff Date must be greater than the Payment Date.
  2. Payment net total must be greater than 0.
  3. Payment net total must be the sum of Payment Amount in Payment Detail
  4. Total of knockoff Amount must not exceed the sum of Payment Amount.
  5. Payment Method is created in General Maintenance | Payment Method Maintenance.

References of AutoCount Accounting version 2.0

AutoCount.Accounting.dll
AutoCount.Accounting.UI.dll
AutoCount.dll
AutoCount.MainEntry.dll
AutoCount.UI.dll
AutoCount.ARAP.dll

AR Payment API Usage

New

public void NewARPayment(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.ARAP.ARPayment.ARPaymentDataAccess cmd =
        AutoCount.ARAP.ARPayment.ARPaymentDataAccess.Create(userSession, userSession.DBSetting);
    AutoCount.ARAP.ARPayment.ARPaymentEntity doc = cmd.NewARPayment();
    //If you want to set your own Payment Voucher number, uncomment the next line, otherwise, the system will use running number.
    //doc.DocNo = “RC-0001″;
    doc.DebtorCode = "300-A001";

    // Add one payment detail
    AutoCount.ARAP.ARPayment.ARPaymentDTLEntity paymentDetail = doc.NewDetail();
    paymentDetail.PaymentMethod = "CASH";
    paymentDetail.PaymentAmt = 100;
    paymentDetail.ChequeNo = "MBB 123456";
    //Knockoff Invoice
    doc.KnockOff(AutoCount.Document.DocumentType.ARInvoice, "IV-0001", 100);

    cmd.SaveARPayment(doc, userSession.LoginUserID);
}

Edit

public void EditARPayment(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.ARAP.ARPayment.ARPaymentDataAccess cmd =
        AutoCount.ARAP.ARPayment.ARPaymentDataAccess.Create(userSession, userSession.DBSetting);
    AutoCount.ARAP.ARPayment.ARPaymentEntity doc = cmd.GetARPayment("RC-0001");
    //If doc (arPayment) is null, doc (arPayment) does not exist in AR Payment;
    //Then exit this function
    if (doc == null)
        return;

    doc.ClearDetails();
    AutoCount.ARAP.ARPayment.ARPaymentDTLEntity paymentDetail = doc.NewDetail();
    paymentDetail.PaymentMethod = "CARD";
    paymentDetail.PaymentAmt = 600;
    cmd.SaveARPayment(doc, userSession.LoginUserID);
}

Cancel

private void CancelARPayment(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.ARAP.ARPayment.ARPaymentDataAccess cmd =
        AutoCount.ARAP.ARPayment.ARPaymentDataAccess.Create(userSession, userSession.DBSetting);
    cmd.CancelARPayment("RC-0001", userSession.LoginUserID);
}

Delete

private void DeleteARPayment(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.ARAP.ARPayment.ARPaymentDataAccess cmd =
        AutoCount.ARAP.ARPayment.ARPaymentDataAccess.Create(userSession, userSession.DBSetting);
    cmd.DeleteARPayment("RC-0001", userSession.LoginUserID);
}



Sample Code with Data for Testing

This sample code provides the example of creating new AR Payment with tested data.

Source Data (Example for reference Only)

Source Data is implemented to hold data that is to be updated into AutoCount Accounting.
The Source Data designed here is for reference only.
You may either create your own data source, or read from your database and assign value to transaction/document of AutoCount Accounting without source data.
public class ARPaymentSource
{
    public string DebtorCode { get; set; }
    public string DocumentNo { get; set; }
    public string ReceiptNo2 { get; set; }
    public DateTime DocumentDate { get; set; } = DateTime.Today.Date;
    public string Description { get; set; }
    public string DepositMethod { get; set; }

    //PaymentCurrencyCode will be the currency code of Debtor's Account.
    //Need to define only when PaymentCurrencyCode is different from Debtor's Account Currency
    public string PaymentCurrencyCode { get; set; }

    //Require PaymentToHomeCurrencyRate,
    //when PaymentCurrencyCode is in Foreign Currency 
    public decimal? PaymentToHomeCurrencyRate { get; set; }

    //Require PaymentToDebtorCurrencyRate,
    //when PaymentCurrencyCode is different from Debtor CurrencyCode
    public decimal? PaymentToDebtorCurrencyRate { get; set; }

    public string Project { get; set; }
    public string Department { get; set; }

    public List<ARPaymentDetailSource> PaymentDetail = new List<ARPaymentDetailSource>();
    public List<PaymentKnockoffSource> PaymentKnockoff = new List<PaymentKnockoffSource>();
}

public class ARPaymentDetailSource
{
    public string PaymentMethod { get; set; }
    public string ChequeNo { get; set; }
    public decimal PaymentAmount { get; set; }
    public decimal? BankCharge { get; set; }
    public string BankChargeTaxCode { get; set; }
    public string BankChargeBillNoForGst { get; set; }
    public string PaymentBy { get; set; }
    //If this cheque is returned/bounced cheque
    //Set the returned/bounced date. Otherwise it is null
    public DateTime? ReturnChequeDate { get; set; }
}

public class PaymentKnockoffSource
{
    //Document Type of ARPayment knockoff
    public const string ARInvoiceDocType = AutoCount.Document.DocumentType.ARInvoice;
    public const string ARDebitNoteDocType = AutoCount.Document.DocumentType.ARDN;

    //Must assign with valid document type
    //in this class, you may find both possible document type for ARPayment Knockoff
    //(1) ARInvoiceDocType, and (2) ARDebitNoteDocType
    public string DocType { get; set; }

    //The DocNo must already exist in the respective document type
    public string DocNo { get; set; }

    //The amount to be used to knockoff invoice,
    //the total must not be more than sum of Payment Amount
    public decimal Amount { get; set; }

    //When knockoff date is null,
    //system will use Payment Date as knockoff date
    public DateTime? Date { get; set; }
}

Create New ARPayment

public void NewARPayment(ARPaymentSource source, AutoCount.Authentication.UserSession userSession)
{
    //Get the login user id
    string userID = userSession.LoginUserID;

    //Create command object of ARPayment
    AutoCount.ARAP.ARPayment.ARPaymentDataAccess cmd =
        AutoCount.ARAP.ARPayment.ARPaymentDataAccess.Create(userSession, userSession.DBSetting);
    //Create a new ARPayment transaction
    AutoCount.ARAP.ARPayment.ARPaymentEntity doc = cmd.NewARPayment();

    //Assign value to master table
    doc.DebtorCode = source.DebtorCode;
    doc.DocNo = source.DocumentNo ?? doc.DocNo;
    doc.DocNo2 = source.ReceiptNo2 ?? doc.DocNo2;
    doc.DocDate = source.DocumentDate;
    doc.CurrencyCode = source.PaymentCurrencyCode ?? doc.CurrencyCode;
    doc.ToHomeRate = source.PaymentToHomeCurrencyRate ?? doc.ToHomeRate;
    doc.ToDebtorRate = source.PaymentToDebtorCurrencyRate ?? doc.ToDebtorRate;
    doc.ProjNo = source.Project;
    doc.DeptNo = source.Department;

    //Loop and assign value to payment detail
    source.PaymentDetail.ForEach(s => AddARPaymentDetail(s, doc.NewDetail));

    //Knockoff document
    foreach (PaymentKnockoffSource knockoff in source.PaymentKnockoff)
    {
        if (knockoff.Date.HasValue)
        {
            doc.KnockOff(knockoff.DocType, knockoff.DocNo, knockoff.Amount, knockoff.Date.Value);
        }
        else
        {
            //If Knockoff date is not defined, system will assign Payment Date to Knockoff Date
            doc.KnockOff(knockoff.DocType, knockoff.DocNo, knockoff.Amount);
        }
    }

    try
    {
        cmd.SaveARPayment(doc, userID);
        //BCE.Application.AppMessage.ShowMessage(string.Format("{0} is created.", doc.DocNo));
    }
    catch (AutoCount.AppException ex)
    {
        //BCE.Application.AppMessage.ShowMessage(ex.Message);
        //log error
    }
}

Add New AR Payment Detail

private void AddARPaymentDetail(ARPaymentDetailSource source, Func<AutoCount.ARAP.ARPayment.ARPaymentDTLEntity> addPaymentDetail)
{
    AutoCount.ARAP.ARPayment.ARPaymentDTLEntity dtl = addPaymentDetail();
    dtl.PaymentMethod = source.PaymentMethod;
    dtl.ChequeNo = source.ChequeNo ?? dtl.ChequeNo;
    dtl.PaymentAmt = source.PaymentAmount;
    dtl.BankCharge = source.BankCharge ?? dtl.BankCharge;
    dtl.BankChargeTaxType = source.BankChargeTaxCode ?? dtl.BankChargeTaxType;
    dtl.BankChargeTaxRefNo = source.BankChargeBillNoForGst ?? dtl.BankChargeTaxRefNo;
    dtl.PaymentBy = source.PaymentBy ?? source.PaymentBy;

    if (source.ReturnChequeDate.HasValue)
    {
        dtl.IsRCHQ = true;
        dtl.RCHQDate = source.ReturnChequeDate.Value;
    }
}

Example of AR Payment in Home currency only

Test Data Result Screenshot

V2ProgrammerNewARPayment0.png

Test Data

public void MainEntry(AutoCount.Authentication.UserSession userSession)
{
    ARPaymentSource source = new ARPaymentSource()
    {
        //Home Currency Debtor, payment with home currency
        DebtorCode = "300-A001",
        Description = "Payment Received",
        DocumentDate = new DateTime(2018, 5, 17),
    };

    source.PaymentDetail.Add(new ARPaymentDetailSource()
    {
        PaymentMethod = "BANK",
        ChequeNo = "CHQ00012",
        PaymentAmount = 100,
        BankCharge = 0.50M
    });

    //Document type is required for document knockoff
    source.PaymentKnockoff.Add(new PaymentKnockoffSource()
    {
        DocType = PaymentKnockoffSource.ARInvoiceDocType,
        DocNo = "I-000015",
        Amount = 45
    });
    source.PaymentKnockoff.Add(new PaymentKnockoffSource()
    {
        DocType = PaymentKnockoffSource.ARInvoiceDocType,
        DocNo = "I-000018",
        Amount = 55
    });

    //Create New ARPayment in AutoCount Accounting
    NewARPayment(source, userSession);
}

Example of Foreign Customer and payment in customer currency

Test Data Result Screenshot

V2ProgrammerNewARPayment1a.png
A payment of SGD100.00 knockoff 2 outstanding invoices, which both invoices currency rate is 3.2.

V2ProgrammerNewARPayment2.png
AutoCount Accounting auto generate Loss in foreign currency transaction.
This is because the currency rate when invoice was issued is 3.2, whereas the payment currency rate is 3.1.

Test Data

public void MainEntry(AutoCount.Authentication.UserSession userSession)
{
    ARPaymentSource source = new ARPaymentSource()
    {
        //Singapore customer, payment in Singapore Dollar
        DebtorCode = "300-S001",
        Description = "Payment Received - Test Data",
        DocumentDate = new DateTime(2018, 5, 18),

        //If Payment Currency is same as Debtor Currency,
        //"PaymentCurrencyCode" can be excluded
        PaymentCurrencyCode = "SGD",
        PaymentToHomeCurrencyRate = 3.1M,
    };

    source.PaymentDetail.Add(new ARPaymentDetailSource()
    {
        PaymentMethod = "BANK",
        ChequeNo = "SGB0009",
        PaymentAmount = 100,    //Currency in SGD
        BankCharge = 0.50M      //Bank Charge is always in Local currency
    });

    //Document type is required for document knockoff
    source.PaymentKnockoff.Add(new PaymentKnockoffSource()
    {
        DocType = PaymentKnockoffSource.ARInvoiceDocType,
        DocNo = "I-000002",
        Amount = 70
    });
    source.PaymentKnockoff.Add(new PaymentKnockoffSource()
    {
        DocType = PaymentKnockoffSource.ARInvoiceDocType,
        DocNo = "I-000003",
        Amount = 30
    });

    NewARPayment(source, userSession);
}


See Also

AutoCount Accounting Account API
AR AP
Transactions Version Transactions Version
AR Debtor (Customer) 1.8, 1.9
2.0
AP Creditor (Supplier) 1.8, 1.9
2.0
AR Invoice 1.8, 1.9
2.0
AP Invoice 1.8, 1.9
2.0
AR Received Payment 1.8, 1.9
2.0
AP Payment 1.8, 1.9
2.0
AR Debit Note 1.8, 1.9
2.0
AP Debit Note 1.8, 1.9
2.0
AR Credit Note 1.8, 1.9
2.0
AP Credit Note 1.8, 1.9
2.0
AR Refund 1.8, 1.9
2.0
AP Refund 1.8, 1.9
2.0
AR Deposit 1.8, 1.9
2.0
AP Deposit 1.8, 1.9
2.0
AR Deposit - Create New or Update
with Refund & Forfeit
1.8, 1.9
2.0
A/R and A/P Contra Entry 1.8, 1.9
2.0

Go to menu

IconAC81.png Go to top
ProgrammerGo.jpg Resources For AutoCount Software Developers