Solved

while selecting order type not getting selected and the same option not open when use from Production Order Detail > More> :Lateassignment

Hello,Has anyone ever added a beginning balance on a new bank reconciliation? We have a petty cash fund which shows as a balance on the balance sheet, but I wanted to add it the reconciliation process. I added the a new bank rec for the account but does not pull in the balance as on the balance sheet. I thought to add a JE to credit the cash account with the GL $ amount, then debited the same amount to the cash account- which do show up in the rec. If I clear the credit line and leave the debit line and the ending balance is populated with the correct amount. The issue is that the other line will never clear - which I prerfer not to see each month. Any thoughts?

I think I’ve been looking at this too long. 24r1I have set ShipVia to be required through cache attached in my SOOrderEntry extension. I added Required = true to PXUIField and changed the PersistingCheck in PXDefault to NullOrBlank:[PXMergeAttributes(Method = MergeMethod.Merge)][PXUIField(DisplayName = "Ship Via", Required = true)][PXDefault(typeof(Search<Location.cCarrierID, Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>, And<Location.locationID, Equal<Current<SOOrder.customerLocationID>>, And<Current<SOOrder.behavior>, NotEqual<SOBehavior.bL>>>>>), PersistingCheck = PXPersistingCheck.NullOrBlank)]protected virtual void _(Events.CacheAttached<SOOrder.shipVia> e){ }So, in theory, I should not be able to save the record without supplying a shipvia value. But, I can click Remove Hold.Now, the record is not persisted to the database, but the order is now Off Hold.And I understand that’s because the action for

Hi,I’m a beginner with generic inquiry configuration. I’m wondering what are all the available functions similar to @me, @monthend, etc. that we can use as a value in the parameters or conditions sections and that are not presented in the “Help” section of Acumatica. Is there a full list available somewhere other than those showed in the operators/functions below?  Thanks!

Hello! Is there a way to create a GI that shows all the workspaces, categories, and the links to the screens?I was able to create one that shows the workspaces and categories, and with these DAC I couldn’t find a field that is for screen titles. Right now the GI is duplicating categories for however many screens are listed under that category. Am I missing data sources? is this information possible to pull in Acumatica?  Thank you!!

This is not so much a restriction requirement but more of a design requirement.When you have multiple companies in one tenant and you have access to all of them it would be great if the only data that you see on the screen pertains to the company that you have selected at the top.Now, you see transactions, customers, vendors for all companies irrespective of the selected company.  It does lead to mistakes and it does not demo well. Thanks 

How to assign Raw material lot number to Finished goods in the production Order.

Hello All,I am encountering the error message, 'Error: Another process has deleted the 'SOShipLineSplit' record. Your changes will be lost.' This occurs when I click the Save button on the Shipments screen after deleting a shipment line. So far, I have observed this issue with serial-tracked items and have not yet verified it with other item types.After investigation, I have discovered that this error is related to one of the declared views see below. public PXSelect<PX.Objects.SO.Table.SOShipLineSplit, Where<PX.Objects.SO.Table.SOShipLineSplit.shipmentNbr, Equal<Optional<SOShipLine.shipmentNbr>>, And<PX.Objects.SO.Table.SOShipLineSplit.lineNbr, Equal<Optional<SOShipLine.lineNbr>>>>> ShipmentSplitDetails;The PX.Objects.SO.Table.SOShipLineSplit DAC directly represents the SOShipLineSplit table from the database, without any projection attributes applied. I believe that during deletion, cascading deletions supported by the PXPare

There is a requirement to retrieve only move transactions, which can be identified by the value of AMBatch.docType. If AMBatch.docType = 'M', it indicates a move transaction. How to write it in fluent BQL?I used the following BQL query, but it contains an error. How can I correct it?.Where<AMBatch.docType.IsEqual<'M'>

The goal is to create a report and/or GI that shows overall items produced each day.I also need to report this for each employee and each machine.There are 2 tables I have identified as possible sources.-    AMMTRAN (This does not have the machine which I need)This has InventoryID, QTY, Employee IDIt has 2 dates that seem valid.  CreatedDateTime and TranDate  (which date would be appropriate to use?  What is the difference between the 2 dates?)-    AMProdItem (This does not have the machine nor the employee which I need)This has InventoryID, QTY, It has 2 dates that seem valid.  CreatedDateTime and TranDate  (which date would be appropriate to use?  What is the difference between the 2 dates?)Have I identified the correct tables?How would I be able to get the QTY produced by machine? Thanks!!!

When I try to open a Sales Order, I get the An item with the same key has already been added error.  As the New Record button works, I was sure the extensions of DACs and Graph of Sales Orders screen do not contain any problematic code. Even more, the same error message can occur when there is no any package published. Investigating the Generic Inquiry of SO3010PL, I found repetitive lines in Navigation Parameters section of NAVIGATION tab. I still wonder how the duplicate lines could be added because when I try to add a record manually I get the The value of this field must be unique among all records. error. I decided to remove the repetitive lines. After that deletion, the SO3010PL GI allowed me to open the Sales Order Document via Order Nbr. field.

The situation is there are inventory Status and processes that need to run Monday-Friday several times per day and between 7am and 7pm. They do not need to run overnight or on weekends, Other than setting up weekly schedules for each time and activity (roughly 160 to go that route) is there a way to have the daily controlled like the weekly for days of the week. Has anyone tackled this  ?

We recently upgraded to 2024 r1 and noticed that our production orders were not being created.  In the logs the request to entity/Manufacturing/21.200.001/CreateProductionOrder/CreateProductionOrderProcessAll now returns a 204 status code when the sales order is on hold.  If the sales order is not on hold the status code is a 202 and the production order is created.  Before the upgrade from 2023 R1 the requests always returned a 202 when the sales order was on holdA 204 indicates that the request was successful and the production order will be created.  If there is an issue creating the production order the status code should be a 40X code.  The API behavior should not changed on a published version.

When attempting the Reverse Disposal action in the Fixed Asset module I encountered an error.  Acumatica will not post to a Control Account when creating the reversal disposal transaction.  Is there something I am missing in the setup? 2022 R122.120.0019 Error EncounteredAllow Manual Entry is OFF for the Account we would like to keep it this wayThe original Disposal We are currently using a work around where we enable manual posting, process the reversal of the disposal and then disable manual posting.  

Getting an invalid type when importing a customization project. It seem like some of my customization transfers over such as database scripts but my graph extensions and other files from extension project aren’t being imported.  

Hello,When I go to shop for rates, I am receiving this error -Autopackaging for UPS resulted in zero packages. Please check your settings. Make sure that boxes used for packing are configured for a carrier.CarrierRequest.Packages must contain at least one package. I have autopackaging turned off in the features, and I have created a package on the shipment. All ship vias have the packages. What could be causing this?

Is thre a way to add more details that will be printed on subcontracts? Or is the line description field the only space? Other softwares I’ve used include a scope of work summary that will print before the individual subcontract lines, as well as having specific fields where inclusions or exclusions can be specified. At the moment the character limit and lack of formatting available for the line description field is way too limited to enter all the necessary information for a subcontract. Note I am currently on 2023 R2 Thanks in advance!  

We have several text UDFs and are wanting to preview data, that is longer than the width of the field, by hovering over the field. The functionality exists in out of the box fields, so can this be extended to UDFs? With the character limit on UDFs being a lot longer than the width of the field, it isn’t very user friendly to have to use the cursor/arrows in order to read the data in full. 

A debit memo was entered in the system when it should not have been I was able to remove the invoices and attach them to the correct payment.  But now I have an Open Debit memo.  Is the best way to fix this is by doing a Credit Adj to clear this payment out?  

Hi Everyone,Whenever we select the Export action in the Payment Batches, receiving an error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index".Build VersionThanks

I am migrating a 2023 project from another developer to get it to work in 2024.Due to the requirements for this customization, the previous developer made a complete copy of the CreateShipment action and injected some changes to add logic to the action.The code in this action has changed from 2023.To start with, I “re-copied” the Acumatica source code for the action.  I have not injected any changes into the override at this time.  The signature of the action did not change from 2023 to 2024.When I attempt to Create Shipment from Sales Order Entry, I get this error message:At this point, I simply have an overridden action with no changes to the base code other than to put “Base.” in front of the various objects that need to reference the base graph.When I am in debug mode, I cannot hit a breakpoint at the very beginning of this code. public delegate IEnumerable CreateShipmentDelegate(PXAdapter adapter, [PXDate] DateTime? shipDate, [PXInt] int? siteID,

My custom field isn’t persisting to the database here: I’ve checked both the bAccount and customergroupid and neither of them are null. This is inside a method that gets called in a persist override.   

We are having issues in a project where we released retainage and then went and printed out an AIA report for this by running the project billing. What we are seeing is that the released retainage is getting applied to the invoice but not specifically on the line that was released. What we are seeing is that the released retainage was distributed across all lines that had retainage. How can we change this so that released retainage applies to the lines we are releasing from? 

I have created a button on the Process Order page What I want is that when I click the Demo Processing button, the Processing dialog should be displayed. To be able to control whether the insert Order was successful or not. Function GenerateNewLineItems will work on insert item in OrderLine.function GenerateNewLineItems.using System;using System.Collections;using System.Collections.Generic;using PX.CloudServices.DAC;using PX.Data;using PX.Objects.CN.Subcontracts.AP.CacheExtensions;using PX.Objects.SO;public class SOCreateShipment_Extension : PXGraphExtension<PX.Objects.SO.SOCreateShipment>{    public PXAction<SOOrderFilter> DemoProcessing;    [PXButton(CommitChanges = true)]    [PXUIField(DisplayName = "Demo Processing")]    protected void demoProcessing()    {        SOOrderFilter filter = Base.Filter.Current;        if (filter == null)        {            throw new PXException("Filter cannot be null");        }        PXLongOperation.StartOperation(Base, () =>        {

Hello! :) Does Acumatica have anything to streamline entry of deposits from scanned checks?  I'm looking for something similar to the inbound documents feature on the AP side.  Thank you!