Report wizard
Tabular Type
table = Cust. Ledger Entry
click OK
select the fields you would like to see on the report
click next
select the tye of sort you would like (Cust No, Posting date,...)
click next
select the grouping if you want (Cust No)
click next
select any fields you would like to total (Amount)
click next
select the type of report style (List Style)
click finish
view->properties of the dataitem
change dataitem table view to:
SORTING(Customer No.,Posting Date,Currency Code) WHERE(Document Type=FILTER(Credit Memo),Open=FILTER(Yes))
because when I think of Unapplied - I think of credits in the system that are still "open".
They are not used and therefore not fully applied. Your definition might be different.
**Save it with a number in the 50000..59999 range
but that's a basic report - you can fiddle with it afterwards (change the layout add a cust name, etc.)
Note: you can also go to the ledger entry form with no filters to show all
then filter on Doc Type= Credit memo & Open=Yes
then copy & paste the remaining into excel.
Comments
Tabular Type
table = Cust. Ledger Entry
click OK
select the fields you would like to see on the report
click next
select the tye of sort you would like (Cust No, Posting date,...)
click next
select the grouping if you want (Cust No)
click next
select any fields you would like to total (Amount)
click next
select the type of report style (List Style)
click finish
view->properties of the dataitem
change dataitem table view to:
SORTING(Customer No.,Posting Date,Currency Code) WHERE(Document Type=FILTER(Credit Memo),Open=FILTER(Yes))
because when I think of Unapplied - I think of credits in the system that are still "open".
They are not used and therefore not fully applied. Your definition might be different.
**Save it with a number in the 50000..59999 range
but that's a basic report - you can fiddle with it afterwards (change the layout add a cust name, etc.)
Note: you can also go to the ledger entry form with no filters to show all
then filter on Doc Type= Credit memo & Open=Yes
then copy & paste the remaining into excel.
http://www.BiloBeauty.com
http://www.autismspeaks.org
Thanks for the info. It was very helpful.
Asah