Create Payment term

15. Create Payment term 

Note: If you don't want to create all the payment terms using the application please use this Oracle script or this PostgreSQL

• Short description:Create payment terms to add to business partner. Do as example "30 days, 5"

• Steps:
  • Login as userA
  • Go to Master Data Management->Business partner setup->Payment Term
  • Click New fill:
    • Value=30d/5
    • Name=30 days, 5
    • Mark "Fixed Due Date"
    • Maturity Date 1=5
    • Offset Month Due=1

• Additional data: Doing the example for "30 days, 5", remember to remove from the script the code related to this issue.

DECLARE
v_paymentterm_id NUMBER(10);
v_client_id NUMBER(10);
BEGIN
SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;

SELECT COALESCE(MAX(C_PAYMENTTERM_ID),999999) +1 INTO v_paymentterm_id FROM C_PAYMENTTERM;

INSERT INTO C_PAYMENTTERM
(C_PAYMENTTERM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY,
 NAME, ISDUEFIXED, NETDAYS, FIXMONTHOFFSET, ISNEXTBUSINESSDAY, ISDEFAULT, VALUE, ISVALID)
VALUES
 (v_paymentterm_id, v_client_id, 0, 'Y', SYSDATE, 100, SYSDATE, 100, '90 DAYS', 'N', 0, 3, 'N', 'N', '90d', 'N');
ad_update_sequence();
commit;
END;