Em Andamento

Excel file to csv for AR

Take a long excel file with too many rows and columns and create a small and simple csv file containing summary data.

The excel file will contain detailed accounts receivable billing data. We need this report to become a .csv file containing a customer number, current amount due, and total amount due.

The deliverable can be a MS Office 2003 product or be written in code. Doesn’t matter except that we don’t want to have to purchase separate software to make it work (like Crystal reports, Filemaker, etc.) or load .dll’s or .ocx’s and the like. Keep it simple.

?

Please no code to support Office 2007 ??" we don’t own it yet.? OS is Windows.? Access2003 app is fine as long as everything is as automated as possible.

## Deliverables

I achieved the small file by taking the original file (see attached) and followed these specific steps:

Converted Customer ID field to number format

Converted Amount due field to currency format

Filter records: eliminate rows or records that have a null field in Invoice/CM field

With the remaining rows or records: create a data field for each Invoice/CM# containing the difference in days between the Date field and the Date Due field.

Next, create a data field for each Invoice/CM# indicating the age of the item ??" the difference between today’s date* and Date. *I may replace today’s date with a forced date off a form or input box…go ahead and code for that option.

If Age +> Terms, flag the item as “currently due??.

Finally, sum the amount of currently due for each Customer ID.

Sum the total due for each Customer ID.

Create one record for each Customer ID indicating the ID#, the total due, and the currently due amount.

Export it as a csv file to a directory location of my choosing (or default to My Documents/ARexport on a windows machine.

You don't have to go through the exact steps as I did as long as you get to the final product. I only added my flow as an example.

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

Ver mais: purchase summary, php to excel export, php code to create report, filemaker work, crystal report with php, c ar, can i get excel support, MS Excel 2007, filemaker software, crystal reports 11, simple invoice format in excel, customer data in excel, simple csv, receivable, php ar, my ar, invoice app, excel-to-csv, excel work today, Excel to CSV, excel to app, excel small work, excel reports, Excel file, excel app

Acerca do Empregador:
( 180 comentários ) Newark, United States

ID do Projeto: #2978928

Premiar a:

praneeth87

See private message.

$10.25 USD em 6 dias
(15 Avaliações)
3.5

29 freelancers estão ofertando em média $50 para este trabalho

fastudiovw

See private message.

$29.75 USD in 6 dias
(635 Comentários)
7.4
pShankar2

See private message.

$85 USD in 6 dias
(404 Comentários)
7.1
schandraram

See private message.

$38.25 USD in 6 dias
(147 Comentários)
6.8
LogixSmith

See private message.

$29.75 USD in 6 dias
(54 Comentários)
6.0
jawadh

See private message.

$106.25 USD in 6 dias
(82 Comentários)
5.9
jal540

See private message.

$76.5 USD in 6 dias
(37 Comentários)
5.6
amcsummers

See private message.

$72.25 USD in 6 dias
(61 Comentários)
5.5
magadhmindslx

See private message.

$68 USD in 6 dias
(158 Comentários)
5.3
VedAlek

See private message.

$34 USD in 6 dias
(54 Comentários)
5.3
DenisSmolentsev

See private message.

$42.5 USD in 6 dias
(84 Comentários)
5.2
schenzvw

See private message.

$85 USD in 6 dias
(47 Comentários)
5.2
BrothersTeam

See private message.

$37.4 USD in 6 dias
(58 Comentários)
4.9
franSystems

See private message.

$33.15 USD in 6 dias
(93 Comentários)
4.8
vw7258315vw

See private message.

$51 USD in 6 dias
(47 Comentários)
4.7
excelsolution

See private message.

$38.25 USD in 6 dias
(57 Comentários)
4.7
dpune

See private message.

$51 USD in 6 dias
(31 Comentários)
4.4
manybodycoder

See private message.

$42.5 USD in 6 dias
(5 Comentários)
3.6
burank

See private message.

$38.25 USD in 6 dias
(19 Comentários)
3.5
tatasthuinfotech

See private message.

$67.15 USD in 6 dias
(13 Comentários)
3.3
afonia

See private message.

$42.5 USD in 6 dias
(4 Comentários)
2.4