Discussion Forums

Dear Acumatica Community,We’re connected to Shopify via the connector and using Shopify Payments for website CC processing. We also accept PayPal payments online. However, when we try to add our website payments to our general ledger, the Payment Method displays as “SHOPIFYCC” for all website payments, even the PayPal payments!We want the Payment Method to display as ‘PayPal’ so we can isolate those payments for reconciliation purposes. Does anyone have a fix for this if you are using Shopify Payments online?    

Hello:Do you have idea how Can I do a transfer 2 steps with Scanner?Best regards

Hi,   Just wondering how the time filter works in Employee Time Card? Like if I want to filter 15 minutes or 2:15? It seems these filters are hardcoded? Thank you.  

We have a Call Sales Report in Report Designer that shows all of the notes/comments a sales rep has entered based on a date range. When the report is put into production and brought up as an axd the full report does not show. Clicking on the HTML also reveals that a major portion of the report is missing as the report should be several pages long, but only one page shows up. Even exporting the report as a PDF has missing parts of the report. In the Report Designer → Common Settings, PdfCompressed = TRUE, PDFFontEmbedded = TRUE, PrintAllPages = TRUE, ViewPDF = TRUE. I’ve tried using the ConvertHtmlToText = False, that cut off the headers (headers have the account number and business name for each visit) for each days entrys. CanGrow = True, CanShrink = True, CanSplit=True. Any suggestions as to how this can be fixed will be appreciated.

Hi I’ve set up ad hoc quality testing, but the system is taking the inventory out of stock.  We complete our visual tests in line, so we do not take samples out of stock. Can anyone help me tell me how I set up the ad hoc tests that it will not take the sample off the inventory? Thanks

Hi Acumatica Community,My name is Andrii Tkachenko, and I'm a Tech Lead at Sprinterra - Acumatica ISV and Development Service Provider, where I work alongside a highly skilled team of Acumatica experts. I've been developing Acumatica customizations for around six years and writing software in different languages and across various industries for over a decade.I was genuinely surprised to learn that the Acumatica Community named me one of the 2025 Acumatica MVPs - our Acumatica Program Director, Alex Mishkur, sent me a link and told me to check out the list. Seeing my name there was unexpected and, honestly, humbling.Coding and development is more than a job to me, it is my passion. It is gratifying to know that my contributions have helped fellow community members solve challenges and reach their goals.What started as a hobby - scratching my creative and problem-solving itches - has grown into a fulfilling career. Engineering solutions that eliminate manual tasks and help businesses op

anytime i  join and validate this statement it good.but when i save and try to people the sales order tab this show upi am trying to put the statement on the statuse column to get different colors.i need help?

We are applying Shipping Discount in Shopify, however, the shipping discount amount sync to Acumatica as an unpaid balance.  Does anyone know how to map the shipping discount to a field in Acumatica so that the shipping discount amount will be waived?  Thanks... 

Hello Community,I am working on a customization in Acumatica where I need to implement a new data type in Acumatica Data Provider for text files (.txt).Does anyone have experience with this or an idea of the approach? Any guidance, or documentation references would be greatly appreciated.Thank you!

Over here in Australia, Acumatica goes under the brand of MYOB Advanced. As a developer we’ve been told that MYOB are wanting to remove support for SQL Views in lieu of the new features in 2024r1 whereby GI’s can now use other GI’s as input tables. This is very useful and will go a long way to removing the need for SQL Views however… I have multiple (reasonably compex) SQL Views with corresponding DAC’s and several sub-tables. I then use the result to display data on the sales order screen. Similar to:[PXUIField(DisplayName="Auto Build Available", Enabled = false)] [PXDBScalar(typeof(Search<AutoKitAssembly.KitAssy.qtyAvail, Where<AutoKitAssembly.KitAssy.builtItemID, Equal<SOLine.inventoryID>, And<AutoKitAssembly.KitAssy.siteId, Equal<SOLine.siteID>>>>))] Where ‘AutoKitAssembly.KitAssy.qtyAvail’ is a field from a SQL View or custom table. I can now re-create the complex SQL View using the new and improved 2024 GI’s however h

Hi,Is it possible to override release action in Fixed Asset Transaction screen? For now, the standard is can release if Transaction Amt >0 , but now i want to change the function so that it can release even though Transaction Amount = 0. Is it will effect others transaction? 

When creating a sales order, if I click the magnifying glass next to the customer search box, is there a way to add a searchable field in that pop up window? We would like to be able to search by Primary Contact Name in that pop-up box.

Greetings,We are currently utilizing the Acumatica Shopify Connector to establish a connection between our Shopify Store and Acumatica (specifically Haufe X360). We have encountered an issue with PayPal Express checkouts that we are eager to resolve. As a result, we are seeking assistance and suggestions on how to address this problem.When customers opt for PayPal Express checkouts, the connector combines the street and house number into a single field. However, in Haufe, we maintain street and house number as separate entities. Therefore, we are in need of a solution to convert the incorrect data format from something like "[Sample Street 374]" to the desired format of "[Sample Street]” “[374]". Is there a feasible way to achieve this, and if so, what would be the recommended approach or is there maybe a customization project already out there in the wilds to use?Your input and guidance would be greatly appreciated.  

In Order Types preference screen, I have added a custom field as usrCompanyAcctCD. In that user will select a company for each order type. In the sales order screen, order type selector should only list down the order types which have current logged company id or null. to that I add a restrictor to Order Type as bellow. but it is not working. [PXDBString(2, IsKey = true, IsFixed = true, InputMask=">aa")][PXDefault(SOOrderTypeConstants.SalesOrder, typeof(SOSetup.defaultOrderType))] [PXSelector(typeof(Search2<SOOrderType.orderType, InnerJoin<SOOrderTypeOperation, On2<SOOrderTypeOperation.FK.OrderType, And<SOOrderTypeOperation.operation, Equal<SOOrderType.defaultOperation>>>>, Where<FeatureInstalled<FeaturesSet.inventory>.Or<SOOrderType.behavior.IsNotEqual<SOBehavior.bL>>>>))] [PXRestrictor(typeof(Where<SOOrderTypeOperation.iNDocType, NotEqual<INTranType.transfer>, Or<FeatureInstalled&

This is the use case.Stock Item   ABCBOM    ABC has 1 outside process for welding.BOM ABC containsStock Item 1,Stock Item 2,Stock Item 3StepsCreate Production order for ABC Create Purchase Order for ABC Create Vendor Shipment (this shipment should have Stock Item 1,2,&3 being shipped to outside process vendor).  but when i create the vendor shipment from the production order it only has the Stock item ABC on the shipment not the components).   The ABC item is the item i should be receiving back into inventory from the vendor.I am missing a step or have the steps being done incorrectly.  What should the proper work flow be?

Hello all,Can any one let me know if its possible to create an auto-debit/automatic withdrawal as a payment method where the vendor can automatically withdraw funds from the bank account?I believe we can implement this via direct deposit → ACH.After setting them up how can we setup the whole scenario?Thanks. 

Hi everyone I’m seeking Help to increase the decimal to 6 value  in our Order Quantity and Quantity on Receipt like in the image below in our unit cost please comment below the method we can do to change the decimal from 2 to 6 in order qty and qty. on receipts. Thank you in advance    

Hi, When using the Create PO process to create drop ship purchase orders from Sales orders that are Marked for PO what is the logic for selecting the Supplier location. Item Warehouse replenishment is configured with a “Drop-shipment” replenishment source and an Override Supplier and Override Supplier Location, but the Supplier location is not always correctly used. The supplier location can be changed in the create process but we need to automate the process. 

I can’t find a way to mass remove the hold box - does anyone know if there is a setting somewhere or any mass action to remove hold on Employee Time Activities? All we need is the time activities that sync from WFG to be completed and then can use mass action to RELEASE them in screenID EP507020  

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Congratulations to our 2025 Acumatica MVPs!At Acumatica, we’ve made this collaborative mindset our Rallying Cry: “Building the Future of Business, Together.” It means we and our customers, partners, and creators rely on each other to succeed in today’s digital and—let’s be honest—uncertain marketplace, and there are many in the Acumatica Community who elevate this collaboration to a different plane.Read the Blog Here How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members be

I have query related to having multiple company calendars with varying period start and end dates.  Centralized period management is disabled, multiple calendar support feature is enabled.  It is 2024 R1. There is 1 tenant with 2 companies. Both companies use USD as their base currency and require intercompany transactions and consolidations. Company A follows Jan-Dec. 12 periods but have period type as user defined periods as start date and end dates varies. Period 1: 1/1/2024 - 2/4/2024Period 2: 2/5/2024 - 3/3/2024And so on…Period 9: 9/2/2024 - 9/29/2024 Company B follows Sep-Aug 12 periods with period type as Month. Period 1: 9/1/2024 - 9/30/2024Period 2: 10/1/2024 - 10/31/2024And so, onPeriod 9: 5/1/2025 - 5/31/2025 I setup Financial Year as Jan-Dec.  I was able to generate Company Calendar for the first company.  But with Second company, unable to change the start and end dates as it is looking at the existing Master Calendar generated as required for company A.  How can I setup a

Site is either super slow or producing connection errors.

Hi Everyone! I’m Laura Jaffe, Partner and Senior Business Consultant at Parallel Solutions. I’ve been with Parallel Solutions since 2010, and have been working with Acumatica ERP since 2019.It’s my true pleasure to be a part of the Acumatica community. This community has been a great help to me and I’m so happy to be able to give back. For fun, I love nature and the outdoors. I enjoy hiking, biking, cross country skiing and kayaking. We don’t have mountains here in Northeast Ohio, but we do have valleys. The Cuyahoga National Recreation Area and the Cleveland Metro Parks are quite nice. I’m a big advocate of life in Northeast Ohio. That’s me on the Cleveland sign, with my family at Lake Erie. Come visit us here sometime!Some of my other hobbies include traveling, knitting (mainly hats), cooking and doing crossword puzzles.My passion throughout my career has been leveraging software to make a difference for people and companies. I especially love reporting of all sorts. Acumatica is a g

Hi, I’m want to send an e-mail with a joined report.This report accepts 2 date parameters, with default values (DateFrom & DateTo) : With a scheduled event, i trigger every month the email sending.On the joined report settings, i have to specify his parameters values In my case in want to have :DateFrom : the start of the next monthDateTo : the end of the next monthI didn’t find the right syntax for this. I also tried to not specify those parameters, but the default values of the report are not applied. Any help would be great.Thanks 

can i get step by step