Solved

I was giving a demo of manufacturing for a potential customer and they asked a great question.Their business is growing plants to sell and they use manufacturing orders to track the plant from germination, through it’s growing stages.The first work center would be “Germination” and it doesn’t matter how many seeds they plant, the germination rate is 3 days for a particular seed.How would that be represented on the BOM under the Run Units and Run Time, if quantity isn’t a factor?Thanks!

2022 R2 We have paid for Shipping Carrier Integration license. I have integrated EasyPost for UPS using our carrier rates as per the provided guides. Tested the setup and it is connecting properly.Tested Confirming Shipment to Verify Connection - It workedWhen shopping for rates at the sales order document and select a rates, it adds the cost to the document and marks up the cost to add a freight price correctly per the freight terms I have setup. Great.Add cost and price based on rate selected and shipping terms (120% of freight cost)But, we don’t have standard packages for all our products. We do manual packaging. So, our workflow requires us to add packages, dimensions, weights at the shipment document level. No problem, add this at the shipment level instead of sales order level. The issue we are having is that after adding the package details, shopping for rate and selecting a rate it does not update the Freight Cost field. Furthermore, if we manually add the freight cost (not ide

Can’t get approval map to do what I want and it is the most simple example possible - need help. If requisition is created by JBROWNE, approval required from MENGLISH.If requisition is created by anyone except JBROWNE (and $ > 0), approval required from PURCHASING.  No matter I what I do, it require approval from Purchasing only - clearly I am missing something obvious.

Our business creates seed mixes via the manufacturing process.The ingredients for the mixes have base units of “EA” or “each” because we purchase and sell the bags by the bag (not by weight). Each ingredient comes in bags that weigh 50 pounds.I have the following BoM to create 1# of the seeds mix:Ingredient 1 - 0.4# (0.008 of a 50 pound bag)Ingredient 2 - 0.4# (0.008 of a 50 pound bag)Ingredient 3 - 0.2# (0.004 of a 50 pound bag)Inventory wise this math works perfectly and I’m able to do a production order flawlessly in the system.BUTOn the production order ticket it displays/tells workers to use 0.008 of a 50# bag and ideally I would want it to tell the worker how many POUNDS to use. I can’t change UoMs of the ingredient stock items.Originally I was going to create a second stock item for each ingredient and call them “Ingredient # BULK” with UoMs as pounds and create BoMs to convert 50# bags (EACH) into Bulk pounds and THEN create a BoM for the mix using the BULK stock items... but t

Hello, is it possible to use a project attribute in a approval mapping? Below are some screenshots of the approval mapping, the attribute is a field with entry mask as number.  Approval mapping:Attribute setup:Thank you,Kage

Hello all,Do we have an GI or Report for check out the logs for Change Management? Thanks.

Purchase Order not recognizing budget on projectThe account code used is included in the TRAVEL account group and TRAVEL is included in the budget.  When posting a JE, it works fine.  When an attempt is made to enter a Purchase Order, it gives error (error comes before and after Cost Code entry)The PO  error:The budget:Account Group 

I’m hoping to confirm the scope of excluded “attachments” the “"Full except Attachments” and the “Full except Attachments and Wiki” actually refer to as Export Modes for snapshots.  I can see from a snapshot I’ve created with one of these modes that “Incoming Documents” within AP are all removed.  Are there any other modules where “attachments” are removed?  I can also see within Construction/Projects the attachments there are retained with the records, not removed, which is what I would hope to find.  Are there any “gotchas” these export modes may surprise me with?  Looks like the email files under “Time and Expenses” module are also removed for the most part.  I do find three incoming email with attachments, but only three.  We are 2022R2, Build 22.205.0026.

Hello, Date range runs out to 8-2-24.In the production order pane, I can scroll to the right, but no all the way to 8-2-24. 

Hi All,I am new to manufacturing. What is the process of disassembling of a closed production order with serialized items? thxDries

Hi all,Why can I see the Contact table in the Schema Builder but not in Expression Editor.   I am using the statement notification email template and there are a specific email setup on the customer contact and set in mailing & printing tab So I am trying to send the customer statement to the mail address that I setup on the customer mailing and Printing.  Thank you in advance.Dries  

I want to add a filter to the report in the report designer. The filter is based on the LastModifiedDate of the AMMTran object. So far, I have tried=DateAdd(Today(),'d',-1) and Today(), but both these filters are not fetching the data correctlyHow do I get the date filter to work?Thank You.

Hello All,Normally we will get the Landed Cost around 3 - 5 days after receiving goods.If we sell products during that time, the item cost will exclude the Landed Cost.Then, when entering the Landed Cost for the sold items (that item does not exist in the system anymore), the amount number of this Landed Cost will go to an expense account.In this case, the cost of goods sold will be wrong.Has anyone got this situation? The additional case for those who use the module Construction. When the amount number of this Landed Cost goes to an expense account, there is no project ID. Therefore, you can't allocate this expense to a different project. Thank you in advance for any ideas that will be posted.Many thanks,Yên Chi

Hello all,I would like to know if it is possible to move the appointment that has an incorrect service order linked to a correct one. Thanks in advance.

So the request was to add the Recurring Unit Price to the Generic Inquiry for Service Contracts [ScreenID: FS3057PL].   However, when I add the item to the results grid after joining the FSContractPeriodDet Table to the Parent Table: FSServiceContract, I get duplicate line entries on the GI.  I have tried a few things to remedy this and can’t seem to figure it out.  I tried grouping by the Service Contract ID, but it totals the amounts of the lines and that is not correct.  There should only be one line per Service Contract.Here is the GI: Here are the results:  

My Acumatica reseller told me that the limit for a single import using either an SQL table or excel spreadsheet based import scenario is 10,000 lines. The seems a bit small given the fact I can import much larger datasets into the free version of MSSQL using and excel spreadsheet.My question then is if that is indeed a limit, and I have over 250,000 activities to import into the CRM portion of Acumatica, is there a tool that anyone know of that can take a large excel spreadsheet of all the 250,000 activities and automatically generate smaller excel spreadsheets of no more that 10,000 lines so I can import them into Acumatica using and import scenario. Any tools or approaches that others have used to import large amounts of data that go beyond 10,000 lines would be greatly appreciated.

Trying to build a GI or maybe a report, that can quickly show me items and when they were produced.  Is there a table somewhere that captures when a order changes status?  I’d like to see the date that certain Work Orders were completed.

We have a client who is using Avalara to process sales tax and they have requested a report or inquiry showing monthly sales by ship-to state that will allow them to audit Acumatica sales tax versus Avalara sales tax reports. Has anyone created anything like this?

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!

Has anyone ever had to make mass adjustments to multiple employees taxable wages before?When you go to the Taxes tab on the Paychecks and Adjustments screen, select a tax code you can manually enter taxable wage adjustments in the right hand pane. This is great but if we need to do this to 100-500 employees doing this manually is quite difficult and time consuming for the customer.Has anyone had any success? Screen: One of the import scenario’s I have tried:Import By Scenario with Error:There is clearly a Wage Type 

If a user needs to reclassfy the expense account of bill, but the original posting period is already closed,then it’s currently not possible to reclassify that in the next open posting period with GL506000. The field posting period is greyed out. The posting date can be changed, it does not lead to a newer posting period though. Is this by design?How can a user correct thiswithout reopening the previous posting period (due to already filed reportings to group companies)? and with keeping up the transparency of reports with / without reclassified transactions?

Hello team, is there a setting in Acumatica for Shopify POS sales orders so that the orders status is set to completed instead of open? At the moment, all Shopify POS orders are coming in as open and we have to close them manually.

Hello - We are a US based hotel company, with one of our properties having a Swedish owner. We need to report our financial statements in USD under GAAP, but our owner also would like to view the reports converted to Swedish Krona. Is there a way to convert a report that has a USD balance to another currency, or will we have to create a separate company and run all of the transactions with the currency converter?Thanks!

Hi team, We have a scenario where a vendor has two points from which they distribute stock to us. Location A is denominated in euro, location B in USD. Looking to support our procurement team by setting defaults for currency which follow the location field for vendor rather than default at vendor, and then allowing override. Before you suggest splitting the vendor into two, it can occur that for speed of delivery they switch locations and thus the order currency. I understand it is difficult/not possible to switch a PO between vendors once issued so we didn’t think that met our needs - but correct me if that’s wrong.Thanks!

Is there a way to view MRP Details from any prior date MRP was generated on?  I would like to be able to show what MRP was recommending (and the Detail Inquiry to support that) from a previous date.  For example, see what sales orders were driving the demand that may have been changed or deleted?Thanks