Discussion Forums

Hello all,How can I display only a second segment of subaccount (AAA-BBB) in my report?So as per the above segment I only want to display BBB in my report. Maybe I would be need to apply formatting condition? Thanks.

There is no ability to prevent the Opportunity from being created when the Baccount is on hold or any other form of restriction at this time.When a BAccount/Customer is ON HOLD we raise an Opportunity without any warning and it’s later in the process when it is realised. Could there not be a warning of the BAccount/Customer status on initial entry.

Hello everyone,  I have a custom screen with a few tabs, at least one grid on each tab.I am trying to add a action to the toolbar of one of the grids, ‘Design, Material & Cost’,  when I have my PXAction like below, which is the grid’s DAC, it appears but does nothing when run: public PXAction<NPDDesignMatlCost> CreateInventoryItem; [PXButton] [PXUIField(DisplayName = "Create Inventory")] public virtual IEnumerable createInventoryItem(PXAdapter adapter) { PXTrace.WriteInformation("Action ran"); return adapter.Get(); }When I have PXAction as the main screen DAC, it does not appear at all. My .aspx is here:<px:PXGrid runat="server" ID="CstPXGrid32" Caption="Design, Material, Cost" CaptionVisible="True" Height="250px" SkinID="DetailsInTab" Width="100%"> <Levels> <px:PXGridLevel DataMember="DesignMatlCost" > <Columns> <px:PXGridColumn Type="CheckBox" DataField="Selected" Width="60" ></px:PXGridColumn> <px:PXGri

Is it possible to print this format as it is in a report using report designer.   

Hi,I been trying to use the Process Bank Transactions (CA306000) screen via API to be used by 3rd party app, how can I make a correct call on the extended API endpoint for Process Bank Transactions? as I have tried, I cannot find any solution on how I can make it work. Web Service Endpoint  Method: POSTJSON body: {    "CashAccount": {        "value": "CA2000"    }}Error: "The record was not processed because of an error during processing of the previous record" METHOD: GETParam: $filter=CashAccount eq 'CA2000'Error:"Optimization cannot be performed.The following fields cause the error:\r\nCashAccount: View TranFilter has BQL delegate\r\n"  

Hi everyone. I am hoping that someone can help me find the cause of my issue.I am trying to setup reason code, so when an inventory item is issued to project task, it uses the subaccounts from default cost subaccount of the project task. I am following this documentation below. but so far unsuccessfully. When I set combine Sub From box to TTTTTT, it says “TTTTTT does not exist in the system”. Subaccount segment key is set to 6 characters. Could someone please point me to the right direction?Much appreciated.Best Regards

I’m looking for best practices.If our AP department receives an invoice/bill for product received but the purchase order totals and unit costs do not match what should we do?Should we be sending an mail to our purchasers and asking them to reopen purchase orders and update the unit costs? I tried that in a test enviroment and the PO updated its costs like I expected, but since the purchase receipt has already been released those costs were not updated and hence when we go to enter the AP bill the old unit costs are the numbers in the AP bill.I don’t feel like it’s reasonable to ask our AP person to adjust all the unit costs if they differ but I need to develop an SOP for our purchasing departments as well.On a related note, which “unit cost” does the stock item use for the “Last unit cost” and “Average Unit Cost” equations?

Hi,I am trying to build connection between Account and Subaccount fields. I need to retrieve all subaccounts that are linked with Account. I tried such approach : added Account and Subaccount for entity JournalTransaction and it worked However, I faced with issue that such request does not return all available subaccount for an account. For example in Bill I have 2 availbale subacounts (samahor, samalon) for Account 5001 but my request return only 1 subaccount - samahor. Hot to make it return all linked subaccounts ?

I’m currently working with the Acumatica API and noticed that some REST services typically return a totalCount field or include the total count of records as part of the metadata in their responses. However, I couldn’t find any documentation or examples indicating that Acumatica supports this feature, in fact the opposite from the links i pasted below.Specifically, I’m looking for a way to retrieve the total number of records in a dataset (e.g., total orders or customers) alongside a paginated response. I don’t see a totalCount in the response body, nor have I found any mention of it in headers like X-Total-Count.My questions are:Does Acumatica support returning the total count of records in the API response? If not, is there a recommended approach or workaround to efficiently retrieve the total count of records? Should I rely on a separate API call to count the records? Are there any best practices for handling this in Acumatica? Any insights or suggestions would be greatly appreciat

I’m trying to add the shipment page to the mobile app, by using this guide: however these steps don’t seem to be working. When I try to manage workspaces, the customization project gets an error. Without it, Shipments doesn’t appear. How can I get Shipments onto the Mobile App?Current Mobile Application 

Is it possible to publish a custom package for a specific tenant.

Hello,I’m using the Expose via OData with some generic inquires to get some data via the OData API. I need to know the total number of records. You can clearly see the total number at the bottom of the results grid but I don’t know how to get this information in the OData response.How can I get the total records for a Generic Inquiry in the OData api?

Hi all,Installing a local copy of Acumatica and it looks like I’m having a SQL login issue:Exception Details: Microsoft. Data SqlClient.SqlException: Login failed for user 'MIGNETISANDBOXS'.Are there any in depth walkthroughs you recommend for installing local copies? Thanks!I

Hi,I created a business event for a client to alert users when their project quotes have been approved. It’s working but many users will have to make edits on a regular basis and the business event triggers an e-mail again after making edits. What condition can I use to trigger the e-mail to be sent once and not after each edit. Here is my configuration: Let me know.Thank you,Frances  

Anyone see this before - For New Items - <NEW> tag plus a totally different item Description Nor New - I have not even put in a Description yet …..

Is it possible to hard allocate a part that is listed as a material requirement and marked for production on a parent production order? When the child production order is completed, we’ve had problems with a sales order getting shipped when the part was needed for the production order first (hence the link production order).  If we have a 3 production orders for 3 machines and each one requires part 123 so we create the production orders that will then be linked to parent machine jobs. We can also sell part 123 on sales orders too, so when a production order that is linked to a parent order is moved into inventory, why does does Acumatica allow a shipment for the part that was made and linked to a machine production order?

I would like to have the results of one widget update another widget on the same dashboard. I have a list of customer invoices that are grouped by customer and shows aging on one widget. I would like to be able to highlight one customer and have the list of their invoices displayed in the other widget. Is this possible?

Hello everyone,I have been trying to setup a restriction for an inventory item by branch, meaning that when a user has branch A selected during Sales Order creation, he is able to add the item to the SO, however if the user has branch B selected, the item is not shown for selection. This item is only manufactured in branch A and shipped directly to customers. The restriction is needed because we have users that enter orders to branches A and B.I have tried to do this with restriction groups, but only managed to do this with users + inventory item, which is not the case because the user that has access to the item can still include it in the SO when he is in branch B, AKA the wrong branch.Is there another way to do this that I am not seeing?Thanks,Clauber

Hi everyone,We have encountered the following issue with the generation of the testsdk wrapper class in the latest build (24.100.0139).If anyone else is experiencing the same problem, could you please provide assistance?PX.Common.PXSerializationException: 'PX.Data.PXSiteMapNode+FactoryPX.Web.Metadata.CompositeSiteMapNodeFactoryPX.Objects.WZ.PXWizardSiteMapProvider+WizardDefinitionValue cannot be null.  

How are people handling Material on Hand (stored Material) payment to a subcontractor? If I pay the subcontractor through their subcontract, it shows they completed units, which really isn’t correct.  You can override the amount box on the invoice, but I am afraid that would cause issues down the line and be cause for missed payment and confusion from subcontractors and office staff. My proposed solution is to create a change order for 0 units and LS cost.  This will show an overpayment of planned units on that line, and when we are actually paid (and stored material reduced) it will back down to zero dollars for the MOH line and positive on the actual work completed line.Any other thoughts? Thanks,Jeremy  

We have a client that has a bit of a unique product where they are mixing lots of product and creating the same product but after testing they get a new lot number. This is very similar to Super Batch in Process manufacturing. You cannot put the same product in a BOM that you are trying to put into finished goods because you cannot have a circular reference, but you can manually add the same lot/serialized item into a production order. They are looking for a solution to be able to to mix these lots of the same product, and I was trying to see if there have been any ideas out there besides doing manual adds of the lots (which may be the best option, but throwing it out there)

How I have two DatePicker StartDate and EndDateI want the StartDate to be only to start from today, past dates  selection disable I want the EndDate only be from the Future but always greater then the Start Date       #region StartDate     [PXDBDate()]     [PXUIField(DisplayName = "Start Date")]     public virtual DateTime? StartDate { get; set; }     public abstract class startDate : PX.Data.BQL.BqlDateTime.Field<startDate> { }     #endregion     #region EndDate     [PXDBDate()]     [PXUIField(DisplayName = "End Date")]     public virtual DateTime? EndDate { get; set; }     public abstract class endDate : PX.Data.BQL.BqlDateTime.Field<endDate> { }     #endregion

At least in the way we’re currently configured (on 23R1) we have the ability to receive a purchase order into an alternate warehouse; the PO Line could be written for Warehouse TX, while the item can be received into warehouse AZ.We do a number of virtual warehouses for a few reasons, but the biggest is to keep costs from potentially intermingling.  I have warehouses TX1 and TX2, and if we get a good deal for a specific customer job, we’ll purchase and receive the material for that customer into TX2, while the regular inventory is purchased and received into TX1.We have a problem with a warehouse getting complacent, not checking where the material should be received, and receiving everything into TX1 even if the PO is written for TX2.  We can transfer it back out, but it impacts average cost of those items in TX1 that we have to adjust for as well.  It would be easier if there were a setting that said that purchase receipts could only be done for PO lines for the same warehouse.

Hi,Is there any way to use the UPS Bill of Lading as a template in Acumatica Report Designer? I tried searching online but couldn’t find anything relevant.We would like to use the same layout as the UPS Bill of Lading. Is it possible to import that template into the Report Designer, or would we need to recreate the design from scratch?Thank you! Please guide 

I am Get erorr "Object reference not set to an instance of an object" when trying insert shipment,Why Like This ?This the problem trackPlease Help me Sense Thanks you