Get inspired and gain all the knowledge you need
It looks like I should be able to do this with AMClockItem and AMClockTrans but has anyone done this? We want to have a status screen for production that shows all production orders that currently have an employee clocked in and show the operation(s) that are clocked in as well as the elapsed time it has been clocked in.
Does anyone know of a way to handle the new CO Retail Delivery Fee ($.27 beginning July 1, 2022) either with Avatax or without? Avalara had sent out communications regarding this which stated to perform the following: Merchants subject to this fee will need to add a $0 line item to their orders with the OF400000 tax code. I’m unsure as to how this would be done in Acumatica. Perhaps someone from Acumatica may know if there will be something released in a new build perhaps?
Hey all,I’m working on modifying the Production Order Performance report. I had some issues with it repeating lines yesterday, but ended up fixing them. After making further changes (necessary ones) it has started looping again. I can’t repeat the same solution, as the solution would simultaneously undo the changes as they conflict. It has to do with the relationships of tables. A screenshot is included below. I need to have the AMProdEvnt and AMMTran tables involved. They are necessary for the changes I am making. I don’t know how to properly configure them as to not cause looping. Any help is greatly appreciated.
We’re running 21R1 with a system email account configured to use Azure Modern Authentication. I’ve had users report a few instances of messages not being downloaded by Acumatica. They’re finding this out when customers send follow up responses that quote their previously sent message.It appears that these emails are just being skipped for no reason I can discern. The system schedule history does not show any errors for processing during the time that message would have been downloaded.Each time I have confirmed that the message is in the inbox for the account Acumatica is configured to use. These messages are marked as unread in the Outlook web UI and no one other than myself has the password to sign into this account directly. None of the emails I’ve investigated were being marked as junk.The most recent instance of this happened last week and as far as I can tell, nothing is amiss with the message. The end user did not modify the subject and the To address is correct. I am not
Price list syncs are taking a very long time, over 20 hours. Not to mention it usually errors out and needs to be manually restarted in this time period.I have tested this with a lot of price changes, and minimal price changes, and the time to sync did not change.Is there a better way to automate this process, and to only update the items which prices have changed (either + or - amount)?BigCommerce did recommend using Price List Importer/Exporter | BigCommerce. I have tested this on Sandbox, and this is a very fast way to update multiple price lists for multiple items at once (I did about 6,000 items in < 10 seconds). While this is an adequate solution, I don't see any way to automate this.
Hi Team,Recently , I have tried posting Intercompany purchase process. I have created PO and triggered the SO then shipment also completed. When I checked the “Inventory summary” inquiry I couldn’t find the movement of inventory from one company to another company.Actually, Purchasing company will receive the inventory and the selling company inventory will be reduced by the quantity which is in the sales order.Please let me know the issue here.Thanks in Advance.
Error: Inserting 'IN Transaction' record raised at least one error. Please review the errors. Error: 'Reason Code' cannot be empty.
Good dayI have created a production order in my main tenant and on trying to release the Material transaction I am getting this error message “Error: Inserting 'IN Transaction' record raised at least one error. Please review the errors. Error: 'Reason Code' cannot be empty.”The reason codes are defined and set under the Inventory Preferences, how do I resolve this issue?
Hi, I am trying to import AP bills. The AP Bills are tied to a PO Receipt. As well as the vendor, I have the PO number & PO Receipt Line number. I am having an issue with trying to select the Add PO Receipt Line in the Scenario. The Document is being created but nothing else is happening.(If in migration mode, you cannot use the Add PO Receipt button) Does anyone have any solutions/ideas for getting this to work?Thank you in advance!Bill
Hi guys,It seems that when link a cash account to an account in the chart of accounts, it has to be “one to one”. When I tried to link more than one cash accounts to one account in the chart of accounts, the systems showed an error. So is it impossible to do that? Thanks.
Hi all,when you design a report, you need to define the data source in the column set / row set. I could only see dimensions listed below. Is there any possibility to have “project” here? We’d like to have financial reports by project. I know there are several reports under project, but is there any one of them that shows financial results of multiple projects for comparison? Thanks a lot!
I have a prospect that receives payments for a scheduled training session i.e. month-1- payment is received however training can be scheduled to take place in month-3- but very often training classes are not yet full so they push training out again say to month-4-. How flexible is our deferral codes or deferral schedules in these instances? I.e., if a scheduled month or two months are missing and do not get ‘run’ or posted, what happens? Can they just skip months as necessary, then run the applicable month and update the schedule somehow? Thanks,
Hi, just trying to figure out if the licensing process has changed in the last couple of releases for ISV partners.Our MO is to setup an internal VM that runs the current Acumatica ERP release locally. Usually we don’t need to license our internal test instances of the ERP, but eventually we need do some multi-threaded integration testing that requires the 6 sessions provided by a standard license. I didn’t make notes before because it seemed easy enough to find a stash of license keys for each version that we were to use internally and are not based on a customer installation.But that was a few months ago - now when I click on licenses in the portal ISV page it just reloads the same page, and my colleagues with similar rights are reporting the same thing. So if someone could kindly advise the best way to request a license, does it just need to be in a support case these days where we provide the system key and such? The articles i find just relate to what appears to be licensing for c
I have a client with numerous warehouses and they need the flexibility to receive items into locations associated with Projects in multiple warehouses. They want to be able to associate a warehouse location with a project in multiple warehouses but leave the task blank for flexibility on the receipt transaction (items sometimes are diverted to different warehouses than indicated on the PO). It does not seem possible to have a project associated with a location in multiple warehouses without a task. What am I missing?
Hi everyone - Below are the Acumatica Community Featured Members consolidated. December 2022 - We will be featuring our 2023 Community MVPs - stay tuned!November 2022 - Naveen Boga - Acumatica Community Featured Member for November 2022October 2022 - Anacarina Calvo - Acumatica Community Featured Member for October 2022September 2022 - Abe Majors - Featured Acumatica Community Member for September 2022
Does anyone have any suggestions on what to check for this problem? I have complete the first level move and it looks like the inventory has been allocated to the production orders but the status of the orders is not changing from “Released” to “In Process”. Any help is appreciated. TIA
Hello, I am trying to export account details for the whole year 2022 by a specific branch for all accounts. on the Account details inquiry (GL404000) we have to include an account, so I was trying to recreate the screen as a GI where we do not have to include an account. I can get all the information in the GI besides the Beg. Balance and the End. Balance, any suggestions on how to get that information?Data class: GLTranRData field: SignBegBalance Screenshot of Account details screen:Thank you,KT
Hi everyone - You may notice that a post you make gets put into moderation. You’ll see the message below when this happens. This is the SPAM prevention utility doing it’s job maybe a little too aggressively. Just know we’ll get it approved as quickly as possible. Please don’t try posting the same post again as it will just lead to duplicates we have to delete. I know this will add some inconvenience but it’s better that allowing the SPAM through we got hit with previously. Thank you all for your support!
I’ve discovered something a bit odd. I’ve replicated it with this trivial GI.Run the query:Now Apply a filter to the results:(if you want to try this, use the Fin. Date from any record in your result set) Now go back to the query, remove the grouping, run it and apply same filter:This time I get the expected result:The filter works on End Date with grouping enabled. Fin. Date is the only column with the issue. As a workaround in any GI with grouping enabled and using MasterFinPeriod I’ve had to switch to using End Date instead, which is Fin. Date + 1, and adjust any criteria against this column accordingly. Any ideas what’s going on?
Hello,We are attempting to use the “Print Invoice and Memos” screen to send out a large number of invoices at the end of the month. We have the customer classes set up in the AR preferences to send the invoices to specific contacts (Screenshot below). when we processed the invoice through the “print invoice and memos” Screen, it was only sent to the primary contact. I have attached another screenshot of Customer mailing preferences. Are we missing a step to use this for this customer class?AR preferences > Customer Classes Customer Mailing and printing settings:
My company is about to implement the MRP and forecasting portion of Manufacturing in our environment. Our end users are very anti-change and anti-technology. I’m hoping to ease their knee jerk reaction by looking for easy to use guides in a “for dummies” style with images and less technical explanations, but I’m not finding much in either the Acumatica University or elsewhere online. I think they’d really benefit from a document that is less technical and slightly easier to read. Any suggestions?
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.