Discussion Forums

Why is the total Dead Stock Cost in the dead stock screen different from the total cost in the inventory valuation & Inventory Summary.I have a item that shows the same QTY ON HAND in the Dead stock, Inventory Summary, Inventory Valuation but the DEAD STOCK COST is 47K but the Inventory Summary & Inventory Valuation the total cost is 14Kwhy is the Dead Stock qty calculating 47K ? How did it get that number Does the dead stock do some sort of Inventory Holding calculation?  

We have a few questions regarding on our API transaction to lessen the throttling of our API calls limits.1. Does plugins count against our API usage.2. how to find out what API calls are going through.

Hello,I’m trying to create SalesOrder through API request, but it keep raising this error: "exceptionMessage": "A data corruption state has been detected. You cannot save the changes. Copy the data you have entered and reload the page. Date and Time: 2024-05-31T20:20:12; IncidentID: 8eee461c-214a-4bd2-803c-894bba76aa0e; Name: Aggregate Validation: PX.Objects.SO.SOOrder+openLineCntr. You can view detailed information about the issue on the System Events tab of the System Monitor (SM201530) form.",here is my endpoint endpoint structureand this is the data that i’m trying to submiturl 

We run 23R2, Build 23.209.0023. When attempting to use the Finish action via the ConfigurationEntry endpoint, the Supplemental Item does not appear on the Sales Order. This is not the same behavior we see when manually creating an SO, where after closing a Finished Configuration, the SO is updated to include the Supplemental Item.Has anyone else had success with the Finish action that’s part of the ConfigurationEntry endpoint? It is properly updating the Configured Item’s Line Description.

Hello, I created a custom printed form and placed it on the site map. I added a customization project that allows this form to be printed from the sales order screen via the action menu > Printing & Emailing section. (This form is a copy of the sales order without prices). When I print from the Site map, the form prints correctly using the selected parameters. When I print from the Action Menu, no data is visible. I have updated the user access to the new form to match the original form that was copied. What am I missing? 

We are new to Acumatica and trying to track the time our users spend per customer on cases. Our customers are billed a monthly set price with no hours limit, but we need to track employee time for statistical reasons. I have tried having the time put against a project but it seems like this would get muddled as these are ongoing support contracts not projects. Is there any way in the system to track employee time per case per client basis?   

Finding out an issue where the Header on my report does not cover all cells when I export to Excel.  This is my first attempt at updating/adjusting Excel formatting with Report Designer.How do I adjust a group or header to match the total cells on the report?  Or, is there some documentation on the Excel formatting and Report Designer?

I am wondering someone has created a business event to push notification when a business event failed or when there are events build up in queue not running in System Queue Monitor.

I have a purchase order that has a extended cost of an inventory item pulled up from the Vendor Prices screen . How to change this setting . I do not want the line item in the purchase order to automatically populate the extended cost from the Vendor Prices screen , instead i want the extended cost in the purchase order to pull the last cost/current cost in the stock items screen.  

Many of our customers find it very annoying that they have to manually touch the “Set Qty” button on their mobile devices in order to set the quantity being picked/packed/shipped. We are trying to include the Set Qty command (*qty) as a barcode on the picklist report so that they can scan that command and then scan the barcode for the quantity (since there’s no way to set the mobile device to default to the shipping quantity).I can’t find the right way to format the command on the report so that the barcode scanner will read it and put the device in Set Qty mode.Does anyone know how to do this? 

Using 22R2.  We have set up a customer account in the Fedex carrier set up and set that to a billing type of Receiver.  When the label prints, the label shows the billing type as Third Party Billing.  Ideas?

Hi - we recently switched from Paya to Acumatica Payments/Fortis for our payment processor. With Paya, we could generate payment links automatically when the invoice is released. The team from Acumatica Payments said we could likely set up a business event to do this as well, but I’m not sure what all that would involve. Does anyone have experience setting this up themselves?

Hello everyone. I am currently working on customizing an API to add customer data one by one into a new screen. I have created the necessary table in the database and the screen to display the data. Everything seems to be functioning correctly. However, I have encountered an issue where adding a new record results using PUT API  in the deletion of the old record from both the database and the screen. What steps should I take to address this issue? I have attached a screenshot below for reference.This is screen.  

Hello,I am having trouble with an activity import. I am trying to import our old CRM call activity to specific Leads, Business Accounts and Contacts. Receiving “Error: 'Related Entity' cannot be empty.” on each record. I have tried importing with the Related Entity being the Acumatica ID as well as the Record Name. The XML for this scenario is attached.   Thanks!

I am trying to deleted a rejected Expense Claim but when I try to do that, I am receiving an error message that says the “expenseRefNbr cannot be empty”;  if it was rejected, why is that occurring?Is this a permissions or setup issue?  And if so, what should I look to change? 

We have this error on an items product availability in Sync history. It is not translating the inventory to the Shopify store and we can’t seem to figure out why. Has anyone had this issue and fixed it?  “The record has been assigned the Deleted status because it is related to an item that is missing, excluded from synchronization, or configured to not track quantity.:

We need to fix the user that shows search result to be like the rest that doesn’t show the result on the sales order screen. See images below for the correct display versus the wrong display.  For this user a results sub window opens as the user types in an Inventory code.   This image shows how it should look without the results displaying: 

I added a Attribute to my Vendors screen (AP303000).  I have that attribute called out in my report.  I have my Report Parameters calling Report.GetFieldSchema('Vendor.APOWNER_Attributes').  I am seeing the filed populate on the Reports Parameters on the screen for report and I an even select the desired result to filter agonist.  But when I pick one of the options and run the report, I still get all values for the Attribute, not the one selected.  Am I doing something wrong, or missing a step. 

Wanted to check that I am not missing something before I write this off.We want to display GI/Dashboard on a large screen on the shopfloor and have it periodically auto refresh.We do not want to tie up a computer for each display on the shop floor.Would like to use a smart TV that could display from the URL.  However, cannot have it prompt for credentials.  So looking for a URL that could have credentials embedded.  (I am sure this is not possible, just checking) Looking for any suggestions:Want to display dashboard on shop floor and have it autorefresh.Do not want to tie up a computer to accomplish this.Do not want to have to enter credentials.   Thanks!

I am having some trouble getting a mass import to go through that will sync to our Shopify store.I have about 1000+ bin locations that I need to import into Warehouse Mapping for Shopify stores in our entities section and I keep getting a “Bindings” error whenever I try to import the data using the Import by Scenario. Here is what I have built out so far: The data is preparing correctly, but it isn’t importing. Does anyone have any tips for this?

I’m looking for a way to assign totes to shipments for wave picking before we print the pick list. Like a process screen that will allow me to do it in bulk.

Is there a way to short ship a wave or batch pick list? Let’s say I go to the location and the item isn’t physically there and I need to confirm the batch or wave pick list without that item. Currently when I try to hit confirm line, or confirm pick it gives me an error that the pick list is not done.

Hi! I am trying to determine what User restrictions are applied when an Active tenant is changed to a Test tenant. Is the number of users restricted to 2 concurrent or does the licensed number of users still apply to the test tenant with all forms and reports watermarked as test?  The Help article I found stated that unlicensed test tenants were restricted to 2 Users however it does not say if this changes when licensed. Customer is on version 2022 R2 if that is a factor in the answer.I appreciate any input!  Thanks,Michelle

What access right should be allowed to view inventory in the creation of a GI? Anyone have an idea as to why this is not able to be viewed as an administrator? 

We are a company that bills time and material invoices through the pro forma invoice setting. We are looking for a way to be able to tie this invoice into the sales order process somehow so that when we go to ship the order, it ties to the pro forma invoice.  Right now we are manually creating the pro forma invoice, manually adjusting the sales order to match the pro forma invoice price, and shipping the sales order. This creates the issue of keeping the shipment in the ‘confirmed’ status, because if we ‘prepare invoice’ from the shipment, it would duplicate the invoice and book AR twice.Does anyone know of a better way of navigating this scenario?