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
Error “Smart List Will Not Export to Excel”
Error “Smart List Will Not Export to Excel” This error normally occurs when an end user tries to export to Excel from Smart List for the first time. It is caused by the end use
Error “The Specified Path for the Output File Doesn’t Exist”
Error “The Specified Path for the Output File Doesn’t Exist” I normally run across this error with the Accounts Payable and Accounts Receivables departments when they are try
Error “Metrics are not Available Because Microsoft Office Charts not Installed”
Error “Metrics are not Available Because Microsoft Office Charts not Installed” You will normally see this error message in the top right hand module of your GP home screen. Th