Looking at working on integrations with our shipping broker, and we are investigating how to pass along dimensions for items we ship through them regularly. I know where is box dimensions that can be captured, but I believe those only come into play during a shipment. We are trying to store these at the stock item, so that when we create a new stock item that we want our broker’s system to know about, that data is readily available to pull.Does anyone have any best practices? We are currently looking at either adding the information as attributes, or adding customs fields to the packaging tab on the stock item record.
I’m looking to figure out how to make my row styles based on the Days Lagging column, which is a formula that is the following:=DateDiff('d', [SOOrder.OrderDate], Today()) I’d like to color code on the Days Lagging to show Red as greater than 90 days, yellow greater than 60 days, green greater than 30 days. I’ve tried using a Switch statement that has IIf inside to do the same math, but I’m getting out of bound array issues. What am I doing wrong lol?
I’ve looked at the articles about this process, but still not getting the results I am looking for. I have a Bar Chart that looks like this:The values are based on a Attribute filed on the Stock Items. Values are Medium, Low and High.In the Color option of the Series, I have the following formula based on the documentation.=Switch(Value = 'High', '#AB400C', Value = 'Medium', '#e9e00', Value = 'Low', '#a9d360')But the results are this:Any ideas?
I’m looking for thoughts on how to handle the following scenario:We have components that we manufacture inhouse, but also outsource. In house, we do standard production orders against a BOM, which generates our standard cost. But, we also outsource these items. Currently, we outsource these components 95% of the time. Because we have BOM for these parts, out standard cost generates whenever we Cost Roll our BOM, but I really need our cost to reflect the PO cost of these items, or a avg of the 2, since we are 95% outsourced. I’d prefer to keep the BOM active for our flexibility.
Hey there everyone, Is there a way to connect a Google sheet into an Acumatica screen to get real time data?
Looking for insight/opinions on scanners/tools to use the Mobile App on my production floor. What scanners have you used? Are there options out there for integration of the scanner to have the Acumatica Mobile app directly on the scanner? Traps and pitfalls setting up the system and using the mobile app for transfers? My use case is to have material handlers stocking and pulling inventory from specific locations to different specific locations. Looking for what has worked best for other companies. I will have forklift drivers and pallet jack operators making the transfers, so I need something rugged and user friendly.
I am looking for a way to hold inventory at $0 and $0. This general idea is that I have used inventory that we want to bring into and out of a location. With this inventory being used, we do not want to value it at all in our GL. These inventory items have the same inventory ID as new items that we want to value. I’ve seen the options in the Warehouse Location to cost separately, but I am still seeing the value sitting when I run an inventory valuation report.
Hey everyone, I know we can use the Mass Change function to swap one item for another across multiple BOMs. Is it possible to use function to just remove an item without swapping out another one.
Mobile app and Manufacturing - Is there a way to make Move transactions against Production Orders inside of the Mobile App? If so, any direction on which settings might need to be changed to pull this off?
I was hoping someone may have some insight to this question. I am coming up with a large WIP variance in our Production Orders, and are thinking Phantom BOMs might be the cause. At the parent level, we backflush material and labor. We also exclude the Phantom, thus allowing us to bypass the move in the production order. At the BOM for the phantom, we have run rates as if we were going to make a Production Order and backflush labor and material. Is the WIP variance related to excluding the phantom and thus not capturing the labor?
Hello everyone, I’m trying to find a way to have the notes on a Stock or Non Stock item automatically print on a Purchase Order. I know I can add notes on the individual line, but I don’t want to have to manually copy the notes per line item for every time I make a PO. Use Case: For our ISO 9000 certification, I need the stock item note to call out a spec reference sheet every time I make a PO for that item.
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.