I have a Payroll file that I wish to import into BC. I'm pretty sure I could fairly quickly write a codeunit in an AL extension to achieve the import I want, but I wondered if BC's standard functionality via Data Exchange Definition, Field Mapping and Transformation Rules would be able to handle this format of file?
I've been following the procedure on the link below, which was very helpful but I haven't managed to import the values I want.
https://robertostefanettinavblog.com/2019/09/24/import-payrolls-in-business-central/
Here's a sample import file:-
Acme Products - Dave - Month 6,,,,,,,,,,
Name,Surname,Gross Pay,Tax,Employee NICs,Employer NICs,Student Loan deduction,Global group - Employee Contribution,Global group - Employer Contribution,Global group - Total Contribution,Take-home pay
,,,,,,,,,,
"Month 6 - Ending 30 September, 2021",,,,,,,,,,
EMP,ONE,"1,026.67",0,0,0,0,0,0,0,"1,026.67"
EMP,TWO,"1,500.00",154,0,22.08,0,0,0,0,"1,346.00"
EMP,THREE,"2,500.00",0,0,0,0,0,0,0,"2,225.00"
TOTAL (3 employees),,"5,026.67",154.00,0.00,22.08,0.00,0.00,0.00,0.00,"4,597.67"
From this file, the only line to be imported is the last line (starting with TOTAL), and for each value on that line we need to create a new record in the Gen. Journal Line (81) table.
So the one input line will create 9 records in BC, each with their particular GL and Bal Account No, Description etc.
Can this be done without a custom import?