Account adjustment reporting

Howdy,

Can anyone tell me how to generate a report showing all adjustments to all 
customer accounts for a specific period?  

ie: We give store credit for consignment/ swap items sold.  these credits 
are applied to a customers acct.  I want to know the dollar amount of credits 
made in June etc.

Also a report showing the entire history of a specific customers acct would 
be nice

thanks
-- 
Jon Kahn
Confluence Kayaks
0
7/18/2007 9:26:03 PM
pos 14173 articles. 0 followers. Follow

3 Replies
497 Views

Similar Articles

[PageSpeed] 25

This is a multi-part message in MIME format.

------=_NextPart_000_03DA_01C7CA42.990878B0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_03DB_01C7CA42.990878B0"


------=_NextPart_001_03DB_01C7CA42.990878B0
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

Jon,

Attached

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "confluencekayaks" <confluencekayaks@discussions.microsoft.com> wrote =
in message news:D34E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com...
  Howdy,

  Can anyone tell me how to generate a report showing all adjustments to =
all=20
  customer accounts for a specific period? =20

  ie: We give store credit for consignment/ swap items sold.  these =
credits=20
  are applied to a customers acct.  I want to know the dollar amount of =
credits=20
  made in June etc.

  Also a report showing the entire history of a specific customers acct =
would=20
  be nice

  thanks
  --=20
  Jon Kahn
  Confluence Kayaks
------=_NextPart_001_03DB_01C7CA42.990878B0
Content-Type: text/html;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Jon,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Attached</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"confluencekayaks" &lt;<A=20
  =
href=3D"mailto:confluencekayaks@discussions.microsoft.com">confluencekaya=
ks@discussions.microsoft.com</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:D34E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com">news:D34=
E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com</A>...</DIV>Howdy,<BR><BR=
>Can=20
  anyone tell me how to generate a report showing all adjustments to all =

  <BR>customer accounts for a specific period?&nbsp; <BR><BR>ie: We give =
store=20
  credit for consignment/ swap items sold.&nbsp; these credits <BR>are =
applied=20
  to a customers acct.&nbsp; I want to know the dollar amount of credits =

  <BR>made in June etc.<BR><BR>Also a report showing the entire history =
of a=20
  specific customers acct would <BR>be nice<BR><BR>thanks<BR>-- <BR>Jon=20
  Kahn<BR>Confluence Kayaks</BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_03DB_01C7CA42.990878B0--

------=_NextPart_000_03DA_01C7CA42.990878B0
Content-Type: application/octet-stream;
	name="Custom - Customer - Account Adjustments.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Custom - Customer - Account Adjustments.qrp"

//--- Report Summary --- //

Begin ReportSummary
   ReportType =3D reporttypeCustomer
   ReportTitle =3D "Account Adjustments"
   PageOrientation =3D pageorientationLandscape
   WordWrap =3D False
   ShowDateTimePicker =3D True
   OutLineMode =3D True
   Groups =3D 1
   GroupDescription =3D "Total"
   DisplayLogo =3D True
   LogoFileName =3D "MyLogo.bmp"
   ProcedureCall =3D ""
   PreQuery1 =3D ""
   PreQuery2 =3D ""
   TablesQueried =3D <BEGIN>
	FROM AccountReceivable LEFT JOIN Customer ON =
AccountReceivable.CustomerID =3D Customer.ID
	LEFT JOIN Store on AccountReceivable.StoreID =3D Store.ID
	<END>
   SelCriteria =3D ""
   GroupBy =3D ""
   SortOrder =3D ""
End ReportSummary


//--- Title Rows ---//

Begin TitleRow
   Text =3D "<Store Name>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 16
   Color =3D "Blue"
End TitleRow

Begin TitleRow
   Text =3D "<Report Title>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 12
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "As Of: <Report Date>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 10
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "Designed and/or modified by Microsoft Corp. and/or Check =
Point Software"
   Font =3D "Arial"
   FontBold =3D False
   FontSize =3D 8
   Color =3D "Black"
End TitleRow

//--- Filters ---//


//--- Columns ---//
Begin Column
   FieldName =3D "Store.Name"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Store"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2190
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column


Begin Column
   FieldName =3D "Customer.AccountNumber"
   DrillDownFieldName =3D "Customer.AccountNumber"
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Account #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2190
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Customer.Company"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Company"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1890
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "CustomerName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Name"
   VBDataType =3D vbString
   Formula =3D "Customer.LastName + ', ' + Customer.FirstName"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D True
   ColWidth =3D 2025
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Customer.LastName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Last Name"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D True
   FilterDisabled =3D False
   ColWidth =3D 870
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Customer.FirstName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "First Name"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D True
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "AccountReceivable.ID"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Adj. ID"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 645
   GroupMethod =3D groupmethodNone
   ColFormat =3D "#######"
End Column

Begin Column
   FieldName =3D "AccountReceivable.Date"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Date"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1005
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "AccountReceivable.OriginalAmount"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Adjust. Amount"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1530
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "AccountReceivable.Balance"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Adjust. Balance"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1575
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column


------=_NextPart_000_03DA_01C7CA42.990878B0--

0
cptsoft (1248)
7/20/2007 3:22:58 AM
Jeff,

Thank you very Much... that solves both problems since I can sort by 
customer and/ or date...
Is it possible to add the Adjustment Comment field to that report?

thanks
-- 
Jon Kahn
Confluence Kayaks


"Jeff @ Check Point Software" wrote:

> Jon,
> 
> Attached
> 
> --
> 
> Jeff
> Check Point Software
> 
> =====================================================
> 
> You must be using Outlook Express/Windows Mail or some other type of
> newsgroup reader to
> see and download the file attachment(s).  If you are not using a reader,
> follow
> the link below to setup Outlook Express.  Click on "Open with newsreader"
> under the MS Retail Management System on the right.
> 
> http://tinyurl.com/75bgz
> =====================================================
> 
>   "confluencekayaks" <confluencekayaks@discussions.microsoft.com> wrote in
> message news:D34E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com...
>   Howdy,
> 
>   Can anyone tell me how to generate a report showing all adjustments to
> all
>   customer accounts for a specific period?
> 
>   ie: We give store credit for consignment/ swap items sold.  these
> credits
>   are applied to a customers acct.  I want to know the dollar amount of
> credits
>   made in June etc.
> 
>   Also a report showing the entire history of a specific customers acct
> would
>   be nice
> 
>   thanks
>   --
>   Jon Kahn
>   Confluence Kayaks
> 
0
7/20/2007 5:14:04 PM
This is a multi-part message in MIME format.

------=_NextPart_000_02EA_01C7F01A.2D267720
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_02EB_01C7F01A.2D267720"


------=_NextPart_001_02EB_01C7F01A.2D267720
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Jon,

Attached.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "confluencekayaks" <confluencekayaks@discussions.microsoft.com> wrote =
in message news:BD4D8593-0D00-4313-97D8-296BCA0996CD@microsoft.com...
  Jeff,

  Thank you very Much... that solves both problems since I can sort by=20
  customer and/ or date...
  Is it possible to add the Adjustment Comment field to that report?

  thanks
  --=20
  Jon Kahn
  Confluence Kayaks


  "Jeff @ Check Point Software" wrote:

  > Jon,
  >=20
  > Attached
  >=20
  > --
  >=20
  > Jeff
  > Check Point Software
  >=20
  > =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
  >=20
  > You must be using Outlook Express/Windows Mail or some other type of
  > newsgroup reader to
  > see and download the file attachment(s).  If you are not using a =
reader,
  > follow
  > the link below to setup Outlook Express.  Click on "Open with =
newsreader"
  > under the MS Retail Management System on the right.
  >=20
  > http://tinyurl.com/75bgz
  > =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
  >=20
  >   "confluencekayaks" <confluencekayaks@discussions.microsoft.com> =
wrote in
  > message news:D34E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com...
  >   Howdy,
  >=20
  >   Can anyone tell me how to generate a report showing all =
adjustments to
  > all
  >   customer accounts for a specific period?
  >=20
  >   ie: We give store credit for consignment/ swap items sold.  these
  > credits
  >   are applied to a customers acct.  I want to know the dollar amount =
of
  > credits
  >   made in June etc.
  >=20
  >   Also a report showing the entire history of a specific customers =
acct
  > would
  >   be nice
  >=20
  >   thanks
  >   --
  >   Jon Kahn
  >   Confluence Kayaks
  >
------=_NextPart_001_02EB_01C7F01A.2D267720
Content-Type: text/html;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3Dtext/html;charset=3Dutf-8>
<META content=3D"MSHTML 6.00.6000.16527" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12pt; =
COLOR: #008000; PADDING-TOP: 15px; FONT-FAMILY: Arial"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true" =
acc_role=3D"text"=20
name=3D"Compose message area">
<DIV>Jon,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Attached.</DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"confluencekayaks" &lt;<A=20
  title=3Dmailto:confluencekayaks@discussions.microsoft.com=20
  =
href=3D"mailto:confluencekayaks@discussions.microsoft.com">confluencekaya=
ks@discussions.microsoft.com</A>&gt;=20
  wrote in message <A=20
  title=3Dnews:BD4D8593-0D00-4313-97D8-296BCA0996CD@microsoft.com=20
  =
href=3D"news:BD4D8593-0D00-4313-97D8-296BCA0996CD@microsoft.com">news:BD4=
D8593-0D00-4313-97D8-296BCA0996CD@microsoft.com</A>...</DIV>Jeff,<BR><BR>=
Thank=20
  you very Much... that solves both problems since I can sort by =
<BR>customer=20
  and/ or date...<BR>Is it possible to add the Adjustment Comment field =
to that=20
  report?<BR><BR>thanks<BR>-- <BR>Jon Kahn<BR>Confluence =
Kayaks<BR><BR><BR>"Jeff=20
  @ Check Point Software" wrote:<BR><BR>&gt; Jon,<BR>&gt; <BR>&gt;=20
  Attached<BR>&gt; <BR>&gt; --<BR>&gt; <BR>&gt; Jeff<BR>&gt; Check Point =

  Software<BR>&gt; <BR>&gt;=20
  =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D<BR>&gt; <BR>&gt; You=20
  must be using Outlook Express/Windows Mail or some other type =
of<BR>&gt;=20
  newsgroup reader to<BR>&gt; see and download the file =
attachment(s).&nbsp; If=20
  you are not using a reader,<BR>&gt; follow<BR>&gt; the link below to =
setup=20
  Outlook Express.&nbsp; Click on "Open with newsreader"<BR>&gt; under =
the MS=20
  Retail Management System on the right.<BR>&gt; <BR>&gt; <A=20
  title=3Dhttp://tinyurl.com/75bgz=20
  href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>&gt; =

  =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D<BR>&gt;=20
  <BR>&gt;&nbsp;&nbsp; "confluencekayaks" &lt;<A=20
  title=3Dmailto:confluencekayaks@discussions.microsoft.com=20
  =
href=3D"mailto:confluencekayaks@discussions.microsoft.com">confluencekaya=
ks@discussions.microsoft.com</A>&gt;=20
  wrote in<BR>&gt; message <A=20
  title=3Dnews:D34E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com=20
  =
href=3D"news:D34E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com">news:D34=
E6035-3D17-4E3D-8B4C-3E0C467A099B@microsoft.com</A>...<BR>&gt;&nbsp;&nbsp=
;=20
  Howdy,<BR>&gt; <BR>&gt;&nbsp;&nbsp; Can anyone tell me how to generate =
a=20
  report showing all adjustments to<BR>&gt; all<BR>&gt;&nbsp;&nbsp; =
customer=20
  accounts for a specific period?<BR>&gt; <BR>&gt;&nbsp;&nbsp; ie: We =
give store=20
  credit for consignment/ swap items sold.&nbsp; these<BR>&gt;=20
  credits<BR>&gt;&nbsp;&nbsp; are applied to a customers acct.&nbsp; I =
want to=20
  know the dollar amount of<BR>&gt; credits<BR>&gt;&nbsp;&nbsp; made in =
June=20
  etc.<BR>&gt; <BR>&gt;&nbsp;&nbsp; Also a report showing the entire =
history of=20
  a specific customers acct<BR>&gt; would<BR>&gt;&nbsp;&nbsp; be =
nice<BR>&gt;=20
  <BR>&gt;&nbsp;&nbsp; thanks<BR>&gt;&nbsp;&nbsp; --<BR>&gt;&nbsp;&nbsp; =
Jon=20
  Kahn<BR>&gt;&nbsp;&nbsp; Confluence =
Kayaks<BR>&gt;</BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_02EB_01C7F01A.2D267720--

------=_NextPart_000_02EA_01C7F01A.2D267720
Content-Type: application/octet-stream;
	name="Custom - Customer - Account Adjustments.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Custom - Customer - Account Adjustments.qrp"

//--- Report Summary --- //

Begin ReportSummary
   ReportType =3D reporttypeCustomer
   ReportTitle =3D "Account Adjustments"
   PageOrientation =3D pageorientationLandscape
   WordWrap =3D False
   ShowDateTimePicker =3D True
   OutLineMode =3D True
   Groups =3D 1
   GroupDescription =3D "Total"
   DisplayLogo =3D True
   LogoFileName =3D "MyLogo.bmp"
   ProcedureCall =3D ""
   PreQuery1 =3D ""
   PreQuery2 =3D ""
   TablesQueried =3D <BEGIN>
	FROM AccountReceivable=20
	LEFT JOIN Customer ON AccountReceivable.CustomerID =3D Customer.ID
	LEFT JOIN Store on AccountReceivable.StoreID =3D Store.ID
	LEFT JOIN AccountReceivableHistory on AccountReceivable.ID =3D =
AccountReceivableHistory.AccountReceivableID=09
<END>
   SelCriteria =3D ""
   GroupBy =3D ""
   SortOrder =3D ""
End ReportSummary


//--- Title Rows ---//

Begin TitleRow
   Text =3D "<Store Name>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 16
   Color =3D "Blue"
End TitleRow

Begin TitleRow
   Text =3D "<Report Title>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 12
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "As Of: <Report Date>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 10
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "Designed and/or modified by Microsoft Corp. and/or Check =
Point Software"
   Font =3D "Arial"
   FontBold =3D False
   FontSize =3D 8
   Color =3D "Black"
End TitleRow

//--- Filters ---//


//--- Columns ---//


Begin Column
   FieldName =3D "Customer.AccountNumber"
   DrillDownFieldName =3D "Customer.AccountNumber"
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Account #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2190
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Customer.Company"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Company"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1890
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "CustomerName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Name"
   VBDataType =3D vbString
   Formula =3D "Customer.LastName + ', ' + Customer.FirstName"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D True
   ColWidth =3D 2025
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Customer.LastName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Last Name"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D True
   FilterDisabled =3D False
   ColWidth =3D 870
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Customer.FirstName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "First Name"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D True
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "AccountReceivable.ID"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Adj. ID"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 645
   GroupMethod =3D groupmethodNone
   ColFormat =3D "#######"
End Column

Begin Column
   FieldName =3D "AccountReceivable.Date"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Date"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1005
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "AccountReceivable.OriginalAmount"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Adjust. Amount"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1530
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "AccountReceivable.Balance"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Adjust. Balance"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1575
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "AccountReceivableHistory.Comment"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Adj. Comment"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D True
   ColWidth =3D 2500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

------=_NextPart_000_02EA_01C7F01A.2D267720--

0
cptsoft (1248)
9/6/2007 7:09:22 AM
Reply:

Similar Artilces:

Can't create an account to account relationship in the account ent
Is this because the default (Parent Account) relationship already exists? Can you not have duplicate relationships? Thanks in advance for the clarification. > Is this because the default (Parent Account) relationship already exists? Yes. > Can you not have duplicate relationships? Yes, you cannot have duplicate relationships in this manner. To do this you need to use the Relationships/Relationship Roles functionality, where you can pretty much do any kind of relationship between clients (ie accounts and contacts.) HTH, R. "GoodByeGoldmine" wrote: > Is this beca...

exchange accounts will not delete from site
I have recently recovered one of my exchange 5.5 servers that crashed. Mailboxes have been restored and replication appears to complete only down to the restored server but not up to the main site mail server that holds the global address list. Due to lack of information in backups, it was necessary for me to manually recreate all mailboxes and then restore mailboxes. However, the new accounts have created with a "2" appended to each mailbox name. Example john@us.com is automatically created as john2@us.com. How do I purge the old accounts from the global list so that I can crea...

Muliple Exchange OMA User Accounts from One SmartPhone
I wish to be able to access multiple user accounts (all on the same Exchange 2003 server) from a single smartphone running Windows Mobile 5.0. After setting up OMA on Exchange and the smartphone and visiting https://FQDN/oma all works well after entering the username and password for one account, but then the smartphone remembers the login (presumably via a cookie) for future visits to the same URL. There seems to be no easy way to delete the cookie on the smartphone, so all subsequent accesses to OMA go straight through to the same user account. One way I have considered tackling this is to ...

Extreme Delays Deleting Change Orders from Project Accounting
We use Project Accounting for Dynamix GP and we are attempting to start using the Change Order features to track changes made to project budget and fees. Unfortunately, during testing, we are experiencing a five to ten minute delay whenever we try to delete an incorrectly entered change order. This occurs even if we simply start to create a change order, never use it for anything and immediately attempt to delete it. Has anyone experienced this, or can anyone propose any clues on what I should look at to find what is causing this large pause? -- Jim Rowley Business Analyst II ...

Re Label Accounts Field
Anybody know how to change the Accounts field label to something else e.g. Organization, or Business? You can rename the 'account' entity to be 'Business'. Organization is a reserved word in CRM (there is already an orgainzation object) so it's off-limits. Dave "Owais" <Owais @discussions.microsoft.com> wrote in message news:25767F85-513C-40F7-A82F-F0E5A627D9FF@microsoft.com... > Anybody know how to change the Accounts field label to something else e.g. > Organization, or Business? ...

want to transfer out funds from a fund within an account to a fund within the same account.
I want to do this to preserve my cost basis. I have a 401k that lets say has a fund that I bought for 100 bucks and it gained 10 dollars. when I issue a buy/sell to transfer it to another fund (within the same 401k account) the new cost basis is 110 dollars instead of the 100 that I actually spent. I know that using transfer in/out will preserve this cost basis, but it doesnt seem to work within an account per other threads of this nature. How can I do something similar within the same account? I am using 2005 premium. Thanks Vic. I don't think your use of Cost Basis reflects tax la...

Excel Templates / Files as Reports?
Hello, we're desperately trying to find a solution to publish customized reports in CRM 3.0 (we've had the Customizatrion Course, but we didn't really discuss much in there). For us, a report in this case is a customized print-out of the data of *one single* contact (the printed version of the contact that is printed when pressing the printer-button in a given contact prints out several pages and does not help us much). From all we found so far, it appears we have to edit a report as an ..rdl-file in Visual Studio .net 2K3 (MS Development Environment Center) and then upl...

Departments on Z Report
Hello, I have noticed that as I set up new departments and categories into the database, the new departments are always printed last...or below all of the other departments. Is there a way to change this, and possibly have them organized alphebetically or in an order I would like? Thank You, Vicne Perhaps if you modified the department table usinfg Microsoft Access 2003 .... not that I would advise that :-) Vince... is this you... my buddy? Since you don't use an email address... I'm never sure if it you... and then I worry I'm getting too personal with someone I don'...

Forwarding email to an external account
If I want to foreward email coming into my exchange account to a personal account such as hotmail for example, how can this be done? In Active Directory Users and Computer, you look at the User's Properties, you look under the "Exchange General" Tab, you look at the "delivery option", you see "forwarding address", you say "ha, ha!" and do some jiggy dance :) I only do this for ex-employees for 30 days at the request of HR. -- Sincerely, D�j� Ak�m�l�f�, MCSE MCSA MCP+I www.akomolafe.com www.iyaburo.com Do you now realize that Today is the Tomorro...

Problem configuring Outlook 2007 w/ job email account
I recently installed Outlook 2007 to my laptop (which uses Vista). Upon trying to "setup" Outlook a small box appeared in the upper left corner of the screen which stated "configuring outlook accounts." A box appeared asking for "Microsoft Exchange Server" and "mailbox." I was not sure as to what to enter so I entered "dss.sc.gov" (which is everything listed after the "@" in my job email address) for the server and my name for mailbox. I then received the following error message: "The connection to Microsoft Exchange is ...

Loan account
Hi, Something else that's giving me trouble. I've set up a loan account - all seems to be fine. It's a three year loan, and the first two payments had already been made when I set the thing up in Money. Money coped with this fine, and within the register of the loan account it now accurately shows the first two payments and the principal-element of each payment, together with the diminishing value of the outstanding loan. However, it doesn't seem to be linked in any way to the account from which the payments are actually being made. Conceptually it seems to me that the loan ...

Report writer Table security violation
I have a user that is getting a table security violation when they are running financial reports out of report writer. This seemed to start after upgrading to 10. ------=_NextPart_0001_8AA41D26 Content-Type: text/plain Content-Transfer-Encoding: 7bit Check that they have access to the tables they need. You can install the Support Debugging Tool for assistance with security issues using the Security Profiler and Security Information windows. http://blogs.msdn.com/developingfordynamicsgp/archive/2009/08/05/installing-the-support-debugging-tool-for-microsoft-dynamics-gp- faq.aspx David ...

Can't set up HTTP account!!
I'm setting up Outlook on a friends computer. On their old computer they were able to view their Charter Communications email account through Outlook. I am trying to set it up so they can do it in XP, but it won't let me see their messages it just comes up blank. What am I doing wrong??!! P.S.- They don't have an account through Outlook/Microsoft Thanks, Locke ...

Monthly Reports Don't Load
When I try to get a monthly report or a report of spending by category, the screen just says "loading" but never produces the report even after a very long time. I'm using MoneyPlus Deluxe, but I had the very same problem with Money 2007. In microsoft.public.money, Davered wrote: >When I try to get a monthly report or a report of spending by category, the >screen just says "loading" but never produces the report even after a very >long time. I'm using MoneyPlus Deluxe, but I had the very same problem with >Money 2007. You might consider File-&...

Convert Lead > Account-Contact-Opportunity Error
Hi, I have several leads opened. If I create a new one it will work "but" especially with this ONE lead I don't get it, I convert it either to Account - Contacts or Opportunity and gives me the following error. I repeat this is only for this one. I tried to close reopen change settings etc... Still not working. Microsoft CRM Platform Error Report: Error Description: Exception from HRESULT: 0x80042F09. Error Details: Details on this error have not been provided by the platform. Error Number: 0x80042F09 Source File: Not available Line Number: Not available Date: 10-2...

Multiple Email Accounts
I have three email accounts. I can only send message from one - some sort of automatic default. How can I select (with each email), what account I want to use to send a message? What version of Outlook are you using, and if 98 or 2000, what mail support mode? If you're not sure, look at the second line of Help | About Microsoft Outlook -- it should say "Internet Mail Only" or "Corporate/Workgroup". (Outlook 97, 2002, and 2003 don't have separate modes.) -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- please ...

Turn off Autogenerate account description
I found out there isn't a way to turn off the autogenerate account description through Customer Source. I would like to add this as a suggestion for future release where I can click a button and it'll not autogenerate the account description for me. It's a nice feature, but it doesn't work for my intent. I understand that the autogenerate account description comes from the account segment list, however, my account segment list doesn't do the account description any justice b/c I have 5 segments, and the names can be long, so GP will truncate it, but not where I wan...

Accountants online, Online accountants, Accountancy services
Title: Accountants online, Online accountants, Accountancy services Accountants online is an entirely new concept which harnesses the power of outsourcing and international website development. we can offer a broad range of web, print, bookkeeping, news report and accountancy services, as well as options to regularly update your customers via emails, Search Engine Optimization and statistics on your site to get feedback on your marketing. We offer a suite of online accountancy services designed for you to outsource labour intensive or routine services at very competitive rates while you stay i...

Money 2005
I upgraded my money 2004 file to money 2005. I then turned off MSN Bill Pay and set up my accounts to be accessed on the web. After synchronization, my MSN Bill Pay account (MSN-Checking) showed up in my account list. I want to link this account to my checking account, but when I select "Merge Duplicate Accounts", it states there are no accounts to merge. The help file tells you to follow these exact steps. Does anybody know a work-around to get this working? Thanks in advance, Brian Don't follow the directions given. Instead, try the following: Open your 2004 f...

New Account for CD
I bought a CD and don't know how to set it up in Money (using Money Plus H&B). When I tried setting it up as a bank savings account there was a note that said I should set it up as an investment account. When I set up the investment account it does not ask me any questions about the CD or even if it is a CD. What am I missing. It seems like it should be a savings account. Please help me? A Savings Account can be used. If you only ever intend to have one CD at a time, that's probably easier. But if you want to manage multiple individual CDs over time, then the Investmen...

Tracking Investments By Account
How do I track an investment by Account only? I hold the same investment in several accounts. I want to see the performance of that investment in that account only and not the accumulated performance accross all accounts! In microsoft.public.money, Bill wrote: >How do I track an investment by Account only? I hold the >same investment in several accounts. I want to see the >performance of that investment in that account only and >not the accumulated performance accross all accounts! Look at Investing->Portfolio and group by Account Name. Select the view you prefer, and c...

Time report
I want to use Outlook in combination with my pocket PC to keep track of the time I spend on various projects. Adding posts on the pocket PC and get it to sync with Outlook on the stationary is no problem. But I cannot find a simple way of extracting the data from the calender into, say, a spreadsheet. I have come as far as printing a pdf of a search list, and then copying that into Excel. Have someone out there come across a better way? Thanks... Ah, well... Found and tried the import/EXPORT! function, and it works just nice. Nice forum, anyway. "Bengaloo" skrev: > I ...

Outlook keeps "forgetting" account password
I am running Outlook 2002 as part of the Office 2002 Professional suite on a machine with MS Vista Home Premium. Every time I open Outlook, the password for my account is apparently "forgotten" and needs to be typed in. However, when I do this, I get an error message: "Task 'mail.bigpond.com - Sending and Receiving' reported error (0x800CCC92) : 'Your e-mail server rejected your login. Verify your user name and password in your account properties. Under Tools, click E-mail accounts. The server responded: �" But the error is not that the password has bee...

I should be able to run the same reports in POS and in Manager
I am able to run reports in the POS at the click of a button by going to Shift F6...I can compare data at the touch of a button...when doing so in Manager, it's more complicated, and there are no charts...which personally I like to look at. It's just faster in the POS...Should be the same in manager! -- Thank You Vince :) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link...

Printing Bank Account
I can't print just one back account...at a time...when I select print it prints out all transactions from all bank accounts. In microsoft.public.money, dd wrote: >I can't print just one back account...at a time...when I >select print it prints out all transactions from all bank >accounts. What screen are you looking at when you do File->Print? ...