Solved

Hi community! I have a customer that does a lot of customer consignment. They basically need to receive items into Acumatica and integrate with Pacejet because of the high number of inbound shipments. Acumatica told me receipt type SO shipment is not supported with Pacejet so I’m wondering if anyone out there has experienced something similar.

“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) 

I would like to force AR Customer accounts to only transact in the currency for which they are set up. I.E. i have set up USD accounts for some customers and only want them to be invoiced and receipted in USD. If the customer wants to transact in another currency, we set up a separate account for them and they need to be restricted to only transact in that currency.  I know that what i am asking for defeats the object of multi currency accounting, but we operate in a strange economy where hyper inflation is a common thing and allowing someone to pay off an invoice raised in local currency, with another currency, opens a risk of arbitrage from our staff which we want to remove. Thanks in advance for any advice offered.   

Hi All, I am attempting to do an import that I know I have done before, but is not working currently! I have an existing open Sales Order (Status  = Open). On that order I want to populate the owner field. The keys being the order type and order number. I also added customer as I have had experiences in the past where for some reason, it throws an error is not there. Anyone have any thoughts?! Starting to go a little insane looking at it!  

Hi, As per the screenshot I need to change the sales value to the number value. It should be all numbers instead of 512.43K.Ex : 512.43K = 512,430        5.33 M =  53,300,000   

Hi community, The system I am creating sales orders on is having some discrepancies between the manually created sales orders and API-created sales orders. When the delivery route assigned to a customer has a trip the next day and you manually create a sales order with a Requested Date of next-day, the sales order auto-fills its Pick On date for today as expected. When doing it via API, it skips the next-day trip and auto-fills the Pick On date for the day before the next trip even if that is next month. I already set the PX-CbApiBusinessDate when creating the sales order and made sure the time zone is correct in my user profile. Is there something I can do like set the Created Date value of the sales order or adjust the date via API after the record is created? Please let me know if I need to clarify anything! Thank you.

Hi,We have a client who is using an external software for their Scale solution. Each day, they upload a file through an import scenario to upload the individual invoices through the Sales Order screen as we need to keep the same document ID when creating the invoice in Acumatica. I’ve create attributes within the SO header section to keep track of important information and we need to have those attribute to transfer over to the invoice document. During our test phase, I did create a Generic Inquiry to pull the Invoice ID and the attributes and a Business Event to do an import scenario to import the attribute values when the Sales Order have been invoiced. The business event was working without issues. Now that we have gone Live with Acumatica, the attributes are not importing in the Invoice document because the business event is giving the following error. “The last error was CustomerID cannot be blank.”. The weird part is, it will work when I execute each record individually within th

hi, I am working on a report. I have passed Parameter name “Items” which is attach with inventoryitems. When I am selecting Items in parameter and running reports its duplicating the grids two time (as shown in picture below) .In the QTY column i want user to select the QTY from parameter. that must be from 1-100. Is there any way to do that? If yes please guide me on this.  I wa unable to see my tables after creating relation between customer and address so I make relation of these tables like this as shown in picture is this causing the issue? I dont want to join Inventory table with any other. but without relation it was added but not shown.     

Hi All,I’m just getting started with the Test SDK, and I’m following the starter guide on GItHub (Acumatica/Test-SDK-Starter-Guide (github.com)) , but I cannot get past the “Could not read configuration file: Illegal characters in path.” error.  I updated the command line to point to the config file, I’ve downloaded the original project multiple times, but I keep hitting the same issue.Feel like I must be missing something simple.Error and Parameter shown in below screenshots. 

Is there any option or formula in Generic inquiry to know total number of line Bills of Material?

I want to add the address field to the selectors commonly used on the Contacts, Leads and Opportunity tables. I have to join the address table to make this happenI looked at this post, but don’t think it will allow me to join the additional table.Is there a way to add Contact.displayName to the columns in the Selector for the Customer Lookup in an SO? | Community (acumatica.com) It's a large effort to modify every field using a Contact, Lead or Opportunities to add this join and additional column, is this the only way? This is the code I am using for the Contact table ContactId field. it looks to work in most cases however when navigating to the contact screen from an opportunity when clicking on the contact field edit button (the pencil button) I get the following error.“Conversion failed when converting the nvarchar value 'Leif' to data type int.” Leif is my name, so that is a clue.     #region Contact_ContactID_CacheAttached [PXMergeAttributes(Method = MergeMethod.Merg

Looking for a way to send ACH payments without leaving Acumatica. Is this available?Basically some sort of integration with bank, or a way to automatically transmit the NACHA file. 

Hello I’m trying to update SalesOrder PurchasingDetails through this url: PUT method https://gtp.acumatica.com/entity/DefaultEndPoint/23.200.001/SalesOrder/?$Expand=Detailsusing this script:{    "id": "91bdadf9-ef21-ef11-835e-06ae6affe5a5",     "Details": [        {            "id": "c5ce115a-f021-ef11-835e-06ae6affe5a5",            "PurchasingDetails":            [                {                    "POOrderType":{"value":"SO"},                    "POOrderNbr":{"value":"Code-000396360"},                    "POOrderLineNbr":{"value":1},                    "Selected":{"value":true}                }            ],            "VendorID":{"value":"V10156"}        }                     ]    }i getting this error message: "innerException": {            "message": "An error has occurred.",            "exceptionMessage": "Purchase Order Line (Order Type = SO, OrderNbr = Code-000396360, LineNbr = 1) cannot be found in Purchasing Details for Sales Order line (LineNbr = 1).",            "exceptio

The user wants to use an RC Sales Order to return an item from a customer into the user’s inventory.  But it was a drop-ship originally from a vendor directly to the customer.  So the original sales order was Mark for PO and linked to a Drop-ship PO from vendor to customer.  Now, when processing the RC Sales Order to credit the customer and return the item to inventory, if they try to create a Receipt against the RC Sales Order, they get an error “Order RC R000xxx does not contain any items planned for receipt on date 05/29/2024”.  The system also won’t let them uncheck the “Mark for PO” box on the detail line of the RC Sales Order.  It seems like the only way to process the RC Sales Order is to create a Vendor Return, tell the system that the item is being shipped back to the vendor (which it actually isn’t), and create another PO and Receipt for the vendor and receive the item into inventory.  Then they can apply any vendor documents against each other to cancel out the fake return a

Hi All, One of our clients has a requirement to have Prefixes to choose from or to type in that have independent Autonumbering Sequences behind it.I know we can handle part of it through Segmented Keys and Values, yet the Autonumbering is Global. What we would need to have is the following:AAA0001AAA0002BBB0001CCC0001AAA0003CCC0002 I hope this makes sense.Are there any solutions in native Acumatica or some recommendations on how to customize this?

I need in formatting profit and Loss financials Statement so that you can see it monthly. As a trend Like January to April 

What do I install for Acumatica 2024 R1 for Visual Studio 2022 to function properly building Customization Projects?I’ve looked everywhere for some kind of Acumatica SDK or Framework installer or download, but all the documentation is from 2021 and is 3 years old? 

Hi All,Are there a report in Acumatica that I can show to the auditors.Auditors need to see if the users have posted anything to Acumatica in 2023, and if they have posted transactions, what they posted thxDries

Hi,I need to create a field in Acumatica that automatically updates its value based on the input of other fields. Additionally, this field should also be manually editable by users. Is it possible to achieve this in Acumatica? If so, could someone please provide detailed steps or guidelines on how to implement this functionality?Thank you in advance for your assistance!

Hi, is there a way we can add the “TaskTotal.Curyxxx” to Projects GI?  

Hello, is It possible to add other field on the screen IN401000 as new filter that doesn't exist in the list of fields proposed in customization? Thanks.

Hi All,Are there a report in Acumatica that I can show to the auditors.Auditors need to see if the users have posted anything to Acumatica in 2023, and if they have posted transactions, what they posted thxDries

Hello all,We are new to Acumatica (Construction Edition).  We are running 2023 R2.  Does anyone have experience with processing joint checks in receivables? We are a subcontractor and the GC issued us a joint check to us and our vendor.  We endorsed it and sent it to our vendor.  Now we need to apply this to AR draw as well as AP bills.  There doesn’t seem to be an easy (or any) way to do this.  All we see for joint checks is to issue a joint check for an AP Bill.  But we are looking for information on how to handle incoming joint checks.  Any pointers are appreciated. 

Hi All, I am trying to create a bill of lading. So I have created a report in which I have passed one parameter of customer_id which will be selected by user before running report. and i want that selected customer to be printed in report under shipment heading. But it’s not printing the complete address not even the name of the customer. Can anyone please guide me or help me I am new to Acumatica Report Designer ? I have attach screen shots and RPX file. I have created the relation of customer with address dac but its shows me error  

When the Action Date for a Purchased Item is in the past (meaning Promise Date is less than today plus lead time), creating a Purchase Order from the Inventory Planning Display results in a PO with a line Promise Date equal to today plus the Item’s lead time. Is there a way to use the date from the requirement rather than pushing it out to full lead time? This doesn’t communicate to the Vendor that we would like the item sooner than their normal lead time if possible.