Trying to reproduce built-in Aged Receivables and Aged Payables

Yahoo Archive
1
You might also try filtering on {APInvHed.OpenPayable} (meaning OpenPayable
is TRUE).


Troy
-----Original Message-----
From: Gordon Schindell [mailto:gordons@...]
Sent: Thursday, July 17, 2003 4:01 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Trying to reproduce built-in Aged Receivables and Aged
Payables in Crystal


All,

Has anyone tried to reproduce the Aged Payables and/or the Aged
Receivables
reports in Crystal? I can't seem to get the same values that Vantage gets
no matter what I try. Values can be high, low, or non-existent.

On the Payables report, for instance, I have three tables: APTran
(primary),
linked to Vendor through company and VendorNum, and APInvHed linked to
APTran through company and InvoiceNum. I group by Vendor.VendorID, and
filter by ApTran.FiscalPeriod = x, .FiscalYear = x, APInvHed.InvoiceDate
<=
x, and APTran.Posted = True. Whatever I use for x never matches the
built-in report, and I can't seem to see a pattern.

If anyone has any ideas about this, or has already created this report,
please let me know!

Thanks,

Gord Schindell
Network Administrator
Almac Machine Works, Ltd.

Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
2
All,

Has anyone tried to reproduce the Aged Payables and/or the Aged Receivables
reports in Crystal? I can't seem to get the same values that Vantage gets
no matter what I try. Values can be high, low, or non-existent.

On the Payables report, for instance, I have three tables: APTran (primary),
linked to Vendor through company and VendorNum, and APInvHed linked to
APTran through company and InvoiceNum. I group by Vendor.VendorID, and
filter by ApTran.FiscalPeriod = x, .FiscalYear = x, APInvHed.InvoiceDate <=
x, and APTran.Posted = True. Whatever I use for x never matches the
built-in report, and I can't seem to see a pattern.

If anyone has any ideas about this, or has already created this report,
please let me know!

Thanks,

Gord Schindell
Network Administrator
Almac Machine Works, Ltd.
3
The other thing you might look into is whether to use InvoiceDate or DueDate
for your breakdowns by period.

Troy
-----Original Message-----
From: Gordon Schindell [mailto:gordons@...]
Sent: Thursday, July 17, 2003 4:01 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Trying to reproduce built-in Aged Receivables and Aged
Payables in Crystal


All,

Has anyone tried to reproduce the Aged Payables and/or the Aged
Receivables
reports in Crystal? I can't seem to get the same values that Vantage gets
no matter what I try. Values can be high, low, or non-existent.

On the Payables report, for instance, I have three tables: APTran
(primary),
linked to Vendor through company and VendorNum, and APInvHed linked to
APTran through company and InvoiceNum. I group by Vendor.VendorID, and
filter by ApTran.FiscalPeriod = x, .FiscalYear = x, APInvHed.InvoiceDate
<=
x, and APTran.Posted = True. Whatever I use for x never matches the
built-in report, and I can't seem to see a pattern.

If anyone has any ideas about this, or has already created this report,
please let me know!

Thanks,

Gord Schindell
Network Administrator
Almac Machine Works, Ltd.

Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]