Does anyone have any ideas on how to add backordered items to an Invoice? These would be zero dollar lines for visibility purposes only.We have the Add Zero Lines for Items Not in Stock checkbox checked on the Sales Orders Preferences (SO101000) screen so we get the following behavior: 1. Create a Sales Order where the first 2 lines are available, but the 3rd line is not available: 2. Create a Shipment and all three lines are carried onto the Shipment, even though the 3rd line is not shipped: 3. Create an Invoice and only the first two lines are carried over. The 3rd line disappears since it didn’t ship:
Does anyone have a clever way to use a Parameter in a Generic Inquiry to generate a HAVING clause in SQL right after the GROUP BY clause? It generates a WHERE clause which doesn't allow me to work with the aggregation results.I can do an on-the-fly filter, but I was hoping to use a Parameter.
Loving the new community. I’m going to send a message out to the AUGForums.com community (which will now pivot to focus on reporting in Acumatica) about this new Acumatica community. Before I do, I want to confirm that it’s ok for anyone to create an account, including MYOB customers, many of whom participate on AUGForums.com.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.