Get inspired and gain all the knowledge you need
Recently active
Allow non-standards to allow quick and easy data entry from Sales Order to Purchase Order to Production Bom. Different from Non-Stock. Non-stock means I have to first setup and/or import into the Non-Stock table before using in a Sales Order, Purchase Order, or Production BOM. For a non standard to be used on a Sales Order this would require either the part would have to be a make (requiring a production order), purchase to a sales order or to a Production Order due to being non-inventory. For a production order, this would allow direct download into the BOM requiring any non standard parts to have to be purchased and/or made (make) via a production order. If I continually use non-stock items, I am having to enter all the parts first as non-stock and then bringing into the production BOM. Other option is to use one Non-stock part number and update the description to change the BOM parts not exactly the best to calculate and capture costs. The part could only be used one time. Set
I am just starting to learn Unit Testing. My custom graph references BAccount, Customer, and about 10 other tables which need data in them. For example, to create a customer, I need to have a Customer Class. The customer class has to reference GL accounts. (Joe falls down the rabbit hole and is never seen again).It would be a MONUMENTAL task to create the data in the caches. I’ve scoured the internet to see if I can use an actual database to use for tests. Is there any way to attach to the sample data in SQL server? If not, then Unit Testing is pretty much useless. In order to get my application certified for the Marketplace, I’m supposed to provide Unit Tests. That is just not feasible. My testing requires a full set of data like is provided in the Acumatica sample data.Any suggestions?
Do you have the ability to log email to Acumatica ERP without CRM installed?
I would like to display the Day of the week in a GI, Either display, Sunday, Monday, Tuesday, etc… or display, 1, 2, 3, Where 1 is equal the first day of the week etc… So for Document Date, I would like to see Document Date Document Day10/6/2023 Monday
Hi everyone,Currently trying to get our version of Acumatica into a sandbox environment so that I can work on customizations without messing up the live environment. However, I keep running into issues and the latest one is that acumatica says I’m missing a file and that’s the reason why I can’t publish anything. Not sure how that’s possible As I downloaded a snapshot and used that in the installation process. We are on version 2022 R2.Error Message I get is: An error on the page ~/Pages/LP/LP303000.aspx with the message: Cannot access the uploaded file. Failed to get the latest revision of the file 592af516-fdab-4bb2-9c7e-3f71618f0f3eIf anyone knows how to fix this that would be much appreciated. Kind regards, Jacob
CSAttributeDetail shipTypeDetail = new PXSelect<CSAttributeDetail, Where<CSAttributeDetail.attributeID, Equal<Required<CSAttributeDetail.attributeID>>, And<CSAttributeDetail.valueID, Equal<Required<CSAttributeDetail.valueID>>>>> (Base).Select("MFGPRPALLE", attributeID.Value); What is the best way above code use in PXSelector ?
I am trying to populate the dynamic material no based on this above report condition. #region TransactionDate [PXDate()] [PXUIField(DisplayName = "Transaction Date")] [PXUnboundDefault(typeof(Today))] public virtual DateTime? TransactionDate { get; set; } public abstract class transactionDate : PX.Data.BQL.BqlDateTime.Field<transactionDate> { } #endregion #region Status [PXString(1, IsFixed = true)] [PXUIField(DisplayName = "Status")] [PXDefault("H")] [PXStringList( new string[] { DocStatus.Hold, DocStatus.Balanced }, new string[] { "On Hold", "Balanced" })] public virtual string Status { get; set; } public abstract class status : PX.Da
I got the next problem. I got report in which i have two field ProjectCD and TaskCD. TaskCD is not required and if it not selected it should show all task that project have.I i run it only using subreport everything look goodWithout task selectedWith task selected But for main report if i don’t select Task it alway will show first one. But if i will select task it will show selected task There are my params for main report for Task Collection that i send to subreport And params for subreport And the view that i use for calculation values [Serializable] [PXCacheName(CAMSPMProjectDetailsTransactionsTaskIDViewCacheName)] public class CAMSPMProjectDetailsTransactionsTaskIDView : IBqlTable { private const string CAMSPMProjectDetailsTransactionsTaskIDViewCacheName = "Project Details Transactions Task View"; #region ProjectID [PXDBInt(IsKey = true)] public virtual int? ProjectID { get; set; } public abstract class projectID : BqlInt.Field<project
How to create business events for GI. And that GI contains Date parameter.For example i need to display the Sales order Total and Invoice total in one GI and for that i have added one filter condition which is displaying weekly wise Total of Sales amount and Invoice paid amount. So fot that i need to create a business events which can trigerred to client every week by weekly wise.
Hi, we have 2 non-stock items in a record in the sales order screen. we need to display these non-stock items in the Proforma Invoice report. we have created a sub report and added it to the main report to get non-stock items. here is the visible expression for the section. and here is the condition to the text field “Freight & Misc”.there is also a Variable called counter.when we run the report, it displays the text field for every single non-stock item record. Can anyone please let me know is there anyway to avoid this and display “Freight & Misc” field only once.Thank you.
Hi There,I’m a newbie - trying to setup a dev instance.I have downloaded and installed a trial instance of Acumatica on a VM - it is unlicenced so comes with the limitations that go with that. I have test data deployed as well.I can communicate with the instance on the VM from my Dev Machine - for example open the web interface and use Acumatica’s built in screens. All that works fine.I’m currently using http rather than https.I am now looking to integrate via the OData APIs with my application. And the first step of that is to communicate via Postman with it.If I use the entity API (ie: URLs like this one http://192.168.1.149/AcumaticaDemoDB/entity/Default/22.200.001/Customer) - it works fine (once I’ve done the login request of course) and I can pull data.However - I am getting nowhere with the OData API. A request like this one for example http://AcumaticaVM/AcumaticaDemoDB/OData4/$metadatagets a 401 Unauthorized response.I’m using BasicAuth in the header cookies using the same user
Hi team,I've added a custom selector field in the stock item screen. This field displays location IDs based on the selected warehouse in the grid. However, there's an issue: when I change the warehouse, the field doesn't refresh automatically. I'm looking for an auto-refresh property, but it seems not to be available in the grid editor properties. Could you please assist me in achieving automatic field refresh? I've also tried using a custom attribute, but the issue persists.I am using the code provided below. #region UsrBinLocation [PXUIField(DisplayName = "Bin Location")] [PXSelector( typeof(Search<INLocation.locationID, Where<INLocation.siteID, Equal<Current<INItemRep.replenishmentSourceSiteID>>>>), typeof(INLocation.locationCD), typeof(INLocation.descr), DescriptionField = typeof(INLocation.descr), SubstituteKey = typeof(INLocation.locationCD))] public virtual int? UsrBinLocation { get; set; } public abstract cl
Hi, For RC Orders in Sales order Screen, Basically when we bring the values from “Invoice Filter” Action it brings inventory items with invoice Nbrs in SOLine. And it Sometimes displays errror message on Qty feild “The return quantity exceeds the quantity available for return for the related invoice line AR010261, FOODCHIP36. Decrease the quantity in the current line, or in the corresponding line of another return document or documents AR010308, AR010316 that exist for the invoice line”, i Have also created another Action button in the grid,that works excatly like invoice filter action, i can bring the inventory items with invoice id to the SOLine grid, But i cannot display the error message that is being displayed with “Add Invoice Action” , Upon doing some R&D, i came to know that the error message is being displayed from “MemoCheck()” Methrod of “SOOrderItemAvailabilityExtension” graph, Hear is the sample code public virtual bool MemoCheck(SOLine line, bool persis
I have an integration that has been working fine since our launch. We are new to the system, 3 weeks in. I have started getting an error on GET calls to /SalesInvoice/Invoice/[invoice id] on some invoice ids. More than one entity satisfies the conditionThis happens on a very small percentage of our invoices. And of course in the UI there is only one invoice with the IDAny suggestions on how to handle this? Or, the cause?
I voided a check in Acumatica accidentally. The check has cleared the bank already, so I cleared it in the bank reconciliation. However, there was a void issued the same day for this check. Because of the timing, the check cleared the bank, and now I have a Voided Check that is “stuck” in an unreconciled status in Acumatica’s bank recon. How do I unvoid this voided check to clear out my recon?
Meet Daryl Bowman our Acumatica Community Featured Member for September 2023. It’s great to have you as part of the Acumatica Community @darylbowman!Hey Acumatica community, I've enjoyed reading about the other featured members, and now I guess it's my turn to share. I choose to spend a significant amount of time on the community site to gain experience and grow my personal brand, all while helping others in the process. The Acumatica community is truly something special. I owe my start in Acumatica due to the company that I worked for, at the time, becoming a VAR. I pivoted from the internal IT team to focusing more on implementing Acumatica. I took several training paths and became certified as a Technical Consultant and System Administrator. After a few years of being a VAR, the company’s priorities moved away from implementation, and I focused my Acumatica expertise on improving the usability of Acumatica internally for the company instead. I had already learned the basics of progr
