Discussion Forums

Hello,we are receiving a pdf of 2 pages from external application, so we would like to import only first page of it, so we are trying to use itext sharp to achieve this. we added reference using Nuget manger, we are getting below error when we trying to process it. Could not load file or assembly 'itextsharp, Version=5.5.13.4, Culture=neutral, PublicKeyToken=8354ae6d2174ddca' or one of its dependencies. The system cannot find the file specified.Please have a look at below code.using (MemoryStream memoryStream = new MemoryStream(data)){    PdfReader reader = new PdfReader(memoryStream);    using (MemoryStream outputStream = new MemoryStream())    {        Document document = new Document(reader.GetPageSizeWithRotation(1));        PdfCopy writer = new PdfCopy(document, outputStream);        document.Open();        PdfImportedPage page = writer.GetImportedPage(reader, 1);        writer.AddPa

Hi~I am tiring to customized Account Summary GL4010000 to excluded Branch information.My final purpose is grouping Account in that screen to see totals include every branch.Is it possible to realize it by my customization? or how can I change the hierarchy for Company/Branch into Company and Branch in the filter?Thanks!!!!

Hi All,We would like to display an error to the user if the Project Budget exceeds while adding the details in Purchase Order and stop them from removing it from hold.Acumatica does some calculation on page load and displays a warning when the budget is exceeded as shown below: This is the budget in the project: For the Project, Project Task, Cost Code and Account Group combination, the budget in project is 1500 but in PO is 1501, so it is displaying the warning message.There are other logic as well which I do not know yet and it is complex if I have to replicate the logic.My job is to see if the budget is exceeded or not if it is exceeding, I need to g

We are aware the leader boards are not presenting properly. The numbers are still accurate. For now the employee board has been disabled. A case has been opened with Gainsight support to resolve. I'll reply here when resolved. 

Hi All.  We are looking for a way to close refunds that remain open with an irrelevant balance on them. There is an option to Write Off invoices or memos, but not for refunds. Is there a way to add that option to refunds?Thanks, 

Is there a Business Event Notification option when a specific item is purchased? I have tried setting up an event but Item ID is not in any of the fields. Is there a way to add this as a field to track? Also, how do I attach the purchase order to the email notification? Reason: certain items require special handling and other departments need to be aware of the purchase when it takes place. 

Hello all,I am new to Acumatica. What is the recommended approach for bulk importing of data from external timekeeping systems into the Payroll module?Specifically, my company is a franchisee of QSRs and the majority of our timekeeping is performed at the restaurant level through our POS system. We can currently get the data exported from our system either as a CSV or JSON formats. My question is, what is the recommended approach for importing such data into Acumatica’s payroll module for processing? We do not plan on using the Timekeeping features of Acumatica at our restaurants and entering the data manually is entirely impractical given the number of employees, so neither of these options will work. The system does not seem to expose a Web Service endpoint that could be used, nor did I see an “Import Scenario” that would be appropriate for bulk import. Any suggestions?Thanks!

I am using Acumatica 24R1 and using 'default' endpoint version '23.200.001' entity 'Customer' using Bearer token authentication using jQuery ajax method, getting error 'request has been blocked by CORS policy', Same I have tried with postman and MVC C# application it is workingwith the following payloadgrant_type:passwrd scope:api username:xx Password:XX Client_ID:xxxxxxx client_secret:xxxxxandURL:{{AcumaticaInstance}}/identity/connect/token Type:POSTget the Bearer token in response and pass the token in below GET request to get the dataURL:{{AcumaticaInstance}}/entity/default/23.200.001/Customer Type:GETWhen I tried this process with postman or MVC application using C#, above both API calling is workingWhen I tried this process whiling using jQuery ajax method getting error 'request been blocked by CORS policy'

I have setup a business event to trigger by schedule, but in the Automation Schedules list it is NOT check marked under “Status” and I cannot figure out why the business event is not executing at all.Does anyone have any suggestions as to why this is NOT working?  

Mistakes were made when item classes were set up and some Stock Items were created as Model Equipment that should be Parts and vice versa. I know the setting is read only on the inventory item, but it doesn’t look like correcting the setting on the item class solves the problem either. Any ideas on how to correct this for existing stock items?

We create service orders and sales orders (type of SO), which then get invoiced from there.  We also create RC Sales Orders for Credit Memos, which are created in the SO workspace.  The invoices, once released, go into Receivables, but they bypass the Receivables approval process.We need approvals on all invoices and credit memos, not just the ones that are created directly in the Receivables workspace, and approvals are not available for SO invoices and CM’s.  Is there a way to put this in place?

I have setup an approval process for PPV (purchase price variance) in AP Bills.  I’m testing this and no Approval record is getting created: And the Bill is as follows: No approval has been created even though there is a 500 PPV.  Am I missing something?

can we generate a GI that includes all transactions with reason codes? We need to see all inventory adjustments and their associated reason codes, as well as write-offs and the reason codes used for them. Thank you!

Hi, quick questionI noticed an Project Allocation was done twice in August….. I tired to reverse 1 Allocation and it reversed in Sept……. How do i reverse a reversal to get it in same month? Is it possible to change a date when reversing an allocation?  

We have created a payment processor for cybersource secure acceptance and we implemented the classes: V2.ICCHostedPaymentFormProcessor V2.ICCTransactionGetter V2.ICCProfileCreator V2.ICCHostedPaymentFormResponseParserView original The issue we have now, is that after payment is done on cybersource, it returns back the response to the PaymentConnector.html which in turn perfom the next line window.parent.px_callback.paymentCallback('action=transactResponse&response=' + urlParams.get("ref") );this close the payment popup, but the payment it self not converted to completed, not sure why and when

Client has repeated error with sales orders with ship via of Walk in - when they go to create the shipmentThe sales order is created through the sales order screen SO301000 and the client uses a paper pick ticket, and the order is placed on hold for pick up.  The current work around is to create a new sales order and they are able to create a shipment.  This was a known issue from older versions, I tried the suggested work around of changing the quantity to zero and then back to one, but still received the error.  Any input is appreciated.The client is on 2024 R1 Build 24.111.0011Build 24.111.0011 Customization: ShopifyOrderNoteMapping2024922,ARPrintinvoices,PXLotSerialNbrAttributeExtPkg,AddKitAssemblyPickListtoScreen,DynBudAdaptors2023,LoginPageImages,longerDescription,SOscreen20240801,GTISOLineUpdater2420240723,KitAssemblyPickLis

We are creating ERP shipments in advance of actually shipping merchandise, and do not want the information to synchronize until shippments are confirmed.  We defined an export filter to limit the Big Commerce synchronization to only shipments that have been confirmed, however it is not working. When the filter below is active, ALL of the shipments are filtered.  Our version is 24.109.0016.   We also tried filtering on Status but with similar results.  Any thoughts what could be wrong?Thanks in advance!    

I am creating a customization on the sales order screen to collect some info on a smart panel and add it to custom fields on the line details. This is a low code project so I created the smart panel using the UI. I dropped a button on the action bar for the details grid. On the PopupPanel property of the button, I pointed it to the smartpanel by adding the ID there.  This all works great. When the button is clicked, the popup panel comes up. The only issue I am facing is that the information entered is always saved to only the first line on the details grid. It does not matter which line I have selected before clicking the button to open the popup panel. What am I missing?I am on Acumatica 2023 R2. 

Hello Community members!The SOLine table records the Price Type associated with the item at time of order (Customer or Customer Price Class). I’d like to also include the Customer Code or Customer Price Class associated with the item. Any thoughts on how this may be done?

On Shopify we arrange our variants in a certain order for many conversion related reasons such as cheapest first, what we want featured on collection pages (since it defaults to first variant of a product), most popular color first, putting a item line that’s mostly sold out last, etc. We always understood that Acumatica does not have its own variant priority/sort order, which is true as far as customizable, but we were fine managing that on Shopify side only. We have found however that template sync will rearrange all the variants on the product in Shopify even if there were no changes, if template is pushed, or if something else changed on the template.Things we have tried:1. Unmapping option 1,2,3 in template and stock item export mapping. This stops the variant order from being overwritten, but does not work since it doesn’t support any new variants being added or syncing a new product since it then pushes everything as an empty default with no attributes

I have a business event that has a subscriber that is an Import Scenario.  The GI that the Business Event uses has a few formulas in the results grid.  When designing the import scenario, all you can see for GI result grid lines that are formulas is something like “=[POReceiptLine_Formula5b2e0f32d4304e46852164172e23dab5]”.  Other than trial and error, does anyone know how to tell what the result grid line is?For example, the business event creates an inventory adjustment based on a GI that looks at PO Receipt Lines.  I have several formulas in the GI results grid.  One formula is multiplying the ReceiptQty by an attribute, and I gave it a Caption of “Ext. Cost”.  However, when I go into the business event subscriber’s import scenario to map that GI results grid line to the Adjustment’s Extended Cost field I don’t see “Ext Cost”, I just see the formula ID’s. I know I could put the formula in the Import Scenario, but if something in the formula needs to be modified I wan

Hello all,I have been looking out for ways where I have some stock items that have the qty more than 0. I am looking to mark them as 0. The only option that comes to my mind is to create Issue trxns. Are there any other options available? The end user is fine if GL trxns are created.

My AUNotificationTemplate table size is 10GB.We do hold a number of notification templates, none of them hold a full history (none of them even hold more than 10 executions in history).Does this table handle more than just automation notifications? What areas might I use to decrease the size of this table? Thanks!

Hi All!We are currently busy implementing ePODs for a customer with the help of Acumatica Mobile. With this we have extended the Shipments Entry (SO3020PL) and Shipments (SO302000) screen to the Mobile App. What we want to achieve is to create a custom action on the Shipments Entry screen that mimics the ScanBarcode action (which opens up a barcode scanner) on the IN202520 screen. We want to basically open the barcode scanner and then override it’s logic to scan the Barcode (which will be the Invoice Number) and then navigate to the related shipment that has this Invoice Number. I know this is a tall order but any advice on this would be greatful. Even only advising where I can look of how the BarCodeCameraScan behavior is stored in order for me to mimic how the scanner is opened:  Thanks! 

Hello all,I am looking to change the display name from “Description” to “Project Description”.added from here: But unable to do so. When I try to select the Customization attributes button it shows the below:How can I modify the name of this field?Thanks.