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
Calculate the Number of Invoices (TRx Types) for a Given Period
— Calculate the Number of Invoices (TRx Types) for a Given Period — Variables below … — Replace the soptype X with a 3 for an invoice and a 4 for a return
Error “Sales Transaction Entry Window Cannot Find A Unique Number”
Error “Sales Transaction Entry Window Cannot Find A Unique Number” Being in the wholesale distribution industry I have seen this error numerous times throughout the last severa
Error “FP Can’t Close Table”
Error “FP Can’t Close Table” I first discovered this issue when one of the AR users kept calling me with the error everyday after she would come back from lunch. She would fi