Re: [WebERP-developers] Convert PO to SO?

[gilberto d. s. a. <gs...@gm...>]

on this link [1] i put some spreadsheet used for migrations and for build
rules for source and target environments.

Examples:

PeopleSoft to SAP;

SAP to legacy-Local-Home-system

See that we map table,colum,attrib, (left side) (rule-number) on center and
(target or to) (rigth side).

Based on this all spreadsheet we build all sql need.

All commands are ansi sql that could run on any ansi-sql-92 compliant.

Data files may be .txt or .xml or .json transmitted by ftp or sftp or any
webservice. we use curl / wget for send and receive operations.

On windows command (AT) and on linux CRONTAB

regards

Please if any doubts we should discuss or explain.



[1]
https://docs.google.com/spreadsheet/ccc?key=0ArRGseydrhtydHRkdFFKcUJkaFVfeVkzU1BqOWI1MWc&usp=sharing


2014/1/24 ExsonQu <hex...@gm...>

> *Dear all:*
>
>               Thank you very much for your feedback.
>
>               After discuss with Steven, we bring out a proposal for this:
>
>               1. Add a QR code for PO pdf file, which contains all the
> information of the PO. (The QR code will be configurable of course)
>
>               2. Create a script to convert the QR code data to SO. One
> solution is use a QR reader of mobile device, another one is a QR code
> decoder(Not investigate yet) to parse QR code in the pdf file.
>
>              Any comments are highly appreciated for this.
>
>              Thanks and best regards!
>
>              Exson
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657190.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil