Discussion Forums

Acumatica will offer the Controlled Release of Payroll in Canada beginning with the 2023 R1 release coming in April. The initial release of Acumatica Payroll will support:Federal and Provincial Tax Calculations T4 and RL1 tax forms (T4 summary and RL1 available in 2023 R1) PD7A remittance validation report for CRA (2023 R1) Record of Employment Final Paycheck Canadian Specific features Paid Time Off calculations Deduction and Benefits calculations  Payroll related features EFT (via Canada localization) T5018 (improvements in 2023 R1, ability to separate goods/services in 2024 R1) The following features will be supported in a future release:Multiple base currencies. Customers who want to run both US and Canada payroll need to implement 2 separate tenants PTO enhancements T4A (AP report)The table below outlines the stages and timelines of the rollout.Stage Tentative Date(s) Information/Activities Acumatica Demonstrations July 2022 Acumatica supervised demos using a previ

Can someone please assist? Thanks

When invoices are dragged and dropped in the “Incoming Documents” screen in the Payables module, sometimes they turn sideways. It appears to be happening when the invoice itself is created in Landscape orientation so Acumatica is attempting to align the image so it’s in Portrait orientation even if that turns it sideways.  Is it possible to have Acumatica align invoices so the verbiage is horizontal regardless of how the paper is turned?

Can anyone assist with why this error is occurring in our our system? We are two years into implementation with SWK Technologies and are still having basic errors like this pop up as we demo the system.  An error occurred during processing of the field Location value WARRANTY IN Error: Selected Location is not valid for receipts.

Hi I want to create same screen as Scan and Count Base screen.I will ScanPI Ref Nbr. Lot serial NbrI will not scan Warehouse and Location.I am trying to customize existing base screen. But After scanning PI ref nbr. i am not able to bring Lot serial Nbr. I have attached the Code of Maint and aspx code file.   

Hello,We are implementing Shiphawk WMS and having trouble with inventory adjustments.  Our stock items are valued as FIFO method, so I believe it is because the “Receipt Nbr” field in the IN303000 screen is not able to populate from Shiphawk.  Is there a workaround for this error so that we can make inventory adjustments from the WMS?

Production detail includes backflushed non-stock items for outwork so that the value of outwork is included in finished goods. Detail Lines are marked for PO and POs will be created from the production order. This does not work unless the non-stock item is not flagged to require receipt. You can create a purchase order outside of the production order as normal. There is no need to receipt the PO, it will be matched to an AP invoice. How to create POs from production orders for non-stock items without PO Receipting ? 

Hi , I Have Attached generic enquiry for three table i have created.Notification source, Notification Receipient , Customer But the customer table am not able to join with other two to display the customer id and name Anyone can suggest and help me to resolve this issue 

Does anyone else look at community posts on Mobile? I am unable to see others comments on Safari, Chrome, and Edge. 

Hi, I have a requirement as follows and need to know how this can be catered via customizing the action.When I click on “Generate Orders for Subassemblies” for a parent item such as given below with a qty to produce of 10.00 When the button is pressed the child items also need to be set to a qty to produce of 10.00, currently the system sets it to 1.00 as shown belowHow can I also copy over the qty to produce as well over to the child items once the button is pressed?

Can I set CMType to visible when selecting a specific option from the  DocType field?  for example i will choose credit memo on doctypeCM Type will be set to visible Is it possible

Hello all,I have been working with customization projects for some time, and I can’t quite seem to figure out why sometimes they publish to the database, sometimes to one tenant, and sometimes to multiple tenants? It seems to be almost random, and I can’t seem to find a pattern. I understand there is the “Publish to multiple tenants” option; however, when I do this in Test and publish to both Production and Test tenants, the projects sometimes don’t publish into the Production. The times they do publish into Production, they still seem to “live” in the Test Customization Projects screen and don’t update the customization projects in production. E.g.- I make edits to a side panel in Test, publish to Test and Prod. I go into the customization in Prod and the changes are not in the project; however, the side panel displays in Prod Acumatica where it needs to be.I have looked over the community, but I can’t seem figure out the best practice and explanation with these projects!Thanks,-RJ

We have a customer who manages some of their cases through our portal. When I try to give them rights to change the status on cases nothing happens the box is still grayed out. These are support users who are assisting us with cases for these customers so they need to be able to edit and close cases that they did not create. Is there anyway to give them these rights through the portal?

How can I disable or hide the Export to Excel button in the report launcher window?

Hi All, I have got in total 6 companies and currently any user that log ins has access to all 6 of them.  I want users to only have visibility of the company they belong to and restrict access to any other company. I know I will need to create a role, but not sure what settings to change about the role under Access Rights by Role. Thanks in Advance. 

WARNING: Skip this paragraph if you are just looking for a quick solution. :)Hello Folks,I have been meticulously working on import scenarios re: Service Management and haven’t seen a lot of folks just sharing what they’ve got in terms of solutions and mapping and exported Import Scenarios and stuff.   I know the info is out there -- I mean people must be importing data for their clients and standing up Acumatica for them,  It’s almost like we see these things as our own personal artwork that we will show a glimpse of to folks, but will not outright share how we did it.   In my 28 years of IT work I have encountered this over and again.  It’s like if you share how you did it with others, you suddenly lose value as a professional.   The presumption here is that you only have a few secrets and if you give them all away, you will not be marketable.   I have always come against this norm by sharing everything I know with people and not holding back the solutions I have come up with.  It so

We just updated our production instance to 24R2 over the weekend.I should have thought to check this, but we had a number of different Generic Inquires created by different users that didn’t have access rights set. Obviously, during the upgrade, all “Not Set” access rights were changed to “Delete”. There are about a dozen screens that I want to go through and set every role to “Revoked”,but we have a lot of user roles in the system. (Afterwards, I’ll manually grant access for roles that require it.)Is there any better way to do this than to manually go through every role for each screen? I would be very comfortable doing this via a database update, but I’ve tried finding the database table that stores this information with no success. 

Hi! I have this starting table which is called usrInventoryItem which shows inventory levels in my warehouse and bin locations:I want to end up with the following view which essentially shows what is on hand (any warehouse locations not equal to Hold) and what is on hold (any warehouse locations equal to Hold):  How can I create this view in SQL?

I am trying to restrict the Attributes that show in the Attributes tab on the Project Entry screen.The Answers view on this graph is not a standard PXSelect.  The first two lines are from the original graph.I’ve tried using  public virtual IEnumerable answers() and  public virtual IEnumerable projectAnswers()but neither of those fire my view override.  I have a breakpoint on PXView currentView = Base.Answers.View; but it is never reached. //[PXViewName(Messages.ProjectAnswers)]//public TemplateAttributeList<PMProject> Answers;public virtual IEnumerable answers(){ PXView currentView = Base.Answers.View; //var view = new PXView(Base, false, myDetails.View.BqlSelect); //var startRow = PXView.StartRow; var startRow = 0; int totalRows = 0; foreach (object row in currentView.Select(PXView.Currents, PXView.Parameters, PXView.Searches, PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startRow, PXView.MaximumRows, ref totalRows)) { CSAttributeGroup a

Has anyone encountered a Shopify order with the SHOP_CASH payment method yet?We received a handful of orders on one of our Shopify Stores where customers have redeemed Shop Cash (Shopify’s points system) to pay for a portion of their order.  In the Shopify documentation it states that you cannot opt out of accepting Shop Cash without disabling the Shop App for the store. The Process Data action for the order fails with the following error, indicating that the new Store Payment Method needs to be mapped in the store settings - which is straightforward enough:“The payment could not be imported because the combination of the SHOP_CASH store payment method and the  store order payment method is not mapped to an ERP payment method for the USD currency or the mapping is inactive in the store settings.”The big question is, what type of ERP payment method should this be configured to?  Can it just be mapped to the same payment method as the primary SHOPIFY_PAYMENTS method, is it a new Payment

Hi All, does anyone have an example how to add the Step numbers in a Production ticket from the BOMThanks

I have an interesting scenario, and I’m not sure if there is a broader need for this, so I’m not posting it as an idea. We have different types of customers, i.e. Wholesale, Retail, Online Marketplace.When we buy stock items, we estimate how much each type will sell over the period we’re buying for. We want to be able to restrict the amount they are allowed to sell before replenishing their stock level. Example, we buy 300 of an item monthly, the estimation is that each division (type of customer) will sell 100 in that period. Then we get a big order from a wholesale customer that depletes the wholesale stock and some of the other stock. Now our retail locations won’t have enough, and it hurts their sales numbers. We’re currently developing a custom solution for this but would love to hear what others think. Having different items in Acumatica, or hard allocating for a specific customer, or having different virtual warehouses won’t work for us, as it would greatly impact our warehouse

My company uploaded stock items into warehouse A. After a little bit of time we decided to make a warehouse B and transfer those stock items into that warehouse. Now I’m finding those stock items still hold a line in the Warehouse A’s Storage Details by Item Warehouse Location GI. How do I remove these records from the old warehouse location details?

Hello,Trying to deactivate a warehouse and it gives us the Unreleased Transaction error.  Can’t seem to find any transactions related to this warehouse.  any ideas?  Thanks in advance! 

Hello All,Does anyone know how Acumatica differenciate if an attachment is uploaded from "Files" or "Image" section of the Expense Receipt?If we upload a jpg from “Upload Image” of the Expense Receipt Screen, the platform shows the “Image Preview” but if we attach the same file from the “Files” on top of the screen it is not previewed.I checked UploadFile, UploadFileRevision and NoteDoc and both of the records are Identical except to their FileID that of course should be a Unique Indentifier anyways.I also checked the EPExpenseClaimDetails and couldn’t find a possible reference to the File which is uploaded using the “Upload Image”. All I can find in the graph, its extensions or the page is a “PXImageUploader” in the page nothing else.Any help is appreciated.