Solved

May I ask if there is a way to change the date formats in acumatica?I tried to format DAC, CreatedDateTime (Created On)  and ResolveDateTime (Resolved On) the format only working on CreatedDatetime column but the other column Resolved On though the dates are correct but the time was always 00:00. This how I format those columnsCreatedDateTimeResolveDateTime 

Hi There,Working with 2023 R1.I am trying to run the following query through PostManhttp://AcumaticaVM/AcumaticaDemoDB/ODatav4/PX_Objects_GL_GLTran?$apply=groupby((AccountID,BranchID,LedgerID,FinPeriodID),aggregate(DebitAmt with sum as SumDebitAmt))And Acumatica is coming back with the following error:"error": {        "code": "",        "message": "An error has occurred.",        "innererror": {            "message": "Object reference not set to an instance of an object.",            "type": "System.NullReferenceException",            "stacktrace": "   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.VisitDacProperty(Type propertyType, String propertyName, SQLExpression defaultExpression)\r\n   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.VisitMember(MemberExpression expression)\r\n   at Remotion.Linq.Parsing.ThrowingExpressionVisitor.Visit(Expression expression)\r\n   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.Visit(Expression expression)\r\n   at

Hello,  When attempting to release a transfer for a Fixed asset, we are receiving this error: Any ideas on what this error could mean, or how to fix it?  Thanks!

Where to find the DAC of production orders workspace and other manufacturing features?

Hello all,I have been working on a report & i am looking to hide the decimals. So for example i have an amount of 1234.56 displaying in the report, now all I want is to round it up & display as 1235 and not display as 1235.00How can I achieve this?I have this formatting applied: 

Hello all,I have been working on a report and when I export the report into Excel, the first column of the report has a greater font than any other in the same row: Project name columnHow can I decrease the size of the “Project Name” font like that of the other columns?

Think I already know the answer to this, but is it possible to make the grid on a process screen editable? Ability to change one or two fields.  I am pretty sure this is not possible but incase someone has a way around the norm would appreciate any insight.

 Hello - Do you have any tips or tricks to make this filter field to be not required? We can make this field disabled or hidden on the customization. However how can we make it not required. Thank you! 

Is there a way to show a budget warning for the issuance of the inventory related to project? Currently we can tag a project on the issue inventory. However, since this is related to a project, a budget control should also be considered when processing the issuance. Is there any answer to this?

I have just modified a Row Set for Financial Report but the value it returns when running the report is zero. It is also not printing Code, Description, just Description.I think the account is restricted but I need to be able to overcome this. Any ideas?Does anybody have any ideas please?Thanks in advance.Barbara

In Report Designer How can I join AMEstimateItem table and SOLine table?

Since upgrading to 2023R2 the Order Description is being automatically copied to the Shipment Description. This is not desirable and causing extra work as we have to remember to remove it manually.Is there a way to customize this to disable this copy? Thanks for any help, Phil

We’re running into this annoying situation where a department that uses the Sales Order GI wants a default tab other than All Records.  I’ve created this tab 3 times and within a day someone deletes it.   I have two questions I am hoping someone knows the answer to.  Is it possible to find out who is deleting a shared filter? Is there a permission that controls if people can delete filters? 

Does anyone know why the Default Offset Account Branch is shown as a column but cannot be edited.  The Help just indicate “The branch to which the default offset account belongs.”.It makes sense to have a default branch when creating an entry type that belongs to one branch only.  Currently, the user have to remember to change the branch on the line entry.Is there any way to have an entry type defaulting to a specific branch? 

How do I see the year-end closing entry?  My balance sheet is off in January 2024 and I think the closing entry is the issue.   Thank you! 

How do I add a barcode for the Purchase Order number to the Purchase Order form?

Any developers here? Do you know the logic of Ship Via import from BigCommerce in 23R1?We have this weird scenario, where if an order has a shipping method in BC that is not mapped on the BigCommerce Stores > Shipping Methods screen, Acumatica will not throw an error on import, but will use a UPSGROUND shipping method.We used to have a formula in Sales Orders entities screen for Ship Via, like this:=iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Ground')<>-1,'UPSGROUND',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Standard')<>-1,'UPSSTD',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Early')<>-1,'UPSNDAAM',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], '2nd Day Air')<>-1,'UPS2Day',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Next Day Air')<>-1,'UPSNDA',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Express')<>-1,'UPSWWEX

Hi, A client is having trouble in the ‘Release IN Documents’ screen as they receive shown below when trying to Release a document. I have found a couple of similar questions in this forum but haven’t been able to access some of the articles mentioned in some of the answers as I seem to be denied access at the moment. For example, I am unable to access the link below which had some debugging information for this exact issue: https://community.acumatica.com/troubleshooting-242/troubleshooting-another-process-has-updated-the-inreceiptstatus-record-error-on-release-of-inventory-transactions-3774 I have also followed the steps from the question linked below related to updating the ‘Quantity Decimal Places’ field to allow for extra decimal places when releasing these documents, but that didn’t resolve the issue either.  Is it possible for me to have access to the first article linked above? If not, could you please provide some steps on how to debug this error to find what is causing the iss

Hello,I have a test tenant that has grown to 41GB. Does anyone have any experience with optimizing a tenant size. I have already deleted all old snapshots. The majority of the data are in the Note and UploadFileRevision tables. 

We have a business event that send a customer when an invoice is created.  The email is sent to the “Account” eamil address.  One customer wants a duplicate email sent to a second person in its organization.  How can we do  this?

Our specific scenario is:1. We place a Purchase Order and transmit it to our partner via EDI2. Our partner ships the product.3. Partner sends us an Invoice via EDI.4. The Invoice is entered as an AP Bill against the PO.5. We receive the inventory.We don't want to pay the bill in step 4 until we get the inventory in step 5.  We also don't want to prevent the bill from being entered because that basically eliminates the benefits of EDI. (nor do we want to put business logic in the EDI layer to not import the AP Bill) So, is there a way to configure the system such that the only items that can be paid on an AP Bill linked to a PO are those items that have been matched to a PO Receipt?

We are a company that creats our own literature type material. We are currently moving towards using projects to track our expenses for the various things we produce. With that, we also make a number non-stock items. Is it possible to add/link machine time to a project? I figured out that I can list a certain machine as an equipment and then submit an equipment time card that’s linked to a project to add the correct expense to the project. But I’m not sure if there is a better way to get the same result. Any ideas?Thanks for your help

Hello, I am trying to reverse the I/C entries on this entry: When I try to book the reversing entry, the I/C automatically reverses it, as shown below: I understand this is working as it should, but we have a one-off event we need to account for in this manner.  Does anyone have any ideas on how I can get this reversed without triggering the balancing entries? Thanks,Sarah

We have a unique process that requires frequent changes to Project Quote line items by inserting groupings of design changes (several line items, different stages of the Project Quote / Opportunity) from a 3rd party CAD Excel export. We have all the functionality and mapping working well, but the users have asked if the selection step can be customized to have Insert All Records as the initial/default mode.  I cannot locate this dialog box in the Customization Editor for this screen (PM304500).Any guidance or other suggestions is appreciated.  Thanks! 

Drop is not working for the sales order type with AR document type is no update. Is there any particular reason why its not working