Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 08, 05:03 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 65
Default Remittance Advice

Hi, I have a data extract that I can draw from a main system into Excel (or
CSV or txt file). From this, I wanted to build a remittance advice into
word, in a special layout.

The file will be along the lines of:

Supplier number, name, address line 1, line 2, city, post code, invoice #,
inv amount, currency.

The data will be for mutliple suppliers, some with mutliple invoices.

Is it possible to create a data merge that puts the supplier address in
certain places on the word doc, the same with the invoice details and makes a
total. Each supplier will start a new page - is this possible?

Rob
--
Rob Gaffney

  #2   Report Post  
Old December 5th 08, 05:11 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 83
Default Remittance Advice

"Gaffnr" wrote in message
...
Hi, I have a data extract that I can draw from a main system into Excel
(or
CSV or txt file). From this, I wanted to build a remittance advice into
word, in a special layout.

The file will be along the lines of:

Supplier number, name, address line 1, line 2, city, post code, invoice #,
inv amount, currency.

The data will be for mutliple suppliers, some with mutliple invoices.

Is it possible to create a data merge that puts the supplier address in
certain places on the word doc, the same with the invoice details and
makes a
total. Each supplier will start a new page - is this possible?



Why are you trying to re-invent the wheel? There are plenty of accounting
programs for small businesses, not expensive, that will do all this and
more.
Much easier and painless to use one of those.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

  #3   Report Post  
Old December 5th 08, 05:21 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 65
Default Remittance Advice

tell me about it but our ERP does not handle it - can you believe it. A
multi national piece of software too!

--
Rob Gaffney


"Gordon" wrote:

"Gaffnr" wrote in message
...
Hi, I have a data extract that I can draw from a main system into Excel
(or
CSV or txt file). From this, I wanted to build a remittance advice into
word, in a special layout.

The file will be along the lines of:

Supplier number, name, address line 1, line 2, city, post code, invoice #,
inv amount, currency.

The data will be for mutliple suppliers, some with mutliple invoices.

Is it possible to create a data merge that puts the supplier address in
certain places on the word doc, the same with the invoice details and
makes a
total. Each supplier will start a new page - is this possible?



Why are you trying to re-invent the wheel? There are plenty of accounting
programs for small businesses, not expensive, that will do all this and
more.
Much easier and painless to use one of those.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)


  #4   Report Post  
Old December 5th 08, 05:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 83
Default Remittance Advice

"Gaffnr" wrote in message
...
tell me about it but our ERP does not handle it - can you believe it. A
multi national piece of software too!



Interesting. As a recently retired Systems and Management Accountant would
you like to divulge the name of this apparent piece of rubbish?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

  #5   Report Post  
Old December 5th 08, 05:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 65
Default Remittance Advice

If you know systems, then the founders Jack, Dan and Eddy should be good
enough!
--
Rob Gaffney


"Gordon" wrote:

"Gaffnr" wrote in message
...
tell me about it but our ERP does not handle it - can you believe it. A
multi national piece of software too!



Interesting. As a recently retired Systems and Management Accountant would
you like to divulge the name of this apparent piece of rubbish?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)




  #6   Report Post  
Old December 5th 08, 05:44 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 83
Default Remittance Advice

"Gaffnr" wrote in message
...
If you know systems, then the founders Jack, Dan and Eddy should be good
enough!



Do you know that they sold their systems in Europe with NO VAT MODULE? I
had to extract VAT data using ODBF drivers and compile the VAT return from
that!
I would NEVER recommend that pile of sh*te to anyone.
The only reason we had it was the previous IT director had a "thing" about
AS400s and the only three things that would run on them were BPECS which we
wanted rid of for Y2K reasons, SAP, which was too big, and this.
Do you know, it went through Dec 31/Jan 1 1999/2000 ok, Feb 29 2000 ok, but
fell over Dec 31 2000/Jan 1 1002? And what did their "support" say?

You won't believe this........


"Yes we know about this. Tell us if you find out what causes it"!!!!!!!!!!!

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
any advice pls.. DumbLittleMan Excel Discussion (Misc queries) 1 September 4th 07 09:10 PM
pls advice dribler2 Excel Worksheet Functions 0 December 29th 06 02:22 PM
Need advice Form maker Excel Worksheet Functions 1 December 2nd 06 04:26 PM
Please put a remittance advice template online gistmei Excel Worksheet Functions 0 October 19th 06 12:50 AM
Advice Please Greg B Excel Worksheet Functions 5 March 17th 05 12:13 PM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017