Or has anyone replaced BC with Acumatica?
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
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
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?
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
Thank you!
@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?
thanks @Jp89
@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.
@lauraj46 Thanks. We did a OData and now its with the customer. Hopefully they are satisfied.
@Olga Anisimovich thanks. Managed to release it without any issue.
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
@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.
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.