开发者

Retrieving All Payments From Sage Line 50 Database

I'm trying to retrieve a list of all payments received/entered into a Sage Line 50 database. The company I work for are members of the Sage developer program, so I have access to the SDK, help files and the like but I have been unable to find any specific information regarding payments.

Some of the .dta files contain references to payments (SPLITS.DTA & HEADER.DTA) al开发者_JAVA技巧ongside Invoice rows.

Does anyone know whether or not there is a separate file which contains only payment information, and if so what is it? Alternatively, will I have to pull the full list of rows from the SPLITS/HEADER files and filter them by type?

Many thanks in advance


I pulled data from the Header and Split files for a test customer this afternoon, and they contain (as near as I can tell) all customer activity - Invoices, Invoice payments and Credits are all reflected in both data files (the split data file containing more in depth data) and can be filtered by bank_code and transaction type.

To get the data - first create a reference to a customer object and from there link to all of the header (assuming you have an existing connection and workspace).

dynamic workspace = this._workspaces[workspaceName];
dynamic customer = workspace.CreateObject("SalesRecord");

bool added = customer.AddNew();

customer.MoveFirst(); //find first customer

dynamic headerObject = customer.Link;

bool headerFound = headerObject.MoveFirst(); //use .MoveNext() to cycle headers

You can then pull data from the header object using :

string AccountRef = headerObject.Fields.Item("ACCOUNT_REF").Value;

Where ACCOUNT_REF is a field in the HeaderData object.

Use the following code to get split data

dynamic splitObject = headerObject.Link;

bool splitFound = splitObject.MoveFirst()  //and so on
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜