-1.png?height=120&name=Untitled%20design%20(24)-1.png)
Reports
Inbound Reports
Purchasing Reports
Inventory Reports
Stock In/Out Details
|
Default |
datasourcefield |
|---|---|
|
|
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 |
|
|
qbstatus |
|
|
qbassetacctid |
|
|
manufacturerwebsite |
|
|
createddate |
|
|
filename |
|
|
qbsequence |
|
|
currentQty |
|
|
reorderlvl |
|
|
events |
|
|
totalitems |
|
|
totalchange |
|
Events |
|
|
receipt # |
receiptId |
|
|
purchaseOrderId |
|
|
purchaseOrderNumber |
|
|
customerId |
|
|
date |
|
|
supplierId |
|
|
supplierName |
|
|
receiverId |
|
|
receiverName |
|
|
accepted |
|
|
itemCount |
|
|
invoiceno |
|
|
purchasedprice |
|
|
eventUser |
|
|
transactionType |
|
|
referenceId |
Fulfillment Reports
Detailed Customer Order Report
May be different in V2?
|
Default Field Name
|
Element
|
|---|---|
|
|
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 |
|
|
qbstatus |
|
|
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 |