export the sales invoice header with sales line

Horse06

Hi expert, when exporting and if the sales invoice line has multiple items, the data will not be exported and have an error as below:
The Excel Buffer already exists. Identification fields and values: Row NO. ='1',Column NO.='38'.

If the sales invoice line has has only one item, the export data is fine.

How to solve this? Appreciate it!

Savatage

Are you incrementing your Rows?

Horse06

Since some orders have multiple items and I don't know how to deal with them when export the data.

Appreciate it.

Horse06

But how to increatment the row? Appreciate it!

Horse06

I need help in this line of code, how to increment the row if I have two items.
EnterCell(1, 38, FORMAT("Sales Invoice Line".Quantity), FALSE, FALSE, FALSE); Appreciate it!

Savatage

EnterCell(1, 38, FORMAT("Sales Invoice Line".Quantity), FALSE, FALSE, FALSE); Appreciate it!

Create A Variable = ROW (Integer)
OnPreDataItem()
Row := 0;
OnAfterGetRecord()
Row := Row + 1;
EnterCell(Row, 38, FORMAT("Sales Invoice Line".Quantity), FALSE, FALSE, FALSE);

Horse06

Thank you! But I still have the same error.

Savatage

Probably because you say your doing a header too. So let's say your header takes up rows 1&2, then you have to start the lines at row 3 not 1 again.

What info are you getting from the header?

Are you using an indented data items? Or a Get in your report?

Savatage

Here's a perfect example using PO Header & PO Line..
https://docs.google.com/document/d/1JCv ... dit?hl=en#

Save it to text file & Import the report & give it a try.
TempExcelBuffer = Record = Excel Buffer

It's basically the same for SO Header & SO Line

Horse06

Thank you Harry!

This report on the gooble is only about one table Purchase line.
I might not make myself clear. I have no problem with one table when exporting the data. My problem is to link,for example, the Purchase header with purchase line together in one report. When there is only one record for the purchase line, there should be no problem. But there are mutliple purchase records for the line, there would be an error like this.

Savatage

I don't know what you are talking about. The sample report prints some header info and the lines on that po. It even gives you a grand total

Look at the report it uses table 38 and 39
I have tested it and it works fine.

If you change the purchase part to sales it will work also

Horse06

Thank you Harry! I tried to import the text file, but I am not authorized to do it. I can only import fob file.

Savatage

Fob Version - Report 50079

https://docs.google.com/leaf?id=0BwY098 ... OTNj&hl=en

Demo of how to export PO header & lines.
You can add or remove any fields you like.

Horse06

Thank you, Harry! It is working now.

Savatage

http://www.youtube.com/watch?v=WQ63cFCPBOQ

Now you can see the code behind the report and apply it to different areas!
\:D/

sharad

Hi
Please increment the row or use random function to give random no. to every line. it set a unique no. which will not conflict when u have more than one item or lines.