Hi,
Basically the main tables involved will be RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL and AR_PAYMENT_SCHEDULED_ALL.
However the report itself is taking also receipts on account etc.....
Please see also my private message on how to get the detailed query ran by the report (Debug Flag of ...
Search found 5 matches
- Sat Oct 18, 2008 6:40 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Invoice aging report Query/ tables involved
- Replies: 1
- Views: 1505
- Fri Oct 17, 2008 7:47 am
- Forum: Application DBA & System Administration
- Topic: Web ADI
- Replies: 4
- Views: 2296
- Fri Oct 17, 2008 7:35 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: how to create prepayement invoice to a supplier
- Replies: 2
- Views: 1027
Use Invoice Type prepeyment and enter the invoice as normal. Don't use VAT on the prepayment invoice but enter it with VAT on the Distribution Line and enter Tax Code (no VAT or something like that).
You can pay this prepayment through manual payment or with a payment batch.
When the actual invoice ...
You can pay this prepayment through manual payment or with a payment batch.
When the actual invoice ...
- Fri Oct 17, 2008 7:32 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Invoices not showing to a user
- Replies: 4
- Views: 1251
- Fri Oct 17, 2008 7:27 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Invoice shows Complete but Status_trx = OP in the
- Replies: 1
- Views: 2070