MFG Under Development

Docs

Ongoing Tasks

Other

Sales Order print query for GST amount need to refactor Round2
Sales Order why gstration we are calcuting & then sum of it will it not be same if simply diiscount added ? related to print query Round2
After using sticky column and scroll the scroll is not completely working because of which the end columns are not visible. Need to fix it. Tried in jobwork1index.
If dncn only main level is created, than invoice & bill is allowed to delete however it is linked need to prevent For Adhoc Dncn it is still allowed
In Payslip if one value is selected from non component autocomplete then it is showing only that value. This is because empcombo is called only when cnt is 0 and here cnt is coming as 1.
In Letter Of Credit Create/Modify if we are taking INR and then changing conversion factor > 1 then it is allowed which is incorrect. Either need to add validation or control it through backend while inserting in table.
If BE is linked to LC then Main BE Modify will also be not allowed? (Date, Due Date we are allowing to modify)
In BE Create 1 Index we are showing a single record for a bill even if it has multiple lines. This is ok?
In CRM Lead Report For New Status Aging Column shown needs to be confirmed.

Doubts

In Bill Create Curreny needs to insert INR, like dncn & fcamount 0, & in modify more info need to show a msg used in fcnr ledger, but gstype I1 we are checking
datecomponent not working properly in modify showing current date instead of 01-Jan-01 in BOE, ORM Date
Create1 Factor needs to be fetched from Cost master if ismanual rate is N like Import–Pending to confirm By vanshika Ma’am
We will truncate Leave records
in date picker can we disable those date which is prior of after to finalized month
Carry Forward Balances Need to compare the other values of opgos like notes, because In Multi 24-25 after doing carryforward notes are coming different in ERP & blazor need to check first without doing carryforward

Queue using Nano Bot

Queue Log Report per db in ErpReport Option hold already index we have

Pending

In Delete generated records feature, Loan table is pending to handle hold
Add sticky column in JobWork1Index hold
Holiday Mst Create, Modify, Option file needs to be deleted once it is confirmed ( for reviewer)
Add a common method to get Sysparameter values in Utility hold
Fix the search string special character crashing in Invoice1createindex, & check is this required to do fix in any other create1index
Inevntory Ledger Show Negative need to test in deep (1st - Details sheet where transactions coming positive but closing negative it should show all the records of that transaction 2nd - Summary sheet needs to be test, total qty is changing after download for negative only) Anila
Advance license status change to something else than download document not showing is this okay ? –> need to fix
Fix the create1index search data speacial character bug, refer invoice1createindex
Change Stdinstruction regex replace same as AR in other email scheduler(indent, order etc.)
changed errormsg to infoms & msg need to shown onbutton clicked in accountmst
In MFG Purchase by month we are not doing dncn * (-1) because of that it is showing double amount
will see invoice delivery date modufy bug issue later on that is sometime showing current date some time correct date that is 01-Jan-01
Master Server Point
In System parameter we will have menu column also in existing table where we have to mention this Sysparemter is for which menu for e.g., Auto EInvoice for Menu Invoice
In system parameter if there is one to many relation between parameters then GetSystemParameterLinkedInfo method will crash.
Opg Os/bal import also need to prevent when bookclosure
instead of having 4 operations buttons on Dncn1QrImport, we will have combo like Invoice
Why for AI Systemprompts & AI Suggested prompts category we have taken as common column that is for user right ? we should have take context table as main value

CRM Salesmen group

Change rolename to CrmSalesmenMst for all Salesmen group feature & check roles for each feature
Sales Group Add combo showing with icon + Add… we should user value only in text field

——-Udit –negativestock–> new branch name circularprogressbar– take in new branch add in Invoice, QA, DNCN, IIRS ⦁ component razor page ⦁ In Alpine Auto create PDN not showing beause trntypedetails coming empty but that also msg not showing ⦁ First we are checking negative stock, then confirmation ⦁ qa negative not working in Alpine for grnid 8313 ⦁ rejected qty showing negative & then onchange also not working, but finally inserted correct value

public async Task<IEnumerable<string>> EmployeeCombo(string employeeCodeName)
{
    if (string.IsNullOrEmpty(employeeCodeName.Trim()))
    {
        return new string[0];
    }
    else
    {
        // if (empCombo.Count() == 0)
        // {
            empCombo = await _IPayslipService.EmployeeCombo
            (_Payslip.EmpCategoryCode, _Payslip.EmpTypeCode, _PostLogin.dbname);
        // }
        if (empCombo.Count() == 1 && empCombo.First() == "ALL Employees-[000000]")
        {
            empCombo = new List<string>();
        }
        StateHasChanged();

        empCombo = empCombo.Where(x => x.Contains(employeeCodeName, StringComparison.InvariantCultureIgnoreCase)).ToList();
    
        return empCombo;
    }
}

System Parameters

GetSystemParameterLinkedInfo - There can be multuple records how singledefault will work
In SysParameterRules Table it is not clearly when this De linking & Linke is applicable, means we should have mention Status of Source System parameter, ON or OFF, then for reference System parameter on or OFF, So from this it will be clear If Source parameter is ON then related parameter staus also should be ON
Table will be part of System Connection not client connection

JV Audit Trail

Audit Trail Will not be base on yearlabel ? No Where clause on Index there will be so many records –> Will see at the end (hold)
In delete isprocessing do we have to add ? as insert in audit trail we are doing
–> Once client started using it (hold)
TableName parameter in detect changes and docid parameter in dynamic create we are not using in Audit Trail
As system parameter introduce are we going to remove audittrail field from companymst ? –> Yes remove
In Bill & JV both when line is modified, main level records also we are inserting with line Id only it should take main id for main level fields
Duplicate JV instead of session year label need to use user yearlabel as not working if I duplicate from last year to current year
IN Bill1 Modify method in which case in audit trail no. will come empty, main modify change it is

Invoice Audit Trail

in what case audit trail no. wil come empty in modify feature

Document Warehouse

Testing Bill & Indent both is pending together with new qr flow
If Same user opened uploaded bill & indent upload both, in this case token will be stored for indent, now instead of indent user try to upload for bill it should not allow test it.
In Doc Upload if there is difference in billamount & Supplier billamt do not allow to upload bill
use bycrpt nuget package for generating tokenId
Need to do security audit in DocUpload files

Voucher Audit Trail

In case of SI/PB only notes is allowed to modify no need audit trail here
In line modify docid for main level field it is taking line id only
refdocname is property name but inserting refdoc(SI,PB in this way) not name
in modify1 in case of PDC we are not inserting audit trail so no need to validate
in Account PDC feature we should insert same like recreate only discuss
as we are inserting recodate column so do we have to add audit trail in reco update feature ?
cancel cheque audit trail, ad modify audit trail do we need ?

Notification

Logic to delete all Notification records that are older than 30 days needs to be taken. hold

Task Schedular

Task Schedular Index cron expression need to decode
For same db, task, cron expression is not allowed
Need to show DB combo in Create

TMS Dashboard/Report

In Dashboard report need to show inactive users also
for due in days in taskplan different dated diff & in report different
In Dashboard Rework is not taken in combo
When there is invalid date range then alignment of field is change in Dashboard
Width of Donut and bar is different refer crmleaddashboard
show Task Status Distribution label one top of donut in between refer crmleaddashboard
Performance how can be more than 100% and as per user formula our system formula is not macth

TMS UD Points

Ind Logic in Repeating task / Task Plan Index needs to be analyzed.
Create method name CreateRepeatingTasks, ValidateRepeatingTask. It will be tasks or task?
Delete Logic Analyze. !string.IsNullOrEmpty(task.RepeatTaskPlanId) then return false not required. Queries are taken in between. Same for Create Repeating Task also query taken in between.
Drag and Drop for Import is not working.

TMS Telegram Changes

In Weekly, Monthly & Yearly Scheduler need to replace csv log with Log table insert. & try catch changes
If send telegram is failed then send a mail to Support mail
Efficiency column formula will be Completed In Time/Total Completed Tasks * 100 in report & telegram
In dashboard status combo take these 4 status in combo (Completed 2, Pending 2)
In telegram send if records not exist for that user for given period than do not share it in telegram, currently it sending for all users doesn’t matter records exist or not.
In Telegram list query from where records are fetch, not found any date where clause why ?

Voucher Payment Scheduler

For downloading RTGS Report posted we are not checking so it will download all those vouchers if neft is created, & in update lock voucher also we don;t have but for NEFT log we have passed –> discuss in more detail, passing islocked = “N” in update voucher will be enough
Add sticky column on Voucher Index
If the inactive record is there in RTGS mst then in RTGS/NEFT Register report it is not coming –> Discuss in more detail
if there is a date range invalid still it is invalid rtgs & showing RTGS invaid all –> Test in more detail

Account Audit trail branch

For main delete if there are two lines in that account then in Audittrail1Index the order by of the records is not coming properly. This needs to be fixed.

Monitor (LC) / Bill of Exchange (BOE)

In GetBillInfo –> Query is different here main level value is used why however in Index1 line level sum is used ?
Show Total amount on boe main details from boe1
Amount calculation validation in LC handled in Linking only not in modify
In connect docs of bill why billno shown as docno isntead of beno
Bill is linked to BOE then we added prevent

DNCN Audit Trail

docid column in meta data table why ?
Line Modify Doc Id of main level need to insert when main properties inserted
Line Delete Doc Id 0 is going, fix it
Bug in Recreate Alpine DB did recreate of invoice id 965 & created adhoc dncn it created duplicate some of rows because of that not able to test tcs, freight round off columns
Need to do cancel of that dncn where these all amounts ara available SELECT TOP 1 * FROM debitcredit WHERE cess2 > 0 AND freight > 0 AND exciseamt > 0 ORDER BY id DESC

Header/Footer changes

we should have window scheduler which call batch file or some thing else for scheduler, currently we are doing through project because of that on server if any crash happens in one db it will stopped scheduler for other dbs like this more issues hold
Verify Header Footer Index need to remove as in scheduler instead of writing header/footer not found for then one units we should write for Unit DDNH not found hold

All Next round

System Admin should know System errors failed scheduler like If it is failed dute numeric overflow, db issue we should inform to System Admin Scheduler is failed –> for catch part error we will send a mail to System Admin
In all scheduler except AI Insights, try errors are user data errors, this will be written in SQL Table, catch errors will be part of csv log Next round
In ERP Log Report, for scheduler log we have to download the records from SQL Table, we don’t have to give csv log to user, users also can also select from date todate (only for 3 months they can download todate current date, 3 months as from date)
We have to delete 3 months older records also from SQL & csv log, through Scheduler Next round
We have to create new scheduler for sending failed scheduler mail Next round
Add try catch logic in reset scheduler

Common JS changes

in crm Bar chart y axis should not be decimal
Percentage or number on donut chart
title of donut chart not coming properly in center, & card size is also different compare to bar chart card

AI Grn Creation

In GRN AI upload, like Bill document needs to be validated for partyname, gstin.
Mic Option not implemented. Kept on hold.

Queue Report UD Points

Retry count logic needs to be discussed and added.
If report crashed due to timeout then we can update status to Queue and send it for queue again.
If report was generated successfully but mail was not sent as mail was invalid then need to log it.
Email not sent then we need to write log.
Add option to download Queuelog in ErpLog Report

AI Reco Bank & Party Ledger

Credit Limit needs to be added.
Free label for demo using needs to be added.

Project UD Points

QR JobWork/DNCN UD

Auto Create PDN is blocked is Sys parameter QR is ON how this is okay ?
When rejected quantity is recorded in the GRN, a QA protocol is generated. Previously, users could create a DNCN against this rejected quantity, ensuring it was properly reflected in the inventory ledger. However, since DNCN creation is now restricted through the QA protocol, there is no mechanism to track or account for the rejected quantity in the inventory system

AI INSIGHTS

DashboardArAp role taken of Receivable only
Same for InventoryAging also have two roles, bom roles
script hardcode year replace with active year label logic
in global prompt mention do not entertain for other prompts

Cash Bank Book Dashboard

Dashboard Insert query needs to be optimized.

LC UD Points

No validation for last shipment date-> UD
if LC is linked with BOE delete we will allow?—-> modify & delete allow validation next round
if it is linked with LC then we will prevent delete but if it is linked with bill we can delete it right?–> only with bill allow modify and delete
BE details/ LC details can be duplicate?—> DROP
bill is authorized only then we can link it, authorize bill cannot be deleted or line cannot be added, but for revoke me can make changes in connected docs —>connected docs
currency also we have to check while linking–> UD
ArAp reports can crash –> UD
Other features like line details, line modify will be in next round

Projecct

QC

QC Test Plan & Test Parameter

1. Role for delete not handled in linkplantoparachecklist
2. In linkplantoparachecklist btns are outside the grid fix it &  title is big please short it
3. Menu not added for both

Task Management

The csv log in scheduler needs to be changed to table log

Sales Summary Email Job

Task all 3 scheduler, AI 2 scheduler are not upto date with new table log insert
In total Inventory Total of Inventory Value of RM and FG it is showing.

Security Audit points

SanitizeFileName method declare but not used
Why in queuemanager only log changes are done not in Scheduler Job
guid changes replace with random no. in next round in all download files
basepath is not there in appsetting than return an error
send mails on team.crystal mail itself instead of support@erpcrystal.in in all places
gstr 2b reminder std instruction regex add
Explore summary error email
rate limit msg not showing sometime test case session expiry true login change global limit to 33 & than click on any index
in Encryption service machineid(16 characters around will take ) needs to be taken in appsetting continue chat Investigating SMTP Authentication Failure in antigravity
fix auto url opening bug refer dpr
logs add in gitignore in erpcrystalmfg
image path case sensitive bug for e.g., Invoice_Header
remove evolve from csproj
do not show unit combo for export invoice header in manage header footer
removed javascript interop changes from error mail (program.cs)
After logout navigate to the separate logout page with relogin feature
Fiel name PaySlip in manager header footer however in download Payslip we are checking creating case Sensitive issue in linux, check & change for all header & footer
invaliduser razor page need to change make interactive
In chs on server in web error user name is not coming need to test in in dotnet10
CHS ValidIdentifier(Utility repository) and Htmlsanitizer changes needs to be address in dpr & mfg
removed run migration file from dpr also & take new logic in chs & dpr like MFG
rate limit in dpr test again with dotnet 10 branch
comment database tuneup menu from all 3 projects
in mfg & chs need to add QuestPDF.Settings.CheckIfAllTextGlyphsAreAvailable like dpr
when we close window & session is there & re opened the website localhost 5289 showing not authorized however in dpr it shows welcome page
in dpr rollback javascript interop from error mail
database tuneup menu comment & add menu for userclientdb
dpr/chs browser back btn & forward is prevented but not in mfg
forward headers, knownIpnetwork changes in mfg
var data = sysconnection.QuerySingleOrDefault(query, new { dbname, subdomain = “%” + subdomain + “%” });//mfg for linux subdomain not working

AI-Grn Creation CHS Lite