Import Journal Vouchers from Excel

Moty

Solution Overview:

The following customize rule upon click on function button will read the journal vouchers values from an excel files and paste them into the journal voucher form.
Structure:

• function button to open a dialog box for excel file selection and import the JV lines into the JV form (COR:Add JV from Excel)

Screenshots:

William Burgos

Please find here an updated version of the rule that uses more current version of excel sheets and correct and issue with credit not posting correctly.

 

 

Regards,

 

William Burgos
Business Developer
LinkedIn |  Twitter 

coresystems usa
1000 5th St | Miami Beach
FL 33139 | USA

 

www.coresystems.ch
www.coresuite.com
follow us on twitter

 

SAP Gold Partner (SSP)
Finalist Swiss Economic Award 2011
Deutsche Telekom Audience Innovation Prize 2010
Best of Swiss Silverlight 2010 Gold Winner
Announced by Gartner as a Cool Vendor 2010

 

drorfold

can the same solution be applied for Import AP Goods Return from excel? will that be on the row level only or also header level?

infosistemasgroup

Hola Willians. Hace poco estuviste en Panamá y fue muy valiosa la información que nos suministraste

 

He tratado de usar OPENFILEDIALOG pero con VBCODE sin éxito. Tendrás algún Funtion Button donde pueda llamar un Excel he importar un Pedido de Mercancía a SAP.

 

 

Saludos cordiales.