protected void AddE052Exception() { VITAPExceptions objException = new VITAPExceptions(); objException.ActNum = exception.ACT; if (!String.IsNullOrWhiteSpace(exception.INV_KEY_ID)) { objException.Inv_key_id = exception.INV_KEY_ID; } else if (!String.IsNullOrWhiteSpace(exception.RR_ID)) { objException.Rr_id = exception.RR_ID; } else if (!String.IsNullOrWhiteSpace(exception.PO_ID)) { objException.Po_id = exception.PO_ID; } else if (!String.IsNullOrWhiteSpace(exception.AE_ID)) { objException.Ae_id = exception.AE_ID; } objException.Err_code = "E052"; objException.Ex_memo = "Paper Queue - Other System"; objException.Ex_memo2 = NewNote; objException.PrepCode = PrepCode; objException.Ba = exception.BA; objException.Orgcode = exception.ORGCODE; objException.PoDocType = exception.PODOCTYPE; objException.Updstatus = "F"; objException.AddException(); }
private void AddException(string allprocess, string err_code, string prepCode) { var objException = new VITAPExceptions(); objException.ActNum = exception.ACT; objException.Rr_id = exception.RR_ID; objException.Po_id = exception.PO_ID; objException.Inv_key_id = exception.INV_KEY_ID; objException.Err_code = err_code; objException.Allprocess = allprocess; objException.PrepCode = prepCode; objException.AddException(); }
/// <summary> /// Handles 036 exceptions /// Only adds an E052 exception /// It was updating FoxPro tables, but that has been removed /// </summary> private void Exception_036(String PrepCode) { //Need the Add Exception code here to add and E052 //This was updating the foxpro tables (Invoice, RR, ExpenseAccruals tables), and code has been removed? // add an E052 exception var objException = new VITAPExceptions(); objException.ActNum = exception.ACT; if (exception.ERR_CODE.Left(1) == "P") { objException.Inv_key_id = exception.INV_KEY_ID; } objException.Err_code = "E052"; objException.Ex_memo = "Paper Queue - Other system"; objException.Ex_memo2 = NewNote; objException.PrepCode = PrepCode; objException.AddException(); }
public void ExceptionU049(string sNotesType) { NewNotes(); switch (sNotesType) { case "CORRECT": //Clear the U049 Exception var responsenotes = exception.RESPONSENOTES + "\r\n" + NewNote; UpdateException(exception, "C", notes.returnVal7, "Manager Accepts U044 Invoice Number Change", responsenotes, "Approved by Manager"); //Make a Custom Transhist Entry var strCuffMemo = "U044 Invoice Number Change Accepted by Manager."; InsertTranshist(exception, "", strCuffMemo, "Approved by Manager", PrepCode); //Update Invoice table as this invoice is now cleared var rtnInv = GetPegasysInvoiceByKey(exception.INV_KEY_ID); var fieldsToUpdate = new List <string> { "INV_STATUS", "PREVALIDATION_FL", "DATAENTRY_FL", "ERR_CODE" }; rtnInv.INV_STATUS = "KEYED"; rtnInv.PREVALIDATION_FL = "F"; rtnInv.DATAENTRY_FL = "T"; rtnInv.ERR_CODE = null; UpdatePegasysInvoice(rtnInv, fieldsToUpdate); break; case "RESET": //Clear the U049 Exception responsenotes = exception.RESPONSENOTES + "\r\n" + NewNote; UpdateException(exception, "C", notes.returnVal7, "Send back to U044", responsenotes, ""); //Make a Custom Transhist Entry strCuffMemo = "Re-establish U044 per Manager."; InsertTranshist(exception, "", strCuffMemo, "Back to U044 per Manager.", PrepCode); //Create U044 Exception VITAPExceptions objException = new VITAPExceptions(); objException.ActNum = exception.ACT; objException.Inv_key_id = exception.INV_KEY_ID; objException.Err_code = "U044"; objException.Updinvstatus = "T"; objException.Pdocnopo = PDocNo; objException.Ex_memo = "Re-establish U044 per Manager."; objException.PrepCode = PrepCode; objException.AddException(); break; } }
protected void ExceptionU043(string sNotesType, bool POExists, bool InvExists, bool RRExists) { var sFaxNotes = notes.returnVal7; var sResponseNotes = NewNote + "\r\n"; var sErr_Response = "C"; var sAllProcess = ""; var sEx_Memo2 = notes.returnVal3; var NewStatus = ""; if (POExists) { var rtnPO = GetPegasysPOFrmByKey(exception.PO_ID); if (rtnPO != null) { NewStatus = GetPOStatus(rtnPO); var fieldsToUpdate = new List <string> { "PO_STATUS", "ERR_CODE", "VERIFICATION_FL" }; rtnPO.PO_STATUS = "VERIFY"; rtnPO.ERR_CODE = null; if (!rtnPO.PO_ID.Contains("&") && !String.IsNullOrWhiteSpace(rtnPO.MODNO)) { rtnPO.VERIFICATION_FL = "F"; } UpdatePegasysPO(rtnPO, fieldsToUpdate); } else { //Create an error log here //INSERT INTO (m.vitapdata) + 'systemerrors'(po_id, err_date, errordesc, errormod) VALUES; //(THISFORM.r_po_id, DATE(),"Could not find PO to set status","correctde.m_u043") } } else if (InvExists) { if (exception.ERR_CODE == "U044" && sNotesType == "U049CRCT") { sEx_Memo2 = "Invoice Number Changed. Send to Manager for Approval"; sAllProcess = "Sent to Manager for Approval"; // Create a new Exception U049 var objException = new VITAPExceptions(); objException.ActNum = exception.ACT; objException.Inv_key_id = exception.INV_KEY_ID; objException.Err_code = "U049"; objException.Updinvstatus = "T"; objException.Pdocnopo = PDocNo; objException.Ex_memo = "Invoice Number changed on U044. To Manager for Approval."; objException.PrepCode = PrepCode; objException.AddException(); } else { var rtnInv = GetPegasysInvoiceByKey(exception.INV_KEY_ID); NewStatus = "MATCHREADY"; if (rtnInv != null) { NewStatus = GetInvStatus(rtnInv); } //Just in case there is a V299 on Hold var rtnExc = GetExceptionV299(); if (rtnExc.Count > 0) { var responsenotes = exception.RESPONSENOTES + "\r\n" + NewNote; UpdateException(exception, "H", notes.returnVal7, notes.returnVal3, responsenotes, sAllProcess); var fieldsToUpdate = new List <string> { "INV_STATUS", "LAST_STATUS", "ERR_CODE", "LASTTIME" }; rtnInv.INV_STATUS = "EXCEPTION"; rtnInv.LAST_STATUS = null; rtnInv.ERR_CODE = "V299"; rtnInv.LASTTIME = 0; UpdatePegasysInvoice(rtnInv, fieldsToUpdate); } else { var fieldsToUpdate = new List <string> { "INV_STATUS", "LAST_STATUS", "ERR_CODE", "LASTTIME" }; rtnInv.INV_STATUS = NewStatus; rtnInv.LAST_STATUS = null; rtnInv.ERR_CODE = null; rtnInv.LASTTIME = 0; UpdatePegasysInvoice(rtnInv, fieldsToUpdate); } } } else if (RRExists) { var rtnRR = GetPegasysRRByKey(exception.RR_ID); NewStatus = "MATCHREADY"; if (rtnRR != null) { NewStatus = GetRRStatus(rtnRR); } var fieldsToUpdate = new List <string> { "RR_STATUS", "ERR_CODE" }; rtnRR.RR_STATUS = NewStatus; rtnRR.ERR_CODE = null; UpdatePegasysRR(rtnRR, fieldsToUpdate); } UpdateException(exception, sErr_Response, sFaxNotes, sEx_Memo2, sResponseNotes, sAllProcess); }
protected void CreateExceptionU048(PEGASYSINVOICE InvQuery, PEGASYSPO_FRM POFrmQuery) { U048table = U048table.ToUpper(); var lGoU048 = true; if (U048table == "PEGINV") { //Updating PegasysInvoice ... var rtnInv = GetPegasysInvoiceByKey(exception.INV_KEY_ID); var fieldsToUpdate = new List <string> { "ERR_CODE" }; rtnInv.ERR_CODE = "U048"; UpdatePegasysInvoice(rtnInv, fieldsToUpdate); } else if (U048table == "PEGPO") { //Updating Pegasyspo_frm ... var rtnPO = GetPegasysPOFrmByKey(exception.PO_ID); var fieldsToUpdate = new List <string> { "ERR_CODE" }; UpdatePegasysPO(rtnPO, fieldsToUpdate); } else if (U048table == "PEGRR") { //Updating Pegasysrr_frm ... var rtnRR = GetPegasysRRByKey(exception.RR_ID); var fieldsToUpdate = new List <string> { "ERR_CODE" }; UpdatePegasysRR(rtnRR, fieldsToUpdate); } if (lGoU048 == true) { //Generating U048... var objException = new VITAPExceptions(); objException.ActNum = exception.ACT; if (U048table.InList("PEGPO,PO")) { objException.Po_id = exception.PO_ID; objException.Updpostatus = "T"; } if (U048table.InList("PEGRR,RR")) { objException.Rr_id = exception.RR_ID; objException.Updrrstatus = "T"; } if (U048table.InList("PEGINV,INVOICE")) { objException.Inv_key_id = exception.INV_KEY_ID; objException.Updinvstatus = "T"; } if (U048table == "EXPENSEACCRUAL") { objException.Ae_id = exception.AE_ID; objException.Updaestatus = "T"; } if (U048table.InList("PEGINV,PEGPO,PEGRR")) { objException.Ex_fund = exception.EX_FUND; objException.Vendname = exception.VENDNAME; if (U048table == "PEGINV" && InvQuery.AMOUNT != null) { objException.Poamount = (double)InvQuery.AMOUNT; } else if (U048table == "PEGPO" && POFrmQuery.AMOUNT != null) { objException.Poamount = (double)POFrmQuery.AMOUNT; } } objException.Ex_memo = notes.returnVal3; objException.Err_code = "U048"; objException.PrepCode = PrepCode; objException.AddException(); var responsenotes = exception.RESPONSENOTES + "\r\n" + NewNote; UpdateException(exception, "Q", notes.returnVal7, notes.returnVal3, responsenotes, ""); } }
public bool FinishCode(string Invoice, double InvAmount, double POAmount, string VendName, String PrepCode) { var TheResponse = "Q"; if (exception.ERR_CODE == "U084") { TheResponse = "B"; } Report_ID = "F01"; ReportForm = "POMod Request"; var responsenotes = NewNote.ReplaceApostrophes(); UpdateException(exception, TheResponse, notes.returnVal7, notes.returnVal3, exception.RESPONSENOTES + "\r\rn" + NewNote.ReplaceApostrophes(), ""); switch (exception.ERR_CODE) { case "P001": case "P024": break; case "P201": Status = "Pending"; ExceptionP201(); break; } var objException = new VITAPExceptions(); objException.ActNum = exception.ACT; objException.Po_id = exception.PO_ID; objException.Rr_id = exception.RR_ID; objException.Ae_id = exception.AE_ID; objException.Err_response = "M"; objException.Inv_key_id = exception.INV_KEY_ID; objException.PrepCode = PrepCode; if (exception.ERR_CODE == "D062" || exception.ERR_CODE == "P201") { objException.Err_code = "P042"; objException.Updinvstatus = "T"; } else if (exception.ERR_CODE == "V299" && !String.IsNullOrWhiteSpace(exception.INV_KEY_ID)) { objException.Err_code = "P042"; objException.Updinvstatus = "T"; } else if (exception.ERR_CODE == "V299" && !String.IsNullOrWhiteSpace(exception.PO_ID)) { objException.Err_code = "O042"; objException.Updpostatus = "T"; } else { objException.Err_code = exception.ERR_CODE.Left(1) + "042"; switch (exception.ERR_CODE.Left(1)) { case "P": objException.Updinvstatus = "T"; break; } } objException.Ex_memo = "Missing Modification"; if (exception.ERR_CODE == "P201") { objException.Ex_memo = "Mod needed for additional goods: invoice " + Invoice + " / invoice amount " + InvAmount + " / PO amount " + POAmount + " / Vend Name " + VendName.ReplaceApostrophes(); } objException.Updstatus = "T"; if (!String.IsNullOrWhiteSpace(VendName)) { objException.Vendname = VendName; } objException.AddException(); var NewEx_id = objException.Ex_id; if (!String.IsNullOrWhiteSpace(NewEx_id)) { //Send PO MOD request notificaton if (!CheckNotificationExists()) { InsertNotification(); } } else { return(false); } return(true); }
public void FinishCode(string prepCode) { if (exception.ERR_CODE.Right(3) == "200") { Report_ID = "P02"; ReportForm = "RequestPO"; Status = "Pending"; notes.returnVal7 = notes.returnVal7.ReplaceNull("").ReplaceApostrophes(); exception.PREPCODE = prepCode; string responsenotes = exception.RESPONSENOTES + "\rPO requested" + "\r" + NewNote.ReplaceApostrophes(); UpdateException(exception, "Q", notes.returnVal7, notes.returnVal3.ReplaceNull(""), responsenotes, ""); var objException = new VITAPExceptions(); objException.ActNum = exception.ACT; objException.Po_id = exception.PO_ID; objException.Pdocnopo = exception.PDOCNO; objException.Rr_id = exception.RR_ID; objException.Ae_id = exception.AE_ID; objException.Err_response = "M"; objException.PrepCode = prepCode; objException.Inv_key_id = exception.INV_KEY_ID; //To avoid creating R041 Exceptions.. if (!String.IsNullOrWhiteSpace(exception.INV_KEY_ID)) { objException.Err_code = "P041"; if (exception.ERR_CODE != "R200") { objException.Err_code = exception.ERR_CODE.Left(1) + "041"; } objException.Ex_memo = "No PO in VITAP"; objException.Updinvstatus = "T"; if (!String.IsNullOrWhiteSpace(exception.VENDNAME)) { objException.Vendname = exception.VENDNAME; } objException.AddException(); string newExId = ""; if (String.IsNullOrWhiteSpace(newExId)) { var rtnExc = GetExceptionByInvKeyID(exception.INV_KEY_ID); string exId = ""; foreach (var row in rtnExc) { if (row.ERR_CODE.Right(3) == "041") { exId = row.EX_ID; break; } } if (String.IsNullOrWhiteSpace(exId)) { exId = newExId; } } } else { Report_ID = "F02"; ReportForm = "poreq"; } if (!CheckNotificationExists()) { var Address = GetAddressFromInvoice(exception.INV_KEY_ID); var rtnInv = GetPegasysInvoiceByKey(exception.INV_KEY_ID); RequestNo = ""; Contact_ID = ""; Amount = rtnInv.AMOUNT.Value; var Search = Address; InsertNotification(); } } }
public void FinishCode(List <NoRRArray> noRRArray) { //set err_response to Q because the P040 will have the M err_response*** var responsenotes = exception.RESPONSENOTES + "\r\n" + NewNote; UpdateException(exception, "Q", notes.returnVal7, notes.returnVal3, responsenotes, ""); if (exception.RR_ID == "MRR") { if (noRRArray != null && noRRArray.Count > 0) { foreach (var row in noRRArray) { InsertMatchRRInv(exception.ACT, row.DOC_NUM, exception.INV_KEY_ID); } } } else { InsertMatchRRInv(exception.ACT, exception.RR_ID, exception.INV_KEY_ID); } var objException = new VITAPExceptions(); objException.ActNum = exception.ACT; objException.Po_id = exception.PO_ID; objException.Inv_key_id = exception.INV_KEY_ID; objException.Err_code = "P040"; objException.Err_response = "M"; var rtnInv = GetPegasysInvoiceByKey(exception.INV_KEY_ID); if (rtnInv != null) { objException.Vendname = rtnInv.VENDNAME; objException.Poamount = (double)rtnInv.AMOUNT; objException.Ex_memo = "No RR in VITAP - Invoice " + rtnInv.INVOICE + "/$" + Math.Round((double)rtnInv.AMOUNT, 2).ToString(); } else { objException.Ex_memo = "No RR in VITAP"; } if (exception.ERR_CODE.Left(1) == "P") { objException.Updinvstatus = "T"; } objException.Updstatus = "T"; objException.PrepCode = PrepCode; objException.AddException(); string NewEx_id = objException.Ex_id; //generate RR request F04 var excList = GetExceptionByInvKeyID(exception.INV_KEY_ID); foreach (var row in excList) { if (row.EX_ID == NewEx_id && row.ERR_CODE == "P040") { exception = row; break; } } var Act = exception.ACT; var Inv_key_id = exception.INV_KEY_ID; var Po_id = exception.PO_ID; var DateQueued = DateTime.Now; Report_ID = "F04"; ReportForm = "RR Request"; if (rtnInv != null) { Amount = (decimal)rtnInv.AMOUNT; } var FaxNotes = notes.returnVal7; Status = "Tomorrow"; InsertNotification(); }