Discussion Forums

...or perhaps I’m not using it properly. I’m experimenting with TimeStamp to understand Acumatica’s locking better.I’ve created the following code, a simple button call the press save.public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>{ public static bool IsActive() => true; public PXAction<SOOrder> CheatSave; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Cheat Save")] protected void cheatSave() { var a = Base.TimeStamp; Base.SelectTimeStamp(); var b = Base.TimeStamp; Base.Actions.PressSave(); }}The button appears on the main menu. When I go to an existing order, update the Description and press ‘CHEAT SAVE’ it works, the chan

We have projects where we charge professional fees at an hourly rate and others that are billed on a flat rate basis.We are in the process of configuring an administration fee applicable to professional fees. For hourly rate projects we added an administration fee percentage directly in the billing rule calculation formula, and it works.On the other hand, we cannot do the same for fixed-price projects, the billing rule doesn’t allow access to the calculation formula. Is there another way to apply an administration fee to progress billing?

We have just upgraded from 2023R1 to 2024R1.When shipping an order in 2023R1 we followed this process while in the @Pack mode.Scan the Shipment Number Scan the Container Size Scan the barcode for each item Scan the Confirm Shipment The shipping label printed.In 2024R1 we are now having to use the following processScan the Shipment Number Scan the Container Size Scan the barcode for each item Scan Confirm Package Scan or click OK Scan the Confirm Shipment The shipping label printed.Is there a setting or way to bypass the Confirm Package and OK scans?While it only two extra steps it does add time and when shipping a large number of packages that time adds up and could lead to orders not being shipped in time.Thank

Hey folks,Question when going-live and transitioning to Acumatica.  I was testing a few scenarios where I have Shopify orders that are fulfilled/pending payment (not archived).  These orders will be associated to a legacy system order that was already shipped and invoiced.   On conversion we will bring over inventory/qoh and our GL balances, including any open AR.In my test I found the following:    It looks like it bring this order over with an open qty that needs to be fulfilled, the SO In ‘open’ status.  Since our beginning inventory and AR will already account for this, what is the protocol here to make sure we do not relieve inventory of another product (since it has already shipped in legacy). When the payment is received in Shopify it will close and ARCHIVE the order, however it does seem to still bring the payment in, but it brings it in as a prepayment (is this because the SO hasn’t ‘shipped’ in ACU?). 

I listened to the Virtual launch event for 2024 R2 yesterday (10/2/24). I attended one of the breakout sessions and was informed that the other breakout sessions were being recorded and would be made available. How do I get those?

Hello,We are trying to identify stock items where the QTY available has changed since xx/xx/xxxx date.  This would be run periodically to support something they are attempting to do.  I thought InSiteStatus was the ticket, but they did an inventory receipt (it was released) and the date indicated did not change.  Any suggestions on how I can get the date the available QTY of a stock item has changed.   

I have imported transactions from multiple tenants. Unfortunately there are about 8 batches that are out of balance. I do not understand why they are out of balance. I would appreciate assistance on this: Does nayone have any ideas on this?

Is there a reason to use Movement Classes with ABC Codes when setting up inventory counts?  Or do you use one or the other? 

 Hi, What’s endpoint version for Acumatica 2024R2, is it 23.200.001 ?

What might be the purpose of having GL accounts on the Customer Class?  The fields aren’t required and seems redundant.   The posting class settings seem to override them anyway, and the options for posting class usage is limited to posting class, inventory item and warehouse.   

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 tea

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);

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, w

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:

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

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?

Hello, I am trying to extend my endpoint to include the AttributeValue0 data fiend in the MatrixInventoryItem data class. I am doing this to try to pull the default column attribute value for the matrix item. However, Acumatica says that the endpoint is not mapped correctly. How would I correct this, or alternatively, is there a workaround for this? Thanks!

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)