Discussion Forums

Hi there,We can’t release AP retainage due to error message of “Error: Inserting  'AP Transactions' record raised at least one error. Please review the errors.Error: 'Subaccount' cannot be empty.”Below is the retainage image from original invoiceThe journal entry from original invoice. Could you please advise? Thank you. 

Based on the attachment provided, the "Select," "Prime," and "Enterprise" modules allow for a maximum of 5 additional tenants to be included. Given that we have 14 tenants, it seems we exceed the allowable number for any of these modules.Could you please confirm if there is any flexibility or exception that would allow us to include all 14 tenants in a single quotation under one of these modules ("Select," "Prime," or "Enterprise")? Alternatively, we would appreciate any guidance on the best approach to accommodate all 14 tenants within the current framework.

Is there any way to use the unit rate specified in Project Revenue Budget below as billing rate in TM billing? 

Hi everyone,I have a client who operates with an Acumatica SaaS with two tenants in a single instance: Tenant 1 (the trading company) and Tenant 2 (the manufacturer). The current setup is as follows:Tenant 1 purchases products from Tenant 2. Tenant 2 manufactures the products and makes them available to Tenant 1.Currently, Tenant 1 needs to view information on all shipments prepared by Tenant 2. I understand that it is not possible to view data from another tenant using a Generic Inquiry in Tenant 1.Users can only access their own tenant, so having them log into both tenants is not a viable option.Given this, what would be the best way to manage and view shipment data prepared in Tenant 2 from Tenant 1? I appreciate any suggestions based on your experience.Best regards,

I have code that I want to run after a long running operation completes, if a method in the long running operation returns ‘true’, to show a simple error message popup.PXLongOperation.WaitCompletion(key);PXLongOperation.WaitCompletion(key); seems to be what I need, but I can’t figure out what to use for the key. When I use ‘this’ as shown in the screenshow, it doesn’t find the long running operation and proceeds to skip over the error message code since the variable value will be null.What am I doing wrong here?

Hi, Is there a way to change the Placed-in Service date for several newly created assets while converting them from the purchase screen? I know you can manually change them, but when you are creating multiple units, it would be nice to have a way to do a mass update. :)  Any suggestion? Thank you

Is there a Monthly Sales Report by Ship to State? 

We need to build Import Scenario to upload Sales Categories to screen IN204060, but the screen is not available for selection in build 23.206, as you can see in this image:This is the screen in build 23.112, where we were able to import data to the Sales Categories:The screen itself is fully functional for manual data entry.Thanks for looking into this.

We have two Acumatica Tenants.  The first Tenant is our live Production Acumatica Tenant.  The second Acumatica Tenant is our “test tenant” we use to train employees.   Our live Production tenant is connected to our live production Big Commerce Website.  I want to connect our second Acumatica Test Tenant to a second Big Commerce Sand box.  And leave this connection permantly in place to do testing.  Can I connect my Second Acumatica test tenant to a second Big Commerce website Sandbox?  Is there risk of polluting of messing up my orginal live connection?    

Hello Experts, I am stuck on one of the process and i am not getting a clear idea how to create a issue transaction  from a request. Actually i thought of using Business event but was unable to create, can anyone help me out from this .

Hello, I recently made a copy of a report and uploaded it to the server and it broke both the original and new report. All I did in the new report was hide fields. The steps I took are listed below. Am I missing something critical that would make both reports break? I would appreciate any advice you can give me.  -Download original report (PM651500)-Rename it and save it to another file location (new name PM651550)-Hide fields-Upload to the server with the new report name -Create the site map location copying the original except for changing the screen name to PM.65.15.50 and the URL to match the screen name -Grant access to the new screen  Thanks!

hello, I am trying to see a history of exports done by a user as well as see what data users are exporting is there a feature in acumatica that allows this.  

Is there a function that can be used in Import Scenarios to return the ISO 8601 Week Number (equivalent to Excel’s ISOWEEKNUM function) for any given date in the import file - or better still, the Acumatica WeekID , being the ISO week number in YYYYWW format for a given date?I’m trying to create an import scenario to append lines to Equipment Time Cards, but the source data only has date but not week ID.(Site is not using custom weeks).I’d rather not have to write a complicated nest of DateAdd this, DayOfWeek that, Year this, DateDiff that if I can avoid it!  

Hello Community, I had a question while performing a customization to auto update inventory during shipments of certain types. I thought I could just set the condition for Update IN during the confirmed state to true, but it doesn’t seem to allow me. How do I go about getting the “Auto-Run Allowed” enabled for me to set that auto run condition to true?Thanks,Adam

How to add link from Sharepoint’s file to Acumatica in every transactions. Please see the snip attached for your reference. Thank you. 

This seems like one of those simple requests.  I actually did this for the same client on SOLine but on CROpportunityProducts I’m not having any luck.This works when new line added to CROpportunityProducts: protected virtual void CROpportunityProducts_Quantity_FieldDefaulting(PXCache sender, PXFieldDefaultingEventArgs e, PXFieldDefaulting baseEvent) { baseEvent?.Invoke(sender, e); CROpportunityProducts row = e.Row as CROpportunityProducts; if (row == null) return; if (!row.Quantity.HasValue && Base.IsImport != true) { e.NewValue = row.Quantity = 1M; } }But when inventory item is selected, quantity goes back to 0.  I saw there is an attribute (PXDBOpportunityProductQuantityAttribute) so I’ve attempted every combination of removing/overriding this using CacheAttached.  This doesn’t work: [PXDefault(TypeCode.Decimal, "0.0")] [PXUIField(DisplayName = "Quantity", Visib

When creating a Bill from a PO Receipt, sometime the PO Receipt Number hyperlink exists and sometimes it does not, and I cannot work out what causes it to be sometimes missing: 

Hey everyone, it’s me again!   Still working through a few import scenarios.   In my most recent Sales Order load, we are importing data from another source that already calculates the tax.  So i have created a tax, tax zone, tax category that is a $0 tax (“MOD”), so that I could then ‘create’ a tax line with the appropriate amount.   The import scenario properly handles the order and assigns this tax category to the line and the SO creates a ‘tax line’:  The challenge is the “Tax Amount”.  It is not populating the Tax Amount   XML is attached.Thank you in advance for taking a look! 

For General: SOAP has GeneralPrimaryContact, GeneralAccountInfo, GeneralAccountAddress, GeneralAccountInfoPhoneType1, GeneralAdditionalAccountInfoPhone1Type, GeneralAdditionalAccountInfoExtRefNbrFor Billing: SOAP has BillingBillToInfo, BillingBillToAddressFor Shipping: SOAP has ShippingShipToInfo, ShippingShipToAddressWhere are these in REST?  Do I need to $expand something to have access?  What are the names?Also, what the difference between a MainContact and PrimaryContact?

See the picture below. I am trying to add these values to a Dashboard, and I’m not sure where to pull this data from. 

When creating a new user and giving him permissions, even admin permissions, no previous transaction appears on any screen

We just switched over to Acumatica and processed our first payroll in the system. After processing, I realized an error in the HSA deduction/direct deposit where the HSA deduction is essentially being doubled up. In our old system, we could tie the HSA deduction to a specific HSA direct deposit account, so the amount specified in the deduction set up was automatically directed toward the account set up under the HSA direct deposit code. Acumatica apparently does not have the ability to do this, so our implementation team advised us to set up the HSA account under direct deposits, and specify the dollar amount to deposit into the account with the remainder going to the regular checking account. Unfortunately, this is actually doubling up on the HSA deduction.For example, say an employee’s net pay was $1,000, including an HSA deduction of $25. They should actually receive $1,000 in their bank account because the HSA deduction was already factored into the calculation of their net wages.

We are looking at outsourcing payroll and I wanted to here from others about what they are using.  We are a construction company and do work in multiple states.  We are currently looking at the following:WorkForce GoMiterLumberPlease let me know your thoughts if you use any of these softwares. Thanks,Jeff G.

Hello,How can I print a report a specific number of times based on a dynamic value in Preferences?I've created a Processing Screen for printing reports, and I need the report to print as many times as the count specified in the Processing Screen.Can anyone please suggest a solution or provide sample code for this?Regards. 

I’m working on a generic inquiry that will ultimately become a report.  I’m joining PMBudget & PMTran so that I can report transactions for a period, total transactions, and budget info.  I’m doing a full join between PMBudget & PMTRAN wherePMTran.ProjectID = PMBudget.ProjectID andPMTran.TaskID = PMBudget.ProjectTaskID andPMTran.CostCodeID = PMBudget.CostCodeID andPMTran.AccountGroupID = PMBudget.AccountGroupIDThe result is giving me all records from PMTran and is correctly populating nul amounts for the budget items that haven’t been budgeted.  But I’m not getting records where PMBudget has a value and PMTran doesn’t (ie, I’ve budgeted for an amount but haven’t incurred any costs yet).The Full join should populate both sides of the join with null values but isn’t.The impact is that the query is showing the total costs for a project but not the complete budget.I’m sure I’m missing something.  Any suggestions?