| Insert excerpt |
|---|
Def - Trans - AP Invoice/Credit Memo | Def - Trans - AP Invoice/Credit Memo | | nopanel | true |
|---|
The purpose of this page is to view, add, edit, remove, and post individual AP Invoices and Credit Memo transactions.
Software Version: YYYY.MM.DD and newer
...
- Invoice: A transaction to record a purchase you are making from a Vendor.
- Credit Memo: A transaction to record a return/refund you are getting from Vendor.
...
Home Tab
...
Database Field: ERPx_APTransactionHeader.ExtendedAmount
...
Database Field: ERPx_APTransactionHeader.Description
...
Database Field: ERPx_APTransactionHeader.TransactionDate
...
| Insert excerpt |
|---|
| Def - Trans - AP Invoice/Credit Memo |
|---|
| Def - Trans - AP Invoice/Credit Memo |
|---|
| nopanel | true |
|---|
|
The purpose of this page is to view, add, edit, remove, and post individual AP Invoices and Credit Memo transactions.
Software Version: YYYY.MM.DD and newer
| Toolbar Icons | Description |
|---|
| Delete | | Insert excerpt |
|---|
| Delete - RV Header |
|---|
| Delete - RV Header |
|---|
| nopanel | true |
|---|
|
|
| Grid Layout | | Insert excerpt |
|---|
| Grid Layout - Global |
|---|
| Grid Layout - Global |
|---|
| nopanel | true |
|---|
|
|
| Journal Details | | Insert excerpt |
|---|
| Journal Details - RV Header |
|---|
| Journal Details - RV Header |
|---|
| nopanel | true |
|---|
|
|
| Load from PO | Loads information from the specified purchase order once a PO is entered. This button is disabled once the transaction is Approved or Ready to Post. |
| Help | | Insert excerpt |
|---|
| Help - Global |
|---|
| Help - Global |
|---|
| nopanel | true |
|---|
|
|
| New | | Insert excerpt |
|---|
| New - Multi-Select Trans Type - Global |
|---|
| New - Multi-Select Trans Type - Global |
|---|
| nopanel | true |
|---|
|
- Invoice: A transaction to record a purchase you are making from a Vendor.
- Credit Memo: A transaction to record a return/refund you are getting from Vendor.
|
| Notes | | Insert excerpt |
|---|
| Notes - Global |
|---|
| Notes - Global |
|---|
| nopanel | true |
|---|
|
|
| Save | | Insert excerpt |
|---|
| Save - RV Header |
|---|
| Save - RV Header |
|---|
| nopanel | true |
|---|
|
|
| View Applications | | Insert excerpt |
|---|
| View Applications - Global |
|---|
| View Applications - Global |
|---|
| nopanel | true |
|---|
|
|
Home Tab
| Fields | Description |
|---|
| Amount | | Insert excerpt |
|---|
| Amount (Transaction Amount) - LV |
|---|
| Amount (Transaction Amount) - LV |
|---|
| nopanel | true |
|---|
|
This is a non-editable text box that displays the total amount based on the sum of all transaction lines on the invoice/credit memo. This defaults to blank and is required. If missing, the message "Doc No is required." will be displayed on Save. This is always editable while in a status of New"0.00" and is not required. This field is never editable by the user, but can be changed by updating the quantity and/or price of one or more transaction lines. Database Field: ERPx_APTransactionHeader.DocNumberExtendedAmount |
| Payment TermsDescription | Payment Terms LVPayment Terms LV This is a single-select standard lookup that defaults from the Payment Terms assigned to the 'Vendor Class' of the selected Vendor. This is required and if missing, the message "Payment Terms are required when approving or posting transactions." will be displayed on Save. This is editable on an invoice while in a status of New, but not editable on a credit memo.| Insert excerpt |
|---|
Def - Payment Terms | Def - Payment Terms | | nopanel | true |
|---|
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Payment Terms. Database Fields: ERPx_MFPaymentTerms.PaymentTermName, APTransactionHeader.PaymentTermSK | PO | | Insert excerpt |
|---|
Purchase Order - LV | Purchase Order - LVtext box to assign a description to the invoice/credit memo. This defaults to blank and is not required, but if entered, it must be <=60 characters. This is always editable.Database Field: ERPx_APTransactionHeader.Description |
| Doc Date | | Insert excerpt |
|---|
| Doc Date - RV |
|---|
| Doc Date - RV |
|---|
| nopanel | true |
|---|
|
This is a text box to assign/edit a date for the invoice/credit memo. This defaults to today's date is required. If missing, the message "Doc Date is required." will be displayed on Save. This is always editable while in a status of New.Database Field: ERPx_APTransactionHeader.TransactionDate |
| Doc No | | Insert excerpt |
|---|
| Doc No - RV |
|---|
| Doc No - RV |
|---|
| nopanel | true |
|---|
|
This is a text box to assign a purchase order document number to a the invoice/credit memo. This defaults to blank and is not required , but if entered, it must be <=50 characters. If missing, the message "Doc No is required." will be displayed on Save. This is always editable while in a status of New. Database Field: ERPx_APTransactionHeader.PurchaseOrderIDDocNumber |
| StatusPayment Terms | Status Status | Payment Terms - LV |
|---|
| nopanel | true |
|---|
|
This This is a single-select standard lookup that defaults as 'New' and is required. This is always editable while the transaction is in a Status of 'New' or 'Approved'lookup that defaults from the Payment Terms assigned to the 'Vendor Class' of the selected Vendor. This is required and if missing, the message "Payment Terms are required when approving or posting transactions." will be displayed on Save. This is editable on an invoice while in a status of New, but not editable on a credit memo. Status Status The Statuses that apply to transactions in this List View include: The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Payment Terms. Database Fields: ERPx_MFPaymentTerms.PaymentTermName, APTransactionHeader.PaymentTermSK |
| PO | | Insert excerpt |
|---|
Def - Vendor Name | Def - Vendor Name | | nopanel | true |
|---|
This is a single-select standard lookup to assign a Vendor to the invoice/credit memo. This | Insert excerpt |
|---|
Def - Status - New | Def - Status - New | | nopanel | true |
|---|
| Insert excerpt |
|---|
Def - Status - Approved | Def - Status - Approved | | nopanel | true |
|---|
| Insert excerpt |
|---|
Def - Status - Ready to Post | Def - Status - Ready to Post | | nopanel | true |
|---|
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK | Vendor | | Purchase Order - LV | | Purchase Order - LV |
|---|
| nopanel | true |
|---|
|
This is a text box to assign a purchase order to a invoice/credit memo. This defaults to blank and is not required, but if entered, it must be <=50 characters. This is always editable while in a status of New.Database Field: ERPx_APTransactionHeader.PurchaseOrderID |
| Status | | Insert excerpt |
|---|
| Status - LV |
|---|
| Status - LV |
|---|
| nopanel | true |
|---|
|
This is a single-select standard lookup that defaults as 'New' and is required. This is always editable while the transaction is in a Status of 'New' or 'Approved'.| Insert excerpt |
|---|
| Def - Status |
|---|
| Def - Status |
|---|
| nopanel | true |
|---|
|
The Statuses that apply to transactions in this List View include:| Insert excerpt |
|---|
| Def - Status - New |
|---|
| Def - Status - New |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Approved |
|---|
| Def - Status - Approved |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Ready to Post |
|---|
| Def - Status - Ready to Post |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK |
| Vendor | | Insert excerpt |
|---|
| Def - Vendor Name |
|---|
| Def - Vendor Name |
|---|
| nopanel | true |
|---|
|
This is a single-select standard lookup to assign a Vendor to the invoice/credit memo. This defaults as blank and is required. If not assigned, the message "A Vendor is required." will be displayed on Save. This is always editable while the transaction is in a Status of 'New'.Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
Properties Tab
| Fields | Description |
|---|
| Created By | | Insert excerpt |
|---|
| Created By- RV |
|---|
| Created By- RV |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.CreatedBy |
| Created Date | | Insert excerpt |
|---|
| Created (Date & Time) - RV |
|---|
| Created (Date & Time) - RV |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.CreatedDate |
| Currency ID | | Insert excerpt |
|---|
| Currency - LV |
|---|
| Currency - LV |
|---|
| nopanel | true |
|---|
|
This is a non-editable text box that defaults from the Currency assigned to the 'Vendor Class'. This is required and not editable from this page. Even though this field is required, it is currently for information only and does not drive any functionality. | Insert excerpt |
|---|
| Def - Currency |
|---|
| Def - Currency |
|---|
| nopanel | true |
|---|
|
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Company Currencies. Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK |
| Discount Date | The Discount Date is the date the discount expires. It is based on the number of discount days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of discount days set up on the selected Payment Terms. This is not required and only editable by changing the Payment Terms assigned to the transaction. Database Field: ERPx_APTransactionHeader.DiscountDate |
| Due Date | The Due Date is the date payment is due. It is based on the number of days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of days set up on the selected Payment Terms. This is required and only editable by changing the Payment Terms assigned to the transaction. Database Field: ERPx_APTransactionHeader.DueDate |
| GL Date |
| Fields | Description |
|---|
| Created By | | Insert excerpt |
|---|
| Created By- RV | Created By- RV | nopanel | true| Insert excerpt |
|---|
| GL Date - LV |
|---|
| GL Date - LV |
|---|
| nopanel | true |
|---|
|
This is a editable date picker that defaults as blank and is required. If not
assigned, the message "A Vendor is required." will be displayed on Save. This is always editable while the transaction is in a Status of 'New'.Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK
|---|
Properties Tab
manually edited, will be automatically set to match the 'Doc Date' when the transaction is saved with a Status of either Approved or Ready to Post. This is always editable while the transaction is in a Status of New. Database Field: ERPx_APTransactionHeader. |
| Last Updated | | Insert excerpt |
|---|
| Created Last Updated (Date & Time) - RVCreated |
|---|
| Last Updated (Date & Time) - RV |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.CreatedDateLastUpdated |
| Currency IDLast User |
| Def - Currency | Def - Currency |
| nopanel | true |
|---|
This is a non-editable text box that defaults from the Currency assigned to the 'Vendor Class'. This is required and not editable from this page. Even though this field is required, it is currently for information only and does not drive any functionality. The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Company Currencies.
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK
Discount Date | The Discount Date is the date the discount expires. It is based on the number of discount days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of discount days set up on the selected Payment Terms. This is not |
|---|
| Last Updated By- RV |
|---|
| Last Updated By- RV |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.LastUser | | Pmt./Apply Hold | Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This is an editable text box that defaults as blank and is always editable, even for posted transactions as long as they have not yet been fully applied. - Invoices on hold will not be selected for payment when building AP Check Batches.
- Credit Memos on hold cannot be selected to apply to open Invoice
Database Field: ERPx_APTransactionHeader.IsOnApplicationHold |
| Transaction Class | | Insert excerpt |
|---|
| Def - Transaction Class |
|---|
| Def - Transaction Class |
|---|
| nopanel | true |
|---|
|
This is a non-editable text box that defaults as 'Default' and is not editable.Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK |
| TransactionSK | | Insert excerpt |
|---|
| TransactionSK - RV |
|---|
| TransactionSK - RV |
|---|
| nopanel | true |
|---|
|
This is a non-editable text box that is system generated, required and is not editable.Database Field: ERPx_APTransactionHeader.TransactionHeaderSK |
| Vendor ID |
Database Field: ERPx_APTransactionHeader.GLDate
Last Updated | | Insert excerpt |
|---|
Last Updated (Date & Time) - RV | Last Updated (Date & Time) - RV | | nopanel | true |
|---|
Database Field: ERPx_APTransactionHeader.LastUpdated
Last User | | Insert excerpt |
|---|
Last Updated By- RV | Last Updated By- RV | | nopanel | true |
|---|
Database Field: ERPx_APTransactionHeader.LastUser
| Pmt./Apply Hold | Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This is an editable text box that defaults as blank and is always editable, even for posted transactions as long as they have not yet been fully applied. - Invoices on hold will not be selected for payment when building AP Check Batches.
- Credit Memos on hold cannot be selected to apply to open Invoice
Database Field: ERPx_APTransactionHeader.IsOnApplicationHold |
| Transaction Class | | Insert excerpt |
|---|
Def - Transaction Class | Def - Transaction Class |
| nopanel | true |
|---|
This is a non-editable text box that defaults as 'Default' and is not editable.Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK
TransactionSK | | Insert excerpt |
|---|
TransactionSK - RV | TransactionSK - RV | | nopanel | true |
|---|
This is a non-editable text box that is system generated, required and is not editable.Database Field: ERPx_APTransactionHeader.TransactionHeaderSK
Vendor ID | | Insert excerpt |
|---|
| Def - Vendor ID |
|---|
| Def - Vendor ID |
|---|
| nopanel | true |
|---|
|
This is a non-editable text box that defaults as the Vendor ID of the selected Vendor. This is required and only editable by changing the Vendor assigned to the transaction. Database | | Due Date | The Due Date is the date payment is due. It is based on the number of days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of days set up on the selected Payment Terms. This is required and only editable by changing the Payment Terms assigned to the transaction. Database Field: ERPx_APTransactionHeader.DueDate |
GL Date | | Insert excerpt |
|---|
GL Date - LV | GL Date - LV | | nopanel | true |
|---|
This is a editable date picker that defaults as blank and is required. If not manually edited, will be automatically set to match the 'Doc Date' when the transaction is saved with a Status of either Approved or Ready to Post. This is always editable while the transaction is in a Status of New.| Insert excerpt |
|---|
Def - Vendor ID | Def - Vendor ID_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
Attributes Tab
| Fields | Description |
|---|
| Attributes | | Insert excerpt |
|---|
| Attribute - Attribute - RV |
|---|
| Attribute - Attribute - RV |
|---|
| nopanel | true |
|---|
|
The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → AP Purchasing).
|
| Available | | Insert excerpt |
|---|
| Attribute - Available - RV |
|---|
| Attribute - Available - RV |
|---|
| nopanel | true |
|---|
|
This value is only editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → AP Purchasing → Transactions hyperlink).
|
| Value | | Insert excerpt |
|---|
| Attribute - Value - RV |
|---|
| Attribute - Value - RV |
|---|
| nopanel | true |
|---|
|
|
Page Detail
Items Grid
The purpose of the Items grid is to add, edit and delete the line items for the Invoice and Credit Memo transaction.
| Toolbar Icons | Description |
| Delete | | Insert excerpt |
|---|
| Delete - RV Grid |
|---|
| Delete - RV Grid |
|---|
| nopanel | true |
|---|
|
|
| Excel | | Insert excerpt |
|---|
| Excel - RV Grid |
|---|
| Excel - RV Grid |
|---|
| nopanel | true |
|---|
|
|
| New | | Insert excerpt |
|---|
| New - multi blank rows - RV Grid |
|---|
| New - multi blank rows - RV Grid |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
|---|
| Checkbox | | Insert excerpt |
|---|
| Checkbox (Tag)- RV |
|---|
| Checkbox (Tag)- RV |
|---|
| nopanel | true |
|---|
|
|
| Description | | Insert excerpt |
|---|
| Item Description (user entered) - LV |
|---|
| Item Description (user entered) - LV |
|---|
| nopanel | true |
|---|
|
This is a text box that defaults as blank, is required and must be <= 200 characters. If missing, the message "A Description is required for all line items." will be displayed on Save. This field is always editable while the transaction is in a Status of New or Approved.
Database Field: ERPx_APTransactionLine.LineDescription |
| Distributed To | | Insert excerpt |
|---|
| Distributed To - LV |
|---|
| Distributed To - LV |
|---|
| nopanel | true |
|---|
|
This is a |
non-editable text box single-select standard lookup that defaults as |
the Vendor ID of the selected Vendorblank and is not required. This is |
required and only editable by changing the Vendor assigned to the transaction.Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK
Attributes Tab
| Fields | Description |
|---|
Attributes | | Insert excerpt |
|---|
Attribute - Attribute - RV | Attribute - Attribute - RValways editable while the transaction is in a Status of New. | Insert excerpt |
|---|
| Def - Not Defined |
|---|
| Def - Not Defined |
|---|
| nopanel | true |
|---|
|
|
The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → AP Purchasing). AvailableThe lookup contains a blank value, the current assigned value, and a list of all the 'Active' Vendors, Employees and Projects. Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK |
| Extended | |
Attribute Available - RVAttribute Available - RV This value is only editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → AP Purchasing → Transactions hyperlink). Value This is a single-select standard lookup that defaults as "0.00" and is required. This can only be edited by changing the Quantity and/or Price of the transaction line. Database Field: ERPx_APTransactionLine.ExtendedAmount |
| Price | |
Attribute Value - RVAttribute Value - RVPage Detail
Items Grid
The purpose of the Items grid is to add, edit and delete the line items for the Invoice and Credit Memo transaction.
| Toolbar Icons | Description |
Delete This is a text box that defaults as "0.00" and is required when the Status is set to Approved. If missing, the message "Price is required and must be greater than zero." will be displayed on Save. This is always editable while the transaction is in a Status of New. Database Field: ERPx_APTransactionLine.Price |
| Purchase Account | Delete RV Grid | Delete - RV Grid |
| nopanel | true |
|---|
Excel | Checkbox | | Insert excerpt |
|---|
Checkbox (Tag)- RV | Checkbox (Tag)- RV | | nopanel | true |
|---|
Description | | Insert excerpt |
|---|
| Excel - RV Grid | Excel - RV Grid| LV | | Purchase Account - LV |
|---|
| nopanel | true |
|---|
|
This is a single-select standard lookup that defaults as blank and is required when the Status is set to Approved. If missing, the message "A Purchase Account is required for all lines." will be displayed on Save. This is always editable while the transaction is in a Status of New. | Insert excerpt |
|---|
Item Description (user entered) - LV | Item Description (user entered) | New - multi blank rows - RV Grid | New - multi blank rows - RV Grid | | nopanel | true |
|---|
| Fields | Description |
|---|
| Def - Not Defined | | Def - Not Defined |
|---|
| nopanel | true |
|---|
|
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts.
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK |
| Quantity | | Insert excerpt |
|---|
| Quantity - LV |
|---|
| Quantity - LV |
|---|
| nopanel | true |
|---|
|
This is a text box that defaults as blank, is required and must be <= 200 characters. If missing, the message "A Description is required for all line items." will be displayed on Save. This field"1.00" and is required. This is always editable while the transaction is in a Status of New or Approved. Database Field: ERPx_APTransactionLine.LineDescription |
| Distributed To | Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK |
| Extended | Database Field: ERPx_APTransactionLine.ExtendedAmount |
| Price | Database Field: ERPx_APTransactionLine.Price |
| Purchase Account | Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK |
| Quantity | Database Fields: ERPx_APTransactionLine.Quantity |
| UOM |
| UOM | | Insert excerpt |
|---|
| Units UOM - LV |
|---|
| Units UOM - LV |
|---|
| nopanel | true |
|---|
|
This is a single-select standard lookup that defaults as blank and is not required. This is always editable while the transaction is in a Status of New. | Insert excerpt |
|---|
| Def - Not Defined |
|---|
| Def - Not Defined |
|---|
| nopanel | true |
|---|
|
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Units of Measure. Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK |
Related Topics
...