The table is AuditHistory, but it is not easily readable because of how Acumatica stores the audited data and columns in single fields. Here is a que...

The DeletedDatabaseRecord field is only available on master data, like Inventory Item, Customers, Vendors, etc so you won't be able to quickly see del...

I was able to use the Replace function to add the carriage return. I used a demo system to add a COLORS attribute to the stock item and then on the s...

I have no idea if this works, but have you tried to use a Replace() function to replace a comma with {br}. So it would look something like Replace([...

You could even use the Left() function in the visible expression. =Left([DAC.FIELDNAME],1)='W' or Left([DAC.FIELDNAME],1)='C' Kurt

The image is the import we used but for another processor. The only major difference I see is the Action:Cancel

The state field can be used where the state is active or online. I have a client where we disable/enable users between 7pm and 7am based on the state...

You can make the following joins to get to the warehouse address. SOShipment to INSite on SiteID INSite to Address on AddressID INSite also ha...

Paul, You could try creating an automation schedule of the Import Scenario in the Process Import Scenarios screen (SM206035) to prepare and import. ...

@idrus-m Adding the field to the grid on the screen is done through the customization project. I would recommend going through the T190 Acumatica cou...

@idrus-m Correct, the code above only adds the field to the data access class. You would still need to add the field to the grid on the screen. T...

Create a DAC extension off the INTran DAC and add the following code. Then you can add the Customer ID and name to the grid. using PX.Data; using ...

I did something similar for a demo, and it doesn't seem like you can have the side panel filter by line. As a result we loaded all lines in the side ...

Jonas, We have a client using the Kit Processing solution from BizTech. It provides a lot of options and allows you to explode the kit on the sales...

Try converting the time spent into decimal first using the formula CDec([PMTimeActivity.TimeSpent])/60. That should fix your issue. -Kurt

@OlgaM You will need a customization to color a cell or line on a screen that is not a generic inquiry. Below is a link to a Stack Overflow post on t...

Tim, Do you know if there are any metrics or articles from Acumatica that discuss potential performance issues with too many fields enabled? We hav...

Here is a customization package that adds the SQL view and DAC. This would be enough to use in an inquiry or report. Thanks, Kurt

It looks like you have an Inner join from ARTran to SOLine that might be causing the issue. Try changing it to Left and see if that fixes the problem...

You will need the CompanyID in the SQL view, but you do not need it in the DAC. Have you designated a key field in your DAC? There is a blog articl...

Like Kevin said the lot serial information is in multiple tables. We had a similar request from a client who needed lot numbers on several different ...

I've seen this quite a few times with our clients who have multiple tenants. For some reason some of the tenants will be marked as read-only and they...

I have a client that we are looking to setup the Amazon integration. I'm struggling to fully understand how to get a developer account setup. I thou...

Kevin, Can you turn on the setting in SO preferences to 'Add zero lines for items not in stock' to push all items to the shipment? Then you will have...

Did you check access rights to make sure someone didn't change permissions? Thanks Kurt

Acumatica has some info on how to fix this issue, but here is the quick fix. 1. Copy and paste chrome://flags/enable-lazy-frame-loading in the address...

The status field is actually stored as a single character in the database and the value for open is 'N'. Below is a screenshot from the code of all t...

Try joining POOrder.NoteID to EPApproval.RefNoteID. Thanks, Kurt

Try changing your Raise Event to 'For Each Record'. That should run your event for all records in the inquiry. Thanks, Kurt

Brett, We haven't upgraded or put any new clients on 2019 R1 yet so I'm not sure if it runs any better. I would recommend searching the known issues ...

The business events that are triggered on a record change are very temperamental and don't always work. If you are using 2018 R2 make sure you are on...

In the target property box you need to enter =blank.

Have you looked at a browser plugin to refresh the page every few seconds? It's not perfect but it may get the job done. -Kurt

Matt, It sounds like the attribute may be a combo box. If that is the case then you'll need to join to the CSAttributeDetail DAC on the AttributeID a...

Ellie, I went ahead and created a quick AP Payment import using a simple spreadsheet and demo data. Below are screenshots of the import scenario, t...

We usually create a simple bank account summary inquiry and then display the data table on a dashboard. Here is the inquiry using demo data. I usual...

Ellie, Below is a screenshot of a import I put together for one of our clients. I had to use the ignore error and make sure the document was on hol...

Tim, We had to manually edit default.aspx since the file is not located in the same virtual directory as their Acumatica instance. Thanks, Kurt

Russ, It looks like you are showing your automation schedule screen. For the New Customer event I would recommend setting the business event type t...

I thought I'd add my work around for another client since I saw this reference somewhere else. As noted by Nic and my previous post, you need a full...

Try removing the spaces and any special characters like the parenthesis from your SQL view column names and Acumatica DAC. For example, rename Invent...

Jerwin, You can use the Database Scripts section of a customization project to add a SQL view to a SaaS implementation. The help information is out...

Nicholas, Did you ever figure out how to get the URL to work in the PDF? It works fine when previewing as HTML, but once the file is converted to P...

I had a similar request from a client who wanted to print price labels for orders, but wanted to print a label for each item so we had to multiply the...

I'm having similar issues in recent v6.1 builds where the page break is not working as expected with subreports. I have created similar reports in v5...