Discussion Forums

Acumatica has a feature to create Attributes,  Attributes can be used for both Screen UDF and as Attributes within an entity; ( like Customer Attributes, Item Attribute, Project Attributes). There is a limitation that an Attribute with a Selector type ( ie Sales person ), is not available to the Attributes within an entity either using Customer Class, Project Attributes).  I do not agree with this limitation.  ( See Acumatica Case 404426) .So, the choice is to create a Combo Box Attribute, that is available to the entity attributes; however the client needs to maintain two screens for the same concept ( sales person profile and sales person combo box attribute).  or have to spend customization dollars to synch this up.  The goal is to use more no code.  Alternate 2 - is to create the Selector Attribute, assign it as a Screen UDF; but screen UDF do not copy from Project Quote to Project),  again I will need to use a customization project to accomplish. (no code vs code).    A simple sol

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.  

I have recently started using the physical inventory module and tried using the “by movement class” as the generation method.    When I prepare a physical count using a high volume movement class, I would expect that all of the items would be high volume items, but was surprised that some of the are stock that we dont sell much and therefore dont stock much.   Just wondering what type of generation method others are using and why you prefer that one?  

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. 

I’m trying to build a GI that shows me Labor entries by Employee ID but that links back to the Clock Entry so I can see when the clock entry was made, not when the labor transaction was created/approved. I can’t figure out how to get that link working. Does anyone have any ideas?

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,

 Hi all,I have a question regarding the Project (PM301000) billing.For the progressive income of a task at the beginning of the project, we enter a Original budget, for example 100K, at 0% completion. For simplification purposes: we do not have a Change order so Revised Budget = Original Budget.Now, We invoice 80% completion, so 80K invoice :Someone makes a Sale Order on the side, on the task in question of 30K and invoices it.ImageIf the project manager returns to the Project (PM301000), in the Budget Income tab, he will see this:Actual amount = 110K, it's ok, we understand that there was the sale order of 30K invoiced in addition to the Progressive.Now the project manager wants to invoice 90%, he sets Completion of the progressive task to 90%, which would logically give an invoice of 10K. On the other hand, the system calculates a credit of 20K, which is not logical.And it is the same principle if we create revenu on this task with another source than a sales orderAm I missing someth

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? 

We are looking to modify a Subcontract (add additional lines), and we typically do this by placing the Subcontract on “Hold”, modify, Save.  However, the “Hold” option is not available/greyed out for a specific subcontract.A bit of brief research indicates that Commitments with a Change Order are not able to be placed on Hold.  Is this true for Subcontracts?  If so, how would we modify a Subcontract to add lines that were not in the original Subcontract?  

We have an RMA Authorization form which needs to have an additional text box added. If there is room on page one, show the text box, if no room, then the text box would show on any subsequent pages but only on the last page.