Solved

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?

Hi,  I have a requirement to create a journal voucher by import scenario and via a business event. The voucher needs to be created to the end of previous month always. Example : If the business event triggers in October the voucher needs to be created to the date 31st of SeptemberCan you please help me with setting this up in the import scenario? Thank you,Dulanjana

Hey All…. I’ve used MYOB V18 desktop version for 20 years, well last week I started a new job and they are using MYOB Acumatica! HELP! 🤣So…How do I do a monthly revenue report? So i can see all the months!Also a monthly profit and loss report, showing each month.Thank you 😖🤣 

Hello,         I have a requirement to display all invoice lines and its related shiplines(the key is the shipped 0 line, which has not converted into invoice) by invoice#         I can get the data using the sql below: select* from ARTran a full join SOShipLine c on a.SOShipmentLineNbr=c.LineNbr and a.SOShipmentNbr=c.ShipmentNbrleft join SOOrderShipment b on c.ShipmentNbr=b.ShipmentNbrwhere a.RefNbr='xxxxx' or b.InvoiceNbr='xxxxx' The key here is the “or” where condition. However , when it comes to report designerI can only either group by artran.ref / arinvoice.reforgroup by soordershipment.invoicenbr either way, I would get data lost.       

Hey folksMy ultimate goal is to have the ability to DAISY CHAIN Automated Schedules (tasks) much like you can do via SQL (SMSS).  As far as I can tell the ability to daisy chain multiple tasks DOES NOT exist in Acumatica (within AUTOMATION SCHEDULE).  I have the need properly launch multiple schedules tasks that are dependent on each other.   I need to know start and end time of a given task in order to do this correctly since daisy chain is NOT an option.  How do I display FINISH time in either the AUTOMATION SCHEDULE STATUSES and AUTOMATION SCHEDULE HISTORY screens? The ability to daisy chain tasks would be great for Acumatica to have, I’ll create an idea assuming that the functionality doesn’t currently exist.  Anybody got any bright ideas on how to handle?

Hello,Client has shipping integration and 2 thermal printers configured via DeviceHub.  1 printer has FEDEX label stock and the other printer has UPS label stock.When I click Print Labels from the shipment screen, it downloads a ZPL file.Where specifically do I specify the printer for the labels so it doesn’t downoad the ZPL file?Can I specify which of the 2 printers to use depending on whether it is Fedex or UPS? Thanks!