Solved

From a production order you can create a PO.  If I purchase material this way it seems that a linkage should have been created from the PO to the production order.  Where can I see that linkage?I don’t see where I can see linked POs on the production order.I don’t see where I can see the linked production order on the PO.Thanks!

The material wizard AM300020 should show me the list of materials to be consumed. From this interface, I will have to take out the materials and create the "Material Management" documents.but nothing is displayed

I have a GI with a list of service orders and want to email that list of service orders in one email notification, triggered by a business event.  If I add the ((FSServiceOrder_refNbr)) it returns just one of several. Is there a way to get it to list, just like in a report designer? -David

Hi,Does anyone have an example of a working Production Order Maintenance import scenario?Currently doing an import for the Qty to Produce field - per usual, keys (Order Type, Production Nbr) are committed first, which during manual entry would populate the form with relevant details such as inventory ID, warehouse, etc.However, have not seen it working with this screen in particular.  Import scenario (refer active rows) Error Have tried multiple configurations of commit/hold/etc, but have yet to get any working. Appreciate any help provided.

Hi,I was able to create one widget and one hyperlink to a financial report in the Dashboard. However, is it possible to create one widget with multiple hyperlinks to different financial reports? I did not see where this could be done.Thanks,@FrancesPantelidakis24    

Hi,I trying to create a GI to just show customer ID and the tax zone. I know I have to include the location table so I can pull the tax zone however I only want to see customer ID and tax zone not all the locations as well. Is there a way to do this? 

We have acquired a new company. Is there a way to change a company setup from a company without branches to a company with branches?

Is there a simplier way to backfill box 7 on existing AP bills once a vendor becomes 1099-eligible?  AP Bills that were created before vendor became 1099-eligible shows blank, while the AP bills created after vendor became 1099-eligible shows box 7. Currently i have to open every bill and add box 7 manually, which is a huge waste of time.

Hello experts,I have been trying to add a dropdown list to a new processing screen but, the list isn’t getting displayed. I have shared the dac and graph codes below. Please guide me out where i am getting wrong.Thanks in advance.Dac code:using System;using PX.Data;namespace MassCust{  [Serializable]  [PXCacheName("Mass_Activity_Table")]  public class Mass_Activity_Table : IBqlTable  {    #region Activities    [PXDBString(50, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Activities")]    public virtual string Activities { get; set; }    public abstract class activities : PX.Data.BQL.BqlString.Field < activities >  { }    #endregion    #region Source    [PXDBString(10, IsFixed = true, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Source")]    public virtual string Source { get; set; }    public abstract class source : PX.Data.BQL.BqlString.Field < source >  { }    #endregion    #region Cust_Lead_ID    [PXDBString(IsUnicode = true, InputMas

Hello,Is there a way to setup an Alert or Notification that will let us know that inventory has dropped below a certain level with Acumatica. Thanks,Nelson

Hello All, I have a Field updated Event Handler that calls a method. It works fine until the change to the field comes from a PXLongOperation. To be more specific, on APInvoice the status field is updated by the different actions. All actions and status changes are monitored just fine until I Release the document (Status changes from Balanced to Open). This is when the handler misses the change possibly because it is running in a separate thread/scope. Below is the Handler I have. How can make the handler listen to the change from PXLongOperation too?protected void _(Events.FieldUpdated<APInvoice, APInvoice.status> e){ if (e.Row == null) return; SyncStatusTransitionLog(Base, e.OldValue, e.NewValue);} 

Has there been any update that will let us print the 1096 form in Acumatica? This form is used in conjunctions with Form 1099 filed with the IRS. The only topic I can find was from 2 years ago, but the links for help lead to a topic that is unrelated.

Hi there,I am trying to make a relationship of Freight details so that I can put the line total on the invoice but I think my relationship is wrong, could someone help please  

On my custom page, I have an action to open the Recalculate Customer Balances screen (AR509900)        public PXAction<RecordsToProcessFilter> Rebuild;        [PXButton(CommitChanges = true)]        [PXUIField(DisplayName = "Rebuild Accounts")]        protected virtual IEnumerable rebuild(PXAdapter adapter)        {            var graph = PXGraph.CreateInstance<ARIntegrityCheck>();            throw new PXRedirectRequiredException(graph, false,                    "Rebuild Accounts");        } There are two versions of this screen.  The new one and the (old) one.When the graph gets instantiated, the highlighted line sees the screen being called from IC501010, not AR509900.  Thus, it kicks me to the else section and uses the OLD way of doing it.  It actually opens screen ID AR509901.  The arReleaseGraph actually errors out when recalculating a customer in the U100 sample data, whereas the new way does not.  Plus, the new way is a LOT faster.protected virtual void _(Events.RowS

 Hi,We need to add created by user name into payment voucher report is acumetica.We try to join ApPayment and Users Table.ApPayment has CreatedByID and User table has username field.Below screen shots attached for the reference.ApPayment TableUsers Table We join these table using report builder below like that.After the report complied it shows below error. Because CreatedById is uniqueidentifier type and user name is nvarchar type. Can you give the solution to get createdby name for the apPayment transactions is Payment Voucher Report.Thank you

Hi All, I want to stop adding new lines to a sales order based on a condition. How can I do this.?I tried adding the following. But It did not worked.  protected void SOLine_RowInserting(PXCache cache, PXRowInsertingEventArgs e)  {            var row = (SOLine)e.Row;            if (row == null) return;            //Condition            if(Condition == true)           {                       Base.Transaction.Delete(row);            }   } 

I have a custom table that stores the customer ID of customers that have been merged in my “Merge Customers” application.  After customers get merged, I want to automatically select them to be processed on the Recalculate Customer Balances screen.  After merging, it is just simpler to let Acumatica calculate the new customer balances than to do it myself.I created an extension for that graph.  The idea is that I redirect to this screen at the end of the Merge Customers process and the user simply has to click PROCESS on the screen as all the affected customers would be selected already.In the extension, I thought I could use the RowInserting method on the grid to check the box on the line if it was in my custom table.  That line doesn’t fire when the grid is being filled from the related View. I also tried FieldVerifying on the Customer field of the grid (and a few others) but they don’t fire unless you actually interact with the grid.Just to try to get something to work, I committed a

Hi, I’m trying to create a unit test for my Extension Library, but retrieving a DAC Extension always returns null for some reason. I followed all the steps in T280 course but I still can’t get the DAC Extension. I am currently trying to create unit tests for version 22R1. Here is the code snippet: using Xunit;using PX.Data;using PX.Tests.Unit;using PX.Objects.CA;using Custom.DAC;using PX.Objects.GL;namespace Customization.Tests{ public class CashAccountMaintExtTest : TestBase { [Fact] public void TestingCashAccountExtension() { Setup<CashAccountMaint>(new GLSetup()); Setup<CashAccountMaint>(new CASetup()); var graph = PXGraph.CreateInstance<CashAccountMaint>(); CashAccount cashAccount = (CashAccount) graph.Caches[typeof(CashAccount)].Insert( new CashAccount { CashAccountCD = "Test" } ); //This

We have a generic inquiry for Move where we display the AMBatch Total Amount and the INRegister Total Cost. We are currently only using final moves from WIP into Inventory, not from operation to operation.How/When is the AMBatch Total Amount populated?  Why are so many zero?Acumatica Build 22.115.0035Valuation Method: AverageProduction Order Costing Method: EstimatedSee attached snipping of our Move GI 

Has anyone successfully recreated the Inventory Valuation report as a GI? We currently have 181614 stock items and each one has more than likely touch multiple location. This leads to multiple entries on the inventory valuation report which then leads to a large document which can be a little annoying to parse through and analyze. I’ve been trying to recreate the report as a GI, but so far have remained unsuccessful. I’m open to any ideas!

Hello,This is what displays as my Linenbr, which seems to follow the line nbr of the list inside the system, I want it to count the line in this print though. Where should I edit this? Thanks a lot!

Hello Hello, I have a custom field on POOrder  named “additionaldescr” (Usradditionaldescr).I want to bring this field value to POReceipt which also have the “Descr1” (UsrDescr) when creating Purchase Receipt by click button “ENTER TO RECEIPT”. After that I would like to carry again “ Descr1” field to APInvoice which have the “Descr2”(UsrDescr2) by clicking Enter AP Bill.The goal is like this. POOrder » POReceipt» APInvoice . Can someone help me please. Best Regards,May

Hello fellow Acumatica Users! :)Do any of you know on the Construction>Revenue Budget, what the “Pending Invoice Amount” represents?  Right now, we have an “Original Budget” of $1,090 and a “Pending Invoice Amount” of -$1,090. Thanks in advance!Kay

I have a UDF UsrCustomerID.I originally used this for my DAC        #region UsrCustomerID        [Customer]        [PXUIField(DisplayName = "Customer")]        [PXRestrictor(typeof(Where<BAccount.parentBAccountID, IsNotNull>), ICSMessages.ParentAccount)]        public virtual int? UsrCustomerID { get; set; }        public abstract class usrCustomerID : PX.Data.BQL.BqlInt.Field<usrCustomerID> { }        #endregionI wanted to have access to the DescriptionField of the selector, so I tried this (which works)        #region UsrCustomerID        [PXDBInt]        [PXUIField(DisplayName = "Customer")]        [PXSelector(typeof(SearchFor<BAccount2.bAccountID>.            Where<BAccount2.type.IsEqual<GetICSCustomerType>.            And<BAccount2.parentBAccountID.IsNotNull>>),                typeof(BAccount2.acctCD),                typeof(BAccountCRM.acctName),                SubstituteKey = typeof(BAccount2.acctCD),                DescriptionField = typeof(BA

MRP is indicating to buy 5,000 units of 173L8100 STK with the following action and promise dates. I have created two POs, one for 2,500 (promised on date of Jan 5, 2023) and another for 2,500 (promise date of Jan. 11, 2023). I have regenerated MRP but those two lines remain on the MRP Display. Why do they remain? When should they disappear from MRP Display?