Feature #1496
Updated by Krishna Kanth A 8 months ago
Hi Bhanu Sir, There is a Need to develop a small screen/tool to generate data as required for PACS ERP upload. Request you to consider the development of this tool. Input source is PCTX file1 (textfile) and output is PCTX file2 (textfile). Please refer to the Attached files for Complete details. Example one record from Input File 0000000000001012pigmy020001185000047200028Balageri Lakshmana 0000004750.0000100.0004/11/202420001184000001 10/06/202404/11/2024 Account No. (Account No ) --020001185000047 =MID(A1,22,6) 2,3 days collection (Agreed Amount) --00100.00 00100.00 =MID(A1,106,6) customer name (Name) --Balageri Lakshmana =MID(A1,43,16) balance after collection(Balance Amount ) --0000004750.00 =MID(A1,93,6) collection date (Last transaction date ) --04/11/2024 =MID(A1,149,8) collection amount of one day (Agreed Amount) --00100.00 =MID(A1,106,6) 2nd line Expected Output: 000047,100.00,Balageri Lakshma,4750.00,04/11/24,100.00 Kindly note that for the Last Transaction Date Field the Dev Team to trim the Year value in the YY Format (i.e 24 instead of 2024) to be displayed in the Output file. Kindly refer to the 2 attached files for the Input File and the Pigmy Data Structure. *Note* : The Below mentioned position(Excel file) is wrt the details shared in the attached file Word Document "Pigmy Data Structure conversion" =MID(A1,22,6) MID(A1,22,6). =MID(A1,106,6) =MID(A1,43,16) =MID(A1,93,6) =MID(A1,149,8) =MID(A1,106,6)