ManPageW PaymentSelection

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

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

Please write your contributions under the Contributions Section



Contents

Window: Payment Selection

Description : Select Invoices for Payment

Help : The Payment Selection Window allows you to select and process the invoices you want to pay. (a) You can create a Payment Selection and select the invoices manually or generate the suggestions based on criteria. You can change the amount to be paid or delete invoices, you do not want to pay.

(b) If you are happy with the Payment Selection, you create the payments.

(c) You print or export your payments in the Window Payment Print/Export



Tab: Payment Selection

Description : Define Payment

Help : The Payment Selection Tab defines the bank account and date of the payments to be made. You also create the payments here.

Table Name  : C_PaySelection

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

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Bank Account Account at the Bank The Bank Account identifies an account at this Bank. C_BankAccount_ID

NUMBER(10)

TableDir

Payment date Date Payment made The Payment Date indicates the date the payment was made. PayDate

DATE

Date

Approved Indicates if this document requires approval The Approved checkbox indicates if this document requires approval before it can be processed. IsApproved

CHAR(1)

YesNo

Total Amount Total Amount The Total Amount indicates the total document amount. TotalAmt

NUMBER

Amount

Create From ... CreateFrom

CHAR(1)

Button

Prepare Payment Create Prepared Payments (Checks) to be paid You create the actual Payments via Payment Print/Export Processing

CHAR(1)

Button


Tab: Payment Selection Line

Description : Payment Selection Line

Help : The Payment Selection Line Tab defines the individual invoices an organization is paying to a Vendor with this payment.

Table Name  : C_PaySelectionLine

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

Payment Selection Payment Selection The Payment Selection identifies a unique Payment C_PaySelection_ID

NUMBER(10)

TableDir

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

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Payment Rule How you pay the invoice The Payment Rule indicates the method of invoice payment. PaymentRule

CHAR(1)

List

Invoice Invoice Identifier The Invoice Document. C_Invoice_ID

NUMBER(10)

Search

Sales Transaction This is a Sales Transaction The Sales Transaction checkbox indicates if this item is a Sales Transaction. IsSOTrx

CHAR(1)

YesNo

Open Amount Open item amount OpenAmt

NUMBER

Amount

Payment amount Amount being paid Indicates the amount this payment is for. The payment amount can be for single or multiple invoices or a partial payment for an invoice. PayAmt

NUMBER

Amount

Discount Amount Calculated amount of discount The Discount Amount indicates the discount amount for a document or line. DiscountAmt

NUMBER

Amount

Difference Difference Amount DifferenceAmt

NUMBER

Amount

Pay Selection Check Payment Selection Check C_PaySelectionCheck_ID

NUMBER(10)

TableDir

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo


Tab: Prepared Payment

Description : View Generated Prepared Payments (Checks)

Help : You create the actual Payments via Payment Print/Export

Table Name  : C_PaySelectionCheck

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

Payment Selection Payment Selection The Payment Selection identifies a unique Payment C_PaySelection_ID

NUMBER(10)

TableDir

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

Payment Rule How you pay the invoice The Payment Rule indicates the method of invoice payment. PaymentRule

CHAR(1)

List

Quantity Quantity The Quantity indicates the number of a specific product or item for this document. Qty

NUMBER

Integer

Payment amount Amount being paid Indicates the amount this payment is for. The payment amount can be for single or multiple invoices or a partial payment for an invoice. PayAmt

NUMBER

Amount

Discount Amount Calculated amount of discount The Discount Amount indicates the discount amount for a document or line. DiscountAmt

NUMBER

Amount

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

Receipt This is a sales transaction (receipt) IsReceipt

CHAR(1)

YesNo

Payment Payment identifier The Payment is a unique identifier of this payment. C_Payment_ID

NUMBER(10)

Search

Printed Indicates if this document / line is printed The Printed checkbox indicates if this document or line will included when printing. IsPrinted

CHAR(1)

YesNo

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo

Contributions

Personal tools