Hello experts,I would like to have guidance from you as whenever we are about to deploy a new instance, the first configuration to be done is from the financial module. But how shall we configure the financial module from start to last? I would like to know the steps. Thank you in advance.
I thought that the only time a View gets populated with records if is you make a call to “View.Select()” or if the View references a “fromcurrent”.In the following simplified example, I have a graph with a view. When I run a SelectFrom statement, without referencing the view, the view gets populated with records and I don’t know why.PXGraph joesGraphin the joesGraph there is a view:public SelectFrom<ICSARAddressSQL>.View JoesView;In my method, I use a fluent BQL to fetch records in the ICSARAddressSQL table (which is actually a SQL View) where the customerAddressID is equal to “item” where item is the CustomerAddressID I am fetching. Then I check to see if that record is in the joesView cache. If it is ALREADY in the cache I update the cache record. Otherwise I add it to the cache in the ELSE section.foreach (ICSARAddressSQL record in SelectFrom<ICSARAddressSQL>.Where<ICSARAddressSQL.customerAddressID.IsEqual<@P.AsInt>>.View.Select(joesGraph, item)){
My production ticket seems too be splitting locations of the same items and I’m trying to find ways to correct that. I also would like help to find a way to sort locations as well so I can have people pick from the same general area of where the items are by and not have them going all over the place when the sheet doesn’t have it in order.
@Irina or someone, I am looking for advise/KB articles or anything else that can help me determine why a report is running so slow. I know it could be the joins, subreports etc but I am hoping for someone to point out the typical culprits.My report takes about a minute + to run, has two subreports and only a few tables that are joined as recommended. Any assistance would be greatly appreciated.
I need to make some fields like Promise On Date, POLine Quantity editable when the Purchase Order is on the specific Purchase Order status is Open.How can I achieve this ??Thanks
Hey Folks,Couldn’t find much on this, so wanted to see if anyone had any thoughts:In template item creation, under the “matrix item” tab, it is picking up the “last cost” and it seems to push this to Shopify as the product cost even though the item has a ‘current’ cost defined under the Stock Item: These particular items have a “Current Cost” but not a “Last Cost”: Do we happen to know why the Shopify Connector uses the Last Cost and not Current? Are we supposed to be updating the cost to “last cost” routinely?Cheers,k2
Hello Everyone,I’m publishing POS on my ERP but the publication is not reaching the final stage.It’s reaching this stage as shown below and does not proceed from there. If I reload the page, I get this error(The session has expired. Please reload the page.) and the customization is shown as published on customization project screen.But this causes POS to misbehave and be erroneous.Kindly assist for it is urgentThank you all
@Anacarina Calvo Does anyone know how to link a refund to a service order? If a refund is issued at some point in the SVO history I am unable to know that it exists without this link. For some unknown reason I can link this customer refund to a SO but in the SVO tab the fields are unusable. Baffling…
Hi,I developed a custom screen as below.As you can see in the above screen shot, I have already saved some records to the database for the above mentioned reference number. After adding and saving record to the database as above, i need to keep the all fillable fields as non editable.I tried to accomplish this task by putting the following event handler.protected void APProforma_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (APProforma)e.Row; APProforma item = SelectFrom<APProforma>.Where<APProforma.refNbr.IsEqual<APProforma.refNbr>>.View.Select(this, row.RefNbr); if (item.RefNbr != null) { //row.Currency = item.RefNbr; APProformas.AllowInsert = false; APProformas.AllowSelect = false; APProformas.AllowDelete = false; APProformas.AllowUpdate = false; APProformaItems.AllowInsert = fals
Hello expert.How cant I get data field in the “details” tab screen AP301000 below image? How can i fetch data each row? Thank you so much.
Get Started HERE and be sure toIntroduce Yourself
Acumatica User Groups
Educational Resources
What you may have missed in the Acumatica Community! February, 2023
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.