Solved

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.

Business case:  Get multiple invoices from same vendor with same dollar amounts. Approver has to click into each invoice to see invoice number. If you click into the invoice, it then reverts the invoices you marked as approved back to blank. Very tedious and time consuming. The vendor invoice number field is NOT available to select in the Column Configuration screen. 

Hello there I voided on the 20th October instead of voiding it on 30 April. How do I correct this 

Hello All,I have been trying to setup and synchronise the consolidation process in Acumatica.I have been using the U100 and Sales Demo data for this and I want to setup the same for U100 instance. I would like to consolidate the data for the Actual ledger of Headoffice with the consolidation ledger of Sales Demo instance.For this I created a consolidation ledger in the Sales Demo instance. Imported the COA of Headoffice to the Sales Demo instance.Here in the above screenshot, I have entered the Username, pwd and the URL for the Sales Demo instance.And upon synchronising the following error is getting triggered:  Kindly let me know what is it I am missing during the process.Thank you in advance.

I do not have access to the Acumatica DB on SQL using SSIS.  Is there a way to backup the entire Acumatica DB and then restore it to a test system from inside of Acumatica?I am thinking there is not.  But I want to be sure.Thank you, 

Need to invisible the field “Bill” in ‘Document Type dropdown’ when selecting ‘AR’ as Module. and also It shouldn’t affect the visibility when selecting ‘AP’ as the module. (logic applicable only for ‘AR’)How can I achieve this. Any Code snippets/ ideas?Make field “Bill” invisible when selecting AR Make field “Bill” visible when selecting AP (as prevailing) 

Hey everyone, I’m currently working on this error and trying a few different things on the Shipstation Configuration settings as well as the the Acumatica to Shopify Entity settings. I’m not seeing it at all on the community so I figured I’d post it here while I work on it. If anyone has any suggestions, please send them my way.  This shipment cannot sync due to this error. It seems to only be an issue on a handful of shipments but it’s possible that this might be a continued error. “Error on errors : All fulfillment orders must have the same delivery method type. Multiple delivery method types ["none", "shipping"] were found.;”

HiI’d like to create a new Mailing ID but I could not find the screen where these records are managed. Is this possible? (they can be selected via the Customers screen, on the Mailing & Printing tab) I did find the table used to store the Mailing ID records: NotificationSetup. The existing records were created by screen SM209900, but I couldn’t load this screen via the UI.Have experimented by adding a record manually to NotifiationSetup via a DB script, seems to work but not sure if this is a recommended approach.My other option is to override an existing Mailing ID, which is my Plan B at this stage.  ThanksJames 

Hello All,I have been facing an issue where i have created a report of 19 pages but for some of my records the report gets duplicate multiple times. Basically it is based on the number of line items. If there are 2 line items my report pages get duplicated twice. But i sm unable how to resolve this. Attaching the zip file of the report.

We are trying to hunt down an issue that pops up with a user being unable to clock out.  When you go to clock entry, find the production order, and the user it returns the current clocked in step.  When you click clock out it spins for a sec and doesnt nothing.  When you go to trace it says Cant add data into AmClockTranDac.  However, if the user puts in a qty of 1, it will work.  This seems to happen most frequently to this one user.  I have looked at her employee record and user rights and they are similar to other users in the team.  Any thoughts?