ManPageW ExpenseInvoice(Alpha)

This Wiki is read-only for reference purposes to avoid broken links.

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section

Window: Expense Invoice (Alpha)

= BETA FUNCTIONALITY =

Description : Payables expense invoices - This is Alpha Functionality

Help : Enter expense invoices from your vendors

---

Tab: Invoice

Description :

Help :

Table Name  : C_Invoice

Fields

Name	Description	Help	Technical Data
Client	Client/Tenant for this installation.	A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.	AD_Client_ID NUMBER(10) TableDir
Organization	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID NUMBER(10) TableDir
Document No	Document sequence number of the document	The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>". If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).	DocumentNo NVARCHAR2(30) String
Order Reference	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner	The business partner order reference is the order reference for this specific transaction; Often Purchase Order numbers are given to print on Invoices for easier reference. A standard number can be defined in the Business Partner (Customer) window.	POReference NVARCHAR2(20) String
Description	Optional short description of the record	A description is limited to 255 characters.	Description NVARCHAR2(255) Text
Target Document Type	Target document type for conversing documents	You can convert document types (e.g. from Offer to Order or Invoice). The conversion is then reflected in the current type. This processing is initiated by selecting the appropriate Document Action.	C_DocTypeTarget_ID NUMBER(10) Table
Date Invoiced	Date printed on Invoice	The Date Invoice indicates the date printed on the invoice.	DateInvoiced DATE Date
Account Date	Accounting Date	The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.	DateAcct DATE Date
Business Partner	Identifies a Business Partner	A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson	C_BPartner_ID NUMBER(10) Search
Partner Location	Identifies the (ship from) address for this Business Partner	The Partner address indicates the location of a Business Partner	C_BPartner_Location_ID NUMBER(10) TableDir
User/Contact	User within the system - Internal or Business Partner Contact	The User identifies a unique user in the system. This could be an internal user or a business partner contact	AD_User_ID NUMBER(10) TableDir
Price List	Unique identifier of a Price List	Price Lists are used to determine the pricing, margin and cost of items purchased or sold.	M_PriceList_ID NUMBER(10) TableDir
Currency	The Currency for this record	Indicates the Currency to be used when processing or reporting on this record	C_Currency_ID NUMBER(10) TableDir
Company Agent	Purchase or Company Agent	Purchase agent for the document. Any Sales Rep must be a valid internal user.	SalesRep_ID NUMBER(10) Search
Payment Rule	How you pay the invoice	The Payment Rule indicates the method of invoice payment.	PaymentRule CHAR(1) Button
Payment Term	The terms of Payment (timing, discount)	Payment Terms identify the method and timing of payment.	C_PaymentTerm_ID NUMBER(10) TableDir
Project	Financial Project	A Project allows you to track and control internal or external activities.	C_Project_ID NUMBER(10) TableDir
Activity	Business Activity	Activities indicate tasks that are performed and used to utilize Activity based Costing	C_Activity_ID NUMBER(10) TableDir
Campaign	Marketing Campaign	The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.	C_Campaign_ID NUMBER(10) TableDir
Trx Organization	Performing or initiating organization	The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.	AD_OrgTrx_ID NUMBER(10) Table
User List 1	User defined list element #1	The user defined element displays the optional elements that have been defined for this account combination.	User1_ID NUMBER(10) Table
User List 2	User defined list element #2	The user defined element displays the optional elements that have been defined for this account combination.	User2_ID NUMBER(10) Table
Total Lines	Total of all document lines	The Total amount displays the total of all lines in document currency	TotalLines NUMBER Amount
Grand Total	Total amount of document	The Grand Total displays the total amount including Tax and Freight in document currency	GrandTotal NUMBER Amount
Document Status	The current status of the document	The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field	DocStatus CHAR(2) List
Document Type	Document type or rules	The Document Type determines document sequence and processing rules	C_DocType_ID NUMBER(10) TableDir
Process Invoice			DocAction CHAR(2) Button
Posted	Posting status	The Posted field indicates the status of the Generation of General Ledger Accounting Lines	Posted CHAR(1) Button

---

Tab: Included Lines

Description :

Help :

Table Name  : C_InvoiceLine

Fields

Name	Description	Help	Technical Data
Line No	Unique line for this document	Indicates the unique line for a document. It will also control the display order of the lines within a document.	Line NUMBER(10) Integer
Charge	Additional document charges	The Charge indicates a type of Charge (Handling, Shipping, Restocking)	C_Charge_ID NUMBER(10) TableDir
Description	Optional short description of the record	A description is limited to 255 characters.	Description NVARCHAR2(255) Text
Tax	Tax identifier	The Tax indicates the type of tax used in document line.	C_Tax_ID NUMBER(10) TableDir
Line Amount	Line Extended Amount (Quantity * Actual Price) without Freight and Charges	Indicates the extended line amount based on the quantity and the actual price. Any additional charges or freight are not included. The Amount may or may not include tax. If the price list is inclusive tax, the line amount is the same as the line total.	LineNetAmt NUMBER Amount
Tax Amount	Tax Amount for a document	The Tax Amount displays the total tax amount for a document.	TaxAmt NUMBER Amount
Line Total	Total line amount incl. Tax	Total line amount	LineTotalAmt NUMBER Amount