Export Invoice Data

[#1]

My client is using an unsupported version of SAP Business One 2005. Can anyone advise on how to export invoice financial data to a file?

[bhavank_gajjar · Accepted solution]

Hi if you are working with Standard SAP Reports or Query based report then there is facility for Exporting to Excel & PDF you have to do just Click on Excel or PDF icon after running your report.

Regards,

Bhavank

[Former Member · Accepted solution]

Can you advise on finding the report that contains invoices that are entered into the system?

[bhavank_gajjar · Accepted solution]

Hi..

go to Sales>Sales Report>Sales Analysis in that report Select Invoices Radio Button & Pass Proper parameter for Filtering Report as you want

Regards,

Bhavank

[Former Member · Accepted solution]

If when running the report no data is returned does that mean that there is no data in the system or they're missing reporting feature?

[bhavank_gajjar · Accepted solution]

Hi...

Try to run this simple query for List of Invoices you will get your desired data

SELECT T0.[DocNum], T0.[DocStatus], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], T0.[NumAtCard], T0.[DocTotal] FROM OINV T0

Run this query in Query Generator & Export it as you want

Regards,

Bhavank

[Former Member · Accepted solution]

Do I run this on the master object? I get this error: Invalid object name 'OINV'.

[Former Member · Accepted solution]

Thank you for your responses.

It seems like within master they have a lot of databases which I imagine are the clients. Running this query on each individual database returns results on some of them. Is there a way to run this query on all the databases and organize it based on client?

[Former Member · Accepted solution]

D'nt run the query on master data object.

select your data base name from dropdown.

or open SAP business onetoolsquery generator--execute it.

click on pencil icon on quey generator and paste query and execute.

Thanks,

Neetu

[Former Member · Accepted solution]

Hi,

Welcome you to the forum.

If you have the complete database list, you may create a big query by union to export all.

Thanks,

Gordon

[Former Member · Accepted solution]

Would you please show me a small sample of doing a union on this database?

[Former Member · Accepted solution]

Try:

SELECT T0.DocNum, T0.DocStatus, T0.DocDate, T0.DocDueDate, T0.CardCode, T0.CardName, T0.NumAtCard, T0.DocTotal FROM Database1.dbo.OINV T0

Union

SELECT T0.DocNum, T0.DocStatus, T0.DocDate, T0.DocDueDate, T0.CardCode, T0.CardName, T0.NumAtCard, T0.DocTotal FROM Database2.dbo.OINV T0

[Former Member · Accepted solution]

How are spaces in the database name dealt with?

[Former Member · Accepted solution]

Using [\] for those names.

[Former Member · Accepted solution]

I'm creating a union query on all the databases that I see on the system. There is one particular one that, when added, returns the error:

Invalid object name 'FLORIDA.dbo.OINV'.

FLORIDA is a database that I see in the object explorer.

[Former Member · Accepted solution]

This database may not be a B1 database.

[Former Member · Accepted solution]

I figured out the previous error.

What does this error mean?

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "T0.DocStatus" could not be bound. I'm using the above SQL.

[Former Member · Accepted solution]

You need put union under each select.

This thread is becoming too long. It is better post a new thread.