In local sales report export order also displaying

(0) Share

Report

Posted on by Community Member

Dear Nav friends,

I'm executing the local sales report - > export to excel . In the output Export Sales are coming in Domestic Sales Register . i have used the following dataitems.

And for sales invoice header and sales credit memo header i have used the following filters.

when i m executing the report i displays the export sales order also .:(

6036.output.PNG my general setup i have given the following .

and i have coded as follows:

EnterCell(RowNo,3,"Sales Invoice Line"."Shortcut Dimension 2 Code",FALSE,FALSE,FALSE,'');

Can you please help ..

*This post is locked for comments

All responses (2)

Answers (0)

ManishS 78 on at

Like (0)

Report

RE: In local sales report export order also displaying

Why don't you filter the records on customer ledger entry on customer posting group ,rather than filtering it on Sales Invoice Header.

The report will execute faster also.
Community Member on at

Like (0)

Report

RE: In local sales report export order also displaying

Hi

2 'not equals' in a filter not possible. Better to include all required using combination of '|' and '..'.

Neil