Discussion Forums

Hi All !For some project we don’t need to have a proforma invoice for our T&M billing. In this case the PM create directly a AR invoice.But we face a problem, in case we have one or more row to writeoff, how to writeoff them easilly(writeoff and hide it for the customer)?  If we delete the row, it become unbilled and will be recalled at the next invoice.When we want to have a reminder it’s fine , but if we want to completly remove the row it doesn't do the job.Thanks 

Is it possible to display weight data from a USB scale directly in the shipment package tab without having the warehouse management module for Acumatica?  We see the scale in device hub but cannot get it to write the weight into the weight field on the shipment confirmation.  

.

We have a Chart of Account group, 5299, that has an Account Group specified (E), on the Chart of Accounts screen. If I create a Project Transaction that Debits a Debit Account (5006), CREDITS 5299, then release, it will get posted to Journal Transactions like this -  It’s just debiting and crediting the same project, which is incorrect. Once I remove the Account Group from the 5299 Chart of Account group, it releases like this (which is what we want) -This is properly debiting the project then crediting our 5299 account. I’m trying to understand why the difference here and what value the Account Group on Chart of Accounts provides in this scenario. Both Project Transactions were setup with the same information as a test, only difference was removing the Account Group from the Chart of Account 5299 in between both tests - 

Our company is testing MRP and I am confused as to why the “Qty On Hand” for this item says 0 on the “Inventory Planning Results by Item” form. Under “Warehouse” there is a “Qty on Hand” field that says 0. According to ACU this what calculates Qty on Hand on this page: Below is the inventory summary of this item with location shown and it clearly shows 3 on hand in that location: Below shows that this location is checked for “Inventory Planning” there is no “MRP check box” as per the above definition but I find that ACU uses “Inventory Planning” and “MRP” interchangeably.So why is “Qty On Hand” 0?? There is no allocated inventory and I have recalculated inventory for that item as well.Thanks :D

Hi, We have report called inventory edit details, which has different parameter. For one of the parameter field in the zoom screen we want to hide a column from the users, can anyone suggest is it feasible or not and how can we achieve this?Refer the below screenshot where highlighted column needs to be hide from the users.  

Payroll AA-2024 (this was the exception so that 2024 would only have 26 pay periods) was supposed to have posted 1/1/2025, but I posted 12/31/2024. I did not realize the problems that would be created.W-2s are going to report pre-taxed contributions that reduced the federal taxable wages and may cause over-the-limit contributions to HSA accounts and 457 deferred comp plan. Is there a way to change the posting date?Should I delete the 12/31/2024 payroll and re-run on 01/01/2025 (major hassle)? Please help!Denise

Hello all,I am trying to create a new employee but when I try to save it, triggers the below error:How to resolve this?

I always have this problem when I am login to system. How can I do for this error? Thanks

Hi Team, We are working with 24R2 (Build version) and created a custom processing screen to create Sales Order but during processing we are getting an error like: 'Another process has updated the 'SOContact' record. Your changes will be lost'. But the same is working in previous build (Build version) On further verification we identified the issue occurs while updating Sales Order Contact and on executing Save action getting another process error, without this code block order created successfully. Please find the below sample code for your verification and review: public static void SetBillingContact(SOOrderEntry graph, ItemResult OrderDetails)        {            graph.Billing_Contact.Current = (SOBillingContact)graph.Billing_Contact.Select();            if (graph.Billing_Contact.Current != null && OrderDetails != null && OrderDetails.BillingAddress != null)            {                graph.Billing_Contact.Current.OverrideContact = true;                graph.Billing_

I don't know why when I had confirmed create Shipment but it had error. 

Please kindly help me and how can I fix this process? I can't use Create Receipt and create shipment 

I am trying to get a custom field (Absolute Variance Quantity in INPIDetail/INPIDetailExt) to get summed up and have that amount sent to a custom header (Total Absolute Variance Quantity in INPIHeader/INPIHeaderExt). The population of Absolute Variance Quantity works just fine, I’m just stumped by the process of having it update Total Absolute Variance Quantity.Here is my code so far:And as text:public class INPIReviewExtension2 : INPIHeader  {    //PXGraphExtension<PX.Objects.IN.INPIReview>,    [PXFilterable]    [PXImport(typeof(INPIHeader))]    public      SelectFrom<INPIDetail>.      LeftJoin<InventoryItem>.On<INPIDetail.FK.InventoryItem>.      LeftJoin<INSubItem>.On<INPIDetail.FK.SubItem>.      Where<        INPIDetail.pIID.IsEqual<INPIHeader.pIID.AsOptional>.        And<          INPIDetail.inventoryID.IsNull.          Or<InventoryItem.inventoryID.IsNotNull>>>.      OrderBy<INPIDetail.lineNbr.Asc>.      View PIDetai

My clients frequently request an ability to show Paid to date values for a specific project (AP and PR), and dollar received on a job (AR) cash entries are not job costed in the current iteration of the system.  What workarounds do other partners utilize to satisfy client requests for paid to date values on a project?

I am looking for an AP report that would show a summary of all payments made to subcontractors for the year, to assist in my annual insurance audits. Is there a way I can sort or filter the vendor transaction history report by vendor class, to show only subcontractors?

We are using sales orders to process sales.  The sales come by Shopify, API (woo commerce) and manual.  Creating sales orders works great!Where we struggle is returns/order changes.  Our most common situation removing an item from the sales order that is not in-stock followed by partial credits.  Currently:Step 1: We go into the sales order and remove the item that is not in-stock.  Then we add a non-stock item to the order for exact same amount.  Create the shipment, ship it and invoice the order.  The reason we add a non-stock item is the order comes in with a payment.  If we don’t close the order for the exact amount the payment remains open with balance.  Step 2: Since it was paid order we credit the customers credit card on Woo Commerce or Shopify.  Then we go into ACU create a return order using the non-stock item with amount of the item removed and any tax.  Then we create a refund payment in ACU, attach the payment to the refund order, lastly invoice.Situation 2:  As a customer

Hello.  I execute a simple BQL query.SOOrderType orderType = SelectFrom<SOOrderType>    .Where<SOOrderType.orderType.IsEqual<@P.AsString>>.View.Select(Base, tran.SOOrderType);I verified the BQL parameter returns “SO”However the results of the BQL is null.  I verified that only 1 version of SO order type exists.  I’m unsure why this happens.

Team,I am trying to inlcude the Bill Description as part of the AP641000 check with Remittance in Acumatica, the only way I found to do the relation is to do a APPayment related to APAdjust and the APAdjust to the APInvoice to get the Bill Description. In this report, I used the BillType variable to now host the APInvoice.DocDesc, on a check with 3 bills paid, the remmirance DocDesc is correct for the first two lines, but not the third line. I hope somebody could check the report and let me know if I am missing something.  report is on the zip attachment Thank you.

Anybody else getting robo Called by this company?  They Claim to be Acumatica (Their Caller ID says Acumatica), but when pressed will say they are a partner. They are trying to sell their authorize.net plugin and stating Acumatica has dropped support for it.   I have asked many times to be removed but it just won’t stop.

It seems that Acumatica allows that a Cross-Reference Bar Code be used across more than 1 Inventory Id code. So how can we ensure that the barcode is a unique identifier of a particular Inventory Item?

The time is passed as a string. which includes date and time. i need to make a filter where i can filter the data by time.E.g. “1/3/2025 4:49:34 PM”. Any idea? 

Hey everyone. We have done a customisation where we extended the Opening Balances to the Customer screen. Here are the fields in DAC: public class MAKLCustomerBalanceSummaryExt : PXCacheExtension<CustomerMaint.CustomerBalanceSummary> { #region UsrMAKLCurrentBalance [PXBaseCury(null, typeof(Customer.baseCuryID))] [CurySymbol(null, typeof(Customer.baseCuryID), null, null)] [PXUIField(DisplayName = "Current Balance", Visible = true, Enabled = false)] public virtual decimal? UsrMAKLCurrentBalance { get; set; } public abstract class usrMAKLCurrentBalance : BqlType<IBqlDecimal, decimal>.Field<usrMAKLCurrentBalance> { } #endregion }We have then extended this field to the Web Service Endpoint, but it returns 0 every time even though the customer has a balance.I have then added the RowSelected event handler and populated the field in there as well, but to no avail. How can I get this field to display in the Web Service? 

If a vendor discontinues an item and we plan on purchasing a different item to replace that stock item, is there a way for me to “link” the 2 items together so that my forecast will be able to tell me how much of the new item I need to order based on the old item history?

My team is trying to clear up our system, and we came across three material moves that were never completed, while the corresponding PO was. It seems like all three were duplicates of original material moves that worked, but now these three orders are stuck with the error “AM Error: The batch contains released related transactions and cannot be deleted.” and can’t be deleted no matter what we do. Is there a way to fix this issue?