Cancelado

Create application to output specificlly formatted csv file

The project is to create an applicaiton that can take an input csv file and output a specifically formated csv file for upload into Dynamics acconting system. A new input csv file will be created each day with each line containing specific invoice detail. The columns are Invoice Number, PO Number, Invoice Date, Company ID, Vendor Name, Vendor ID, Terms, Financial Period, Primary GL Account, Additional GL Accounts, Primary GL Sub-Account, Additoanl GL Sub-Account, Total Amount, Workticket, and Task ID. Most lines will only contain Primary GL Account and Primary GL Sub Account but if the amount of the invoice is to be split between muliple GL Accounts the additional account numbers will be in the Additioanl GL Account field with the corresponding GL SubAccount in the Additional GL SubAccount field. If multiple additioanl GL Accounts and Sub Accounts the values will be seperated by a space(could have a character seperator if preferred, like a ; for example) If multiple GL Accounts there will be a corresponding Work Ticket number with a : seperating the Work Ticket number and the specific amount to apply to that number. These work tickets and amounts will equal the total amount. If only one GL account the Total amount will be applied to the work ticket number.

The output file must create a batch heading, A line 1 for every invoice which will show Invoice Number, PO Number, Invoice Date, Company ID, Vendor Name, Vendor ID, Terms, total amount and Financial Period. A line4 will follow each line 1 for every GL account, Sub Account, Work Ticket, Task ID, and unit amount.

## Deliverables

I've attached the sample files from the previous window. Information about the ouput file.

1. The perpost field is the translation of the financial period field ie November 2010 = 201011

2. The ctrltot filed is the batch total amount for all invoices being processed ie add total amount from all line 1's

3. doctype is always VO

4. discbal is always 0

5. statusd is always A

6. cdiscdate, duedate, and paydate are determined by taking invdate and adding the terms

7. capcpny3 and cpny are always set to the company ID field

8. linetype is always N

9. all fields left blank on sample output file will be blank but need to have a place holder so the fields line up appropriately.

Habilidades: Engenharia, Microsoft, Gestão de projetos, Arquitetura de software, Teste de Software, Área de trabalho do Windows

Ver mais: po number invoice, all po, window application, vo, Ticket management, ticket id, po file, financial management task, create invoice, create a character, ticket management system project, project input output, project financial management system, split file, project tickets, ticket line, batch file name, line ticket, field work ticket, formatted, ticket add fields, csv file input, line csv, financial translation, additional output fields

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #2989839

22 freelancers estão ofertando em média $4265 para este trabalho

gmit2

See private message.

$4250 USD in 14 dias
(84 Comentários)
7.7
jared23

See private message.

$4250 USD in 14 dias
(256 Comentários)
7.6
DavidWeiss

See private message.

$4250 USD in 14 dias
(61 Comentários)
7.2
igorrumv

See private message.

$4250 USD in 14 dias
(75 Comentários)
7.1
softskyvw

See private message.

$4250 USD in 14 dias
(26 Comentários)
7.0
RobotMarvin

See private message.

$4250 USD in 14 dias
(23 Comentários)
6.6
gontham

See private message.

$4250 USD in 14 dias
(52 Comentários)
6.4
jal540

See private message.

$4250 USD in 14 dias
(39 Comentários)
5.6
codeNconquer

See private message.

$4250 USD in 14 dias
(50 Comentários)
5.4
dracopaladine

See private message.

$4250 USD in 14 dias
(17 Comentários)
5.3
konnectitinc

See private message.

$4250 USD in 14 dias
(24 Comentários)
4.7
RentAGuru

See private message.

$4250 USD in 14 dias
(7 Comentários)
4.6
alexitkin

See private message.

$4250 USD in 14 dias
(31 Comentários)
4.7
RadikleSolutions

See private message.

$4577.25 USD in 14 dias
(12 Comentários)
4.0
gandalfvw

See private message.

$4250 USD in 14 dias
(6 Comentários)
3.7
marcotroise79

See private message.

$4250 USD in 14 dias
(9 Comentários)
3.3
herb191

See private message.

$4250 USD in 14 dias
(3 Comentários)
2.4
stevenyvw

See private message.

$4250 USD in 14 dias
(0 Comentários)
0.0
tarponweb

See private message.

$4250 USD in 14 dias
(0 Comentários)
0.0
leslie1234

See private message.

$4250 USD in 14 dias
(0 Comentários)
0.0