Chapter 5. Planning Application Integration

Chapter 5. Planning Application Integration

You may use two basic methods to import data into the planning application:

  1. Copy and paste data from existing Excel workbooks.
  2. Import data using SQL commands.

If you have a lot of data, you may contact us to discuss other methods.

Copying Data

It is a simple method as it requires time only.

You may use a trick. Create a row set with accounts to import and a form that uses this row set.

In this case, you may import data for all periods and any entity and category at once.

Also, you may create an export form in the source workbook and paste data into existing forms.

Note that you have to open the periods for changes to insert data.

Importing Data

You may use the dbo25.usp_import_fact procedure to import data easily.

For example, you may use commands like this:

EXEC dbo25.usp_import_fact 200, 'CC111', '2017.01', 'ACTUAL', 'KAM.DE', 'COUNTRY.DE';

EXEC dbo25.usp_import_fact 200, 'CC111', '2017.02', 'ACTUAL', 'KAM.DE', 'COUNTRY.DE';

EXEC dbo25.usp_import_fact 200, 'CC112', '2017.01', 'ACTUAL', 'KAM.DE', 'COUNTRY.DE';

EXEC dbo25.usp_import_fact 200, 'CC112', '2017.02', 'ACTUAL', 'KAM.DE', 'COUNTRY.DE';

You may export such commands from your accounting system and import using the sqlcmd utility.

Note that the procedure accepts member codes as parameters.

You may contact us to discuss other methods.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK