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
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