Discussion Forums

Can anyone explain to me why this error are starting to show? At first there is no problem with our syncing of company entity to shopify then this year 2025 I’m not really sure exact date this problem start occurring  At least one GraphQL error has occurred. Error: Field 'locationCount' doesn't exist on type 'Company';Error: Field 'orderCount' doesn't exist on type 'Company'; 

Is there someway to send an “approval” flag if a part gets released without an attribute filled out or a technical drawing attached to it?  I’d like to introduce some systemic control over engineering releases to make sure we are filling out data fields. 

Hi Team,I am experiencing a strange system process that I am trying to figure out if its intended or a customization somewhere.Essentially if you create a new record on Customer Locations screen the new location will auto pull in “Warehouse”, “Ship Via”, and “Shipping Terms”. Essentially the account defaults.Yet when you do the same action of creating a new location on the Sales Order these defaults don’t get pulled in. My gut is saying there is an issue here because if the account defaults aren’t being used for new locations what is the point of account defaults?-Jacob

We are using incoming documents to process vendor invoices. Our vendors are billing us in a unit of measure that is different from the purchasing unit of measure on the purchase order.  The conversion exists on the items and what we are being invoiced is also the base unit of measure. It does not appear that the purchase order is fully reconciling against the invoice, the quantity is still showing unbilled but the amount is 0.00.  The purchase order remains in completed status and not closed.How does this functionally work and does the system run any nightly updates to correct this?

I have a custom web control which want to add to a project of mine. I want to render this control for every request to the acumatica. But It renders only once and not redering for the subsequent requests. (Ex: Button clicks)     public class ProgressBarControl : PXWebControl    {        public int Progress { get; set; } // Progress percentage (0-100)        protected override void Render(HtmlTextWriter writer)        {            writer.AddAttribute("style", $"width: {Progress}%; background-color: green; height: 20px;");            writer.RenderBeginTag(HtmlTextWriterTag.Div);            writer.Write($"{Progress}%");            writer.RenderEndTag();        }    } 

Hey there! Our business repacks seed potatoes and I’m wondering if there is a way for us to use MRP in such a way that allows us to not have to do any calculations outside of Acumatica (example in excel). We buy seed potatoes in bulk and repack into 4 different sizes based on weight. Each of these items have their own stock item.Right now MRP is running and consolidating sales orders so that we can create production orders. This works great as long as well sell exactly how much we have purchased, but if we sell less we will still want to repack the remaining into various sizes (ideally at the same time of repacking for sales orders). Our work around is to export the production orders out of ACU, put it into an excel sheet, change the “Qty To Produce” of the production order using calculations in the excel sheet, and importing those chanes for those production orders.Is there anyway to utilize inventory planning so that all of the remaining bulk is put into an additional production orde

Good morning! My company needs to place a purchase order that will give us enough stock of an item until April 2026. We have been in Acumatica for less than a year. Below is my proposed method of approach and I’m looking to see if the method will work.Manually enter monthly forecast data for February 2025-April 2026Increase “days of supply” for my purchased items to “453”Should MRP then give a PO recommendation of how much inventory to purchase?

Good afternoon fellow developers,I’d like to get assistance from community with the customization of the SO Shipment.I need to add SOShipLineSplit with partial allocation - identical to what I am doing via LINE DETAILS dialog (see on screenshot) Doing it via below code (with Qty set to 1,500.00) actually creates SOShipLineSplit, but it is always fully allocated, and Qty that I provided gets ignored. I’ll appreciate any recommendations Best regards,Andrey

I have a custom processing screen with two filter fields.The filter for the screen id works.  The filter for the file extension does not.Ignore the first filter field.  I was trying to use a selector to get UploadAllowableFileExtensions, but the value returned includes a “.” in front of the extension.  So I created a DDL with just the last three characters of the extension.  I could not figure a way to trim off the “.” in the value of the selector. When just the screen id is provided, it shows three files for that screen: As soon as I choose PDF from the File Extension2 DDL, the view is refreshed and attempts to apply the file extension filter.  Here is the code for the applyfilters method:protected virtual void ApplyFilters(PXSelectBase<UploadFile> shCmd, RecordsToProcessFilter filter){ if (filter.ScreenID != null) shCmd.WhereAnd<Where<UploadFile.primaryScreenID.IsEqual<RecordsToProcessFilter.screenID.FromCurrent>>>(); if (filter.FileExtension2 !=

  Hi everyone, this might be something really simple but I tried adding a new column (YTD Prev) and it’s only the lines in the headers that are getting cut off.  What I did is put the next column in the column range but that doesn’t seem to work. Any input would be much appreciated. Thank you.  Thanks so much in advance. 

Is there way we can flow the Phone number from ACM to Customer/Company in shopify via custom mapping? Thank you in advance

Good day CommunityI have a customer who creates an internal sales order to move stock for exhibition purposes. They do not want to create an invoice but the stock needs to be moved.Is there a way to close the shipment and ignore the “Prepare Invoice” step?Is there a way around this please? These shipments remain as confirmed, not complete.RegardsBarbara 

Good day CommunityI have a real mystery. I have deleted budget in the GL but when I run an ARM report, the budget is still there.It has also been deleted in the database by the administrator. Is there another table holding the budget information?GL Budget Edit:ARM Report:This make no sense to me. Can anybody assist please?Many thanks

Good Morning Ladies and GentlemenI have a bit of a problem regarding dead stockI am trying to add the Location field to the dead stock screenThis is what I currently have: Non filtered by locationFiltered by location Now the problem I am facing is with the dead stock calculationsAcumatica stores inventory history in INItemSiteHistByCostCenterD, but there is no table that has it based on location, or includes the locationid field (like INItemSiteStatusByCostCenter vs INLocationStatusByCostCenter) Would there be a nice work around, or would I have to build a custom view/DACTo be honest, I just want more advice ;)

Hi,One of our clients has many items with a base of UOM and a Purchase Unit of M2. These items are set up with conversion factors (as shown in the first image below) to correctly convert based on their formulas.This conversion setup seems to be causing some confusion in the PO History tab of the Purchase Orders screen, as a Purchase Receipt was processed using the M2 UoM, but the PO History tab in the Purchase Order is displaying the Receipted Qty in the EACH UoM, which is a much larger number after the conversion (second image below).After looking into the makeup of this field, I found that this PO History tab field is set up to use the Base Unit. Is there a way to ensure that this field always shows what was processed in the main Purchase Receipt record instead of converting to the Base UOM?Let me know if I can provide any other information.Kind regards,Andrew This is the conversion set up for the item shown in the PO and Purchase Receipt belowPurchase Order displays receipt in Base

Since upgrading to Acumatica 23R2 from 22R2 we are getting occasional sync errors saying:Object reference not set to an instance of an object.when syncing new orders from Bigcommerce to Acumatica. I’ve looked at the trace but I’m not really sure how to troubleshoot this error.The external orders also don’t look any different to ones that are syncing without problems.If anybody has any ideas that would be very helpful.Phil

We use DHL Ecommerce through EasyPost, and have had no issues for a year, but a few days ago DHL started to not return any rates.I noticed all the selectable codes now have SM in them, but in the trace for the error, the SM is not there, nor is it in the codes on the EasyPost site itself. Nothing was changed on our end before the errors started to happen. The codes look like this now. DHLSMParcelExpedited vs DHLParcelExpedited DHLSMParcelGround vs DHLParcelGround I’ve reached out to DHL, EP, and Acumatica and not had any luck. Any suggestions for what I can do? 

Is It Possible to  make Bar Charts / any other Type of Charts Using a PIVOT Table Created from a GI 

Hi Team, I have created AP Bill using AP Bills and Adjustment screen and on a custom button action I have created a Debit Adjustment out of it. Now, I wanted to apply the newly created debit adjustment against that bill. However, I am getting an issue of “Document out of Balance” error while saving the same.Below is the code I have written which seems to be failing on (paymentGraph.Actions.PressSave()). APPaymentEntry paymentGraph = PXGraph.CreateInstance<APPaymentEntry>();APInvoice fetchedDebitAdj = PXSelect<APInvoice,    Where<APInvoice.docType, Equal<Required<APInvoice.docType>>,    And<APInvoice.refNbr, Equal<Required<APInvoice.refNbr>>>>>    .Select(Base, APDocType.DebitAdj, debitAdj.RefNbr);APPayment newPayment = paymentGraph.Document.Insert(new APPayment{    VendorID = apinvoice.VendorID,    DocType = APDocType.DebitAdj,      CuryOrigDocAmt = fetchedDebitAdj.CuryOrigDocAmt,     Hold = false // Set hold status});// Link the Debit Ad

Hello,I am looking for a deprecation report to show all my assets, regardless of depreciation. My auditors like the standard report in Acumatica within FAS (“Depreciation” ) but it is only returning assets that have depreciation within the period. Therefore it does not show all my assets regardless of depreciation value. I looked in the schema on report builder and cannot figure out why it is limiting records. Anyone have any insight on it?   

When I attach a file in a Sales Order and try to create a receipt , I get an error code  :406

How to Resolve Error: Inserting 'AM Transaction' record raised at least one error. Please review the errors. One or more lines have unassigned Location and/or Lot/Serial Number … The Lot Serial Class assigned to the Inventory  has Assigning Method ‘When Used ‘ and in the production order type Require Parent Lot/Serial Number = Never 

HI All,When entering a Bill, it is pulling the expense account from the vendor even when I put in an inventory item. I have checked the posting settings and preferences and feel like I am just missing something. Does anyone have any ideas? The client wants it to pull the expense account on for the item on the bill. My local Acumatica pulls in the item’s expense account though. Not sure what I’m missing. The bill with no inventory itemThe vendor GL accountsWhen I add the inventory itemThe inventory item expense account 

I’m trying to create a GI that shows ACHUPLOADS via Checks and Payments to employees and combining that with a Business Event notification. The problem I’m having is correlating the ‘Vendor’ with an email address (Contact > Email) of the employee. Could anyone help point me in the right direction? Attached is what I have in place right now. It pulls the proper data that we’re after but not the email.

Hi everyone,If you are attending Acumatica Summit this year, be sure to stop by the Community booth! It’s always great to put names to faces and meet our members! We will be located in the Acumatica booth area of the Marketplace in the Lafite Ballroom. Cheers and hope to see as many of you as possible!Chris