@Gabriel Michaud Thanks for the reply. I had a look. It works if it is a “Value” in the pivot table, but not when we have a number field as a row or a column of the pivot table. Unfortunately mine are all rows.
thanks @lauraj46. However I am still struggling to get the outcome needed. My Pivot has SOOrder.Openorderqty as a row field. GIGIPivot Properties In the excel
@Olga Anisimovich thanks. Managed to release it without any issue.
@lauraj46 Thanks. We did a OData and now its with the customer. Hopefully they are satisfied.
@Debbie Baldwin yes, its production orders and you can create a Prod Order without a BOM in Acumatica. We want to restrict it. That is if you do not have an active BOM, you cannot create the Production Order from the Sales Order. I am trying to see what’s the easiest and best way to do it. Do note, we are only using the MRP, BOM, Prodcution Order and Estimate Modules.
thanks @Jp89
@gmercede thanks for the info above. Hoping you can add some more clarity for me.Currently we are using standard cost valuation method. For purchasing we have set “AP Bill Release”. My stock item doesn’t have a standard cost defined.If I receipt this particular stock in to inventory with a unit cost of $10, still I do not see anything in my cost statistics. Should not the last cost be updated to $10:00 in this scenario?If not is there a way that we can get the last cost or pending cost set to last purchased price for inventory that uses “Standard cost” valuation method?
Thank you!
Can I please have access to the below: https://community.acumatica.com/property-management-206/acumatica-2021r2-property-management-and-cash-basis-reporting-update-01-10469
Hi, if you are maintaining your sales price at the stock item level (Price/cost info - Default Price) or sales price list, you can get the sales price from there and the production cost from the prod order. Is that not an option?
Hi JamesIn addition to tasks/ activities, if you use the full Purchase requests and requisition process, then you can track the flow from request to issue, by department / workgroup for non-stock items.Hope this makes sense./Uma
Please try below if you haven’t so far:In the Inquiry:Fetch the prod order nbr from AMProdItemIn the event:Group By = AMProdItem.ProdOrderIDTriger ConditionRecord InsertedNew Field Value → AMProdItem.ProdORderID Is not Empty Also when you are testing, you are releasing a new record, isn’t it?I have always used group by with a Schedule (Trigger by Schedule), which has worked without no issues.Worst case scenario, have a another inquiry with Group By, and use that with Raise Event = Each Record.Good Luck! Kind RegardsUma
Or has anyone replaced BC with Acumatica?
I have faced a similar problem. I am using FIFO, Lot tracked with AVG costing. What we realised is that in the INCostStatus table for the particular receipt the On Hand Qty (i.e. 15) is lesser than the actual receipt qty (I.e. 35). So it allows us to return up to that 15 items but not the whole of the receipt qtyNow the issue is how to fix it. Is a simple data correction would do? We are going back to Acumatica support on this.
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.