RE: Reconcile Trade Creditors Account to G/L

If you know your G/L account numbers then the payables report (ACP2??) will
give you the outstanding A/P to match.

If you have various A/P liability G/L accounts then you will need to
summarise otherwise APH (payables header) holds the outstanding base amount
(ABCOUT) of each invoice and AMH (payment header) will hold any unallocated
payments.

The problem isn't finding out how much is owed per se but to what accounts
they have been posted to for matching against G/L.  Query can help (using
APH/AMH and ATY - for G/L account retrieval) to match against G/L.  If
vendor types (ATY) have been changed then it may be difficult to match to
G/L.


Regards


-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]On
Behalf Of Mike Ozanne
Sent: Wednesday, March 31, 2004 6:26 PM
To: SSA's BPCS ERP System
Subject: Re: Reconcile Trade Creditors Account to G/L


At 17:46 31/03/04 +0800, you wrote:
>Hi,
>
>Are there any options available within V4.05 of BPCS that would tell me
>what payables invoices exist with no payments and then match them to the
>G/L.
>
>We are trying to reconcile the G/L Trade Creditors Account to the accounts
>payable.


Look for unmatched records between the Payables file, and the Payments
file, joined on Invoice no.
 From memory (not working well today) APH and ALP (????)

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.