How to add product or select previously added product in Invoice

Discussion in 'Developers Forum' started by neotericuk, Apr 21, 2011.

  1. neotericuk New Member

    I am using API
    While adding Invoice how can i add product to invoice so that when i am checking details it will select one of the product from the dropdown?
    Or
    Provide me a way by which i will be able to add product while adding invoice. so that on details it will show me complete details.
    i.e. product, rate, quantity, vat, total. Currently i am able to add all the data except product?
    neotericuk, Apr 21, 2011
    #1

  2. knu New Member

    If you want to do this by ProductDescription you'll have to GetProducts then loop through the array that's returned then use ProductID
    knu, Apr 21, 2011
    #2

  3. knu New Member

    Sorry. That's wrong. It's GetSubProducts you need I think.
    knu, Apr 21, 2011
    #3

  4. knu New Member

    Just try both !!
    knu, Apr 21, 2011
    #4

  5. knu New Member

    I went back and looked at my code for this and to populate the 'Product' field I set the ProductID member (which I accessed by looping through the array returned by GetProducts and searching by ProductName) - which was as I originally thought. And this definitely works.

    If you look at the docs (KashFlow API - Manual - Classes - InvoiceLine) it says you use the ID of a SubProduct - I think this might be misleading, though I've not actually tested that...
    knu, Apr 26, 2011
    #5

  6. neotericuk New Member

    Is their any API of kashflow or you have created your own code for doing so.
    Can you provide me some suggestions.
    Any help is appriciated.
    neotericuk, Apr 28, 2011
    #6

  7. knu New Member

    It's certainly wise to create a library of functions in whichever language you're using (I'm writing in php). It avoids a lot of tedious repetition.

    Regarding my post above, the on line API docs are correct - you do use GetSubProducts in order to populate ProductID in each InvoiceLine.

    I hadn't done that. Instead, I had hard coded my sub product ids by going to https://securedwebapp.com/SalesTypes.asp, clicking on a sales type which has products (or SubProducts in API speak), and then when you select one of those products you get the id from the url (https://securedwebapp.com/ManageProductList.asp?prodid=xxxxx).

    The whole naming convention is still a little confusing though. Products in the web interface are SubProducts in the API. And Sales Types in the web interface appear to correspond directly with either (the API) Product or NominalCode (which do have slightly different properties, the first being more product and stock focused and the second more accounting and sales focused - but there appears to be a one-to-one correspondence between them.)
    knu, Apr 30, 2011
    #7

Share This Page