Solved

Saw this message in 23.110 in file upload window. It doesn’t have any impact on functions, but please let me know what this message means and how to resolve it.   

Does anyone know if the ProGlove Mark 3 scanner is compatible with the Acumatica mobile app? https://proglove.com/products/hardware/mark-3/

Hi All,Need to clear the data view in the graph in the beginning. Currently following view returns data from the table. But I need to remove coming data from the view and show the grid empty(As per attached image).public SelectFrom<HMRCVendorRegisterDetail>.View VendorRegisterDetail_X;Can someone help me out?Thanks

Is there functionality on the Customer Portal that allows the Customer to upload sales order lines to the cart,  similar to the sales order upload process?This client’s customers will have sales orders with 100plus lines and would like to allow for an import since the customer uses excel to buildout the order on their end.Wondering if anyone has encountered this as well?  

When I prepared invoice in shipment I got this error: Another process has added the 'ARInvoice' record. Please try again.

So first off let me lay out my scenario. I work for a food Distribution company. We special order items for customers weekly. Once they arrive to the warehouse, they are manually shipped out to the customer based on when their next order is placed in the system.  I am looking for a way to have them added to the order when it is created. Meaning…. the salesmen creates their normal order, but does not add the special order item. Since that customer has a order out there (ORDER TYPE NS) for the special item when he creates the normal Sales order that is routed on a truck for delivery i would like some type of scenario where when their normal Sales order is in an open state it will add the special order item on there. SO far I have created a GI that pulls my SO’s that ship out that day and on the same GI its listed my special orders that are for that customer. Currently I'm manually creating a new order and manually adding it to the truck every night. I would like a way for this “smart sys

Hi,I need to trim a part from the string in my report field.This is my report I need to show ST2-MATERIAL HANDLING   -GST value as MATERIAL HANDLINGand ST2-AGRICULTURE PNEUMATI   -GRN as AGRICULTURE PNEUMATI How can i do from the report designer in acumatica

The warning popup did not appear when attempting to add the BA after converting the opportunity into project quotes, despite initially adding only the address instead of the BA.

Hi everyone,I have been working through an issue that has me stumped where on the invoice report, it is assigning a completely random ship-via code to drop shipments.Ship Via displayed on the printed invoice Ship Via on the freight details on the invoice As you can see, it doesn't match up. However, I did some more digging and realized that it isn't even recognizing the shipment type.Shipment type on the printed invoiceShipment type on the freight details on the invoiceHere is the relationship between SOShipment and SOFreightDetail in report writer. Thanks for the help!

Is there a way to override AR Cash Discount? Payments is not letting me enter cash discount amounts. I am getting the error “The amount entered exceeds the remaining cash discount balance” I am assuming that this is due to the fact that the payment date is greater than the Cash discount date. Can this be overridden?

Hello all,  I am new here, I am trying to connect SQL with Acumatica for the first time but I have been unable to do it. I’d appreciate any advice. This is the message I get… 

I have a few processing screens that I’ve created recently that I just noticed recently don’t update their progress until the processing is completely finished. For example, if I process 25 records, the progress bar will spin indeterminately with 25 ‘remaining’ until it has completely finished, and then all 25 will be ‘processed’.This does not strike me as being normal behavior, but I wanted to check in to see if anyone else has experienced this or if I am doing something wrong. I am working with 22.209

Hi,I added the user defied field (UsrFlag) in the POLine table, I've extended the Endpoint to add the custom field. How I can pass the user defied field to the PurchaseOrderDetail class using the Custom property? Thanks,Ev

Hello - One of our properties has a new procedure for invoices, and wants to send an email to all of the vendors for their property. They are all designated to a specific vendor class that only that property can see. Is there a way to generate an email that would automatically pull in all email addresses from each individual vendor within that vendor class, so we can send a mass email with the new instructions?Thanks!

an error occured while importing data into table  i swill back up data  but this erorr , why ?,can  help me , what this problem ?thanks

I know I just asked a similar question recently, but I am still having an issue.  I really need to be able to use a dynamic value in the PXSelectBase command.In this code, I am overriding a PXSelectBase command. (public delegate PXSelectBase GetShipmentsSelectCommandDelegate(SOShipmentFilter filter);)  One of my overrides works, but the one with the GroupBy / Having clause fails.This one works.  Note that the And is pulling from the ICSProcShipPref.QtyLessThan field in my custom table. If I change the value in the table, the result set comes back as I would expect.  This allows me to use a dynamic amount to be selected based on the value in the table at run time (not have to use a constant).  cmd = new SelectFrom<SOShipment>. InnerJoin<INSite>.On<SOShipment.FK.Site>. InnerJoin<Customer>.On<SOShipment.customerID.IsEqual<Customer.bAccountID>>.SingleTableOnly. InnerJoin<SOOrderShipment>.On<SOOrderShipment.shipmentNbr.IsEqual<SOShipment.shipm

Hello Community,I have been trying out either to modify the $TotalAmountSpelling variable expression in the report designer tool or just create a similar one. But I am unable to get a clear view of what logic shall I apply so that the system generates spellings for amounts.Thanks in advance. 

Does anyone know how to permanently set the screen to display more records ie. vertically?  Some of the screen has a scrollbar on the side to scroll up/down for more records although there are still a lot of room at the bottom of the screen.For example, this screen the bottom part still has a lot of room and I can only drag the line down for a few more rows: I can zoom in on my browser to display more records vertically but then the font size becomes too small to read.  Please advise if there is a way to modify the screen to display more rows (ie. permanently).  Thanks...

Hello all, I have come across a special need that requires changing of “Time” field in EP317000. The graph is EPWeeklyCrewTimeEntry, the DAC is EPActivityApprove (driven from PMTimeActivity) and the field in question is Date. This is one of those fields that has DateTime value but in the UI Date part and Time Part are displayed in two different columns of the grid. Out of the box, these two fields carry a DisplayName of the “Date” and the “Time” that absolutely makes sense. But for a very good business case reason, we need to change the “Time” column DisplayName to “Hours”. When I look at the field property on the UI the platform assigns “Date_Time” name to the “Time” column but in reality, such a field does not exist at all. So the question is how can I change the name of a field that does not exist in DAC. Just to be clear I am not referring to bound and unbound properties. The “Date_Time” is a made up column name that does not exist in DAC. I need to 1) change the DisplayName presum

I am working on a customization that will change the appointments summary (FS400100) page ordering to descending instead of ascending which it is currently (this build is 23.108).  While i was working on this issue, I realized that it is sorting in descending order on Build 23.111.0019. This does not make sense as the business logic is identical. I also unpublished all the builds on both instances to make sure that a different customization wast the causing this. Was this fixed in the new build? or am i missing something. Thank you

We need to migrate from the 2018r2 acumatic version to 2023r1, with certain custom options included in the original versions, which is the best strategy to migrate a large version difference.

how to clients currently handle tracking emergency contacts for employees?is this best done via attributes? love to hear others thoughts!

The Track Expiration Date on Lot/Serial Class already Created is Grayed out . Is It Possible to Activate it ? Why it is Grayed out  

Other than the SOOrder table, what other table(s) contain the ShipVia_Carrier_description? I am modifying the invoice (AR641000) to match what we need for emailing out and one of the fields that needs to be on the form is the Ship Via description. If possible, I would like to not use the SOOrder and feel that if it is on the SOOrder, then it should be somewhere on the ARInvoice, which appears to be not the case. I have combed over the following tables in the hope of finding it rather than mapping additional tables to the form:Branch, Address, ARTran, Contact, Customer, ARAddress, Terms, Note, EPEmployee, Location, ARInvoice, ARContact, PreferencesGeneral, BAccountNoMask, and CCPayLink which are the standard tables within AR641000.

Dear all has anyone integrated whatsapp with acumatica. I am on version 2022r2.