Discussion Forums

Would like to print blank forms and reports to be used for ISO documentation.For instance, print a sales order confirmation form, but with no actual data on the form. I believe we’ll be printing these to PDF and blanking out the displayed values using a PDF editor. Any thoughts?

We are implementing Acumatica. We have about 100 machines grouped into 5 work centers. A typical production order is about 300 pieces and typically runs 2-4 days. The issue we are having it that as we test scheduling it is spreading the work from one production order to all 25 machines in the work center. It is there a way to keep a single production order confined to a single machine without turning the all 100 machines into individual workcenters?

Hello all,I created a few SQL views in a test environment and uploaded them to a customization project to create a new DAC. Everything went well, and I was able to access the data through a generic inquiry as intended.Moving the scripts to the production environment and creating the project there resulted in success and no issues.Now, when I select the table in the GI, it shows up, and all the fields appear under the results grid. However, when I go to actually view the inquiry, it is completely blank except for the hundreds of pages and thousands of records indicated at the bottom of the inquiry.Any insight into what is happening and potential fixes?

Hello all,I have a need to override “OnPersisted” method (actually I don’t to be called at all) in a drived class from EPApprovalList (a few level of inheritences) but no matter what I do it still gets called. First I tried to override the method itself. The override method in my custom class gets hit when I trace. In my override I just have one command which is “return” but still the code in the base class somehow gets executed (I am guessing because it is in fact an event handler so the base code is already executed when gets to the override). So I decided the remove the handler when class is initialized. I took two approaches to remove the handler. the codes seems to be executed successfuly as when I trace I do not receive any error and it seems to dp what I want but again I am not sure why still “OnPersisted” methods gets executed. Long story short how I can prevent this method from being executed. Here is the related portion of the drived class I have.using System;using System.Col

Hello Community, I am working on a project to create a sales order based off of a receipt (RMA) of a shipment. I am relatively new to Acumatica Development side and just had a few questions. I believe I have my action added and code that will create the SO document and I am ready to populate those objects, however, I am unsure on how to reference the data in the shipment record. I essentially need to copy the line items to a sales order with the transfer type. How would I reference the shipment record in the code below? Thanks in advance. I understand the code below may not be accurate, but I am mostly just noodling through this as I learn much better through doing and then fixing my mistakes as I go.  public class SOShipmentEntry_Extension : PXGraphExtension<PX.Objects.SO.SOShipmentEntry> { #region Event Handlers public PXAction<PX.Objects.SO.SOShipment> CreateTransferSO; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Create Tr

Is there a way to set a condition in Acumatica’s GI editor that will filter down to only unique results for a given field? in this case I have a report I created that pulls contacts with specific fields filled out and one of the fields in the results is the “Full Name” or Account Name; I would like to only have one result per Account name.I am doing this to try to parse out some KPI Data for management, they want to get the number of accounts that each sales rep has at least 1 Contractable Ingredient with out of a list of their total accounts in their possession. so even if there are 5 contacts with 5 ingredients we only want to see one of them for counting purposes.

Hi All, I have created a new grid screen which uses the same SOLine DAC and used views are as follows.public PXSave<SOLine> Save;public PXCancel<SOLine> Cancel;[PXFilterable]public PXSelectJoinOrderBy<SOLine,        InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>,            And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>,        LeftJoin<InventoryItem, On<SOLine.inventoryID, Equal<InventoryItem.inventoryID>>,        LeftJoin<AMProdItem, On<PX.Objects.AM.CacheExtensions.SOLineExt.aMProdOrdID, Equal<AMProdItem.prodOrdID>>,        LeftJoin<AMBomItem, On<AMProdItem.bOMID, Equal<AMBomItem.bOMID>,            And<AMProdItem.bOMRevisionID, Equal<AMBomItem.revisionID>>>,        LeftJoin<AMBomOper, On<AMBomItem.bOMID, Equal<AMBomOper.bOMID>,            And<AMBomItem.revisionID, Equal<AMBomOper.revisionID>>>>>>>>,        OrderBy<A

How can I ovveride this buttons on Transfer screen?  

I’m trying to understand the relation between SOLine and SOLineSplit. Especialy what is the logic behind setting IsAllocated true or false. If I see a record in SOLineSplit with IsAllocated true what it really says.Thank you

Hi,In one of your live instances, some of the help articles cannot be accessed. Please see the attached screenshots. Has anyone got this issue? Please help to resolve this issue.   Thanks,Charithma 

Hi,I created a graph extension for the  Inventory Adjustment window, but when I try to extend the AddInvSelBySite action, I don’t find it in the class. This class inherit from the INRegisterEntryBase class. How I can extend this action? I need to get the selected records and the quantities from  the Inventory Lookup before the system clear the cache.   Thank,EV

Hello all,I was wondering if there is a way to offset a "Purchase Recipt" against a "Purchase Return" so the “Enter AP Bill” goes away without the need to really enter AP bill? The case is it happens that users accidently enter a purchase receipt and release it but then realise something is wrong (i.e. a wrong vendor is selected). Considering the document is released then it can not be deleted so they enter a purchase return. But, considering in reality there is no invoice or credit memo and simply a user error has caused the issue the need for this offset arise. Any way out-of-the-box we can make this work?

We are running into an issue with the Construction Project End Date due to the fact that we need to make end of year journal entry updates and to do so we must activate the project again. When we mark the project as closed after making our updated journal entries, it is updating the project end date to the current date which cause issues with our Project WIP report. Is it possible to manually set the Project End Date after Completing the project so that are reports remain accurate?

Is there a report in Acumatica that lists out all BoM that a stock item is used in?

Hello - We are looking at creating an SFTP interface between Birchstreet and Acumatica. It is a pretty straight forward interface, that would be sending vendor and payment information outbound to the SFTP, for Birchstreet to pick up, and Birchstreet would be sending AP, (Bills with file attachments) to Acumatica. I know we can run import scenarios with AP Bills, and this seems pretty straight forward, but our Acumatica host SWK, quoted us at 100-150 hours of coding to get this done. This seems very high for such a simple interface. Does any other Acumatica user have an existing interface with Birchstreet?Thanks!

I have a custom screen I am using to attempt to update serial numbers in Acumatica.  When the items are received, the customer doesn’t know the actual serial number at that time.  We are autogenerating a TEMP number.I have to TRY to update about 6 tables to change the S/N.  Some of those tables have the S/N as a key field or a foreign key field, so I don’t know if I will even be able to do this.However, when they click Save, I want to completely override the Save action by overriding the Persisting method.  I do not want to even call the base method.  This is my screen:This is my code:public class SerialNumberUpdate : PXGraph<SerialNumberUpdate>{ [PXOverride] public virtual void Persist(Action baseMethod) { using (PXTransactionScope ts = new PXTransactionScope()) { baseMethod(); //MY STUFF ts.Complete(this); } //UpdWorkOrder.Cache.Persisted(false); } public PXSave<Filter> Save; public PXCancel<Filter> Cancel; public PXFilter<Filter> FilterView; public

Hello, we have a requirement to import bulk Sales Order into Acumatica, so we created a custom screen and an action button in it. Then we created a web service endpoint with the custom screen and also added action in it. We are able to create Sales Order through postman but that doesn’t returning any response.Please have a look at below code and guide in correct direction. [PXButton(CommitChanges = true)]        [PXUIField(DisplayName = "Process", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)]        public virtual IEnumerable process(PXAdapter adapter)        {            List<OrderImportFilter> list = adapter.Get<OrderImportFilter>().ToList();            if (this.Filter.Current != null)            {                if (!string.IsNullOrEmpty(this.Filter.Current.OrderData))                {                    OrderResponse responseData = JsonConvert.DeserializeObject<OrderResponse>(this.Filter.Current.OrderData);                    if (r

I have not been able to find a successful method for this yet.Wrong stock item was issued to a project/cost budget. The correct item has since been issued, but trying to remove or reverse the wrong item out of the project. I can do a receipt or adjustment back into stock on the inventory side if needed, but I am unable to determine how to reverse the issue project transaction to correct the project. Thank you,Greg

Has anyone had experience with Fusion WMS?I am getting a login error upon sign in to the fusion app on our tc21 scanners that says “Error: The request is invalid” I can sign into the acumatica app with the same account no problem and The user has all the correct Fusion and Branch access roles. I just wanted to see if there is a step im missing or anyone has had experience with the mobile app. 

I have to build a report for our phased construction project.  We want a report that will showphase  (TaskCodeID)  Hard Cost/Soft Cost  (first two digits of CostCodeID <29=HardCosts, 30=Land, 31-98=Softcosts, 99=Contingency)    Cost Code Category (first two digits of CostCodeID)        detail lines based on CostCodeID    Cost Code Category Total  Hard Cost/Soft Cost totalPhase TotalI’ve been able to create variables in the data section of my report called $HardSoft & $CostCostCat and I can get that data to display in the details section.But, I don’t seem to be able to use the variables to control my groups.Each groups section seems to also have a VARIABLES property.  Do I have to redefine the variables in in section?As you can see all of the data for these variables is already within the CostCodeID so creating ATTRIBUTES and having to input this data on every bill seems unnecessary.Any help?

There are situations where we order materials without a formal PO and wait until we have the bill in hand.  Is there a way to Quick Process (in a similar manner as SO > Shipment > Invoice) a PO so that the Purchase Receipt is created/released and the bill is created in one step?

Hi All,Build 23.212.0024This question has resulted from debugging work we’ve done related to another question here:We ran an SQL profiler to attempt to debug the above issue where a processing screen is acting differently depending on whether it is run manually by a user or run using an automated schedule.It revolves around an issue we’re finding when the query that builds the list of rows for the processing screen, Acumatica is appending different predicates to the where clause of the SQL depending on whether the it is run by a user or by an automated schedule.Specifically the BranchID fieldWhen run by a user, the SQL generated includes the following predicate:( [POReceiptLine].[BranchID] IS NULL  OR ( [POReceiptLine].[BranchID] IN ( 23, 24))However when run by an automated schedule, the predicate becomes this: [POReceiptLine].[BranchID] IS NULLThe tenant in question has two branches and POReceiptLines are being set with the relevant BranchID and not NULL.Setting the BranchID in the A

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. Megan Friesen - Acumatica Community Featured Member for July 2024Meet Megan Friesen our Acumatica Community Featured Member for July 2024. It’s great to have you as part of the Acumatica Community @meganfriesen37! Hot Tips, Known Issues and BlogsHow to set up Approvals for your custom DAC or screenHow to resolve the "Viola

Hi All,Is it possible to add a new Customer Status, to this drop down called “Legal” that behaves the same way as the “Inactive” status throughout the system? If so, how do I do it thxDries

hello,I have a scenario where we have multiple rates for lets say one employee on multiple projects. How can i setup my allocation rule that whenever an allocation transaction is ran, it takes in the rate specified for the particular project?Thanks.