MFG Under Development

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.

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

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

——-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;
    }
} 

JV Audit Trail

2. 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)
3. In delete isprocessing do we have to add ? as insert in audit trail we are doing
   –> Once client started using it (hold)
4. TableName parameter in detect changes and docid parameter in dynamic create we are not using in Audit Trail
5. As system parameter introduce are we going to remove audittrail field from companymst ? –> Yes remove
6. 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
7. Duplicate JV instead of session year label need to use user yearlabel as not working if I duplicate from last year to current year
8. IN Bill1 Modify method in which case in audit trail no. will come empty, main modify change it is

Invoice Audit Trail

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

Voucher Audit Trail

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

Queue Report

• Logic to delete all queue log records that are older than 48 hours needs to be taken.

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

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.

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

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

Project UD Points

GRN QR

• Delete Prevention needs to be added for GRN when linked with different documents Vanshika Ma'am

QR Stock

1. roles name are pending to confirm Vanshika Ma'am
2. new menu & program.cs changes pending Vanshika Ma'am
3. Download Model Stock Qty, not matching with Inventory Qty, also no. of items
4. Records are missing compared to the system data. Please re-download the model.Import failed due to validation errors. –> Msg confirmationVanshika mam
5. Index to view SubTrns and also Print Sub TrnNext Round
6. Delete Prevention needs to be added for GRN when linked with different documentsNext Round
7. In Grn Delete, Delete1 controller instead of trnid list cnt check System parameter like create1 controller if ON then call delete subtrn method
8. GetPrintSubTrnCount, GetSubTrnCnt analyze it GetSubTrnCnt not needed & GetPrintSubTrnCnt may changed to GetUnPrintedSubTRnCnt
9. qtyperbox min range from 1 change to 0.01 in grn, qa, item mst (create, modify, import all where)
10. from QA when PDN is getting we will make changes in next round ?Pending to DiscussNext Round
11. Log changes for delete1, create1, modify1 add trnid in notes, & also change delete
12. as after qa modify full rejected happens Grn trnid empty but not packet & QTY perbox –> needs to be change to 0
13. If trn id is printed & then deleted main level/line level/QA modify not deleting TrnIds –> need to delete
14. from QA also common delete qrsubtrndelete method needs to call

jobwork QR

• In jobwork Print if two items are there in Print it should show only 1 item

• Jobwork1 qty, weight column length will increase to 12,3 need to add script, make changes in existing errorcodes/validations

• Ind column need to add ScannedSubTrn table

• common grn second round changes are not address like range for qtyperbox min & max both in validate

• scanned trn Party Unit etc should be same of reftrnid compare to jobwork

• instruduce line ID in scanned subtrn table & when user deleteing a line we have to rollback based on Id not on trnid

• In from Grn when record is created , Trn Id column will be empty

• Out From Entire Grn/Import, Trn Id will be empty

• Finally TrnId will have value for Inout Type Code 2

• reftrnid column will be dropped in Jobwork1 table

• Job Work QR pending to test as there are changes, also as per test report those test cases also pending to test

• In scannedsubtrn 14,3 data length we have to change to 12,3 & in Qr subtrn this change is required or not please discuss, according to that validation might be change in QR Stock & other places -9. qtyperbox min range from 1 change to 0.01 in jobwork

• QR JobWork test case

1. In this Case final insert 123, 124 in one line as item same
2. second line G000125 will be inserted
3. In rollback as mentioned above it will be inserted with generated jw1id without grouping while delete 1st line it will rollback 6 rows in rollback table
4. rollback will contain 6 rows, Jobwork will conatin 2 rows

AI INSIGHTS

• Multiple charts pending to implement
• chart not coming correct of show the sales details of item 009616 of last quarter command
• not working show customers where current minus refdate 61-90 days

• ---

• Optimize System Prompts
• schema in Open AI instead of mention full mention just mention the table name & fetch schema from SQL next round
• Confirm the Model class property names of AIInsights Next Round

• ---

• This prompt in multi show total outstanding of party CLASSIC SIGNAGES PVT LTD not working
• show search prompt bottom after clicking on send only when result is received

  AI INSIGHTS Indent, Order, Purchase

  • download chart & report icon is too small & bottom we should take download chart icon tope of chart & download report on top of grid, & icon needs to be confirm
  • In report wrap text on first column for that user prompt also getting wrapped
  • When report is download chart is also getting refresh
  • numbers are coming as string need to fix in AI Insights report if take time & then discuss & drop the point
  • create new table in ErpCrystalMfg table where doctype mention as G, P, V when user ask for Voucher then take Voucher SystemPrompt here only
  • AI Insights Bita review