Solved

I have a customization that creates a CSV file and stores that as an uploaded file in Acumatica.Is there a way to automate so that when that file is created that it will automatically be downloaded to a shared folder?Alternatively, is there a way I can connect to Acumatica via web api and have my external web api connection automatically download a file?  (the file name varies based on the creation date)I tried setting Synchronization of File Maintenance, but that does not work the way I want it to.BTW, a second question is : In WHAT table are all uploaded files stored in Acumatica? Below is a screen shot I took of where I located the “name” of the files I want to automatically download from the [dbo].[UploadFile] table in Acumatica.  However, I do not know where those actual files are stored and how to pull them down in an automated way.  It is highlighted in the screen shot, and there are multiple files of this again, based on the date in the file name.(yes, I actually want to DL all

 From the Invoice screenshot below you can our user can create invoices but invoice data is not visible. Is this a permission issue?  Thanks,Tom  

We have a scenario on hand.   Assume that we have a Template Item SKU as Parent001 with three combination SKUs as follows: Child001Child002Child003Each of these products is being sold at a base price of $20Next let us say on the Sales Prices screen we have defined a quantity break of 5 and a price of $16.  On the Sales Order, if we add Child001 with the quantity as 10, then the price reflects as expected to show it as $16 each.   Our customer has a requirement that if someone buys 3 qty of Child001 and another 3 qty of Child002, thus exceeding the break qty of 5 defined at the Template parent level, the Sales Prices should kick in since the discounted break qty price is based defined at the parent level.   Any thoughts here to achieve without a customization?   Thanks in advance !!!     

The customer has created one GI that stopped displaying the data of adjustment Qty “tranPtdQtyAdjusted” after disabling this field Include in Qty Available in the warehouse screen. Does this field have any relation to Table "InItemSiteHist" of storing issue and Adjustment qty?

Why has the ability to link 2 separate sales orders to 1 single purchase order been removed?We have many vendors that have a free shipping dollar amount threshold. We have many customers that send in multiple purchase orders throughout the day for the same product line.  Sometimes 2, 3, or even 4 separate orders.  We used to be able to take all the customer’s purchase orders, create sales orders, and link their sales orders to a single purchase order, place the order with the vendor and get free shipping for our customers.  We no longer can do this without making a workaround.The workaround is as follows and it is truly ludicrous to have to do:1. Create 3 separate sales orders for the customer’s purchase orders from the day​​​​​​​Put all the sales order line items onto 1 purchase order. Send the purchase order over to the vendor. “Break” apart the purchase order into 3 separate purchase order internally Re-link those new purchase orders to the separate purchase order HOPE that you can

Does anyone know if there is a report in Acumatica that will list any unreleased/pending bills and expense claims for a specific project? We have run into several situations where the Project Manager or CEO completes the project not knowing whether all costs have been posted/released to the project. I have to go back and look at the Automation Schedule History to see if anything has not released. Want to try and be proactive before the project is closed/completed.

We are moving from an older ERP to Acumatica. One of the things we had in our old system that when we printed a Work Order the printout would print to our Dot Matrix DFX-9000 and also print the WO confirmation onto our Canon iR-ADV. This is also the case with our remote locations as they would print a WO that would print to the dot matrix and also the local Canon. It would also in certain instances trigger a third print that would print the confirmation at head office as well. We have device hub setup with all the printers and everything works as long as it’s going to one printer. How would we trigger when certain reports are printed it also prints copies to different printers at the same time. For example Florida location prints a Work order to the dot matrix, once that happens it knows to trigger another report to print the confirmation to the Florida Canon and also the Canon in NY.This is the same for invoices, needs to print locally and at head office accounting as well. 

Cost Roll History by BOM ID provides cost information by Cost Roll date (although I do not like the fact that it rolls the total cost from subassemblies into the materials category for the finished goods).  Now my question: does anyone know how to view a Multi Level BOM Costed on a specific date.  Sure you can change the date in the report but that only pulls in the correct revision of the BOM ID, it does not retrieve the inventory id cost as of that date.  Am I missing something?  

I am new to Acumatica and am struggling to get a selector working in the purchase order screen. I want to add a customer field to the screen in the header area. I have created a custom field and want to use a selector to allow the user to choose the customer for the PO. Here is the custom field:        [PXDBString]        [PXUIField(DisplayName = "Customer")]        [PXSelector(typeof(SearchFor<Customer.bAccountID>                             .In<SelectFrom<MOSCustomerProject>                             .InnerJoin<BAccount>                             .On<Customer.bAccountID.IsEqual<BAccount.bAccountID>>>),                    new Type[] {                        typeof(Customer.bAccountID),                        typeof(BAccount.acctName)                    },                    DescriptionField = typeof(BAccount.acctName),                    SubstituteKey = typeof(BAccount.bAccountID))]The issue that I am having is that the selector does not get pop

 Hi all, I want to create Trial Balance by Period in ARM Report, but I have a problem with account Income and Liability, they show as plus sign then total beginning balance and ending balance not equal to 0.My purpose is to have a report exact data to Trial Balance Report (GL632000) and can filter from period to period. I have total debit and credit equal but my beginning balance and ending balance I expect it equal to 0.Can anyone help me solve this

How to implement Drag & drop functionality on the grid ?

There is an old video on the topic of Customer Refunds where the user goes through about five or six steps to issue a refund to a customer.  And it works great!  However, there were too many steps and Acumatica appears to have simplified the process in subsequent releases.So now, in my 2021 R2 demo database, when the credit memo is on the screen, there is an option on the ...More menu to REFUND the amount to the customer.  I’ve done that and I see a JE that shows AR was debited and Cash was credited but I don’t see where a check was actually issued to the customer.  I can’t find a pending payment in payables but the JE looks like is was processed as a check.The whole point of this exercise is to issue a refund check to the customer and I’m just not seeing it.  What am I missing here?

Hello, I’m trying to use UnBoundFormula to aggregate some values in a detail DAC and save the result to a custom field in a header DAC. Below is my extension to the qty field on the SOLineSplit DAC. I want get the sum of allocated lines, and write this to usrQtyAllocated on SOLineExt.public class SO_SOLineSplit_ExistingColumn : PXCacheExtension<PX.Objects.SO.SOLineSplit>{ [PXMergeAttributes(Method = MergeMethod.Append)] [PXUnboundFormula( typeof(Switch<Case<Where<SOLineSplit.isAllocated, Equal<True>>, SOLineSplit.qty>, decimal0>), typeof(SumCalc<SOLineExt.usrQtyAllocated>))] public Decimal? Qty { get; set; }}Below is the definition of the custom field on SOLine where I want to write the total.public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>{ [PXDBQuantity()] [PXUIField(DisplayName = "Qty Allocated", IsReadOnly = true)] [PXDefault(TypeCode.Decimal, "0.0")] public virtual Decimal? UsrQtyAllocated { get; set; } public abstrac

Hi Team,I have customized a screen to pull data from another System to Acumatica. I want to schedule the action button which is higlighted below. could you please let me know how I can do this.Nite: Need to schedule the action button to pull the data from another system to Acumatica.  Regards,Ramya

So it looks like move completed the WO, and then an employee closed the WO before the move was released. What should i do here… Error below: The WO WO128702 production order with the Closed status cannot be used in this process.  

Hi there,I have a scenario where I need to invoice one shipment on three different invoices, as our sales rep has agreed that the customer can pay over three months.Is this possible, rather than just creating one invoice and telling the customer to pay in equal instalments over three months

Hi Community,I have an issue with the Push Notifications it is not hitting in my local URL with Webhooks.I’m able to add a new Push notificaition and configure the URL with the https://webhook.site/ and it is working fine and getting the updated details as shown below when making changes in Manufacturer tab. Now I’m trying to do the same in my local in a ASP .NET Core Web API project I have written a small POST request and updated the URL in the Push notifications Tab, but every time I edit or add a new Manufacturer it is being listed in Process Push Notifications tab with an error message:“Send to target TestWebhook failed. Message: Send to web hook fails. Error: An error occurred while sending the request.” My local URL: https://localhost:7262/Manufacturer/PostManufacturerUpdate  Please let me know if I’m missing any steps or is there anyting wrong with my POST request or if there is any issue related to Webhooks so that I can resolve this issue.Thanks in advance.!!!

Hello Community,I have been trying to record a payment manually under Payments & Applications form but not able to add the Sales Orders. I checked out in other demo instance, but it does allow me to add. Not able to add SOAble to add SOPlease let me know if there’s anything I am missing out here.Thanks in advance.

What I am looking to do is simple, I want to have a workspace item which, when clicked, opens an external URL I specify in the same tab.Note : I do not want the external website to be embedded in my Acumatica screen(The external website doesn’t support that).I’ve tried several different things, but none have quite worked.One approach I took is creating a new Screen and then adding in the below code to the aspx.cs code behind file’s  Page_Load callback. This got me very close but there is a pesky popup message when I try opening the page before the redirect happens.    protected void Page_Load(object sender, EventArgs e)    {        System.Web.HttpContext context = System.Web.HttpContext.Current;        String url = "https://www.acumatica.com";        context.Response.Clear();        context.Response.Write("<script language=javascript>");        context.Response.Write(String.Format("window.open(\"{0}\",\"{1}\");", url, "_top"));        context.Response.Write("</script>");   

Is there a way to rotate an image in stock items screen also known as ID CST.IN.20.25PL?

Hi Everyone,  We are looking to have our calendar year set to the 4/4/5 method but the taxes are filed based on a Fiscal Year.  Is it possible to get Trail balances and Financial statements based on a Fiscal year while the Financial year setup in the system is 4/4/5?

Hello, I am dealing with the issue that issue material cost based on Lot and Serial Number. I issue the material with the lot and serial number but it keep getting the Average cost of that material. Reference is below. Can some one help me with these issue. Thanks  

Hello,I am trying to export Sales Orders to Salesforce using the Salesforce Sync Data Provider. It’s mostly working as expected, but I am having an issue with the “Details” tab.I want to export all the Inventory ID’s on the order to a field in Salesforce I made called “Inventory_ID__c”. I setup the field like I normally would, but I’m noticing that it’s only the last Inventory ID that’s actually syncing to to the field in Salesforce. How do I tell the export scenario to “combine” and export all inventory ID’s?Attached is my current export scenario. thanks!

When having to select segment 2 of a subaccount , linked to the Employee master, the logical step would be to add the default location ( For vendor) and then link that to GL.Sub. Even when using substring/ left/ right , the result is blank. Fortunately , there are a DAC that already has this info: Employee (EPEmployee)And I am sure the DAC’s exist for other business accounts where this is required

Client had a clerk mistakenly enter 1000 sales orders.  Is there a way to wipe the slate clean without going into each sales order and deleting?