Discussion Forums

2 warehousesManufactured item had demand for 100I have none in the warehouse with demand.I have 100 in warehouse that does not have demand.Using MRPI want to create a production order to meet demand, UNLESS I have quantities in the second warehouse.  Then I want inventory planning to tell me to transfer these.Since the source is MFG, inventory planning tells me to build when I could do a transfer instead. Same question on purchased items.Is this a thing in Acumatica?Thanks!

I have a requirement to create a purchase receipt using Acumatica API.This is my code for that. RootObject obj = new RootObject(); obj.Type = "Receipt"; obj.VendorID = "GRI SL"; obj.VendorRef = "2131"; obj.Locatrion = "Main"; obj.ShipmentRef = "00028"; obj.Date = DateTime.ParseExact("10/10/2022", "dd/MM/yyyy",CultureInfo.InvariantCulture); obj.PostPeriod = DateTime.ParseExact("10/10/2022", "dd/MM/yyyy",CultureInfo.InvariantCulture); var jsonStrings = JsonConvert.SerializeObject(obj); PXTrace.WriteInformation(jsonStrings); var jsonString = JObject.Parse(jsonStrings); PXTrace.WriteInformation(jsonString.ToString()); var URL = "https://globalrubberindustrieslimited.acumatica.com/entity/CustomEndpoint/22.200.001/PurchaseReceipt"; var httpRequest = (HttpWebRequest)WebRequest.Create(URL); httpRequest.Method = "PUT"; httpRequest.ContentType = "application/json";

“New connection to support Shopify’s new payments platform is now available!We encourage you to act now by following these steps.You will need to make all changes by June 28, 2024, to prevent the payment card option at checkout from disappearing.”Shopify App: https://apps.shopify.com/authorize-netAnyone having issues with payment importation? (wrong processing center ID, no 10 digit trans key from auth.net) 

Hi,How the system selects the tax code for a change order created for a commitment update (Sub Contractors) ? Thanks,Dulanjana

Seems as though 24R2 Version of Acumatica has gotten rid or disabled the autocomplete function in fields?Not the biggest deal, but definitely a pain when trying to input information. Wondering if anyone is also struggling with this, and if there is a work around. Thanks!

Hi all,I have been trying to update the vendor item number on the vendor details tab on the stock item profile, specifically I would like to add a vendor item ID. However, because there is a vendor there, it gives me an error saying “An attempt was made to add a duplicate entry.”. I have followed a few other discussions on here (I linked the discussion that seemed to be most similar to my scenario), but I still cant get the vendor details to update. Here is a screenshot of my map -Any help would be greatly appreciated! Thank you. 

Hi TeamWe have a requirement where we want to update Acumatica Customer level attributes value (based on some configuration) while customer sync from BigCommerce to Acumatica.Can you please suggest what is the best possible way to achieve it.  Thank you in Advance!

Since an update from 2024 R2 207 to 2024 R2 208, backflushed material transactions are pulling material from the wrong location.  The component is lotted.  When there isn’t enough material on a single lot in the specified location to meet the requirement, the split transaction takes material from a location other than the one specified on the production order detail.We’ve opened a support case and it is with R&D.Just wondering if anyone else has encountered this issue.  It’s causing some major inventory issues.​@angierowley75 Thanks in advance,Laura 

Hi all,I’ve implemented a customization to the Physical Inventory Review screen.In short, the customization is to accomodate the odd occasion where lot tracked items have multiple batches on a single location (technically shouldn’t happen, but in a retail environment it’s impracticle to have multiple locations, so we operate on 1 shelf location).I’ve implemented the customization in such a way that the staff can count all of the lot numbers of a particular stock item into 1 ‘fake’ lot number. I’ve then added a new custom action to the menu, which allows them to distribute the counted line item across multiple lots.I’ve managed to get all this done & working correctly, EXCEPT that the screen doesn’t update the details section & totals section until such time that the screen is reloaded manually. Am I perhaps missing some call in the code to refresh the screen sections?PS. we are on Build 22.111.0020Any assistance is highly appreciated.Screen before & After clicking the Distr

Hi, I need the detail section to print by invoice due date:Due in the next 7 days print firstDue over 7 days print secondAnything already overdue print last. I have created 3 detail sections and for each section have added a visible expression:=([ARInvoice.Status] = 'N') And (DateDiff('d', Today(),[ARInvoice.DueDate]) > '0' And DateDiff('d', Today(),[ARInvoice.DueDate]) < '8') =([ARInvoice.Status] = 'N') And (DateDiff('d', Today(),[ARInvoice.DueDate]) > '7') =([ARInvoice.Status] = 'N') And (DateDiff('d', Today(),[ARInvoice.DueDate]) <= '0') however when I run the report it prints in the wrong order  I have also tried to do this as a group with the same result using a nested IIF statement and only 1 detail section.=IIf( DateDiff('d', Today(),[ARInvoice.DueDate]) > '0' And DateDiff('d', Today(),[ARInvoice.DueDate]) < '8', [ARInvoice.DueDate],IIf (DateDiff('d', Today(),[ARInvoice.DueDate]) > '7',[ARInvoice.DueDate],IIf (DateDiff('d', Today(),[ARInvoice.DueDate]) <=

Hi,I want to give an access right for deleting row in Purchase Order form without giving the right to delete an PO(header).How to reach the Detail grid in order to set it to delete ? I don’t see it : 

Hello everyone,In the below popup(Bank deposit->Add payment), I have added a custom button(Update).In the button click, I will verify some conditions and I have to update the selected checkbox to true to the payments which are satisfied the conditions. But, I’m unable to update the checkbox to true. Below is the code i have tried. #region Event Handlers public PXAction<PaymentInfo> ImportPayment; [PXButton()] [PXUIField(DisplayName = "Update")] public virtual IEnumerable importPayment(PXAdapter adapter) { if (Base.AvailablePayments.Any()) { foreach (PaymentInfo paymentInfo1 in Base.AvailablePayments.Select()) { if (paymentInfo1.ExtRefNbr == "417028599")//Some conditions need to be checked to make selected checkbox true { paymentInfo1.Selected = true; // Base.AvailablePayments.Cache.Update(paymentInfo1);

I’m looking for a solution how to scan POD documents in bulk (300 pages at a time) and the system should store them in the proper SO within Acumatica (identifying the proper order number from the document bar code) and then email them together as page two when creating and sending invoices to our customers, we don't want to use a mobile app for signatures, we hand a piece of paper to the driver for every delivery and when they return the signed document we want to have them in the system and use it to email it together with the invoice as proof of receiving the goods, any idea how to accomplish this would be very helpful, do to the volume scanning and dragging each document wont be an option, Thank you.

Hello I want to override value of field Asset Class and Department of data class FAAccrualTran (screen FA504500)I implemented event handler RowInserting to set value for two fields: Asset Class and Department as following:protected void FAAccrualTran_RowInserting(PXCache cache, PXRowInsertingEventArgs e, PXRowInserting InvokeBaseHandler){ if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (FAAccrualTran)e.Row; if (row != null && row.GLTranInventoryID != null) { InventoryItem inventory = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, row.GLTranInventoryID); if (inventory != null) { var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventory); if (inventoryItemExt != null && inventoryItemExt.UsrDepartment != null) { cache.SetValueExt<F

When I click a particular Payment on the Checks and Payments screen, then go to the AP Payment Register report, then click the Send button, I would like to have a simple email template which populates data from the AP Payment Register report. Specifically, I would like to use the Vendor Name and Email Address and the Amount. I would also like the User’s Name in the email signature.I have tried two things.I created an email template based on the Checks and Payments screen and specified that in the AP Payment Register Report Designer. But none of the Data Fields I select in the email template work. The AP Payment Register Report screen does not appear to be available for the basis of an email template. Next, I scrapped the email template idea and tried to enter the email in the Report Designer Mail Settings fields. The problems here include not finding the Vendor Email Address and not being able to create the email Body with the line breaks and formatting desired.The email template optio

Hi - does anyone have any recommendations for a UK based Acumatica consultant who can help on UK VAT set up?

Hi, We need to update the Item Cost base on the FIFO cost method. Ex. Item A - 20 Qty with 10$ After add the Laded Cost Value for particular Item Cost, it would be 12$. Have there any possibility to update the Item cost manually? Since user already has completed the landed cost process without adding additional 2$.Now we need to update that additional 2$ to Item. RegardsNethupul  

I think the answer is no, but I have to ask.  Is there a way to disable a field in a grid, but not the entire column?If an item is not a stock item, I want to disable a field in a grid, but just for that row. 

Is there a way to have a certain payment type always post as a prepayment instead of a payment? For context:We create sales orders and send them to customers so they can pay for their items before they are delivered. The payments made through the integrated payment processor all post as "Payments" which creates a negative AR and really throws the AR Aging reports and overall AR out of whack. Especially since it can be a month or more before an animal is delivered and the SO is converted to an invoice, thus balancing out the AR. Manually generated payments can be posted as "Prepayments" and thereby coded to Customer Deposits instead of AR on receipt and don't cause that issue. Ideally, we'd have specific payment types automatically generate as "Prepayments" instead of "Payments" so that they post to our Customer Deposits account until the item is delivered and the transaction completed. Does anyone know if that is possible?

Where are the permissions to allow the adding of contacts on the Customer and/or Business Accounts screens?  I can add contacts on the Contacts screen in the Marketing workspace.

I'm having a hard time integrating Okta into Acumatica. Do you people  this is possible because I can't find the relevant documentation?. If you did, could you please give can i guide? Thanks a lot THiNGknghĩđộng từnghĩ, nghĩ ngợi, suy nghĩ, tưởng tượng, ý định

I was hoping to add the ability to filter by SOLine.InventoryID_description in the Sales Order Details by Customer report, but for the life of me i can’t get this field as an option. Following what online tips i could find I added this field to the Viewer Fields in the schema browser. Then I also placed it in the groupDetails section on the report itself at another recommendation. Every other writeup i can find is either putting it in as a parameter or a sorting option, neither of which is what im looking for.End result, our staff wants to be able to sort this report by keywords in the item description. Sales Order Details by Inventory Item doesnt work for us in this case because its layout is item-first instead of customer-first.I have my fingers crossed this is something simple im just not seeing as i don’t spend alot of time in report designer.

Is there a way to increase the qty shipped on a shipment record without first having to edit the original sales order?

Hi - Is there a way on the compliance management screen (CL401000) to only show vendors that are active?  Our compliance list is showing many vendors out of compliance, but many are inactive vendors we are no longer seeking documents for.  Another layer would be the ability to add the last transaction date for that vendor to help determine if they should be active or not.  I’m unable to edit this since it is not a regular GI.  I appreciate any help you can provide.

Is there a way to take information on the Stock Item page and display it on the line when that part is chosen for a Sales Order?