Hello, My company has a generic inquiry they use to show when items will go on back order at the line item by using this comparison in the conditions tab of the generic inquiry.So we are wanting to see items where the quantity available is less than the quantity ordered. Simple enough. However, the QtyAvail from the InSiteStatus table seems to be subtracting the qty from the order quantity first, then making the comparison. Therefore, we are seeing items on this GI where they may be 400 available and 300 ordered. But the “Qty Avail” in the GI is saying 100 available, because it already pulled the 300 for that order. So it is showing that order on the report, even though that one is good. Any ideas on how to fix this, or maybe another better way to show items that are going to be put on Back Order? Thanks!
Hello, I’m trying to create a GI that shows when the quantity of an item ordered is more than available for the item. What we currently have set up looks at individual line items and compares the line items to the qty available. However, we have noticed that one stock item will be used for a 12 pack and a 6 pack non stock item, for example. If someone orders both the 12 pack and the 6 pack, those show up as two separate lines items. We just experienced a situation where the whole order total should have been put on Back order, because there wasn’t enough of the single stock item, but it did not show up on this GI because neither line item by itself was more than the qty available. Does anyone have any suggestions on how to get this condition to look at the whole order, but still specific items? Thanks!
Hello, Is there any way to delete a discount line from a sales order that has been imported from Shopify? I have full permissions in Acumatica, but the X is greyed out. Very rarely, discounts are duplicated during the import from Shopify, such as the example screenshot. This also may be an issue with the connector, but I’m not seeing anything on how to fix that either. Any suggestions are appreciated!
Hello, I have a report created to track changes made to vendor profiles. Then I’ve also setup an automation schedule, business event trigger, and email template that will send out an email once a day with all changes to vendor profiles from the previous day. The email gets sent out only when changes were actually made the previous day, which is fine. However, the issue I’m still facing is that when using the HTML embedded format for the email, it only shows the top 3 lines from the report. I’ll share the schedule and business event here. The report also is created from the following generic inquiry. Does anyone know why it won’t show all the record changes? Thanks!
Hello, We just implemented Shopify for both ecommerce and POS and I’ve noticed an issue with the order type import on a few orders. I’m not sure why or how this is happening. On the Shopify Stores screen, we have our Order Type for Import set as WB for web orders, and then FI and FO are the POS order types. However, a few orders have come through with a different order type, MO for mail order. The one common thing I have been able to find between these sales orders is that there are items included that are automatically fulfilled (for shipping orders) or items that are not automatically fulfilled (for in store orders). Has anyone else noticed this issue or resolved something like this? Thanks in advance!
Already have an account? Login
Enter your 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.