c2c-oerpscenario team mailing list archive

["Raimon Esteve \(Zikzakmedia\)" <resteve@xxxxxxxxxxxxxxx>]

Hello,

@raphaël: where to download ktr file for process payapal payments for
Kettle+TerminatOOOR?

@kylle: at revision 317 (1) we developed account_payment depend at
magentoerpconnect for controle this funcitions: payments. At future,
we thing create new module depend magentoerpconnect.

@kyle: we developed account_payment_paypal for import CSV paypal
payments and process. Maybe it is not necessary kettle.

Import Paypal Payments from a CSV file.

Adds a wizard in bank statements to select a CSV file with Paypal
payments lines like this:

Date, Time, Time Zone, Name, Type, Status, Currency, Gross, Fee, Net,
>From Email Address, To Email Address, Transaction ID, Counterparty
Status, Address Status, Item Title, Item ID, Shipping and Handling
Amount, Insurance Amount, Sales Tax, Option 1 Name, Option 1 Value,
Option 2 Name, Option 2 Value, Auction Site, Buyer ID, Item URL,
Closing Date, Escrow Id, Invoice Id, Reference Txn ID, Invoice Number,
Custom Number, Receipt ID, Balance, Address Line 1, Address Line
2/District, Town/City,
State/Province/Region/County/Territory/Prefecture/Republic, Zip/Postal
Code, Country, Contact Phone Number,
"25/03/2009", "23:45:35", "GMT+02:00", "Computer Company", "Web Accept
Payment Received", "Completed", "EUR", "20,00", "-0,89","19,11",
"from1@xxxxxxxxx", "to@xxxxxxxxx","0LN645674B531493M","Non-U.S. -
Verified", "Non-U.S.","Item1 title", "1", "0,00","","0,00","usr",
"45678","","","","","","","","","","","","","1.315,74",
"address1","","city1","state1", "zip1","country1","",
"28/03/2009","21:58:54","GMT+02:00", "John Smith", "Web Accept Payment
Received", "Completed", "USD","20,00","-0,94","19,06",
"from2@xxxxxxxxx", "to@xxxxxxxxx", "6V823569E37342433",
"Verified","Confirmed","Item 2 title","1", "0,00","","0,00","usr",
"34567","","","", "","","","","","","","","", "20.979,99",
"address2","", "city2","state2","zip2","country2","",

These fields are optional: Address Line 1, Address Line 2/District,
Town/City, State/Province/Region/County/Territory/Prefecture/Republic,
Zip/Postal Code, Country, Contact Phone Number.

Only the Paypal payment lines with the same currency as the bank
statement are imported. And if 'Status completed' option is checked,
only the Paypal payment lines with status field = 'Completed' are
imported.

Paypal transactions are classified as:
    * customer: 'Type' in ['Web Accept Payment Received', 'Payment
Received', 'Subscription Payment Received', 'Refund']
    * supplier: 'Type' in ['Credit']
    * general: Other cases, 'Type' in ['Transfer', 'Chargeback Settlement', ...]

Tries to fill the partner and invoice to conciliate from the Paypal
transaction ID. If not, try to find the partner with the from
(customer) or to (supplier) email addresses (from1@xxxxxxxxx or
to@xxxxxxxxx in the example) and, if the 'Search invoice to reconcile'
option is checked, try to conciliate it with an open invoice with the
same partner, same amount+-accuracy, same date+-accuracy and payment
type 'PAYPAL'.

(1) http://bazaar.launchpad.net/~openlabs-akretion-
consortium/magentoerpconnect/magentoerpconnect/revision/317


-- 
Raimon Esteve
// OpenERP, gestió empresarial flexible
// Magento, botigues virtuals dinàmiques
// AulaERP, formació online
// easyOERP, tu aplicación OpenERP lista para usar
www.zikzakmedia.com

-- 
if we pay the invoice of an order from Magento, then it doesn't get reflected in OpenERP
https://bugs.launchpad.net/bugs/512753
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in Magento Open ERP Connector: Confirmed

Bug description:
When  we create a sales order in Magento and its invoice , then the  status of the order is not imported to OpenERP. It does not show the sale order as “Invoiced 100%” in OpenERP.
I created a sale order and invoiced it and “updated order status” but the status of order-Invoice in openERP does not show it “Invoiced” .