Purchasing Reports/Inventory Reports
Stock In/Out
Data Source Fields
- imasterid
- companyid
- imastersku
- imasterupc
- imasterdesc
- imastercategory
- imasteruom
- imasterprice
- imasterweight
- imastereconorder
- imasterleadtime
- imasterkit
- imasterimage
- imasterbarcode
- perishable
- tracklot
- active
- leakageriskid
- ccfrequencyid
- minccfrequencyid
- clientid
- finishedgood
- rawmaterial
- nonmaterial
- dropship
- serialized
- needsapproval
- baseprice
- assembly
- listid
- rrp
- userfield1
- userfield2
- userfield3
- notes
- userfield4
- userfield5
- userfield6
- orderlimit
- importlogid
- manufacturerwebsite
- createddate
- filename
- currentQty
- reorderlvl
Events
- totalitems
- totalchange
- receiptId
- purchaseOrderId
- purchaseOrderNumber
- customerId
- date
- supplierId
- supplierName
- receiverId
- receiverName
- accepted
- itemCount
- invoiceno
- purchasedprice
- eventUser
- transactionType
- referenceId
Fulfillment Reports
Detailed Customer Order Report
Default Field Name
- customerorderid
- companyid
- customerid
- ordersourceref
- integrationsource
- status
- ordereddate
- extordernumber
- ordernumber
- itemcount
- ordervalue
- customertitle
- customername
- customersurname
- customeraccount
- customercity
- customercompany
- pickedcount
- orderedcount
- reservedcount
- unprinted
- here
- nonmaterialcount
- shippingbillingmode
- clientid
- completeddate
- completed
- cancelled
- cancelledby
- cancelleddate
- cancelledreason
- projectno
- orderplacedbyuserid
- orderplaced
- userfield1
- userfield2
- userfield3
- mylist1
- mylist2
- orderplacedbyname
- customerfullname
- shippingaddressid
- billingaddressid
- shippingaddress1
- shippingaddress2
- shippingaddress3
- shippingcity
- shippingstate
- shippingzip
- shippingaddressname
- shippingaddresscompany
- shippingcountry
- shippingphone
- customeremail
- customeraddress1
- customeraddress2
- customeraddress3
- customerstate
- customerzip
- customercountry
- customerphone
- billingaddress1
- billingaddress2
- billingaddress3
- billingcity
- billingstate
- billingzip
- billingcountry
- billingphone
- billaddressname
- billingaddressname
- billingaddresscompany
- shippedcount
- dropshipcount
- lotnumber
- pickprintdate
- shipvia
- discountpercentage
- note
- weight
- packages
Items
- imastersku
- imasterprice
- imasterdesc
- userfield1
- userfield2
- userfield3
- userfield4
- userfield5
- userfield6
- customerorderitemid
- imasterid
- orderquantity
- orderuom
- quantity
- partofkit
- pickeddate
- completed
- discountpercentage
- purchasedprice
- customerprice
- customertotalprice
- linenumber