Points of Integration

There are many MoneyWorks API resources available. However not all resources are part of the Ostendo – MoneyWorks integration. The affected resources are as follows:

 

1.

Name  table - this is the MoneyWorks resource which holds Supplier and Customer information. Any addition or change in Supplier/Customer master records in Ostendo will be reflected in MoneyWorks.

               Supplier records require the Accounts Payable ledger code to be included in the transaction.

               Customer records require the Accounts Receivable ledger code to be included.

               Please note the following differences between Ostendo and MoneyWorks:

a.

               In Ostendo, Supplier names and Customer names are unique, but not in MoneyWorks. Therefore you should remove duplicate names in MoneyWorks before integrating with Ostendo.

b.

               In Ostendo CustomerMaster records, we have a BillingCustomer field.  There is no equivalent field in MoneyWorks Name table. In MoneyWorks, a BillingCustomer is indicated by a period (“.”) at the end of the NameCode (see example below). A customer which                has a billingcustomer will have a namecode which starts with the BillingCustomer namecode first.

               

               This Namecode has no relevance to Ostendo. It is noted here just for your information.

  c.                If you are using multi-currency, make sure all required currencies are set up in MoneyWorks before you export customers or suppliers over to MoneyWorks. In Ostendo, all customers and suppliers transacting in foreign currencies must have the Foreign Currency                box ticked and the Currency code specified. All other customers or suppliers transacting in the base currency must have the Foreign Currency box unticked.

 

2. Transaction table – all journals except Invoice Payment and Invoice Deposit, invoices/creditnotes  are posted to this resource in MoneyWorks.

 

3. Payments table - Invoice Payments and Invoice Deposits

 

4. Transaction Types

a.

CR        -        Customer payment, Customer Deposit, Invoice payment, Invoice Deposit

b.

JN                -        Journals

c.

CI                -        Purchase Invoice

d.

DI                -        Sales Invoice

 

All financial transactions generated in Ostendo will be summarised into the following tables and posted to Transaction/Payment tables in MoneyWorks:

       a.        JOURNALHEADER

       b.        JOURNALLINES

       c.        JOURNALINVHEADER

       d.        JOURNALINVLINES

 

Changes to Customer Master and Supplier Master record will create transactions in FINANCIALCUSTOMERS and FINANCIALSUPPLIERS tables respectively and posted to Name table in MoneyWorks.