GL Clearing account reconcilliation report

Yahoo Archive
1
Thanks to all who replied, I am still having problems trying to find a
history of the clearing account in either the PO tables or the APInv tables.
I have always had problems trying to use GL accounts in previous Crystal
Reports.
I have contacted Epicor directly about this to see if they can shed some
light on the linking.

----- Original Message -----
From: <sarah.vareschi@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 11, 2002 12:21 AM
Subject: RE: [Vantage] GL Clearing account reconcilliation report


> YES! You need to link the PO tables to the AP invoice tables, NOT the
> Invoice tables (which are A/R). The PO# in the AR invoice tables should
be
> a number, it links easily in report builder, anyway.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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 http://docs.yahoo.com/info/terms/
>
>
2
Hi all Vantage gurus.
I have a Crystal report which I need to write, and I am having some problems. I am hoping someone here can help.

The report is a General Ledger Clearing account reconcilliation, which basically shows similar info to the 2 internal program reports, General Ledger, and Inventory/WIP reconcilliation.

The report needs to include PONumber, PO Line, Invoiced amount (from Invoice), Purchase Cost (from PO), Adjustment (difference between Invoice cost & PO cost) and Net cost. This will immediately show any inconsistancies between receipts and orders.

I am trying to link PO tables and Invoice tables (this might be incorrect, might I need to use APInv tables instead?)

Problems:-
PONum in PO tables is a number, PONum in Invoice tables is a string and not linkable!
At no point in the history of the PO is there any connection to the Gl Clearing account. (It is there, but no PO refers to it.)
Has anyone got any ideas? How do you do this reconcilliation in your company. It wasn't a problem for us until a manufacturing sub company started using Vantage, and they have lots of purchases (resistors etc) per month.

Any help would be greatly appreciated.

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

Phone: +61 8 8245 6789
Fax: +61 8 8245 6788
Direct Phone: +61 8 8245 6732
Postal Address: PO Box 1141, Marleston SA 5033
Site Address: 37 Belford Ave, Devon Pk SA 5008
================================
email: dsloan@...
Web: http://www.entechgroup.net
================================


[Non-text portions of this message have been removed]
3
>>PONum in PO tables is a number, PONum in Invoice tables is a string and not linkable!

It is possible to link a number to a string by using a subreport in Crystal. You create a formula in the main report which converts the number to a string (or vice versa), and then you can link the formula to the String field (or number field if you used the vice versa) in the Subreport.

It slows the report down a bit, but it works.

Troy Funte
Liberty Electronics

----- Original Message -----
From: David Sloan
To: vantage@yahoogroups.com
Sent: Wednesday, January 09, 2002 6:52 PM
Subject: [Vantage] GL Clearing account reconcilliation report


Hi all Vantage gurus.
I have a Crystal report which I need to write, and I am having some problems. I am hoping someone here can help.

The report is a General Ledger Clearing account reconcilliation, which basically shows similar info to the 2 internal program reports, General Ledger, and Inventory/WIP reconcilliation.

The report needs to include PONumber, PO Line, Invoiced amount (from Invoice), Purchase Cost (from PO), Adjustment (difference between Invoice cost & PO cost) and Net cost. This will immediately show any inconsistancies between receipts and orders.

I am trying to link PO tables and Invoice tables (this might be incorrect, might I need to use APInv tables instead?)

Problems:-
PONum in PO tables is a number, PONum in Invoice tables is a string and not linkable!
At no point in the history of the PO is there any connection to the Gl Clearing account. (It is there, but no PO refers to it.)
Has anyone got any ideas? How do you do this reconcilliation in your company. It wasn't a problem for us until a manufacturing sub company started using Vantage, and they have lots of purchases (resistors etc) per month.

Any help would be greatly appreciated.

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

Phone: +61 8 8245 6789
Fax: +61 8 8245 6788
Direct Phone: +61 8 8245 6732
Postal Address: PO Box 1141, Marleston SA 5033
Site Address: 37 Belford Ave, Devon Pk SA 5008
================================
email: dsloan@...
Web: http://www.entechgroup.net
================================


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


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]
4
YES! You need to link the PO tables to the AP invoice tables, NOT the
Invoice tables (which are A/R). The PO# in the AR invoice tables should be
a number, it links easily in report builder, anyway.



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