Solved

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.

I am relatively new to Acumatica...I am still very much a novice when it comes to searching for solutions in this user community.How does my organization modify/customize the “welcome” screen (see screenshot below).  Some of the information appears to be stale/out of date or of no interest to my end-users.  Would like to link with my own documents/wikis etc.Can someone point me in the right direction on how to make changes to this page   

I want to know if I do not have the Projects module licensed and I want a similar option that is the Account Groups under the Chart of Accounts function what can I use to further group my GL Accounts.

We are beginning to add stock items to service orders. These items are being marked for PO, and we are then generating a PO for the items. When the items arrive, they are allocated to the service order. How do these items get depleted from inventory? When I complete the SOR, these inventory items seem to get unallocated but they don’t actually deplete from inventory? I must be missing something here?

Hello, i have seen that discounts in blanket order are only possible on row level. Is it planned in the future that discounts in the blanket order are also possible for the whole document?The background is that our customers have a lot of lines in the blanket orders and it is very cumbersome to enter a discount for each line. Is there possibly a workaround for this?

Hello!I have this visible expression here. What if I need to specify many values in this conditional statement, where or how should I place them? Thanks so much in advance!