IN Transaction
URL | Verbs | Function |
---|---|---|
INTransaction | GET | Query a list of INTransactions |
INTransaction | POST | Create a new IN Transaction |
INTransaction/<reference> | GET | Query a specific IN Transaction by its reference |
Supported modifiers
Query String | Definition | Sample |
---|---|---|
modifiedSince | Return IN Transactions modified since a particular date and time | modifiedSince=2013-02-28T16:45:00 |
tranType | Return a list of IN Transactions for a particular Transaction Type | tranType=Transfer |
Security Linked Menu
Menu Item | Located |
---|---|
IN Transaction Entry | Data Entry / Inventory |
Sample XML Response
<INTransaction>
<Edition>10</Edition> <OidString>2613.120</OidString> <EntryTimeStamp>2011-09-12T14:32:43</EntryTimeStamp> <EntryUser>SUPER</EntryUser> <ModifiedTimeStamp>2011-09-12T14:32:43</ModifiedTimeStamp> <ModifiedUser>SUPER</ModifiedUser> <CurrencyRate>1.00000000</CurrencyRate> <DocumentDate>2011-09-12</DocumentDate> <Discount>0.00</Discount> <HoldAmount>0</HoldAmount> <NetAmount>173000.00</NetAmount> <TaxAmount>0.00</TaxAmount> <IsCurrencyRateMultiply>true</IsCurrencyRateMultiply> <IsPrinted>false</IsPrinted> <IsRootTransaction>true</IsRootTransaction> <BatchNumber>4000</BatchNumber> <Branch>02</Branch> <Currency>AUD</Currency> <PostingDate>2011-09-12</PostingDate> <Reference>1011</Reference> <SourceSystem>External</SourceSystem> <StandardText>Manual average cost adjustment</StandardText> <Description>Manual average cost adjustment</Description> <Detail/> <TransactionType>Cost Adj</TransactionType> <LineItems collection='true' count='2'> <LineItem> <LineType>ININLineItem</LineType> <LineNumber>1</LineNumber> <OidString>3077.371</OidString> <Edition>3</Edition> <TaxCode>GST 10%</TaxCode> <TaxType>Exclusive</TaxType> <Quantity>0.0000</Quantity> <DiscountPercentage>0.00</DiscountPercentage> <Amount>15000.00</Amount> <DiscountAmount>0.00</DiscountAmount> <HoldAmount>0.00</HoldAmount> <TaxAmount>0.00</TaxAmount> <TaxPercentage>0.0000</TaxPercentage> <UnitPrice>15000.0000</UnitPrice> <StandardText>Average cost adjustment to 200 qty on hand</StandardText> <CurrencyRate>1.00000000</CurrencyRate> <DocumentDate>2011-09-12</DocumentDate> <IsCurrencyRateMultiply>true</IsCurrencyRateMultiply> <IsRateFixed>false</IsRateFixed> <LineItemType>IN</LineItemType> <NonTaxPrice>15000.0000</NonTaxPrice> <PostingDate>2011-09-12</PostingDate> <TaxInclusivePrice>15000.0000</TaxInclusivePrice> <CostNet>15000.00</CostNet> <CostTax>0.00</CostTax> <IsPrintBasedOnReceivingQty>false</IsPrintBasedOnReceivingQty> <IsPrintOneLabelPerLine>false</IsPrintOneLabelPerLine> <LabelsPerUnit>0</LabelsPerUnit> <Location>03.Z01</Location> <StockItem>MF-PP</StockItem> <TransactionType>Cost Adj</TransactionType> <UnitOfMeasure>EA</UnitOfMeasure> <EffectOnStock>0</EffectOnStock> <PrintLabelsBaseUnit/> <StockingQty>0.0000</StockingQty> <IsTransfer>false</IsTransfer> </LineItem> <LineItem> <LineType>ININLineItem</LineType> <LineNumber>2</LineNumber> <OidString>3077.372</OidString> <Edition>3</Edition> <TaxCode>GST 10%</TaxCode> <TaxType>Exclusive</TaxType> <Quantity>0.0000</Quantity> <DiscountPercentage>0.00</DiscountPercentage> <Amount>20000.00</Amount> <DiscountAmount>0.00</DiscountAmount> <HoldAmount>0.00</HoldAmount> <TaxAmount>0.00</TaxAmount> <TaxPercentage>0.0000</TaxPercentage> <UnitPrice>20000.0000</UnitPrice> <StandardText>Average cost adjustment to 200 qty on hand</StandardText> <CurrencyRate>1.00000000</CurrencyRate> <DocumentDate>2011-09-12</DocumentDate> <IsCurrencyRateMultiply>true</IsCurrencyRateMultiply> <IsRateFixed>false</IsRateFixed> <LineItemType>IN</LineItemType> <NonTaxPrice>20000.0000</NonTaxPrice> <PostingDate>2011-09-12</PostingDate> <TaxInclusivePrice>20000.0000</TaxInclusivePrice> <CostNet>20000.00</CostNet> <CostTax>0.00</CostTax> <IsPrintBasedOnReceivingQty>false</IsPrintBasedOnReceivingQty> <IsPrintOneLabelPerLine>false</IsPrintOneLabelPerLine> <LabelsPerUnit>0</LabelsPerUnit> <Location>03.Z01</Location> <StockItem>MF-USB</StockItem> <TransactionType>Cost Adj</TransactionType> <UnitOfMeasure>EA</UnitOfMeasure> <EffectOnStock>0</EffectOnStock> <PrintLabelsBaseUnit/> <StockingQty>0.0000</StockingQty> <IsTransfer>false</IsTransfer> </LineItem> </LineItems> </INTransaction>
When posting data, you have the option to exclude the Amount element on a line item, Greentree will use the other fields to calculate the price, taxes etc for each line item. This allows for a typical integration where a 3rd party simply wants to tell Greentree to transfer a number of widgets, or allocate them to a Job without care for any of the financial values.
At its simplest, the data required to create an IN Transaction is as below :
Sample POST data
<INTransaction>
<TransactionType>Cost Adj</TransactionType> <LineItems collection='true' count='2'> <LineItem> <LineType>ININLineItem</LineType> <Quantity>3.0000</Quantity> <StockItem>MF-PP</StockItem> </LineItem> <LineItem> <LineType>ININLineItem</LineType> <Quantity>4.0000</Quantity> <StockItem>MF-USB</StockItem> </LineItem> </LineItems> </INTransaction>