#C and SDK issues

Hi,

A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.

We are trying to create POs, Time records, and add Cost Codes to the DB.

Reading from Sage is working without issues, but writing is corrupting the DB.

Q1: Is there a way to provide CRUD operations for the Chart of Accounts?

Q2: Is there a way to do a GetAll() and Update() for Purchase Orders?

This may be a lot to ask, but if someone out there has experience providing CRUD operations we would be willing to pay for your time.

Thanks in advance!

Patrick

  • pwebber said:
    We are trying to create POs, Time records, and add Cost Codes to the DB.

    If you are managing the additional detail and descriptions, etc. in another application, and just want the 'bare facts', Sage 50 can import most non-payment source documents, and there are commercial import utilities available for Sage 50 Canadian.

    pwebber said:
    Reading from Sage is working without issues, but writing is corrupting the DB.

    I'm surprised to hear that, are you working in single, or in multi-user mode, when adding / updating information?

    pwebber said:
    Q1: Is there a way to provide CRUD operations for the Chart of Accounts?

    The Chart of Accounts is mostly a static list, like Customers, Vendors, inventory, Projects, Employees, not a transactional table.  The Sage 50 interface assumes these items remain the same from start to end of a transaction - it allows creating items, but usually will not allow removing or marking items inactive in multi-user mode, due to the possibility that others are currently using them.  In multi-user mode, renaming is allowed, but renumbering accounts isn't.  (the 'Account Number' is the actual key ID field.)

    So Chart of Accounts data transactions are limited to Create, and some fields can be Replaced and Updated, never deleted.  If it's something that you can share in a public forum, please post what, more exactly, you need to achieve?

    pwebber said:
    Q2: Is there a way to do a GetAll() and Update() for Purchase Orders?

    There is a 'utility' function that should let you do pretty well any SQL call.   Again, if it's something that you can share in a public forum, please post what, more exactly, you need to achieve?

    pwebber said:
    This may be a lot to ask, but if someone out there has experience providing CRUD operations we would be willing to pay for your time.

    Please feel free to contact me off-forum if you want to get into the details of any of these items.  We haven't done exactly what you've described, as the built-in Import can usually do what we need.