A/P Freight Reconcile for Multi-Site Companies
A/P Freight Reconcile for Multi-Site Companies A few things about this query: – Replace the ‘XXXX-XX-XX’ with a date range of the financial period you are closing
A/R Freight Reconcile for Multi-Site Companies
A/R Freight Reconcile for Multi-Site Companies A Few thing about this query: – Replace the ‘XXXX-XX-XX’ with a date range for a closing financial period. –
Inventory Excess Report with SKU Ranking by Procurement Software
Inventory Excess Report with SKU Ranking by Procurement Software A few things about this query: – Q1, Q2, Q3 and Q4 sub-queries have XXXX for the year. – Location Cod
SKU Purchase Report by Customer
— SKU Purchase Report by Customer — Note: this report will display the posted date of the invoice, the invoice number, item number (SKU), item description and the exten
Customer Profitability / Cost to Serve Report
— Customer Profitability / Cost to Serve Report — Variables Below … — Set the XXXX in year(docdate) to the desired reporting year — Set the XX month(d
Display Running Gross Sales Numbers for a Period
— Display Running Gross Sales Numbers for a Period — Variables Below … — Replace the XX in month(glpostdt) to the period number you desire — Replace t
Display Customers that Purchased the Same Month they are Created in GP
— Display Customers that Purchased the Same Month they are Created in GP — Variable Below … — Change the XXXX in @Year = to the desired year — Change
Display Customer Accounts Setup in a Certain Period
— Display Customer Accounts Setup in a Certain Period (month) — Variables Below … — Change the XX in month(creatddt) to the desired month (period) —
Calculate the Number of Open Backorders/Canceled SKUs in a Given Period
— Calculate the Number of Open Backorders/Canceled SKUs in a Given Period — Variables below … –Change the = ‘X’ to IN (‘3’, ‘4’) to include both in
Calculate the Number of Line Items Sold for a Given Period
— Calculate the Number of Line Items Sold for a Given Period — Variables below … — Replace the soptype X with a 3 for an invoice and a 4 for a return — C