AP191 – Unrealized Gain or Loss
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 10 tables
- References
- 22 tables
AP191 (Unrealized Gain or Loss) is a Lawson Accounts Payable batch program. It updates ADDRDATA, APDISTRIB, APINVOICE, APMONITOR, APPAYMENT, APVENBAL, CKPOINT, JBOOKHDR and 2 more and references APACCRCODE, APCOMPANY, APINUSRFLD, APPAYGROUP, APPROCLEV, APVENGROUP, APVENLOC, APVENMAST and 14 more.
About AP191
Run Unrealized Gain or Loss (AP191) for companies that pay non-base currency invoices to calculate and create unrealized gain and loss general ledger transactions for payment accrual and unrealized gain and loss accounts. Unrealized gain and loss transactions are created for released, non-basecurrency invoices only. **Processing Effect AP191 compares the currency exchange rate in effect at the time of invoice entry to the exchange rate in effect as of the Revalue Date you define. If a difference exists, the form creates an unrealized gain or loss transaction for the invoice. If the rate increased, this form creates an unrealized loss transaction. Likewise, if the rate decreased, the form creates an unrealized gain transaction. When the invoice is paid, Payment Closing (AP170) reverses the unrealized gain or loss entry, and creates a realized gain or loss general ledger transaction to reflect any exchange rate fluctuation between theinvoice date and the payment date. If unrealized gain or loss transactions are created for the same invoice in more than one accounting period, the entries for the previous periods are automatically reversed and the newly calculated unrealized gain and lossentries are sent to the general ledger for the current accounting period. Entries created by this form are summarized when they are transferred to thegeneral ledger. *** More Information When revaluing invoices that have retainage, the offset to the unrealizedgain/loss is split between the AP accrual code and retainage accrual code. Revaluation for non-retainage payments go to the AP accrual code, whilerevaluations for the retainage payments go to the accrual code assigned to thepayment or the retainage code assigned to the invoice.
Updated files (10)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APDISTRIB | Invoice Distribution | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| APVENBAL | Vendor Balance | AP |
| CKPOINT | No description in the Lawson data dictionary | — |
| JBOOKHDR | Journal Book Header | IF |
| POMATCHOBJ | Cost Change Information | PO |
| SYSTEMCODE | System Code | IF |
Referenced files (22)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APINUSRFLD | AP Invoice User Fields | AP |
| APPAYGROUP | Pay Group | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| CUACCT | Currency Gain and Loss Account | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| POMATCHOBJ | Cost Change Information | PO |
| PORECEIVE | PO Receivers | PO |
| PORECLINE | PO Line Item Receivings | PO |
| PURCHORDER | Purchase Order Master | PO |
Program calls
Invoked programs (20)
ACAC, ACTA, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU