Discussion Forums

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? 

How is it possible to invoke the “Create Child Orders” action using the REST API?

HiReally appreciated if you can share your experiences and how you manage them specialy about the CONSRegardsPrasad

Hi Acumatica community,This is more for my personal interest/because I like to understand things.  I figured a long time developer might know. In-between when I initially sat I320 and when I’m redoing it now, the guidance in the course changed.The new guidance is to send 1 request, with a double expand if you’re retrieving records from. So I have 2 questions:When did the guidance change? Why did the guidance change? (Technical perspective) I spend a fair amount of time explaining reasons for choices to implementers/developers, and while I’ll certainly follow I320 it helps to understand why the guidance changed. Screenshot of i320 Question: Suppose you need to retrieve detail lines & shipment lines of multiple sales orders. 

Hi Guys, As you all probably do, we have a few images within our email signatures. Is there any way to default the outlook add-in to not attach these images as files? Thanks,Aleks

Can you require a file attachment to certain transaction screens - Bills and Adjustments, Purchase Orders...Client wants to force a file attachment be done. If the user forgets, they want the system to give an error message. Please advise. 

It appears that our inventory is not relieved/backflushed until an Invoice transaction is made. Is there a way for the backflush to happen on Shipment, and not on invoice? I’m hoping there is a setting somewhere I am missing.  

I've tried this GET method but I just get an invalid type cast error:https://sandbox.com/entity/Default/22.200.001/Customer?$expand=PrimaryContact&$filter=PrimaryContact.Email eq 'kylelauridsen86@gmail.com'

When I try to open a Sales Order, I get the An item with the same key has already been added error. As the New Record button works, I was sure the extensions of DACs and Graph of Sales Orders screen do not contain any problematic code. Even more, the same error message can occur when there is no any package published. Investigating the Generic Inquiry of SO3010PL, I found repetitive lines in Navigation Parameters section of NAVIGATION tab I still wonder how the duplicate lines could be added because when I try to add a record manually I get the The value of this field must be unique among all records. error. I decided to remove the repetitive lines. After that deletion, the SO3010PL GI allowed me to open the Sales Order Document via Order Nbr. field.