Discussion Forums

While  Creating invoices for Service order   with 2 Non Stock Items both assigned to same Posting Class , But while releasing the Invoice One Item is taking  with GL Account mentioned in Posting Class and another one is taking from Item level GL Account . The Sales Sub Account mentioned in Ordertype is  to take from Branch - C , but its pulling from posting class the default sub Account  other than to the revenue posting . Kindly advise 

We have a client who needs to depreciate their assets (Land/Property) for a FULL year at a time every year.  So they may have some assets that depreciate over 5, 10 or 50 years, but they only want the full amount of depreciation for the year on the last day, NOT monthly.We thought we could define a depreciation method for the year, but then it wants to depreciate the first full year on the day you enter it and then the next year it will still calculate monthly.They could do this in their old system, so perhaps I’m just missing something?How can I define the depreciation method for them accurately and have it only post annually on the last day of the year? 

I am looking for an Acumatica out of the box Inventory Usage report that will allow our organization to understand our usage of inventory to help us update our min., max, and safety stock levels. I saw Acumatica has a future consideration that was proposed for this but I don’t see any update on the item. We are on 2023 R2, and I have to think there is functionality to review, analysis, and update the min., max, safety stock levels, etc. based on usage. Can anyone help me out with this?

Dear Community,  I would like to request your help on clearing amount of “Unbilled Prepayment Total” field under “OTHER” tab of a purchase order. We created a PO with 2 detail lines with same price “14,673,000”. After that we made one Prepayment Bill for first line of the PO. And we paid through Check and Payment Screen.After that, actual Bill came in and the amount was only “13,480,699”. So, we created Refund form for the remaining “1,192,301” and linked with Prepayment.

Could you advise me ? what’s happen

SO 009895 is linked to PROD120168 and PROD120169. MRP Planning should only show the production materials needed, why does it also show the demand from Sales Order? This cause the purchasing team to over-oder the materials. I have seen this issue on 2023 R1, logged a case with support, but it hasn’t been resolved (the client updated to 2023 R2, and the issue was no longer actual).This just happened again to another client running 2023 R2 .209 

Hi FriendsI have a Stock Item which is defined with the following UOM configuration:  On the Sales Order, for the same SKU, we have the following 2 lines on a single order.  But while attempting to create a Shipment for this order, seeing the following issue:  The error seems to be from the core framework as per the Stack trace.  Any thoughts on why this might be and what needs

Hey Acumatica Community!I’m running into a very perplexing situation - some system screens (Expense Claims, Expense Receipts) are shown in the site map, I have full access rights to them, but they’re not showing up anywhere in the UI. Has anyone run into this before? Any ideas where to start troubleshooting? Thanks in advance!

I am trying to execute code to check if a customer qualifies for our reward program.  It needs to run when the order is removed from hold but after the SOOrder.OrderNbr is assigned.  Right now the value is <NEW> when I write the reward record to my custom table. public delegate IEnumerable ReleaseFromHoldDelegate(PXAdapter adapter);[PXOverride()]public IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate BaseMethod){    BaseMethod(adapter);    SOOrder row = Base.Document.Current;    if (row != null)    {        Rewards(row);    }   return adapter.Get();}Thank-you

Please assist with import scenario to delete item linked to request class. Request class is used in request items. It can't be deleted.

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

Is there a way to link the activities on Appointments or Service Orders so they show up on the customer account in Activities as well?

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 upda

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

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 

The MRP procedures state that the "Calculate Replenishment Parameters" function in the inventory module can be used to review the following items:Safety Stock/Reorder Point Lot SizesHowever, there is a note in the "Creation of a Replenishment Class" section specifying:"If you want to configure automatic calculation of replenishment parameters, you must use only replenishment classes with the Purchase or Transfer replenishment source. For details, see Configuration of Replenishment: Replenishment Methods and Configuration of Replenishment: Demand Forecast Model."We are deploying the usage of MRP and want to have suggested safety stocks or reorder points under different service levels as part of our internal ABC Inventory Management Strategy. However, when calculating the replenishment parameters, only parameters associated with demand are shown (as we get the demand with the top accessible assembly). No information is shown for lead tim

Where are these accounts set up for stock items?  When the item class is selected on the General tab it auto populates these GL accounts and I need to revise some of them.  

Since we installed Acumatica 2023R2, Our service techs have been complaining, especially when using the android version of the Acumatica App. Here is what happens:1. They will use the “View on Map” button to see the location of their next appointment.2. The app will open up Google Maps correctly.3. When returning to the Accumatica App after looking at the map, it is locked up. Every time they need to restart the app and log-in again.This is frustrating. Any suggestions on what we can do?