Discussion Forums

This one is pretty open ended, so please feel free to share. No issue is too small.

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 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 benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. Aleks Iwan - Acumatica Community Featured Member for September 2024Meet Aleks Iwan our Acumatica Community Featured Member for September 2024. It’s great to have you as part of the Acumatica Community @aiwan! What you may have missed in the Acumatica Community! August, 2024 Hot Tips, Known Issues and BlogsHow to resolve th

We are trying to make a weekly report containing multiple unrelated data. Currently, we want to bring in cases as a subreport to a inventory report. Is this even possible? It seems like subreports need to connect via a related table. Is it possible to bring in a subreport completely unrelated to the main file?

I have been asked to produce a form that prints the total of a collection variable on page 1 of the form, page 1 of the form will print detail lines 1 - 10, then text boxes for collection variable total, form verbiage and signature boxes. Page 2, 3 … will print detail lines of the SOShipLine with the collection variable calculated with each line.  I thought this could be accomplished with the WhileRead on the collection variable and WhilePrint on the detail sections.   I have placed a visibility expression on the detail section to print the required text boxes at bottom of page one, but this section prints for every detail line.  It appears the visibility expression isn’t working.  I haven’t been successful finding online documentation that guides the usage of ProcessOrder WhilePrint for detail sections.   

Good day,I have a user report that on his BOM he has two items that are Template items.  1. We don’t have this feature enabled.  2.  How can that happen?I checked all the logical places;  Item profile, Item Class, Item Settings.  Is this a known issue?  I have not been able to resolve it.  Is there away to change from template back to finished/regular item without having them create a new item.Any suggestions?  Your assistance is greatly appreciated.Evan

Hi all, Can you help me about my concern, I want to add the specific module from workspace in the three dots (...) option menuLike this:  and I want to add in the three dots this (DR) in Receivables - Reports   Thanks

We have two different GI’s, one called AR-OE Export which is legacy data from an old ERP, and the other one called Ar-Invoice History. Both of the GI’s have been set up the same way as far as naming the fields are concerned. What we would like to do is combine both GI’s to form one dataset and have parameters to choose year and month and turn the results into a pivot table. We’ve looked at the WYATT.ERP method and it doesn’t seem feasible in our case to pursue that line of thinking.

We are using an email template to reply to emails.In Support>Cases we locate the Case ID, go to Activities, open the email, click on REPLY ALL, SELECT TEMPLATE, Choose the template we want and click SELECT. The email template content is at the bottom of the email we are replying to instead of the top. Since upgrading to 2022 R2 there is a new option to Replace Email Contents when you apply the Template.  That wipes out the entire email which we do not want to do.What we end up doing, is copying and cutting from the bottom of the email and pasting to the top.I’ve reviewed settings for the Email Templates and don’t see anything new. Any thoughts?    

I was hoping someone may have this export/import scenario already created instead of me reinventing the wheel.I need an export scenario to export all available attributes and then an import scenario that allows me to add attributes to multiple item classes. Or if there is a way to just “add all” attributes to a selected item class? But I don’t see that readily available.

Is it possible to link the new Project screen Project Group to approval mapping for invoices and memos? We have a situation where we need to set-up a specific approval workflow for annual invoices and doing this with Attributes on the project linked to a project type does not seem possible. Having a project group could be a solution but not sure if this can link to approval mapping.  Is this possible?

Entered a Sales Order with an item marked as Configurable but the Configure tab is not active.  What are we missing?  

I am having an issue with labor recording to the incorrect subaccounts.  It appears that this has been incorrect since the latest update The labor credits for invoices started to be recording to the AD subaccount instead of the matching subaccount as the debit.  There must be a setting that was updated during the update.  Thoughts on where to look in the system to correct this?Thanks!

Hello all,I have currently run an import scenario for import Labor time for projects. So I ran this for Employee Time Activities. its status is completed but it didnt appear on the project transactions or employee time card. What is it that I am missing here? Import mapping Attaching the import xml file.

Hello,I want to accept credit card payments in my Acumatica instance using CybersourceAcumatica already support Authorize.Net, but for Cybersource I will need to create a new payment integration.What I understand is that I will need to create a new Payment Processing Center for cybersource, where the integration code will be written, then I should add payment method where its Payment Processing Center is the new Processing center I developed. The problem is that it’s not clear how we can proceed on that, so if anyone can send us any document that can guide us in this process or give some hints and tips will be much appreciated. thanks in advance.

We want to list all customers with Mailing ID “STATEMENT” and associated report ID. However, the GI only shows about 35% of the customers.How can we ensure it includes ALL our customers with the “STATEMENT” mailing setting?Here is a screenshot of my current GI setup.Thanks for your help!

Good afternoon,I use a three check paper for my refund check process for my company.We use one check template for all three of the checks.However, when I go to print the third check on the paper seems to shift up, causing the name to not fit in the envelope for mailing purposes.Any suggestions on how to correct or is it just a printing format issue on my printer?! (I have tried to alter those as well, but still the third check is shifting up).

Dear Members,I have duplicate screen of Purchase Receipt, I have different screenID but using same POOrderEntry Graph. when i add activity it open up and link to Standard PO screen. How to link to my Duplicate screen. when i click on Related Entity Edit Icon it open up Purchase Order screen instead of my Custom duplicate screen.  Thanks,Arun.

I have a project with two tasks on it. Both tasks are active. I am using REST API to mark the task as complete. I keep getting an error that says “The Complete Button is disabled”This message is misleading as the button is very much enabled on the UI.Please see screenshots. Call from PostmanComplete button on task. 

When we try to split an asset that was fully depreciated in a prior closed year/period, Acumatica tells us we cannot do this without opening up the periods all the way back to the “Last Depreciated Period” of the asset. Unfortunately opening a submodule like FA also opens the GL periods which is undesirable in this case. Considering no GL entry gets posted as the result of the split we are doing, we are not sure why Acumatica stops us from processing a split back in time to a closed period. Other than opening the FA submodule and GL periods, is there a way to accomplish splits to prior year fully depreciated assets without having to do this?

How do I allow a user to have view only access to Audit History? I have tried Acces Rights by Screen and by Role without success.

Attempting to convert a sales quote to a sales order and I’m running into a blocker when trying to call DoCreateSalesOrder saying that I need to pass in a document of type CRCreateSalesOrder.DocumentHere’s what I have so far:var quoteGraph = PXGraph.CreateInstance<QuoteMaint>();var soGraph = PXGraph.CreateInstance<SOOrderEntry>();var quote = quoteGraph.Quote.Search<CRQuote.quoteNbr>(quoteNbr, opportunityId) .RowCast<CRQuote>().First();var filter = new CreateSalesOrderFilter{ OrderType = "SO", MakeQuotePrimary = false};var filterExt = filter.GetExtension<CRCreateSalesOrderFilterExt>();filterExt.AMCopyConfigurations = true;var quoteGraphExt = quoteGraph.GetExtension<QuoteMaint.CRCreateSalesOrderExt>();quoteGraphExt.DoCreateSalesOrder(soGraph, quote, filter);Appropriate any help or insight!

Adding a parameter to the Leads (CR3010PL) GI for OwnerID which defaults to “@me” works beautifully on desktop, but on mobile the parameter selector isn’t showing (the filter is technically working, because the leads are indeed filtered). This means that on mobile there isn’t a way to display all the leads, which is why I would love to use that selector.I know that we could use a shared filter, but the request is that “All Records” be filtered by default.I followed the steps outlined in this post (https://stackoverflow.com/questions/48670213/generic-inquiry-in-acumatica-mobile-app), but unfortunately the `Filter_` container isn’t displaying on the app after a publish.Commands:update screen CR3010PL { type = FilterListScreen add container "Filter_" { placeBefore container "Result" add field "OwnerID" }}Result: add screen CR3010PL { type = FilterListScreen add container "Filter_" { add field "OwnerID" } add container "Result" { fieldsToShow = 4 listActionsToExpand =

Hello community. Working through a customization project and I am having issues locating an SO using a search in a custom processing screen. In my code below my primary DAC is SOLine. I am using values from there in a foreach statement to then load the SO in an SOOrderEntry graph. However, it is not returning the SO record. Is there a better way to go about this code? The code returns “Object reference not set to an instance of an object” on the final line below when testing.  Thanks,Adam

Is there any way to integrate Acumatica Projects with Microsoft Planner? Specifically, two-way integration of tasks in Planner and tasks in Acumatica Projects?

Scenario:I have created a report based on Backlog report - Named as Backlog report by subaccount.For one customer or subaccount data is not showing in the report.But it should show in the report because the report is capable to display the december record as well.For ex:- I have created a SO with commit date 31st december it is not showing the Backlog report by subaccount.But when i change the SO commit date as 30th december it is getting reflected but with other amount it should display proper data. Screenshots:When the Commit date change to 30th DecemberIt is showing some other data when select commit date as 30th December instead of that it should display 525,000Inside this column the formula added but it is not working