Pull posted AR invoices to a table when 5 companies are setup.

I'd like to pull posted AR invoices from each of our 5 companies and update a table daily. Can anyone tell me how to find/distinguish the data for each company?

Any recomended procedure to pull this data to the table?

Thanks for all responses!

Parents
  • 0

    Need a little more detail.  Where is the table you want to update daily? In another app, in Access, in Excel, in SQL.

  • 0 in reply to BigLouie

    Hi BigLouie!

    I was planning to create an external table that would be used to store the AR invoices for the day. I would then pull the invoices to an oracle database where it would be consumed. The final destination requires a text file for import. I've considered a linked table or creating a stored procedure in the SQL Server database to pull the invoices and load the table.

    So the table would likely be in SQL, but all options are on the table.

    I hope that makes sense.

    Thanks

Reply
  • 0 in reply to BigLouie

    Hi BigLouie!

    I was planning to create an external table that would be used to store the AR invoices for the day. I would then pull the invoices to an oracle database where it would be consumed. The final destination requires a text file for import. I've considered a linked table or creating a stored procedure in the SQL Server database to pull the invoices and load the table.

    So the table would likely be in SQL, but all options are on the table.

    I hope that makes sense.

    Thanks

Children
  • 0 in reply to Journeyman2

    I would create an Access database with a SQL Specific Pass Through Query and a make table query.  With a little programming you could place the Access database in the Windows scheduler, have it open at a certain time, pull the data and then export a text file and close down.

  • 0 in reply to Journeyman2

    I'd consider a scheduled report (using a 3rd party tool like Visual Cut) to go straight to the text file format you want.  It would be one text file per company code, but you could then use batch file commands to merge them.

    If you need the SQL table, a linked server should allow direct ODBC queries for company specific silent DSN's.