Jiwa

Hi all
I am working on a system integration tool to link the details of Debtors and Creditors in JIWA with a SugarCRM.
changes in one need to be reflected in the other.

So far the SugarCRM side is fairly straight forward with their REST API.

on the JIWA side of things I can:
- Pull From JIWA Data through SQL queries straight to the JIWA database.
- Push to JIWA changes through SQL queries straight to the JIWA database.

I am stuck on the being able to create a new Debtor / Creditor record.

Environment:
- C# .net
- JIWA 7
- Microsoft SQL

Any help will be appreciated.

Cheers
Drew

Also noted that as of sometime last week that the following https://help.jiwa.com.au/Jiwa7/7.00.126 ... index.aspx
which might have been helpful now nolonger works..

Hi Drew,

Reference JiwaApplication.dll, JiwaDebtors.dll and JiwaODBC.dll in your project and then you can create a debtor using something such as this:

Code: Select all

private void CreateDebtor()
{
   JiwaFinancials.Jiwa.JiwaApplication.Manager.Instance.Logon("SQLServerName", "DatabaseName", JiwaFinancials.Jiwa.JiwaODBC.database.AuthenticationModes.JiwaAuthentication, "Admin", "password");

   var debtor = JiwaFinancials.Jiwa.JiwaApplication.Manager.Instance.BusinessLogicFactory.CreateBusinessLogic<JiwaFinancials.Jiwa.JiwaDebtors.Debtor>(null);
   debtor.CreateNew();
   debtor.AccountNo = "1234";
   debtor.Name = "Test";
   //debtor.Classification.ReadRecordFromDescription("My Classification"); //<-- Example of setting the debtor classification
   debtor.Save();
}

Creditors is very similar - just change "debtor" with "creditor" in the above.

Mike

Drew wrote:Also noted that as of sometime last week that the following https://help.jiwa.com.au/Jiwa7/7.00.126 ... index.aspx
which might have been helpful now nolonger works..

That post which referred to that link was corrected last week with the right link

Thanks Mike that is the start I needed.

Technical Hitch..

How would I Create/set the DeliveryAddress details when creating a debtor?

Cheer
Drew

This is off the top of my head:

Code: Select all

   JiwaFinancials.Jiwa.JiwaDebtors.DeliveryAddress myNewDeliveryAddress = new JiwaFinancials.Jiwa.JiwaDebtors.DeliveryAddress();

   myNewDeliveryAddress.DeliveryAddressName = "Head Office";
   myNewDeliveryAddress.Address1 = "1 Smith St";
   myNewDeliveryAddress.Address3 = "Sydney";
   myNewDeliveryAddress.Address4 = "NSW";
   myNewDeliveryAddress.Postcode = "2000";

   debtor.DeliveryAddresses.Add(myNewDeliveryAddress);


So to add this to Mike's example from above:

Code: Select all

private void CreateDebtor()
{
   JiwaFinancials.Jiwa.JiwaApplication.Manager.Instance.Logon("SQLServerName", "DatabaseName", JiwaFinancials.Jiwa.JiwaODBC.database.AuthenticationModes.JiwaAuthentication, "Admin", "password");

   var debtor = JiwaFinancials.Jiwa.JiwaApplication.Manager.Instance.BusinessLogicFactory.CreateBusinessLogic<JiwaFinancials.Jiwa.JiwaDebtors.Debtor>(null);
   debtor.CreateNew();
   debtor.AccountNo = "1234";
   debtor.Name = "Test";
   //debtor.Classification.ReadRecordFromDescription("My Classification"); //<-- Example of setting the debtor classification

   //Add a delivery address
   JiwaFinancials.Jiwa.JiwaDebtors.DeliveryAddress myNewDeliveryAddress = new JiwaFinancials.Jiwa.JiwaDebtors.DeliveryAddress();
   myNewDeliveryAddress.DeliveryAddressName = "Head Office";
   myNewDeliveryAddress.Address1 = "1 Smith St";
   myNewDeliveryAddress.Address3 = "Sydney";
   myNewDeliveryAddress.Address4 = "NSW";
   myNewDeliveryAddress.Postcode = "2000";

   debtor.DeliveryAddresses.Add(myNewDeliveryAddress);

   debtor.Save();
}


EDIT: Forget to new.