Solved

Hello Everyone,I was wondering if it is possible for an SO-Invoice to inherit the sales accounts from a non-stock item when the order type says use sales account from customer location. For instance , all the stock items would inherit gl accounts from the customer's sales account but the non-stock would inherit their gl accounts from the actual non-stock item itself.I haven't found any settings to play with on order types, ar prefs, or so prefs. I am thinking this is probably just locked from what you put in order types and that you would have to manually change the gl account. Thanks

I have set the formula to count the margin, I’m not sure is the formula correct?=([Products.CuryUnitPrice]-[Products.curyUnitCost])/[Products.CuryUnitPrice]does someone know how to solve this problem?After I set the formula, it come out the error. “Divide by Zero error encountered”.  

Hello, I’m new to Acumatica customisation so I’m looking for some pointers.I want to write some data to a custom table when a new record is inserted into the SOShipLine table.My custom table is similar to the SOShipLineSplit table with 3 primary keys of ShipmentNbr, LineNbr and PickNbr.I want to enter data into my table when a new row is created in SOShipLine so I’m using the RowInserted event - SOShipLine_RowInserted(PXCache sender, PXRowInsertedEventArgs e).I’ve found that in the RowInserted event I cannot get access to the field values for ShipmentNbr and LineNbr, I guess this is because the data hasn’t been submitted to the database yet. But without these values I cannot set the values for ShipmentNbr and LineNbr in may custom table either. I’ve tried quite a few idea to get the key values from the new record but I’m starting to think that perhaps I’m taking the wrong approach to this problem. Perhaps I’m using the wrong event, or maybe I should be looking to set up parent/child re

Hi, I´m new in Acumatica and I’ve trying to safe a PO and every single time i got the error message of¨Error: Inserting ‘Production Item' record raised at least one error. Please review the errors. Error: 'Entered Period' cannot be empty. ¨I’ve traced the problem and I get a problem whit the AMProdItem, and really don´t know how to fix it 

Good day.I am trying to set a custom field in my header to true if my purchase order detail line contains a blanket PO Nr.I have created the custom field, and am currently trying to change the field in the row updated event.I am currently getting a An object reference is required for the non-static field, method, or property 'POLine.PONbr'An object reference is required for the non-static field, method, or property 'POLine.PONbr' error.Any help would be greatly appreciated.Please see my code attached here #region UsrContainsBlanketPONo [PXDBBool] [PXUIField(DisplayName = "Contains Blanket No")] public virtual bool? UsrContainsBlanketPONo { get; set; } public abstract class usrContainsBlanketPONo : PX.Data.BQL.BqlBool.Field<usrContainsBlanketPONo> { } #endregion protected void POLine_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e) { var row = (POLine)e.Row; foreach (POLine line in Base.Transactions.Select().

Hi, The bill screenshot below is unavailable when I try to apply it to the debit adjustment that was created by reversing the bill.  Can anyone advise why?  It also doesn’t show up if I go to Prepare Payments in an attempt to cut a check for it.  Everything about it appears correct to me.  

I am having to adjust prices for vendors periodically, and was wondering if there was a way to do multiple items at one time?  

Hi, I use estimates for Manufacturing. when I create a Sales order Quote I link my estimate to the quote. When I copy order to SO it doesn’t carry over my detail line in the SO type. I can see the total amount is correct but no detail line. I need to mark item for production in the SO line. can someone please help me. Thanks 

Hi, We need to insert Inventory stock item with few attribute values. We have tried to add attributes and only Item created process was success.Attached the Screen shots for further reference.  RegardsNethupul   

I have a client that uses Subitems and I have modified some reports to show the sub item along with the inventory ID but they need the segment value description to print instead of the segment value. In this setup, there are 5 subitem segment IDs, e.g. W-AE-FRS-PA -1/10 where W = Wild, AE = UAE, FRS = Frescomar, PA = Panulirus argus and 1/10 = 1/10 lb. Is there a way to link by the subitem back to the individual segments and pull the description for any or all of the subitem segments that make up the subitem so instead of printing the subitem as W-AE-FRS-PA it would print as Wild-UAE-Frescomar-Panulirus Argus-1/10lb.

I saw from another community topic that Acumatica can automate sending a reply message to incoming emails...how is this done? Is it through Business Events or some other means? Here’s our scenario:We are using Cases to bring in all the service requests that we receive from a shared mailbox. These service request email notifications require that we “accept” the service call within x minutes. They also require that the “accept” be appended to the end of the existing subject line.Example of the original email subject: DISPATCHED: Work Task 22350022 Store 26094 Priority 2 - MediumExample of our accepted reply: RE: DISPATCHED: Work Task 22350022 Store 26094 Priority 2 - Medium accept Back to the original question… can this be done through Business Events or another means of automation that does not involve customize development?

Hello Everyone,We have a requirement where we are using Manufacturing module and trying to map options from "Configuration Entry" pop-up through code but while doing getting unexpected errors like: “Move Next” etc.Sharing our requirement and sample code for your review and feedback, please find details below:Requirement:Created a Configuration ID on Configuration Maintenance screenUsed that record on Sales Order screen under Details tab. Now on Sales Order Save action based on some custom condition we want to check include checkbox, then execute save action on pop-up and then execute FINISH button, available on pop-up. As per below screenshot we want to mark Included checkbox true under OPTION tab for each feature: Pattern, Grove, Doors, Jamb through code. Sample Code:public class KNBCSOOrderEntryExt : PXGraphExtension<SOOrderEntry>    {        public static bool IsActive() { return true; }        #region Persist Override        public delegate void PersistDelegate();        [PXO

Greetings,After downloading the most recent package on the Apply Updates screen, clicking Install Update throws the following error:The website contains a published customization. Click Customization Compatibility to validate the compatibility of the selected update with the customization.When I click Validate Customization (I do not see Customization Compatibility), I get the following error:There are no customizations, published or unpublished, showing on the Customizations screen.Does anyone know what I am missing?Thank you!Kimberly 

An unhandled exception has occurred in the function 'Move Next". Please see trace log for details.  This error is happening when I try to file the 2021 941/Schedule B/941-V Report &MI UIA 1028 eFile Report. All other taxes I’ve filed have no issues through Aatrix. Thank you!

I would like to create a GI showing all the AP Invoices and AR Invoices for a custom table having a field called Housebill. I can get it to work showing only AP invoices or only AR invoices, but not both at the same time. I attached screenshots of the existing GI. Any help would be appreciated.

The Process Orders screen can be used to ‘create shipments’ but not ‘create receipts’. So I put together a business event and import scenario to trigger the <Action: Create Receipt> (CreateShimentReceipt) but am running into issues with the dialog box. Any ideas on how to populate a multi field dialog box? 

Hello Guys, I wanna simulate the press action on save when updating a field i m using this code: protected void Choixfournisseurline_Selected_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e){ var row = (Choixfournisseurline)e.Row; PXCache cache2 = this.Caches[typeof(Choixfournisseurline)]; cache2.Persist(row , PXDBOperation.Update); this.Save.Press(); this.Save.SetPressed(true); cache.Graph.Actions.PressSave(); //cache2.Graph.Actions.PressSave();}but it’s not working!  Thanks.

Have massive customizations on IN202000 screen. After upgrade from 2019R1.214 to 2020R2.210 can’t publish customization project on this screen.Here is the error message:Any idea where to look at? What is “original index Template 2”?

A custom field is created in the Sales Order line level which pulls attribute values from Attributes form (eg- dropdown attribute created and custom field shows those dropdown values) but once line is saved the value is not shown on the UI but only when you click on it.I have also put MatrixMode = true in the grid but issue still remains.Before SavingAfter Saving 

Hi, i have some problem to get value from old value data, anyone have an idea ? example, new SO have qty = 65 after save user edited value qty in SO become 50. i want to get value qty SO =  65.or, how to implement query limit = 1 in acumatica ?

Hello,      I think it is possible, I am just seeking whether there is existed solution, or how difficult if I have to do it on my own.      We plan to integrate 1 Acumatica tenant with another Acumatica tenant. For simplicity, they can exist in 1 Acumatica instance/url address for the time being. For the long run, they may sit in different Acumatica instances.      The need is below:Supposing we are having 1 Acumatica tenant A, as  Distribution center, all the inventory are stored there. But the inventory belonged to other owners. The distribution center only provide receiving, storage, delivery service. And we are having several sales channels in Acumatica as Tenant B or C. The sales channels will receive orders and payment from end customers.         When Acumatica tenant B receive order from customer, it sync the order to tenant A.        Tenant A do the shipping, and sync the shipment information to tenant B. (Maybe no inventory deduction in tenant B, causing the real goods are st

Hello,       I’ve met an issue in 2020R2 as below: I created a Variable named FN to control the sub report visibility.If $FN=0, would display sub report “FNNOW”,if $FN>0, would display sub report  “FN”, As math tells, the two conditions above can not be both true at the same time It is working as expected when showing on screen or export to PDFBut when exporting to Excel， both sub report are displayed at same time. I don’t understand, is it a platform glitch?

I am trying to add some more info to the Availability status at the bottom of Sales Order - Details grid. Specifically, I am trying to pull the last sold cost for the sales order header’s customer and the sales order detail/line inventory ID field. Is there an imbedded way/function to load this price or will this require the PXSelect methodology? Thanks!

Hi Experts,I’m working on the certification for 2021R2, and I got some validation errors from Acumatica(like “The error has been found in the SQL scripts. The project-specific database tables and columns must be mapped to DACs.Sql | Table1”).I have fixed these errors, but I want to validate locally before I submit it. I know I can validate the project by the following steps. But I got the following message “No errors or warnings have been found during validation.Validation has completed successfully”.Does any one have some idea about validating the customization projects locally? Thanks,Frank

I am looking to make a report or inquiry that will work as follows:Select the customer Results should pull a list of all the parts that customer has order in s certain time frame. Time frame defined by input field. Is there something like this that already exists ? Any advice or help would be greatly appreciated. Thanks!