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>