Projects:APR Migration Tool/Technical Documentation/Payment Method
Contents |
Payment Method Migration
Payment Method
Each payment rule of All_Payment Rule list reference will be migrated as a new payment method, new record in FIN_PaymentMethod table. These are the default payment rules provided in Openbravo ERP master data:
| Form Of Payment | Search Key |
| Wire Transfer | 1 |
| Check | 2 |
| Promissory Note | 3 |
| Money Order | 4 |
| Bank Deposit | 5 |
| Cash | B |
| Cash on Delivery | C |
| Credit Card | K |
| On Credit | P |
| Bank Remittance | R |
| Transfer (ACH) | T |
| Withholding | W |
There will be available on Financial Management || Receivables & Payables || Setup || Payment Method || Payment Method.
Default configuration of the generated payment methods:
| Field | Value |
| Name | The name of the payment rule. |
| Description | Generated by the Migration Tool process |
| Allow Payment IN / OUT | Yes / Yes |
| Automatic receipt / deposit | No / No |
| Automatic payment / withdrawn | No / No |
| Execution type | Manual |
| Upon receipt / deposit | In transit |
| Upon deposit / withdrawn | Deposit / Withdrawn |
| Upon clearing use | Cleared account |
Mapping for Cash and Cash on Delivery payment rule: the receipt/deposit and payment/withdrawn are set as automatic. The general rule is: If the Form Of Payment name contains (no case sensitive) in the name the string cash it will be migrated with the following configuration.
| Field | Value |
| Automatic receipt / deposit | Yes / Yes |
| Automatic payment / withdrawn | Yes / Yes |
Linked entities
In the following windows the Form of Payment value has been migrated to the corresponding new Payment Method.
Project Proposal
- Table: C_ProjectProposal
- Window: Project & Service Management || Transactions || Service Project || Service Project >> Proposal
Service Project
- Table: C_Project
- Window: Project & Service Management || Transactions || Service Project || Service Project
Payment Term Line
- Table: C_Paymenttermline
- Window: Master Data Management || Business Partner Setup || Payment Term || Header >> Lines
How to identify a migrated Payment Method
In Fin_PaymentMethod table a new column em_aprmt_payment_rule has been added where is stored the search key of the base form of payment. Other explicit indication is the description of the payment method: Generated by Migration Tool