Solved

I need to include the Sales Account under Customers in Receivables for a Generic Inquiry. I tried adding tables and the Location ID to pull the information but nothing is pulling. Attached is my export of the GI. What am I doing wrong? Thanks, Framces  

Can “Automatically Apply Amount Paid” be turned off on the Load Options screen when loading documents to apply a check to in Payments and Applications?  

Hi Anyone know how to split the profit & loss financial report based on branch?Currently, our Profit and loss financial report is combine 2 branch into one.Based on existing combine Profit and loss financial report, Not sure if anyone one know how to create/split a Profit and Loss financial report to individual branch 

We are adding another branch that has a very different quote form that they want to stay with. Grouping& sorting conditions are not the same as for other branches.What would you recommend as the best way to get Acumatica use a branch-specific quote, SO or invoice? Please share your advice. Thank you!

 I Need help.I Got this error after i update acumatica from 2019 r1 to 2022 r2. does anyone got the same trouble ? 

Hi,i would like to check in below scenario, what is the best way to record the transaction. The original purchase cost for product A is $100, we purchased 50 pieces, did purchase receipt and posted vendor bill. and we sold 40 pieces by end of the month. On the last day of the month, vendor will review our sales and give us a rebate for Product A, lets say is $20 per piece for all 50 pieces. so our cost for product A become $80. The problem is we already posted the purchase receipt and the cost of $100 is used as COGS, our sales person commmission is calculated by profit, so is there a way to adjust the vendor bill and re-calculate the profit for sales transactions already posted. Thank you

Hello Everyone,In the persist delegate, I would like the custom field inside the PXLong Run operation but value is not updating. Can anyone help me on this?If try to save again, it is re-calling the Persist method and going to the infinite loop.Here is the sample code for your reference.  public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate baseMethod) { baseMethod(); if (Base.Document.Current != null) { PXLongOperation.StartOperation(Base, delegate () { try { //my custom logic is here //Updating the custom field value below, value is holding in the caches but updating Base.Document.Cache.SetValue<SOOrderExt.usrCustomField>(Base.Document.Current, true); Base.Document.Cache.Update(Base.Document.Current);

Hello,We want to print a shipping label when we ship.There is a “print label” button on the more menu of the shipment screen.It is grayed out.I enabled “shipping carrier integration” feature even though I won’t really be using it in an attempt to enable the button.How do I enable that button so I can print a label that I design?I understand that I need device up installed.  I have not yet done that.  Is that possibly why the print label button is grayed out?Thanks! 

I need to report some data to a supplier via ASCII files. those files have header record, details and end record. How can I achieve this with Data Providers. I tried to load the fields from the file but it only reads the first record which have a different layout than the details record and the end record. Maybe it is better to do this with the Report Designer?Please advise. Jesus. 

Hello-I have created a custom table and have then created a view under ProjectEntry ext graph. However, when I try to run a script to update the values- it will not, for the life of me, update the values- I’m perplexed- I’ve never had issues with base detail tables on the ProjectEntry graph.. but now that I have a custom table it is really not liking it. See below for view that I created and then the action that I call to update the value in the cache based on a static value (just for testing). I have simplified the code down a lot for testing and de-bugging purposes, but for all intents and purposes, the same logic applies.View:public PXSelect<BlyIconPMBudget> BlyIconPMBudgetView;Action: public PXAction<PX.Objects.PM.PMProject> UpdateBalances; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Update Balances")] protected void updateBalances() { foreach (BlyIconPMBudget b in BlyIconPMBudgetView.Select()) {

Hello,We have a new Foreman attribute that should allow the user to Select from the Employee List when adding new projects. We set up the attribute as follows:When we try to add Foreman to Project Attributes screen, it’s not in the list. Why? What  have I missed?  The attribute appears to be active and is not used elsewhere. Thank you! 

Can an item on a Sales Order that does not have Replenishment parameters be added to a PO in the Create Purchase Order process without item being Mark for PO?

Trying to add lot serial cost data into a GI, and would like to use the following table (believe it is called a projection table) - INLotSerialCostStatus.Can’t seem to find this table in the DB from Tables section of the GI (found it through the DAC) and believe it is a ‘projection table’ or more of a view).  Is there a way to access this data within the GIs themselves?

Hi,  A total of 8000 stock items need to be inactivated via the import scenario.  RegardsNethupul

Hello Everyone,I would like to add posting class selector to these filter. The screen name is Historical Inventory balance(ScreenId=IN616000). Kindly assist for it is urgently required.All responses will be highly appreciated.Thank you all.

Hi Team,I’m unable to import snapshot since I’m getting the error, “ An error occurred while importing data into the 'APInvoice' table”. can someone help me to rectify this error.

Hi,I created a xml data provider to get xml export for the purchase orders.Then I need to pass purchase order number when getting the export from export from scenario as a parameter.Is it possible to pass a parameter into export scenario.

I need to print Customer Statement on demand and want to create an import scenario for that.I created the one below (attached the xml) but it is not working. Our version is 2022 R1. 

Dear Team, I would like to know whether we can do multiple fund transfers in Acumatica. An example scenario is as follows. Source Account: HSBC 788Source Amount: USD 10,000 Destination Account 01: HSBC 544Destination Amount 01: USD 5,000 Destination Account 02: HSBC 533Destination Amount 02: USD 5,000

Hi,I created a new setup form for my custom screen in the same customization project. After publishing, it’s working fine in my local instance. Now I want to add this into the UAT instance and publish my customization project, But after importing and publishing the project package, setup form is not visible in the project editor, only the custom screen which is Proforma Invoice can be seen.what is the reason for this and can someone help me to resolve this?Thank you.

I can't see the whole list of items from the IN2025PL screen but I can see them from the IN202500 screen…version 22R2 Some help please :) !thanks in advance.

Hello,  we are new to Acumatica, & are trying to figure out how to add a miscellaneous cash receipt to a bank deposit. For example:  We periodically will receive a rebate check from a vendor, that I would need to record as rebate income. I want to add this to an existing bank deposit that contains payments on account from customers.

We just noticed that when creating AP Bills, you can enter the Qty and the Unit Cost, and Acumatica will calculate the Ext Cost.But, I can go to the Ext Cost and modify it and will allow it too even the qty*unit cost does not match the Ext Cost. I can move forward and release it. If this the expected behavior or is there any configuration I should do to prevent it?   

Hi Guys, I’m trying to add custom column - contract Price field from service contract and display in run service contract billing screen.I added the field in Screen editor customization. created the DAC, and graph but I’m not able to view the data in run service contract billing screen.Below is my custom field. DAC,#region UsrContractTotal        [PXDBDecimal]        [PXUIField(DisplayName = "Contract Price")]        public virtual decimal? UsrContractTotal { get; set; }        public abstract class usrContractTotal : BqlDecimal.Field<usrContractTotal> { }        #endregionGraph,Public class ContractPeriodToPostEntryExt : PXGraphExtension<CreateInvoiceByContractPost>    {        #region Event Handlers        public static bool IsActive() => true;        protected virtual void ContractPeriodToPost_ServiceContractID_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e, PXFieldSelecting InvokeBaseHandler)        {            if (InvokeBaseHandler != null)             

Short time listener… First time Caller…Going Live 3-31-23 with VERY SIMPLE business requirements.Import Scenario: Leads is our ONLY data conversion.Getting Provider object 'Template' is not found. error.Any suggestions ?