Page 1 of 1

Posting purchase invoices to sage from VB.Net

Posted: 13 May 2011, 11:26
by Jimothy666
Hey all

I was just wondering if anyone could help? I'm having a problem with posting to sage from a VB.net application. I'm setting the header details as "Header Detail" but when I then run through my purchase order invoice lines and set them to say "Line 1 - XXX" and "Line 2 - XXX" it is overwriting the header detail with "Line 1 - XXX, Line 2 - XXX, Line 3 - XXX" etc.

Just wondered if anyone had this problem before and if they have managed to solve it.

I've tried resetting the Header("DETAILS").Value again just before I run the update function...but it just overwrites it again.

Thanks for all help given in advanced :0)

Re: Posting purchase invoices to sage from VB.Net

Posted: 13 May 2011, 12:04
by leyburnsolutions
You set the individual item line details as follows:

oSplitData.Fields.Item("DETAILS").Value = CStr("Split Details")

When you say the details field on the header is being overwritten, where are you seeing this?

As an aside, Sage do have a forum specifically for members of their Developers Programme here: http://developerforum.sage.co.uk/index.php

John

Re: Posting purchase invoices to sage from VB.Net

Posted: 13 May 2011, 13:26
by Jimothy666
John

Thanks for your reply, this is causing me no end of frustration.

I set the header details as follows:

oTransactionPostCr.Header("DETAILS").Value = "Header Detail"

then later as I loop through my order invoice lines I do

oSplitData.Fields.Item("DETAILS").Value = LineNumber & "- LineDescription"

But then in Sage it says "1 - LineDescription, 2 - LineDescription, 3- LineDescription" against the header description (the top pain under details on the customer activity screen)

I've even tried setting the oTransactionPostCr.Header("DETAILS").Value AFTER I have added all my splits, but it still just does the same

Thanks again

James

Re: Posting purchase invoices to sage from VB.Net

Posted: 13 May 2011, 13:45
by Jimothy666
Just got off the phone to Sage Developer support (found out we had an account)

They've told me that it is a know UI problem with the VB.Net SDO, and all I can do is only post 1 split....which is not good when we want details invoice postings....

Ahh happy days!

Thanks anyways

James

Re: Posting purchase invoices to sage from VB.Net

Posted: 13 May 2011, 13:47
by leyburnsolutions
Just to confirm, you are saying that all the split descriptions are being put together in one long string to form the Header details?

John

Re: Posting purchase invoices to sage from VB.Net

Posted: 13 May 2011, 14:32
by Jimothy666
John

Yes that's it exactly. Sage said they've had this problem before and the guy I spoke to went away and came back a couple of minutes later and then told me it was a known UI (I guess he meant SDK) problem. No plans to fix it anytime soon :cry:

Thanks

James

Re: Posting purchase invoices to sage from VB.Net

Posted: 13 May 2011, 17:59
by leyburnsolutions
This is a UI issue with the program itself, it is not an SDO issue. If you post a transaction in Sage itself with multiple splits, you get the same result...

John