Can we create purchase order or invoice using api without adding items on portal

test
test Member Posts: 3 Novice Member Novice Member
edited December 2023 in Reckon API

while creating invoice or purchase order we need items to add.

 <InvoiceLineAdd defMacro = "MACROTYPE">
            <ItemRef>                                         <!-- opt -->
              <ListID>IDTYPE</ListID>                         <!-- opt -->
              <FullName>STRTYPE</FullName>                    <!-- opt -->
            </ItemRef>


Api fails, if item ref doesn't find the item on portal. So, while creating purchase order or invoice can we create item or add the item that is not on portal.

Answers

  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 319 Reckon Legend Reckon Legend

    No, items need to exist in the Reckon file. You need to create the item first.


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au


  • Teddy
    Teddy Reckon Alumni Posts: 12 Former Reckon Staff Member Former Reckon Staff

    Hi @test,

    Nick sent you an email with all the info you need. From the previous email sent to you, we attached an XML file called qbxmlops61.xml and this file contains all the payloads you need to create, modify, and query data in your company file via API.

    That same file contains payloads to create service, inventory, and non-inventory items which you can then use to create invoices and purchase orders.

    If you have any further questions, feel free to respond to this comment.

    Thanks, and regards,

    Teddy

  • boresz
    boresz Member Posts: 2 Novice Member Novice Member

    Hi @Teddy ,
    I have same question with test.
    I have installed postman but there is no "Item Inventory Add"
    I also tried XML from intuit page. still no luck.

    Could you please also send me the xml?

    Thanks

  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 319 Reckon Legend Reckon Legend

    Hi @boresz

    There is ItemInventoryAddRq in the intuit page:

    https://static.developer.intuit.com/qbSDK-current/common/newosr/index.html

    You will be able to find the XML example there as well. Here is the one for ItemInventoryAdd;

    <ItemInventoryAddRq>    <ItemInventoryAdd> <!-- required -->        <Name>STRTYPE</Name> <!-- required -->        <BarCode> <!-- optional -->            <BarCodeValue>STRTYPE</BarCodeValue> <!-- optional -->            <AssignEvenIfUsed>BOOLTYPE</AssignEvenIfUsed> <!-- optional -->            <AllowOverride>BOOLTYPE</AllowOverride> <!-- optional -->        </BarCode>        <IsActive>BOOLTYPE</IsActive> <!-- optional -->        <ClassRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </ClassRef>        <ParentRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </ParentRef>        <ManufacturerPartNumber>STRTYPE</ManufacturerPartNumber> <!-- optional -->        <UnitOfMeasureSetRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </UnitOfMeasureSetRef>        <SalesTaxCodeRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </SalesTaxCodeRef>        <SalesDesc>STRTYPE</SalesDesc> <!-- optional -->        <SalesPrice>PRICETYPE</SalesPrice> <!-- optional -->        <IncomeAccountRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </IncomeAccountRef>        <PurchaseDesc>STRTYPE</PurchaseDesc> <!-- optional -->        <PurchaseCost>PRICETYPE</PurchaseCost> <!-- optional -->        <COGSAccountRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </COGSAccountRef>        <PrefVendorRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </PrefVendorRef>        <AssetAccountRef> <!-- optional -->            <ListID>IDTYPE</ListID> <!-- optional -->            <FullName>STRTYPE</FullName> <!-- optional -->        </AssetAccountRef>        <ReorderPoint>QUANTYPE</ReorderPoint> <!-- optional -->        <Max>QUANTYPE</Max> <!-- optional -->        <QuantityOnHand>QUANTYPE</QuantityOnHand> <!-- optional -->        <TotalValue>AMTTYPE</TotalValue> <!-- optional -->        <InventoryDate>DATETYPE</InventoryDate> <!-- optional -->        <ExternalGUID>GUIDTYPE</ExternalGUID> <!-- optional -->    </ItemInventoryAdd>    <IncludeRetElement>STRTYPE</IncludeRetElement> <!-- optional, may repeat --></ItemInventoryAddRq>


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au


  • boresz
    boresz Member Posts: 2 Novice Member Novice Member

    Hi @PhuongDo
    yes, I've tried the XML from intuit page before. In my case, the required fields are

    Name
    IncomeAccountRef
    COGSAccountRef
    AssetAccountRef

    it's working now.
    Thanks!