Friday, 8 November 2013

Auto Invoice Error : Please enter quota sales credit percentages that equal 100 percent for this line.

When running the autoinvoice import program you might be faced with the error :
Please enter quota sales credit percentages that equal 100 percent for this line. This error comes if we have multiple records in the table ra_interface_salescredits_all for one invoice line record and the sum of column : SALES_CREDIT_PERCENT_SPLIT is not equal to 100.
 

Thursday, 7 November 2013

Supplier Import Error :POS_SPM_CREATE_SUPP_ERR1

During Supplier Import you may be faced with an error : POS_SPM_CREATE_SUPP_ERR1 . This error is reported if there already exists a record in ap_suppliers/ap_supplier_Sites_All with the same VAT_REGISTRATION_NUM as the current record being errored out.

Oracle does not allow creation of 2 suppliers with the same VAT numbers via supplier import. If needed you can import the suppliers by making these VAT  numbers as null and then hard update the Oracle base table column : VAT_REGISTRATION_NUM with the required value,

Thanks

Supplier Import Error : AP_VEN_DUPLICATE_NAME

When performing Supplier Import you might be faced with an Error : AP_VEN_DUPLICATE_NAME .

The Oracle Supplier Import API has a check that the Oracle system (ap_suppliers) should not have a vendor with the same name as the vendor being created. If a match is found the record will be errored in import and error will be inserted in the table AP_SUPPLIER_INT_REJECTIONS with the error code : AP_VEN_DUPLICATE_NAME

Thanks