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
GP Document Locked by Accellos Warehouse Unable to …
Working in GP Dynamics with the Accellos One warehouse management (WMS) integration will change the way GP interacts with inventory as the WMS becomes the “parent”
Order Status Report to Inform Sales of Orders that did not Sync with WMS
Order Status Report to Inform Sales of Orders that did not Sync with WMS — Orders in GP but not in WMS — Replace the XXX for a.docid for the different order types withi
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