AP Invoice: Difference between revisions

4,074 bytes added ,  5 years ago
no edit summary
(Created page with "==Under Construction== ===Rules in APInvoice=== # AccNo (Purchase A/C) cannot be empty or null. # AccNo (Purchase A/C) cannot be Creditor Account No. # NetTotal cannot be in...")
 
No edit summary
Line 15:
<br />
==API Usage==
===New AP Invoice===
<syntaxhighlight lang="csharp">
public void NewAPInvoiceEntry(BCE.Data.DBSetting dbSetting)
{
string userID = BCE.AutoCount.Authentication.UserAuthentication.GetOrCreate(dbSetting).LoginUserID;
BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess cmd = BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess.Create(dbSetting);
BCE.AutoCount.ARAP.APInvoice.APInvoiceEntity doc = cmd.NewAPInvoice();
BCE.AutoCount.ARAP.APInvoice.APInvoiceDTLEntity dtl = null;
 
doc.CreditorCode = "400-X001";
doc.Description = "Purchase Generated";
doc.DocNo = "<<New>>";
doc.DocDate = new DateTime(2018, 5, 28);
doc.PurchaseAgent = "TOM";
doc.JournalType = "PURCHASE";
 
doc.RoundingMethod = BCE.AutoCount.Document.DocumentRoundingMethod.LineByLine_Ver2;
//Document Level Inclusive Tax
doc.InclusiveTax = true;
 
//Add two lines of detail
dtl = doc.NewDetail();
dtl.AccNo = "700-1010";
dtl.Description = "Raw Material Metal";
dtl.ProjNo = DBNull.Value;
dtl.Amount = 1000.00M;
 
dtl = doc.NewDetail();
dtl.AccNo = "700-1010";
dtl.Description = "Process Cost";
dtl.ProjNo = DBNull.Value;
dtl.Amount = 150.00M;
 
try
{
cmd.SaveAPInvoice(doc, userID);
//log success
//BCE.Application.AppMessage.ShowMessage(string.Format("{0} is created.", doc.DocNo));
}
catch (BCE.Application.AppException ex)
{
//log ex.Message
//BCE.Application.AppMessage.ShowMessage(ex.Message);
}
}
</syntaxhighlight>
 
===Edit AP Invoice===
<syntaxhighlight lang="csharp">
public void EditAPInvoiceEntry(BCE.Data.DBSetting dbSetting)
{
string userID = BCE.AutoCount.Authentication.UserAuthentication.GetOrCreate(dbSetting).LoginUserID;
BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess cmd =
BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess.Create(dbSetting);
 
BCE.AutoCount.ARAP.APInvoice.APInvoiceEntity doc = cmd.GetAPInvoice("PI-000001");
BCE.AutoCount.ARAP.APInvoice.APInvoiceDTLEntity dtl = null;
 
//if this AP Invoice has been knockoff(offset) with payment or credit note,
//Changing of CreditorCode is not allowed.
//Therefore, when such case arise, it is advised to issue Credit Note and issue a new AP Invoice
//doc.CreditorCode = "400-X001";
 
doc.Description = "Purchase Generated";
doc.DocDate = new DateTime(2018, 5, 28);
doc.PurchaseAgent = "TOM";
doc.JournalType = "PURCHASE";
 
doc.RoundingMethod = BCE.AutoCount.Document.DocumentRoundingMethod.LineByLine_Ver2;
//Document Level Inclusive Tax
doc.InclusiveTax = true;
 
doc.ClearDetails();
 
//Add two lines of detail
dtl = doc.NewDetail();
dtl.AccNo = "700-1010";
dtl.Description = "Raw Material Metal";
dtl.ProjNo = DBNull.Value;
dtl.Amount = 1000.00M;
 
dtl = doc.NewDetail();
dtl.AccNo = "700-1010";
dtl.Description = "Process Cost";
dtl.ProjNo = "Project A";
dtl.Amount = 150.00M;
 
try
{
cmd.SaveAPInvoice(doc, userID);
//log success
//BCE.Application.AppMessage.ShowMessage(string.Format("{0} is created.", doc.DocNo));
}
catch (BCE.Application.AppException ex)
{
//log ex.Message
//BCE.Application.AppMessage.ShowMessage(ex.Message);
}
}
</syntaxhighlight>
 
===Cancel (void) AP Invoice===
<syntaxhighlight lang="csharp">
public void CancelAPInvoice(BCE.Data.DBSetting dbSetting)
{
string userID = BCE.AutoCount.Authentication.UserAuthentication.GetOrCreate(dbSetting).LoginUserID;
BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess cmd =
BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess.Create(dbSetting);
 
try
{
cmd.CancelAPInvoice("PI-000001", userID);
}
catch (BCE.Application.AppException ex)
{
BCE.Application.AppMessage.ShowMessage(ex.Message);
}
}
</syntaxhighlight>
 
===Delete AP Invoice===
<syntaxhighlight lang="csharp">
public void DeleteAPInvoice(BCE.Data.DBSetting dbSetting)
{
string userID = BCE.AutoCount.Authentication.UserAuthentication.GetOrCreate(dbSetting).LoginUserID;
BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess cmd =
BCE.AutoCount.ARAP.APInvoice.APInvoiceDataAccess.Create(dbSetting);
 
try
{
cmd.DeleteAPInvoice("PI-000001");
}
catch (BCE.Application.AppException ex)
{
BCE.Application.AppMessage.ShowMessage(ex.Message);
}
}
</syntaxhighlight>
 
==Sample==
Line 53 ⟶ 190:
 
===Implementation===
[[File:GenerateSaleInAR.PNG|link=]]
<syntaxhighlight lang="csharp" highlight="16,17">
public void MainEntry(BCE.Data.DBSetting dbSetting)