Solved

I need to clarify a few points regarding the modification of an existing Bill:Is it possible to update the VendorRef field in an existing Bill? Is it possible to update the ‘Approved for payment’ checkbox in the Financials tab of an existing Bill? Can we change the status of an existing Bill via a REST request? The initial status may vary; what restrictions could there be ?

I have a question why it is not displaying the data of RefNBR

i am able to create check before one month but now i cant able to create checki have posted this data {"CuryOrigDocAmt":{"value":0},"CashAccount":{"value":"10060"},"Type":{"value":"Check"},"Vendor":{"value":"V001097"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":10.19},"PaymentMethod":{"value":"CREDITCARD"},"Details":[{"CashAccount":{"value":"10060"},"PostPeriod":{"value":"102024"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":10.19},"Balance":{"value":10.19},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"001301"}}],"PostPeriod":{"value":"102024"}}and my endpoint https://localhost//entity/acumaticalocal/1.0.3/Check

Hi I have a custom checkbox created in the Stock Items screen under the manufacturing screen, when this is checked I need the "Allow Preassigning Lot/Serial Numbers" to be automatically checked as well in the Production Order Maintenance screen. My code works but when the event handler is triggered it clears out the other header fields such as the Inventory ID. How can I fix this?Custom Checkbox FieldEvent Handler to be Applied to this Checkboxusing PX.Objects.Common.Scopes;using PX.Objects.PM;using IQtyAllocated = PX.Objects.IN.Overrides.INDocumentRelease.IQtyAllocated;using LocationStatus = PX.Objects.IN.Overrides.INDocumentRelease.LocationStatus;using LotSerialStatus = PX.Objects.IN.Overrides.INDocumentRelease.LotSerialStatus;using SiteLotSerial = PX.Objects.IN.Overrides.INDocumentRelease.SiteLotSerial;using SiteStatus = PX.Objects.IN.Overrides.INDocumentRelease.SiteStatus;using System;using PX.Data;using PX.Objects.IN;using PX.Objects.CS;using System.Collections;using System.Collec

We are going live with Acumatica and in the process of loading Closed Invoices for Historical Data load.We have migration mode ON. All our financial periods are closed and only 10-2024 is Open.When we import Jan-24 invoices, Post Period is defaulted to 01-2024 and the import scenario throws error that The 01-2024 financial period is closed. We hard coded post period in the Import Scenario to 10-2024 and still the same error. Acumatica is defaulting Post period to be same as Invoice Date. Are we missing a setting? We do not want to Open the financial periods.  

I would like the value to display as a currency with 0 decimal places and comma separators.However, when I used a formula like CInt(x), it still showed 1,111.00, so I would like it displayed as 1,111. I also created a new field decimal type (19,0) and selected it in the schema field, it still showed the same like1,111.00. Is there any suggestion? Thanks!

I am trying to update my references from Acumatica endpoint version 20.200.001 to 22.200.001 because only the later version contains mappings for Invoice line detail field Tax Category.Current ReferenceBut when I update these references to Acumatica.Default_22.200.001 (updated all versions to latest version 5.3) I get this error for the namespace using Acumatica.Auth.Api; which worked perfectly fine before.Reference ErrorError CS0234 The type or namespace name 'Auth' does not exist in the namespace 'Acumatica' (are you missing an assembly reference?) SkillInvestAPIIntegration C:\PROJECTS\MYOB\SkillInvest\CODE NOT MODIFIED\SkillInvestAPIIntegration\SkillInvestAPIIntegration\SkillInvestAPIIntegration\Rep\MYOBFunctions.cs 1 ActiveCould I please get some assistance on this, thank you!

Hi,In the Sales Orders screen, a client is wanting to search for a customer in the Customer box using the Ext Ref Nbr as well as the Customer ID, as they have migrated some customer data across from another system which could be looked up via both an ID and a reference number.I have added the Ext Ref Nbr column to the selector, as shown below, but I am unsure how to include this column in the filtering function.The code below is how I attempted to do it, but this just made the Customer selector return no results at all when you first click on the magnifying glass icon of the selector.Do you have any recommendations for how I could implement this?Let me know if I can provide any other information.Kind regards,Andrew [PXDefault][Customer( typeof(Search<BAccountR.bAccountID Where2< Where<BAccountR.acctCD, Like<Current<SOOrder.customerID>>, // Search by Customer ID Or<BAccountR.acctName, Like<Current<SOOrder.customerID>>,

How can i convert a report into GI. “Inventory Analysis”1. That Report Contains Subreport2. These Fields were displayed in the reportSubreport Contains parameter - InventoryItem.InventoryCD Please help, Thanks in Advance

An employee has a checking and savings account that is split with a regular paycheck. He received a bonus and wants the full amount to go into his checking account only. Is this possible without changing the payroll settings?

Some of my technicians have complained of some differing amounts from the Service Order to the Appointment, and it has boiled down to taxes. I’ve seen it pop up a few times, and its always a Special Tax issue.The  address was validated at the Customer level, and not overridden on either the Service Order or Appointment.Has anyone experienced this issue? Appointment, with the extra line of taxesService Order, lacking the extra tax Acumatica 2022R2 Build 23.212.0024

Hello Team,I Got Some Error during customization on Acumatica 2024 R1, the codes works fine on Acumatica 2021 R2, but when upgrading to Acumatica 2024 R1 it throw error A data corruption state has been detected here simple customization code. protected virtual void _(Events.FieldUpdated<RQRequisition,RQRequisition.vendorID> e){ if (e.NewValue != null) { int? vendorID = Convert.ToInt16(e.NewValue); foreach (var line in Base.Lines.Cache.Cached.RowCast<RQRequisitionLine>()) { var vendorPrice = GetVendorPrice(vendorID, line.InventoryID, line.SiteID, line.PromisedDate); decimal lastPrice = vendorPrice == null ? 0m : vendorPrice.SalesPrice ?? 0m; Base.Lines.Cache.SetValueExt<RQRequisitionLine.curyEstUnitCost>(line, lastPrice); Base.Lines.Cache.RaiseExceptionHandling<RQRequisitionLine.curyEstUnitCost>(line, null, null); } }} 

Hi,I would like to ask for some insight on this API request error, if there is any available work around or fix. Create Bill causes error Subaccount cannot be empty. Inserting  'AP Transactions' record raised at least one error. Please review the errors. Customization: noneversion 23R1endpoint: Default/18.200.001{    "message": "An error has occurred.",    "exceptionMessage": "Bill.Details[0].Account: Account is inactive.\nBill.Details[0].Subaccount: 'Subaccount' cannot be empty.\nInserting  'AP Transactions' record raised at least one error. Please review the errors.",    "exceptionType": "PX.Api.ContractBased.OutcomeEntityHasErrorsException",    "stackTrace": "   at PX.Api.ContractBased.EntityService.GetOperationResult(EntityImpl entity, EntityExportContextBuilder entityExportContextBuilder, PXSYTable exportedKeys, PXOuterException contextError, Boolean throwOnError, Boolean addCancelCommand) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityService.cs:line 724\r\n   at

Hello Acumatica Community,  Hope all is well. Has anyone had any luck receiving in non-stock items that require receipt through WMS? I’m using Receive and Put Away. I get that non-stock items are not tracked in inventory and there is no inventory controls but the receiving part should still be allowed to tell the AP department to bill for the item being received in.  Thank you

Hi All, I want to add a related Item to SOLine in a sales order programmatically. I tried to find a relationship between SOLine DAC and RelatedItem DAC. But I was unable to find a clue to proceed with this requirement. Any help would be much appreciated. Thanks

Hey everyone, I have looked at all of the online help regarding planning buckets and I still don’t have a good grasp as to what a planning bucket actually is and how I should set them up. Can anyone help further explain what they are for? Thanks!

Hello!Documents need to be approved is updated in the dashboard and inquiry for the dashboard is taken from the Approvals form. We want to show the project ID of the document to the dashboard but unfortunately Project ID is not in the Approvals form. Hence we create another inquiry joining Approvals form and the document but it seems not accurate. Is there any possibility to join the Approvals (EP503010) form and the Bills and Adjustments (AP301000), if so please assist me. Regards Amanda 

Is there a report that totals prepayments by purchase order?  I am only looking for amounts that have actually been paid, not in process.

Hi Community!I have created a pivot table that counts Orders and Lines per day. How can I then add a column that averages the two totals in the pivot table or is this something that can only be done using Velixo?  

Hello,On Acumatica Cloud 2024 R1I’m using the end point Default/23.200.001/Payment (also tried with Default/22.200.001/Payment) After creating a SaleOrder, I’m trying to add a Payment for it using the web service, but I’m stuck in error returning from the API with this message:{ "message": "The request is invalid.", "modelState": { "": [ "An exception occurred during input parsing" ] }}I’m not sure what is invalid, I’m using the same JSON format I used to create the sales order, here is my payment POST request: { "Type": { "value": "Payment" }, "CustomerID": { "value": "1047204" }, "ApplicationDate": { "value": "2024-10-18T11:00:51" }, "PaymentAmount": { "value": "439.22" }, "PaymentMethod": { "value": "ONLINE" }, "PaymentRef": { "value": "86561" }, "CashAccount": { "value": "11140_____" }, "AppliedToDocuments": [ { "Type": { "value": "SO" }, "ReferenceNbr": { "value": "86561" },

Hello Acumatica Community,We have developed a customization that requires storing an API Key, but we need to ensure that generic users cannot access it. Our initial approach was to save it as a password field in the database. However, we noticed that this method still allows the key to be read as base64 from snapshot files, which can then be converted back to the actual key.Our customers are mostly using SaaS instances from Haufe, so we're unable to modify snapshot configuration files directly. Therefore, we're looking for solutions to either:Hide or secure the key in a way that prevents it from being exposed via snapshots, or Exclude the custom table that stores the key from being included in snapshots through a customization project.If these options aren't feasible, is there a way to manage the key externally or implement a similar secure solution like dynamic encription?Any suggestions or insights would be greatly appreciated. Thank you!

Is there a way to configure the system or the web browser which allows you to preview/ view attachments, without downloading them?  If I just want to reference them, I don’t necessarily need to download them.

hi, All. We have one screen name bank deposits. I am trying to put data in ths screen using API. I have extended the endpoint and add this screen in webservices. But when I am calling put method it returns an error.Can any one please guide me on this 

We have a customer in the medical manufacturing field. They need to transfer approximately 12 years of transactional data to Acumatica from a legacy system. We know this is not the norm - but being in the medical industry they need to be able to track any medical equipment manufactured by lot number sold to their customers. Backward and forward tracking.What would be the best approach to import this data? Anyone with similar requirements?

Recently our Acumatica site was down for a full day of work. We are service based and have techs out in the field all day. With the site down we were unable to access appointments and eventually we had to send all techs home.This triggered us to realize we need a Disaster Recovery Plan. I wanted to see what others have done to make sure you can still function if your Acumatica site goes down?