x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 55 subscribers
  • Views 517 views
  • Users 0 members are here
Browse Forums
Announcements
764
topics
17
replies
Financial year end
78
topics
177
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
175
topics
311
replies
Install your software
138
topics
375
replies
Making Tax Digital
286
topics
692
replies
Manage your VAT
147
topics
321
replies
Protect and repair your data
44
topics
137
replies
Run your accounts remotely
85
topics
197
replies
Working with the bank
114
topics
292
replies
J Rowlan

Sage 50 Invoicing

SUGGESTED
Posted By

I am usually a Sage 200 developer but have recently been asked to work on a Sage 50 Invoicing issue.

Given the 3 type of data below, I would like to pull the various fields from the collection of all 3 types of data objects

I would appreciate if someone could give me a heads up on how I may go about this in perhaps a snippet of an example.

I am aware that under HeaderData the INV_REF is not always a numeric integer so I need to grab the INVOICE_NUMBER from InvoiceData or InvoicePost

PAYMENT_DUE_DATE is available in InvoiceData and InvoicePost and HeaderData as DATE_DUE

INVOICE_NUMBER is avalilable in InvoiceData and InvoicePost

InvoiceData
INVOICE_NUMBER
INVOICE_DATE
PAYMENT_DUE_DATE

HeaderData
INV_REF
DATE_DUE

InvoicePost
INVOICE_DATE
INVOICE_NUMBER

I believe all 3 data files are instrumental in creating an invoice.

I would like to know how to read all three data files together so that I can choose the salient parts for reading properties.

This is so that I can start work on a module to send email requests to customers where invoices are overdue.

can anyone assist please?

thanks

jON

  • 0

    Hi Jon, 

    Thanks for using Sage City.

    This looks like a Sage 50 Accounts query, but it's posted in the Sage Accounting forum, I'll move it to the 50 Accounts forum now so hopefully the community can assist.

    Andy
    Sage UKI

  • 0 in reply to Andy Rickeard

    I am not sure where I should go to se a reply to my post, I know it has been moved but where should I look out for replies please?

    thanks

    jON

  • 0 in reply to J Rowlan
    SUGGESTED

    you should get automatic email notifications of any replies so hopefully you will see this.

    Reading data is the same across all data object types so the help topic called 'Fields Property' in the SDK help file would be a good place to start as it includes a short code sample demonstrating how to read the data, It's really just a simple case of getting the Value property.

    There is also another topic in the help file called 'Example - Reading the Item Lines of an Existing Invoice' that I think you would find useful as this has a more complete code sample showing how to find and read data from an invoice record and it's line items,

    Hope that helps

*Community Hub is the new name for Sage City