Skip to main content

Discussion Forums

Get inspired and gain all the knowledge you need

15778 Topics
H
Captain II
HarshitaCaptain II
asked in Everything Else
How to convert the field to accept Alphanumeric characters

Hello experts,i have been trying to enter the Tax ID that should accept alphanumeric characters. But the system is triggering the following error: Kindly let me know how to resolve this. Thank you in advance.

6
H
Captain II
1 year ago
H
Captain II
HarshitaCaptain II
asked in Distribution
Complete order in Sales Orders (SO301000) screen

Hello linkies,I would like to have a clarification on the Complete Order option which under More Menu of the Sales Orders(SO301000) screen.  I have been trying to modify the status of an order from Open to Completed without creating any shipments.Even when the Completed checkbox is active at the line level, the status of the Sales Order still remains to be Open as shown below: Kindly let me know the use of Complete Order option for the same. Thank you in advance.

6
H
Captain II
1 year ago
D
Jr Varsity III
dgross54Jr Varsity III
asked in Reports and Generic Inquires
Report Designer performance troubleshooting

@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. 

7
D
Jr Varsity II
1 year ago
A
Freshman II
aidenwills15Freshman II
asked in Reports and Generic Inquires
Adding Salesmen Parameter to AR Aging report not working

Hello all,I am attempting to add a salesmen parameter to my AR Aging report so I can run that report as it is relevant to each salesman. I have attempted to add a parameter, however it still returns all invoices, and not just the invoices based on the salesmen entered into the parameter. Here is how it is currently set up -As stated, the report returns all invoices regardless on the salesperson ID entered into the parameter. Thanks all!

6
A
Freshman II
1 year ago
NAthukorala47
Jr Varsity III
NAthukorala47Jr Varsity III
asked in Distribution
Access Rights Update via Import Scenario

Hi,  I have updated the Access right via Import scenario. It updated high level access security. Ex. We enabled Funds Transfers as view only, but, system allow us to do the reverse when i open the funds transfer form. Is there any possibility to restrict all the levels at once? Regards    

3
Chris Hackett
Community Manager
1 year ago
V
Jr Varsity III
victoravila63Jr Varsity III
asked in Distribution
how create a transfer from sales order

Hello: how create a transfer from sales order, but the item comes from secondary warehouse? Best regards

3
V
Jr Varsity III
1 year ago
J
Jr Varsity II
jsieberJr Varsity II
asked in Configuration and Installation
Multifactor Authentication with Authenticator App

I’d like to setup Multi-factor authentication for all users in our tenant. I see options for sending an email or SMS but I would prefer using an authenticator app such as Microsoft Authenticator. Is this possible and I’m just not finding how to set this up?

3
J
Jr Varsity II
1 year ago
C
Freshman I
ctrabada28Freshman I
asked in Configuration and Installation
Need to add employee ID to project inquiry but keep getting a reference number

I need to add the project manager employee ID (AcctCD)  to the PM-Projects GI but keep getting the Account ID (BAccountID) instead. This is my setup. EPEmployee is linked to PMProject. How do I get the employee id that starts with “E”? 

4
meganfriesen37
Captain II
1 year ago
A
Freshman II
abaker86Freshman II
asked in Develop Customizations
Multiple copies of report printing from one transaction

We just very recently had an issue come up where we have two copies of a production label printing from one production transaction. We are not looking for multiple copies and it is very hit or miss with transactions either printing one or two labels when performing a transaction. Has anyone else seen this or know of a setting I am unaware of? TIA

6
A
Freshman II
1 year ago
E
Varsity I
eddiedacoVarsity I
asked in Develop Customizations
Problem with smart panel

Hi, Good night. I have a simple smart panel with a grid with checkbox. If in my datasource i use “AggregateTo” the checkbox (for some reason) turned into readOnly (and i cant select the values) and when y delete “AggregateTo” the checkbox works fine. Can you help me please? I need to group by the result. my query/datasource public SelectFrom<Contact> .InnerJoin<CEBidPackageManagementPhaseCodeDetail> .On<CEBidPackageManagementPhaseCodeDetail.contactId.IsEqual<Contact.contactID>> .InnerJoin<CEBidPackageManagementPhaseCode> .On<CEBidPackageManagementPhaseCodeDetail.idBidPackageManagementPhaseCode.IsEqual<CEBidPackageManagementPhaseCode.id>> .Where<CEBidPackageManagementPhaseCodeDetail.bidPackageNbr.IsNotEqual<CEBidPackage.estimateNbr.FromCurrent>.And<CEBidPackageManagementPhaseCode.idPhaseCode.IsEqual<CEBidPackageManagementPhaseCode.idPhaseCode.FromCurrent>>>

2
Chris Hackett
Community Manager
1 year ago
S
Jr Varsity II
steph23Jr Varsity II
asked in Distribution
Sales price worksheet error when processing the field UOM

We are trying to extract and update the base sales price using either ‘Sales price’ or in the ‘Sales price worksheet’ then using the copy prices option.  When we click on the ‘create worksheet’ or ‘copy prices’ we get the below error:An error occurred during processing of the field UOM value LENGTH Error: UOM 'LENGTH' cannot be found in the system. Please verify whether you have proper access rights to this object.We have tried to change the UOM for the rows with Length but we just get the same error but with the UOM we changed it to mentioned.Any suggestions?

3
Chris Hackett
Community Manager
1 year ago
C
Jr Varsity II
cdelacruzJr Varsity II
asked in Develop Integrations with Web Services | APIs
Reference Nbr API Error in Payment Details after upgrading to 2021R2

Hi,We recently upgraded to 2021R2 and I am now unable to apply invoices to a payment via the API.The invoice can be applied manually without issue. I am seeing this error message:"An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'IN150421' cannot be found in the system.\nPX.Data.PXOuterException: An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'IN150421' cannot be found in the system.", This is the PUT command, using Default/17.200.001/Payment {  "ReferenceNbr":{"value":"013185"},  "DocumentsToApply":[                       {                        "AmountPaid": {"value" : "641.99" },                        "DocType": {"value": "Invoice" },                        "ReferenceNbr": {"value" : "IN150421" }                    }                   ]} Thanks in Advance for any help.

7
Chris Hackett
Community Manager
1 year ago
P
Freshman II
philr75Freshman II
asked in Manufacturing
Multiple Production Clock Entry, Operations Tab Production Link Not Working

I’m attempting to troubleshoot a problem we’re seeing on a client site running 22.205.0026 where the production order hyperlink on the Operations Tab of the Multiple Production Clock Entry form does not create the pop-up for the order. On the Clock Entries tab, the link will work. More puzzling is that I’ve tried the link on different sites and do not have the problem (one was the same release as mentioned above).I believe I’ve added the site to my pop up allow list for the browser. I’ve tried different browsers after checking the pop up setting. I’ve made sure all customizations were unpublished and still cannot click that particular hyperlink. I’ve also experimented with production order type settings to see if that has any affect but have not found a setting that has any impact on the link problem.Has anyone else encountered the issue? I’ve been combing through the known issues list and am not finding a specific topic that explains this problem. 

6
Chris Hackett
Community Manager
1 year ago
A
Freshman II
aidenwills15Freshman II
asked in Distribution
Price Multiplier not working correctly

Hello all, The price multiplier does not seem to work when I change the UOM. I have ensured to enable it in the SO preferences, and the item has a value in the price multiplier. Am I missing anything?Item at base UOMItem when UOM is changedPrice settings in SO PreferencesConversion setupAny help would be greatly appreciated. Thanks!

0
A
Freshman II
1 year ago
M
Freshman I
Mle45Freshman I
asked in Manufacturing
Receive partial stock-item to inventory from outsite processing

For the Production with Outside Processing process, can we partially receive stock items and have them show On-hand in the warehouse with the purchase order on Open status?  I’ve done all the steps as guided, but on step 10, when creating the Move transaction, the received stock items don’t show up on the warehouse (on-hand) until the purchase order status is changed to completed or closed. We would like to have the purchase order open and continue receiving items from the vendor until the order is fully received. Are there any settings/steps that I’m missing?  Thank you,  

3
Chris Hackett
Community Manager
1 year ago
J
Jdavis64
asked in Manufacturing
MRP Detail Inquiry Missing Information 2022 R2

We just upgraded to 2022 R2 and we’re having issues with MRP detail inquiry not pulling in Qty On Hand, Safety stock, Replenishment source, Replenishment warehouse, Transfer lead time.  This is happening intermittently.  I can run MRP and it won’t plan correctly on a particular part and rerun and it will plan correctly.  We are utilizing multiple warehouse and the items are set up correctly in Item Warehouse Details replenishment settings.

2
Chris Hackett
Community Manager
1 year ago
Denham
Jr Varsity II
Denham
asked in Develop Customizations
Change SO Status through workflow based on SO Line conditions

Hello everyone!I am trying to customize our SO workflow to change the state of a sales order based on conditions of sales order lines. By default I am not able to reference any of the SO Line fields in a condition for the SO301000 screen. Is there a way to add the SO Line fields so that I may reference them in a condition to automate the workflow changing the order status?For example I want to set up a condition like this:SO Line Description contains “Bar”ANDSO Line Qty over “200”Any and all help with this will be greatly appreciated! 

5
Denham
Jr Varsity II
1 year ago
tahirsiddiqui190
Freshman I
tahirsiddiqui190Freshman I
asked in Reports and Generic Inquires
Row Not correctly Highlighted GI

 

3
Chris Hackett
Community Manager
1 year ago
Kandy Beatty
Captain II
Kandy BeattyCaptain II
asked in Distribution
Default Transfer location

Does anyone know of or have a work around for default locations for transfers? I am talking specifically for automated operations. Acumatica has a default Issue from and Receipt to but there are no other defaults that I can see.  

5
Chris Hackett
Community Manager
1 year ago
param2022
Jr Varsity II
param2022Jr Varsity II
asked in Develop Customizations
Stop user from saving when there is an exception on Purchase request screen

I don’t want user to save the record if there is any error, I wrote a custom fieldverifying event for the RQRequestLine and it works fine when the values is selected however, it allows user to save the record event if there is rowpersisting event written that calls fieldVerifying event. protected void RQRequestLine_RowPersisting(PXCache cache, PXRowPersistingEventArgs e) { var row = (RQRequestLine)e.Row; if (row != null) { object newValue = row.ExpenseAcctID; this.Base.Lines.Cache.RaiseFieldVerifying<RQRequestLine.expenseAcctID>(row, ref newValue); } }protected void RQRequestLine_ExpenseAcctID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e){ // logic cache.RaiseExceptionHandling<RQRequestLine.expenseAcctID>(row, Act?.AccountCD, new PXSetPropertyException(Messages.Test, PXErrorLevel.Error, row.Expen

4
Chris Hackett
Community Manager
1 year ago
J
Varsity II
jwarrenVarsity II
asked in Financials
Changed Valuation Method from Average to Standard

We recently migrated all our SKUs from average to standard costing due to average costs getting all mixed up. We did this by issuing out all of the inventory, updating costing to standard and entering a receipt back in. I am running the inventory valuation report but continuing to see the inventory valued at average cost rather than the new standard cost of the SKU for many items. One example is the following SKU:L175:Standard Cost - $42QTY on Hand - 425Expected Cost - $17,850 Cost per Valuation ReportAverage Cost - $235QTY on Hand - 425Cost on Inventory Valuation Report - $99,875 This appears to be an issue for all SKUs with an INCost ValMethod of “A”.Any reason why this INCost ValMethod would remain as average despite the SKU having been changed to Standard Cost?

5
L
Varsity I
1 year ago
R
Semi-Pro III
raphrfSemi-Pro III
asked in Reports and Generic Inquires
Generic inquiries - Add Attribute Value ID

Hi, In the Result Grid Tab, when i add a column and I set it to the attribute, it show the Attribute description by default. How to show the Attibute Value ID instead of the Description?I already tried a lot of workaround like Attibute.Value without any succes.I don’t want to use “schema field” because i will need to put this in formula .My starting point is from the Non stock list PX.Objects.IN.InventoryItemThanks  

5
Chris Hackett
Community Manager
1 year ago
Michaelh
Semi-Pro II
MichaelhSemi-Pro II
asked in Other Developer Topics
How do I change the order of actions in Process Shipments

I have actions from my SHIPMENTS screen that are carrying over to PROCESS SHIPMENTS. Hooray! How do I change the order of those actions in the PROCESS SHIPMENTS screen? I would assume a customization, but I’ve not touched processing screens much and am trying to avoid making a mess. Any advice is greatly appreciated.

4
Michaelh
Semi-Pro II
1 year ago
J
Varsity I
jessicaASAVarsity I
asked in Payroll
WA Cares Payroll Tax Implementation

Hello - does anyone know if the WA Cares tax for Washington state will be included in a future Tax Maintenance update? We are running payroll the first business day after the effective date, so we are very interested in the timing if this involves a Tax Maintenance update. Thank you.

2
K
Acumatica Employee
1 year ago
M
Semi-Pro I
malinthawarnakulasooriya08Semi-Pro I
asked in Reports and Generic Inquires
Why are status Balanced typed invoices' reference numbers not in the "Select-reference number" of the report parameters section?

New InvoiceI created above Commercial Invoice report by using the ar641000.rpx.Below screenshot shows the relevant parameter and filters used for this invoice report.Used Parameters  Used FiltersBut when passing the reference number as the report parameters to generate this Commercial Invoice Reports, the Balanced status type Invoice reference numbers not show in the “Select-reference number” list. Please check the below screenshots.Sales order Invoices ListStatus type Balanced Ref Numbers Not FoundBut I want to display all the reference numbers in the Sales Order Invoices in the section of report parameters “SELECT-Reference Number” . So please give me some guidance to overcome this issue. Thank you.

3
Chris Hackett
Community Manager
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings