MS Access EDI report using Data from Quick books POS

We use "QuickBooks Point Of Sale V8 Pro Multi Store" for our operation.


Our objective is to produce a CSV file a week, containing the weekly sales data by store, or for selected stores.

Our trading weeks start on Sunday through to Saturday (Saturday is the last trading day of the week). Therefore the sales file should contain the Saturday date.

For example – if we were to produce a CSV sales file for the week (Sunday 7th September to Saturday 13th September), the date on the sales file would be 20140913. The sales file will need to contain the product EAN numbers.

An example of a Sales file is shown in the attachment. Also attached is a copy of the Message Implementation Guide.

When multiple sales of the article are made throughout the week – the sale is grouped together (highlighted in blue).

The sales value on the left is the total value (39980), the figure on the right is the value of a single unit (19990)

Pink = Any store returns are recorded as negative sales – with the corresponding negative sales value.


1- QuickBooks POS sends the day's sales activities from the branch to the Headquarters station, so we can run the same EOD report from the HQ station with no problem.

2- You can retrieve data from POS using the official free SDK, you need to register though (Visit this link)

[url removed, login to view]

3- QuickBooks Point of Sale is a different product than QuickBooks Financial

6- Don't consider using FlexQuarts ODBC driver.

7- Send me your Skype ID

General Thoughts:

1- The QB POS SDK allows you to use a Programming language of your choice (Visual Basic .NET, C++, C#, etc.)

2- Messages to and from QuickBooks can be sent using one of two mechanisms:

a- Using the QBPOSXML Request Processor API or

b- Using the QuickBooks POS Foundation Class (qbposFC) Library API.

3- I need to have full control on all the databases objects.

4- Please, don't set your bid too high as we are on a limited budget.

Kemahiran: Pentadbiran Pangkalan Data, Microsoft Access, Kejuruteraan Perisian

Lihat lagi: visual basic programming notes, visual basic net programming language, visual basic net developer, visual basic 6.0 programming language, software developer overview, skype programming language, sales administration, report programming, recorded books, quickbooks.net api, programming books, ms access programming, MS Access Database Developer, ms access administration, is net a programming language, intuit com, free programming books, foundation software, database processor, c# programming books

Tentang Majikan:
( 2 ulasan ) Amman, Jordan

ID Projek: #6782009

Dianugerahkan kepada:


Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We are a professional development company head-quartered in Pakistan. If you like what you see and if our qu Lagi

$200 USD dalam 5 hari
(4 Ulasan)

5 pekerja bebas membida secara purata $164 untuk pekerjaan ini


I already used QB Pos SDK to get data of sale receipt from qb database. I can do this task for you easily. Thanks Ali

$200 USD dalam 3 hari
(6 Ulasan)

Aucune proposition n'a encore été fournie.

$155 USD dalam 3 hari
(1 Ulasan)

I am a profession in MS office, so your job I think so fill with me. You can choose me to help you solve your job. Thank

$111 USD dalam 3 hari
(0 Ulasan)

Hello, I have years of experience working in data extraction and conversion. I also have specific expertise is MSAccess that will allow me to quickly meet your needs. Please let me know if you have any questions. Lagi

$155 USD dalam 3 hari
(0 Ulasan)