Solved

I have 2 Inventory PI Count sheets stuck in the Physical Inventory Locked Items. How do I release them please?Any advice much appreciated, thank you. Can I delete them?

Good morning all, I recently did a local installation for Acumatica (version 2022.205.103.4522) and all the functionality is working fine, however when I tried to publish a customisation package, it fails with the following:  When I opened it in Visual Studio (2022 and 2019) I get this error:..\..\licenses.licx: Could not transform licenses file into a binary resource.  Index (zero based) must be greater than or equal to zero and less than the size of the argument list.    As anyone else experienced this, or found a solution around this?Thanks

Has anyone created an approval workflow for issuing inventory adjustments? Our controller was wondering if this was a possibility. Thanks, Jonathan

Hi All,How can I remove the repeating sub-headings on this report when I export it to excel, please? The report is “Historical Inventory Balance” 

We have experienced a situation which created a huge issue for our Acumatica production data:A lot of import scenarios (128), but not all,  were triggered to run at an unexpected time. Most of these import scenarios were not set up to be run by the scheduler. We only had 6 import scenarios that were scheduled to run regularly.There was randomness in terms of how many import scenarios were run (we do not understand why some scenarios ran and others did not run), and also randomness in terms of when the import scenarios ran (no scheduler ran at that particular time).After investigation by Support it was determined that one faulty scheduler, which did not  have a condition, (pic 2) created this situation.The faulty scheduler was created by using the regular way (pic 1) of creating the scheduler from an import scenario. We do not believe that we deleted the condition after creating the scheduler. Pic 1 pic 2 pic 3After resolving the data issue, we tried to mitigate future occurrences of th

Good day all. I am trying to import Inventory Receipts. Whilst the import went correctly, I am getting an error when trying to release. Here is the trace. Can anyone help me urgently please? 

Hi All,I am setting up a map with the following:Level 1: The employee is from the Department PR. When creating an Employee Time Card, it needs to be approved by the Group Project Admin Level 2: After Level 1 is approved, Group DM will be approved as Level 2 Level 3: After Level 2 is approved, Group Management will be approved as Level 3 Company Tree Setup With the current setup, I got issues as explained:If Approver Level 2 belongs to only Group DM, they can't open the Time Card If Approver Level 2 belongs to Group DM and Group Project, they can open the Time Card. However, they can approve a Time Card with the skip on Level 1This is quite similar to creating a multistage approval with instructions on  Acumatica. However, this document is out of date and can't be applied to my current version 23R1.Hope you all can help!Thank youYên Chi

Hello all,I have been trying to display a range of columns in balance sheet. So the starting period is fixed - July 2023 whereas the end period is not fixed. It can be either Jun 2024 or greater than that. So how can I setup the report so the number of columns are displayed based on the selection of the end period. below is the design of the balance sheet.balance sheet will have the multiple columns of periods 

Hi,I want to trigger Sales Order remove hold action via REST API.End point : Posthttps://globalrubberindustrieslimited.acumatica.com/entity/SFEndPoint/22.200.001/SalesOrder/ReleaseFromHold{ "entity": { "OrderNbr": { "value": "SO000896" } }}But when request is triggered it shows an error.But , This So is already created.Can anyone help for this

Can an employee record that was deleted be recovered?  I deleted employee (0000709) because there was a duplicate.  But I actually need to use id 0000709 for an employee.  However, if I try to set an employee ID to 0000709 now it gives the following error.  I figured if I could recover the deleted record, then I can simply update the other information for that record.  What's the work around here?

when selecting employee employee rate is not comming on labor rateset the employee rate in labor rate screen.what am i missing out .

I have a csv file that I am using for a GL transaction import scenario. The debit and credit amounts are in one column, debits positive number, credits negative numbers.  How can I get the import scenario to populate the debit and credit fields properly?thanks, coleen

Hi,Does anyone know how to reset line number to 1 in PO641000? The number in my report is starting with number 5 because the previous records were deleted. How do I reset it to 1?The report is currently starting from 5In the system, the previous records before 5 were deleted. 

I have a dac extension of SOLine in which i have few fields. . Below is the code of DAC extension with two fields only but there are more similar fields.    [Serializable]    [PXCacheName("TSSOLineExt")]    public sealed class TSSOLineExt : PXCacheExtension<SOLine>    {       #region UsrOriginalEquipmentNbr[PXDBString(15, IsUnicode = true, InputMask = "")][PXSelector(typeof(TSRentalFleet.refNbr))][PXUIField(DisplayName = "Original Equipment Nbr")]public string UsrOriginalEquipmentNbr { get; set; }public abstract class usrOriginalEquipmentNbr : PX.Data.BQL.BqlString.Field<usrOriginalEquipmentNbr> { }#endregion#region UsrOriginalInventoryID[StockItem(DisplayName = "Original Inventory ID")]public Int32? UsrOriginalInventoryID { get; set; }public abstract class usrOriginalInventoryID : PX.Data.BQL.BqlInt.Field<usrOriginalInventoryID> { }#endregion}Now I have to hide this field when SOOrder.OrderType = ‘HC’ or ‘QT’. For WorkOrder it will be visible. These order types are c

Hi guys, I have been having an issue with an entry screen for a custom screen i developed. I have added the screen and on its own it works exactly as intended, however I have made a GI to replace it as an entry screen, I can access the screen through the GI itself. However, as soon as i tick the ‘Replace entry screen with this inquiry in the menu’ tickbox, I get the error ‘Object reference not set to an instance of an object.I have attached the code for the graph and the DACs which are used in the screen.Has this happened to anyone before/does anyone know why this could be happening? Thanks,Aleks

I need help reversing a time and material invoice which has an incorrect date.   When I go to the ProForma invoice to do a correction, it is telling me “You cannot make corrections to the pro forma invoice because it has at least one time and material line”.  All lines are time and material.  How do I reverse this invoice, is there another way?  I have looked everywhere for an answer, please help. 

How do we fix the error: "EP Error: User must be an Employee to use current screen."  The User IS an employee, so I am confused.  Thank you. 

I’ve encountered a weird formatting issue with Report Designer. Preview looks fine, but after printing to PDF, all I’s, some lowercase L’s, and periods appear bold and strangely formatted. Sample below:   If I switch report from HTML to PDF default, the problem disappears. But, the logo looks terrible, so I need a solution that allows printing from the default HTML view. Anyone have an idea? Thanks

For an integration, we are triggering a API by the InventoryItem_RowPersisted event handler when creating a NonStock item in Acumatica. By the response JSON some essential statuses are saved and maintained in custom fields as shown in the below diagram.After creating a NonStock item and when clicking the save button these two custom fields get updated. But right after the screen refreshes or closes the screen the values get lost without saving the updated values of this custom fields. I have already inserted a explicit save, but it seems to be not functioning as expected. Here with I'm attaching essential segments of the NonStockItemMaint graph. If you guys can provide any guidance in this regard, I would greatly appreciate it. Thank you. For explicit saving i tried this “                        // Mark the extension fields as updated                        PXCache caches = Base.Caches[typeof(InventoryItem)];                        caches.Update(row);                        caches.Pers

Hi Team,We have a scenario where we need to update a column of a table across all the tenants during publishing of the package from any of the Tenant.Is it possible to Achieve this? if yes can you please share us the code sample.Thanks in Advance.

We are setting up and testing the “Calculate Replenishment Parameters” for certain items.  Not sure if we have missed some setting(s) in the Replenishment tab as the “Calculate Replenishment Parameters” process failed with a  message “IN Error:  InternalError: Sequence’s sorting order is wrong or it’s not sorted”.Any suggestions would be really appreciated as this is our first time setup and try the Calculate Replenishment Parameters.  Please find attached the settings on the Replenishment Tab in one of the item, and also the Calculate Replenishment Parameters errors when we run the process.  Thanks...

We are running our first PI and received this warning Unfreezing stock when a PI process is not completed may cause discrepancy in cost or quantity of stock items and inability to release PI adjustments.If we proceed, will we run into issues? 

I’m in build 2024R1 testing out Manufacturing module and trying to setup work flows for my organization, and I’ve run into what I see as a bug - the replenishment in the Inventory Planning Display seems to be triggering from On Hand and not from Hard Available. This feels like a bug to me - does calculating from on hand and not hard available provide value for anyone? Here’s an example of where things can go wrong: You have 30 items on hand, but in shipping status, and so 0 hard quantity available. Your safety stock is set to 10, but it won't trigger, because you have 30 units 'on hand' even though they're in shipping status (or they might have already shipped and not yet been invoiced). So let’s say I have a process to repull inventory demand part way through the day. If I have 500 orders that are moving through shipping, and those orders have reduced my hard available inventory completely on a number of items, those items won’t show up in my inventory planning display to replenish, s

I am trying to bring over the Customer from the Sales Order through the Purchase Order Details by Inventory Item Report. I can see that the SO Demand section is pulling the Data through on the SOLineSplit3 table and I have attempted to join the tables together with the settings shown in the picture but it just prints out blank. does anyone know how I should be Joining these two tables together to get that Customer ID as a Field I can add?

Hi,A client is having an issue where purchase receipts have been created for a purchase order, and it is fully receipted, but the purchase order is not able to be closed as it is still thinking it needs to be receipted, as shown in the image below.I was thinking a way to close this purchase order would be to publish a custom sql script, and then remove this customisation after the script has run successfully. However, I am not sure how to update the status field via SQL. The dropdown values for the Status field show that the Closed option has a value of ‘C’, so would I set the status to ‘C’ or ‘Closed’ in the SQL query?Let me know if I can clarify anything.Kind regards,Andrew Enter PO Receipt button still showing despite order being fully receipted and billed After the Enter PO Receipt button was clicked