E
Edgar
I am trying to qrite a macro to automatically format a
remittance from date exported from my accounting system.
The date will look something like this
Inv no Due Date Curr Amount
6232 AUD 5423
584741Name 20/11/03 AUD -1423
584123Other 20/11/03 AUD -2000
543672Pax 21/11/03 AUD -2000
The first line on this payment is the payment line and the
lines underneath this are for invoices.
There are a couple of complications though, firstly the
length of the remittances is always different.
Secondly sometimes the accounting system creates two
different payment lines, i will need to delete one of
these and just sum the invoice lines.
Is this possible if so please help!
Thanks
Ed
remittance from date exported from my accounting system.
The date will look something like this
Inv no Due Date Curr Amount
6232 AUD 5423
584741Name 20/11/03 AUD -1423
584123Other 20/11/03 AUD -2000
543672Pax 21/11/03 AUD -2000
The first line on this payment is the payment line and the
lines underneath this are for invoices.
There are a couple of complications though, firstly the
length of the remittances is always different.
Secondly sometimes the accounting system creates two
different payment lines, i will need to delete one of
these and just sum the invoice lines.
Is this possible if so please help!
Thanks
Ed