Solved

I can see under the 23R1 documentation that setting the Availability of a Non-Stock item to “Set as Unavailable” is supposed to disable it and make it “not available for purchasing in the online store”: However, I can’t see that anything changes in Shopify when the Non-Stock item is Set as Unavailable; I am still able to purchase the product online.Can anyone advise what the expected behavior is for this setting and Non-Stock items in Shopify?

I am trying to upgrade a customer. I am getting an error in a few places, especially around printing reports. (From 2021 R2 to 2022 R2)I’m not sure how to debug this. The error is not tripped by my debugger. I go into Sales Quotes and try to do a “Print Quote” when I do that I get an error. I have no idea what report is being called, so I don’t know how to look at that.I tried to do an override of the PrintQuote function, so I could see what was going on inside of it but no dice. It wont permit an override. This is the source to it:public IEnumerable PrintQuote(PXAdapter adapter) { Dictionary<string, string> parameters = new Dictionary<string, string>(); string actualReportID = DefaultReportID; PXReportRequiredException ex = null; foreach (CRQuote item in adapter.Get<CRQuote>()) { Save.Press(); parameters[nameof(CRQuote.OpportunityID)] = item.OpportunityID; parameters[nameof(CRQuote.QuoteNbr)] = item.QuoteNbr; ex

Hi, We have a requirement to Track manufacturing work order material issue cost via project Module. Followings are the steps we performed.  1). Create a Project and added Labor and Material Cost budget tasks which attached with Material        and Labor accounts groups.2). Then create a Item Work order via particular project/Task and release it. 3). When issuing Items Project/Task tied with work order and will issue appropriate Project Task. System will create a Inventory and Project transactions. but those values are not showing in Balance Tab. Under the view transaction tab all are showing. 4). Labor is not capturing from Manufacturing end and using Time card. When performed the time card  or particular user those values are transferring as we expected and showing under the balance tab in  the project Form.      05). Need to know how Work Order Inventory Items are issuing to Projects and what are the workflow steps happening are there?Attached the Screenshots document.  Regards   

Hello, - When trying to generate Government Reporting in Aatrix has anyone gotten an error message generated by Acumatica that states “Input string was not in correct format”, while a larger box on the screen that appears to be generated by Aatrix states “Waiting for Payroll Data” ?   If so, would you mind sharing the solution?  It will be greatly appreciated! Thank you!

We are integrating Acumatica and BigCommerce. There are >100k of Stock item records in Acumatica. With that amount, only a subset of products will be exported in BigCommerce based on criteria provided. We noticed that as a default, Export to External is set to true. Is there a straightforward way to achieve our goal where in only the identified items based on criteria shall be exported and the rest will not?Now, what we are doing is to create a GI and make everything Export to External as false, then running an Import Scenario to explicitly set the Export to External true based on criteria given.Hoping to hear your suggestions for a more direct and elegant way on fixing this. Thank you so much :)

With the latest update I am now required to enter the “Cost Layer” column and “To Cost Layer” column for transfers to projects as either Normal or Project. I cannot imagine how requiring this field helps anyone. The cost layer was formerly IMPLIED by entering the actual origin in the Project column and the destination To Project column. It seems to me that the only thing these columns do is limit you from selecting the project you want unless you select “Project”. No one is asking for even more tedious columns per line item. I already am required to enter the task and cost code for every line, without being given the option of having a default task and project per stock item. Now I have TWO MORE columns that I didn't ask for, it just slows down entry across the board, and that’s all I can see these columns accomplishing for me.   

Where would I find information on 3 way PO matching in Acumatica?

We have a few confirmed shipments which have not generated inventory GL entries through the Update IN function. Further, when I review the shipment itself, the Update IN field is greyed out. The order type is set to Update IN on shipment confirmation, so I am not sure why the Update IN has not run for this order - additionally not sure why I am unable to run it manually through the shipment itself.FYI - The invoice associated with this order has not been released, it remains in Balanced status. 

we have a job setup with a cost code of 01-0500 Labor. When I view this cost code from Projects > Cost Budget it shows Actual Quantity of 58. However the actual amount is well beyond what 58 x our hourly rate would be.If I export all the time entry / payroll transactions that have hit that cost code, they are truly 315.5. And if I divide the ACTUAL AMOUNT / 315.5 that is accurate and correct.So my question is any idea why the cost budget would be showing only 58 hours? 

I’m trying to set up Approval Maps for AP Bills.  Certain Vendor Bills need to be approved by certain managers.  There is also a list of vendors that don’t need an approval.  My first attempt didn’t seem to work.  IBelow are the screenshots for the Step & Rules.  Any help would be appreciated!     

I have looked on the forum and haven’t found a single post or more information for “leveling” customization on the Customization Projects Screen. Is there a good way to properly level customization? What kind of approach should someone have when dealing with multiple customizations for the same screen? 

Hello, It is possible to add by default a labor item when we use the button “Completed Summary” ? 

Hi All,I am currently researching how to automatically send label files to a printer for printing.After reviewing the documentation, we found that we can utilize Acumatica Device Hub for this purpose. I would like to inquire whether Acumatica Device Hub can be installed separately on the client-side.Additionally, apart from using Device Hub, are there any other methods you would recommend for achieving automatic label printing? Thank you,Reggie

While trying to get the Inventory ID and transaction description on the pivot table, we noticed that when the fields are added to the Values section, they are displayed as numbers in the pivot table.    The fields work fine in the other sections of the table except for that particular one. Any thoughts?  

In 21R2, I had created a small customization project to handle UI tweaks. One of these was to alter the grids on GL40.40.00 and AR40.20.00 so that they would generate 200 records at a time which could be scrolled through, and the rest could be accessed via paging. I accomplished this with these settings on the grid. AdjustPageSize: ManualAllowPaging: TruePageSize: 200 After upgrading to 23R1, these settings no longer work, and AllowPaging appears to behave like a mutually exclusive switch between paging with auto page size and scrolling with manual page size. Is this just the new behavior of these settings? Are scrolling and paging not allowed simultaneously anymore?

We just upgraded to the latest acumatica version R1 2023 and the StoragePlaceStatus status table is now obsolete.   I need quantity info from table for one of our generic inquiries.  Does anyone know which table may now contain that datafield that I am looking for.  Or is there a map available somewhere of the tables?

Has anyone deployed the Service Orders management screen to the Mobile App?  Are the any code snippets available for this?

Hello everyone!, I hope someone can help me 🙂I have to change the label of a button, but I realized that it does not change the Translation Dictionary. Does anyone know another way to do it?

how do you manage old customization (delete them or keep them in Acumatica for a certain period of time before deleting) We have many customers with customizations that we no longer use, for the sake of organization my team wants to clear these old customizations from the Project Screen and delete them. Is this common practice?

Hello everybody,is it possible to restrict a certain user that he/she can only DELETE files that he/she have created herself? As of now, I know only the option to restrict a user to not delete any file (no matter who created it).Many thanks in advance!

Through web api not able get vendor order by LastModifiedDateTime.

I have few customizations. I’m wondering why my Fields and Conditions in “e2SOCostCodeAndDepartment” are not reflecting. Maybe because I have another Customization for Sales Order after that? Here’s my customization:Here’s After it: 

Is there a process to reverse and apply debit for multiple AP bills as once ?

 I still can’t write off an AR balance after I have enabled write-offs for a customer,. What suggestions do you have?   

Hello, in Sales Order GI, the customer CD and Customer Name are displayed from the SOOrder Object.Object:SOOrder and Data Field:CustomerID this gives us customer cd, but when we use same in if condition it is giving us customer DB ID. Can someone please help us. We know we can join BAccount table but can i get customer cd without joining BAccount table.=IIf([SOOrder.CustomerID] >0 , [SOOrder.CustomerID], '0') here the result is Customer DB ID