Solved

More and more people we cold call want to communicate thru text messaging. Is there a known 3rd party solution/integration that give us the ability to create and respond to text thru the Acumatica platform?

Hello! I’m having an issue with the sync between my BigCommerce store and my Acumatica Sandbox environment. I have a customer that will not sync to Bigcommerce. Previously it had been syncing to our Bigcommerce stores, but I believe that at one point the account on the Bigcommerce side had been deleted. Now, when I go to process data (or sync from sync history), the sync runs indefinitely. It does not throw an error, it just keeps going with no result. I’ve tried re-creating the customer in BigCommerce and changing the external ID on the sync to match the new one. That did not clear up the issue. Any ideas? 

Hello - I have a weird issue. We have a custom field on our PO form called “Requested By”. If I go to the PO screen and preview/print, the value appears perfectly. However whenever the PO form is sent via a business event that I created, the “Requested By” field shows but not the value for some strange reason. I confirmed the business event is pulling the same form ID than the one I see when I preview it from the PO screen, so I have no idea what could be causing this. Wondering if there is something I need to change on the form itself or perhaps the business event?

Good dayMy company updated to 2022 R1.  I have a number GIs that use the @Today function.  Does it still work in the upgrade version.  I was previously on 2020 R1.  Do I need to replace it with Today().  (Date/Time fields). Does anyone have a list of the 2022 R1 GI functions?Thank you@Evan G 

Hello!I’ve made some modifications to the Inventory Lookup smart panel in the Sales Order Screen.I added a new grid with a Split panel like this:The left grid shows the available attributes for the selected ItemClassID so that the users can search inventory items by it’s attributes.The “Search” button on the top of the attributes Grid, goes through the filtered Item list and gets the list of items that matches the user’s attribute selection.The problem is that I can’t update the right grid with the list of items.The Callbackcommand in the aspx is the following:<px:PXDSCallbackCommand Name="AttributeSearch" DependOnGrid="Attributes" Visible="False" />The button:<ActionBar> <CustomItems> <px:PXToolBarButton Text="Search" CommandName="AttributeSearch" DependOnGrid="Attributes" Visible=""> <AutoCallBack Command="AttributeSearch" Target="ds" /> </px:PXToolBarButton> </CustomItems></ActionBar>In the graph I try to

We have a unique situation where employees sometimes need pay advances for whatever reasons. These are usually paid back each pay period based on a fixed amount. I am wondering if anyone has dealt with this and what the best way would be to set this up in Acumatica Payroll so that repayment deductions can be made each pay period. 

Has anyone ever added the overall average to the footer of this report? I’ve tinkered with it but haven’t gotten it to work and was hoping someone else has already accomplished this and could share their report version. Thanks!

 “Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. Unable to read data from the transport connection.”Emails processing failing. Unable to get rid of the above errors. Kindly assist 

Hi everyone,In report of dunning letter (AR661000). I wonder how to show only the detail of the first invoice  which dunning level is 1 instead of showing all including level 0Thanks in advanced

Hello! I am looking for some help because I keeping seeing this error when we try to use the quick process function to create a shipment form an SO: “The document cannot be completely processed. Creating shipment. The given key was not present in the dictionary.” Anyone have any insight on what this means? Thanks in advance for the help!   

Hello experts,I want to add field FullName of DefBillContactID to selector of CustomerID I use the following code but it doesn’t work. [PXCustomizeSelectorColumns( typeof(PX.Objects.CR.BAccountR.acctCD), typeof(PX.Objects.CR.BAccountR.acctName), typeof(PX.Objects.CR.Address.addressLine1), typeof(PX.Objects.CR.Address.addressLine2), typeof(PX.Objects.CR.Address.postalCode), typeof(PX.Objects.AR.CustomerAttribute.Contact.phone1), typeof(PX.Objects.CR.Address.city), typeof(PX.Objects.CR.Address.countryID), typeof(PX.Objects.AR.CustomerAttribute.Location.taxRegistrationID), typeof(PX.Objects.AR.Customer.curyID), typeof(PX.Objects.AR.CustomerAttribute.Contact.attention), typeof(PX.Objects.AR.Customer.customerClassID), typeof(PX.Objects.AR.Customer.status), typeof(PX.Objects.AR.Customer.defBillContactID), typeof(PX.Objects

Hello, a few of our client have the same issue: when exporting shipment information from Acumatica to BigCommerce, the export fails, when there are 2 or more packages on the shipment, and no items are assigned to each box:The error on the export would be: The [shipment number] shipment could not be exported because the [tracking number] box has no items. Please delete this box or assign an item to it.Can we have Acumatica disregard any and all tracking numbers, UNLESS it’s the only tracking number (1 package on a shipment) or the package has items assigned?Thank you!

Hi,I have added the below dropdown in the customer location screen(AR303020) and the dropdown should have the sales Rep names from Salesperson screen.drop down should contain the below list.DAC name is SalesPerson, ​​​​​​  can someone help how to write the code for this. 

Hi,  I have a prepayment applied to a check and a partial bill that I need to void.  The prepayment doesn’t allow me to reverse the application and is requiring me to reverse it on the check level. However I can’t reverse the check application either since I don’t have what to apply it to.   

We seem to be having an issue with our reports changing balances for previous periods.  Our Aged Period Sensitive report under Receivables is no longer tying out to our Trial Balance Summary report.  This issue seems to go back to February 2022, and each month from February to November no longer agrees. The issue seems to be invoices that were credited in subsequent months.  For example, the February Summary Trial Balance report shows a balance for the AR Trade (account# 11000) of $3,852,680.46.  The Aged Period Sensitive Report under Receivables shows a balance of $3,805,177.77 for a difference of $47,502.69.  This variance is due to AR invoice #38530 now not being picked up on the Aged Period Sensitive report when you run it for February 2022. This invoice was credited in May 2022. Not sure why the Aged Period Balance is dropping invoice #38530 when run for February. At the end of each month we tie out our Trial Balance with our subsidiary ledgers to make sure they agree and I save t

Is there any ability to creating “recurring” Tasks in Acumatica? We have Tasks that happen every quarter and what we have to do is to “complete and follow up” and then update the start dates for the next quarter. Is there a way to add a Task and have it appear each month, quarter, year, etc. 

Hello,To solve a performance issue, I need to get VendorID list from this query :select distinct (VendorID)from APPayment, APRegisterwhereAPPayment.doctype='PPM'and status='N' -- Statut ouvert'and APPayment.RefNbr = APRegister.RefNbrand APPayment.DocType = APRegister.DocTypeTo comply Acumatica, I guess I have to use a DAC to do that. In a way, this DAC would we be a kind of reduced version of the APPayment DAC in which I just would need to embbed the following fields an not the other ones :- DocType,- VendorID,- StatusHence the title of this topic. Is it possible to do that in Acumatica ?

Our client is interested in using a 28 day billing period for a few of their service contracts.  Is there any way to set that up in Field Service?

Hi All, We are preparing for a client upgrade and need to find all modified reports. Is there a way in Acumatica that tells you all the modified forms and reports ? Thanks,Shyam.  

Hi, I need to add a field value in the customers form to my custom form. I tried using field selecting to achieve this but no value is populated to the custom form.custom form field needed to populatevalue needed from customer formprotected void NCPMCustomerMaster_Outstanding_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { NCPMCustomerMaster row = (NCPMCustomerMaster)e.Row; if (row != null) { Customer customerObj = PXSelect<Customer, Where<Customer.acctCD, Equal<Required<Customer.acctCD>>>>.Select(this, row.CustomerIntType); if (customerObj != null) { row.Outstanding = customerObj.Balance; } } } 

Not sure if I am missing something, but I have been having trouble overriding the SaveBucketImport method under 22r2 in the BC Connector.  The prior definitions did not include the optional parameter CancellationToken.The new original signature  looks like :public override async Task SaveBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, String operation, CancellationToken cancellationToken = default) In my extension I have public delegate Task SaveBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing, String operation, CancellationToken cancellationToken = default);        [PXOverride]        public virtual async Task SaveBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, String operation,  CancellationToken cancellationToken = default, SaveBucketImportDelegate baseMethod,) When i compile, it is indicating that the Optional parameter (CancellationToken) must be after the Required parameter (SaveBucketImportDelegate) - if i switch them around

Hello -- I am trying to locate the T100 dataset referenced in F350 training course.  Can someone direct me to the storage location?  Thank you!

Hi, I’m using this GET to get tue customer with the bill to and ship to addresses/entity/Default/18.200.001/Customer?$expand=MainContact,MainContact/Address,ShippingContact/Address,BillingContact/Address It works just fine, the only thing I noticed is that on each request I get the Address.id property (that looks like a guid) changes value Is this expected?What is the best way to get a unique ID of it? Thanks,Ignacio

Good morning,Our customer works with authorized.net.Their customers call in ahead of a sales and give them their credit card to be stored in Acumatica.So, our clients needs to be able to store multiple credit cards per customer ahead of the orderWhere would these credit cards be added and stored?Thank you!Monika

We currently have 11 Branches set up in our Acumatica but we wanted to export those sales orders created in Acumatica that is under one particular branch only to Bigcommerce. So, we created export filtering, see reference below. I tried creating sales order but seems to filter all orders instead of letting only SLC-APPL orders through.Is this supported by the native connection of Acumatica-Bigcommerce? Or any suggestion on how we can possibly do it?Thank you.