Discussion Forums

I need to print all subcontracts related to one project for an external auditor. I tried to enable mass actions into a generic inquiry to be able to print all sub contracts related to the specific projet. Unfortunately, it always print only the first sub contract. Even if I select all and select print all, there is only the first printing. I have over 200 subcontracts to print so going one by one is time consuming. Anyone can help me with this issue?  

Hello! Can a case be re-opened if its status is rejected? All of the actions are greyed out here because the case status is “reject.”   

Meet Aleks Iwan our Acumatica Community Featured Member for September 2024. It’s great to have you as part of the Acumatica Community @aiwan!Here is a little bit about Aleks:A quick backstory to me, I am 20, and my daughter turned 2 in April, safe to say I am a young dad. My fiancé and I are saving to buy a house and get married. We love walks in the countryside, beaches, and most adventurous out of all of those, cliff jumping.I started my first job out of sixth form, I believe this is the equivalent to the last two years before college/university for America, an apprenticeship with the company I work for back in October 2022. They had already been slowly bringing Acumatica in however we had not gone live yet. In April 2023, we went live and that is when my involvement with Acumatica started to skyrocket. I became the superuser for my department and organized and delivered training sessions for my team.Slowly over time, the scope of my involvement with Acumatica widened, becoming the m

Hi,looking for a way to automatically substitute on old Inventory ID with the new one when adding items to a Sales Order. We can use the Related Items to either suggest or require the change to the new item but, we’d like to be able to enter the old sku and have the system automatically change it to the new sku Similar to how the Customer Part number works on a Sales Order but, without the requirement to add the Alternate Id for every customer in the system.

 I declared a method in the SOOrderEntry graph as follows.public void UpdateSalesOrder(PXCache cache, PXFieldUpdatedEventArgs e, string blanketOrderNumber = null){ PXTrace.WriteError("Field_updated"); // Tenant selection if (PX.Data.Update.PXInstanceHelper.CurrentCompany == 3) { // Determine the appropriate SOOrder row SOOrder row = null; if (!string.IsNullOrEmpty(blanketOrderNumber)) { // Fetch the specific SOOrder record matching the blanketOrderNumber row = PXSelect<SOOrder, Where<SOOrder.orderType, Equal<Required<SOOrder.orderType>>, And<SOOrder.orderNbr, Equal<Required<SOOrder.orderNbr>>>>> .Select(cache.Graph, "BL", blanketOrderNumber); if (row == null) { PXTrace.WriteError($"No SOOrder found with OrderNbr: {blanketOrderNumber} and OrderType: BL.");

Hi Team,We have a scenario regarding the consolidations of the financial statements. Appreciate if you could give your opinion regarding the scenario. There is a group of companies that contain 10 separate legal entities within the group. And the requirement from the client is to have separate financial statements for those legal entities and at the end of the month or any specific period of time, all the financial statements need to be consolidated. Also, the client needs to maintain 10 separate charts of account structures within the system. I already know we can have only one chart of account structure for all the companies within the system but i need to know whether if there is any workaround for that.  An example for the consolidation scenario is as follows. Company A has an account for record debtors as "Trade Receivable A" and then company B has an account for record debtors as "Trade Receivable B". At the end of the period, we need to consolidate these two A and B accounts int

I’m trying to select MatrixInventoryItem record inside a static process.  I have the corresponding InventoryItem which I thought I could just cast as MatrixInventoryItem but was not able to.  I have this for my BQL:MatrixInventoryItem matrixItem = PXSelect<MatrixInventoryItem, Where<MatrixInventoryItem.inventoryID, Equal<Required<MatrixInventoryItem.inventoryID>>>> .Select(itemGraph, item.InventoryID);If I debug this I see that item.InventoryID does have a value.In SQL profiler, I’m seeing this WHERE clause which returns no rows:FROM [InventoryItem] [MatrixInventoryItem]WHERE ( [MatrixInventoryItem].[CompanyID] = 2) AND [MatrixInventoryItem].[DeletedDatabaseRecord] = 0 AND (NULL = @P0) OPTION(OPTIMIZE FOR UNKNOWN)',N'@P0 int',@P0=675But expecting this, which does return the row I need:FROM [InventoryItem] [MatrixInventoryItem]WHERE ( [MatrixInventoryItem].[CompanyID] = 2) AND [MatrixInventoryItem].[DeletedDatabaseRecord] = 0 AND ([MatrixInventoryItem].[

I’m first creating a blanket sales order. Then, I create some child orders by splitting the quantity of the blanket order. After selecting one child sales order, I continue the process. During this process, after releasing the relevant POReceipt for that sales order, the 'Shipped Quantity' field of the parent blanket order gets updated. I want to capture this update.I tried using a SOLine_ShippedQty_FieldUpdated event handler in the SOOrderEntry graph, but it is not being triggered. Please check the below screen shot. Please let me know how I can detect when the 'Shipped Quantity' field is being updated.Qty.On Shipments(ShippedQty)protected void SOLine_ShippedQty_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e){ PXTrace.WriteInformation("SOLine_ShippedQty_FieldUpdated triggered");} 

Hey Crew, have been working on this or a bit but running into a snag.I have a nice little GI for backorders linking the promised date at the POline level to the item on backorder. For 95% of the time this works fine. But if i have multiple PO’s open with the same SKU the GI/Report will duplicate the SKU. This 5% is actually for the customers i want to automate a weekly report.It doesn’t seem likely that i can change the PO structure. One supplier requires a yearly standing order, other suppliers wont always fill a PO completely whilst another PO is already generated in the meantime for more stock. For both scenarios these are where suppliers are over seas and there is huge delays with sea freight and production. PO creation to completion can easily by 4 - 6 months whilst also adding new PO’s with similar products. Has anyone got a creative way around this? GI lined below.I believe the culprit is this relation 

We receive PO’s from Amazon Vendor Central to ship requested items they ordered to various US warehouses.  In order to integrate EDI in Acumatica and be able to use Amazon Vendor Central, we need to set up each US Amazon warehouse into Acumatica under the customer locations.  Just wondering if anyone has done this and how it works?

Every rep firm we work with requires Line Item details on commissions reports.  The Commission Details report isn’t at all what it is named, it’s just a list of invoice numbers.The Commission Details report is not actually a “report” (.rpx), but there is a reference to PX.Objects.AR.ARSPCommissionDocEnq.  I hope that CommissionDocEnq indicates there is an enquiry/inquiry somewhere behind the scenes. Has anyone created a project to add Line Item information to this report?

Is there a way to update the Stock Item ID associated to a BOM, without deleting and re-creating the BOM?   Thanks!

Hi,I’m trying to filter out Project Tasks via my API query but so far haven’t been able to get this to work correctly. So far, I’ve tried filtering like this:“VisibilitySettings/TimeEntries eq 'true'”and“VisibilitySettings/TimeEntries eq true” For both of these filters, I will still get back ProjectTasks whose TimeEntries Visibility settings are equal to “false”. Is this possible to do?

Is there a way to include a table that is embedded into the “Detailed Description” tab of the change order in the Change order print? (please see the attached image)

Good day i have a question regarding this because i want to create a invoice type then the referenceInvoice Type :Sales Invoice and Service InvoiceThen i want to change the number sequence depending on the Invoice typeSales InvoiceSA000000Service InvoiceSE000000Is it possibleI already created a customization project that will generate a field for invoice type ​​​​​​my problem is i dont know how will i change my number sequence when i change a invoice types is that possible?

I am setting up a QA/Testing Env. This is all on one box. Everything is installed. however the acumatica installer is coming back with no available websites. (See img)   

My company has implemented integrated for UPS, however, we find that our discount with UPS is not applying. What could be causing this glitch and how can it be fixed?Acumatica’s Integrated Shipping Cost Our Expected Rate

Does anyone know how to query for Payments with a non-zero Available Balance — curyUnappliedBalUnfortunately this field isn’t available in the DB, and the code references other fields that also don’t exist in the DB. Someone on my Accounting team asked for a GI/SQL to isolate these Payments.    

I use $expand to examine an existing Sales Order:https://sandbox.com/entity/Default/22.200.001/SalesOrder/WB/WB00162584?$expand=FinancialSettings,BillToContact,BillToAddress,ShippingSettings,ShipToAddress,ShipToContact,Details,TotalsHowever, the Details JSON doesn’t include Subaccount.  Do I need to expand something else to see it?  I want to be able to create another details line and include the Subaccount but I’m not sure what to use.

Hello all,How can I override the Print Invoice button in the SO Invoices (SO303000) screen. i tried to override the Mailing ID = SO Invoice for both Customer & Sales Order Pref  with the report ID that I want to override but it is not getting overridden.How can I get this done?

 i created GI for my subaccount first 5 line is not data contained from my system, i already checked in my segmented key values, no values found keyed-in as per my screenshot. help me, is there any wrong realtion i created that make this value appear ? 

Is there any way to restrict a user from clicking the following options based on document status?If not possible based on doc status, at least being able to restrict a user. 

Looking for what some others are doing in this area when it comes to Projects in the construction arena and rental equipment or company owned equipment. Historically we have tracked equipment (Containers, Skid Steers, Lifts, etc) by the rental company site or excel sheets. Now that we have moved into acumatica we would like to have one place to track thsi info but be able to tie it to the project in Acumatica while building out a dashboard for the staff that maintains this info. My initial thought was the equipment model in Services but that seems geared more towards equipment you are renting. Next I though maybe a something similar to the compliance model to track and be able to use that GI for a Dashboard.  Curious to get some feedback from the community on what you may be doing or ides on how we could best accomplish this in the most effective manner.

When viewing a Blanket Order in the Acumatica UI, a tab is displayed which lists the children of that blanket order. Is there any way to fetch this list of orders using the REST API?Thank you.

Good day, I have a client that has a employee on vacation, with the delegation to a other employee from 9/27/24 to 10/12/24, so right now, the reassignation should be working the rule has the checkbox turned on to allow reassignation of Approvalas,. and instead of Employees, we have Workgroup to be the approver, the employee on vacation belogs to that workgroup, but the system is not allowing us to reassing the approval on the “Reassign Delegated Activities” screen (EP503020). if you have a Employee as the approver on the rule, the system reassings everything automatically with no issues, but not with a workgroup. As anybody find a solution how to reassing the approvals of a workgroup when they are out?