Discussion Forums

​@dgodsill7348 posted this wonderful Idea in the community.  Extend Prepayment Invoice Capabilkity to no VAT clients. | CommunityWe all appreciate all of the effort that goes into the constant evolution of the platform.  I can tell you that after 15 years of deploying Acumatica, I’ve seen countless wonderful improvements to the platform. With that said, can someone on Distribution product side clarify why it’s necessary to enable VAT tax if a client wants to generate Prepayment Invoices?  This seems like a no-brainer feature that a lot of manufacturers and distrubutors want; especially those in the ETO space. This goes beyond credit term management, and Advance Revenue management is likely too heavy of a lift for accessing such a feature (probably ill suited as well).  There are other solutions less capable than Acumatica that supports this.  I’m working with a client presently whose legacy platform that not only supports prepayment invoices, but also allows for order-specific payment

I’m looking to create a custom webservices endpoint that will take in a request with a custom format, extract Ids from some of the objects in the request, retrieve data on stock items and some related tables based on the Ids provided then put that data into a specific json format to return it.Is this possible and how would I go about doing this?

Hi, is it possible to use SQL stored procedures or SQL functions in Report Designer?

The customer has expressed a desire to restrict the system's ability to release transfer documents when there is no quantity available. They are currently utilizing the "allow negative" checkbox in the item class. Furthermore, they aim to generate a shipment for kit assembly orders even when there is no quantity available, but at the same time, they want to impose restrictions on releasing documents with a negative balance during transfers.Any one please suggest how to meet this requirement? Any configuration? Thanks in advance

How can I see Inventory on hand, reserved, and available in a grid view? I am sure someone is doing this already. Are you creating a GI or am I just missing where to go and get this. I would like all of my inventory to populate in a grid view. I dont want to look at one item at a time I would like to populate the full inventory list and then filter and sort. Stock items screen lacks inventory information I am needing.

When adding someone as a delegate for approvals, is it possible to also have the original approver still receive the notifications and approve documents?  

I have some problem. I have all right. But report parameters not availible. in 24R111 version. But in 25r1 its work. With some rights. With debug i see this error: 1️⃣ PX.Web.UI.PXReportViewer.SetReportSignFlagIfPdfCertificateIsPresent()    → C:\build\code_repo\NetTools\PX.Web.UI\Controls\Report\ReportViewer.cs:line 12182️⃣ PX.Web.UI.Metadata.AspxScreenInfoCollector.Collect(String screenId, String locale)    → C:\build\code_repo\NetTools\PX.Web.UI\Metadata\AspxScreenInfoCollector.cs:line 153In trace i have this  its error i have when i refresh report parameters. All report have this error and I can't set parameters

Good day,I could use some assistance with the review the attached Import Scenario; it worked before we upgraded to 2022R1.  The scenario creates the sale order.  However it creates only one order with all the items in it rather than create a separate order.  The file has 55 orders.  When I tested it created one big order.  I can figure out what changed after we upgraded.Have a nice day.@Evan G 

I created an custom field in purchase Order and need to enable it for all the status of the Purchase order. Is this can be done without coding?

Has anyone overcome this issue? In a classic UI dashboard, the embedded page widget is working fine for a webcam view of a construction project. Similarly, an embedded weather widget works.  Switching it to Modern UI and it results in a 404 - File or directory not found error. The weather widget has the same result. Toggling back and forth between classic/modern, the embedded pages work in the classic UI and 404 in the modern UI Sample webcam URL used for testing: https://share.earthcam.net/tJ90CoLmq7TzrY396Yd88KKPTYvGpuC9sn7UZHiL1L4.tJ90CoLmq7TzrY396Yd88KndwTghhAJ91QbmhhD8hKQ/tonnelle_ave_bridge/camera/panoramaSample weather URL: https://oneweather.org/new_york_city/#now

Our client wants to have two separate continuation pages: one for the original contract, then one for any change orders. I added a formula to group change orders separately - the client adds them in separate tasks starting with “CO”. This formula is working like a charm except the change orders always appear first. I’ve tried every group formula I can think of, changed between ascending and descending, etc., and get the same result every time. Has anyone else come across this? If so, how did you address it? First GroupSecond Group 

Hello everyone,I’m experiencing an issue with the invoice reports: the invoice discount is currently displayed as a separate line item. This causes two main problems: The line numbers in the invoice start incorrectly at 2, because the discount is counted as a regular line item. The sales order number (SOOrder.OrderNbr) and customer contact information (Customer.ContactInfo) are not displayed correctly when a discount is present.     I tried to fix the line numbering issue by adding a filter to the detail section in the Report Designer:=IIf(Not IsNull([ARTran.InventoryID]) And [ARTran.TranType] <> "Document Discount" And [ARTran.LineNbr] >= 1, True, False) This hides the discount line, but the line numbers still start at 2 instead of 1, and the sales order number and customer contact information still don’t show correctly. Expected Behavior: The invoice discount should not appear as a separate line item. Line numbers should always start at 1, regardless of whether a discoun

Hi, I want to create expense claim but when i try to select the expense item, i can not find any list of my Inventory ID (Non-Stock Item with type Expenses). Please help me to to solve about this, thank you.  

Hi, i want to create a request but the while i try to select one of the chart of account and subaccount form on of my item request, there’s no option to selected the COA and Subaccount. I already import the COA and also create the Subaccount. There’s any step that i miss while i config?Here i attach the capture of my problem, i really appreciate you responds and help. Here is the capture of the Subaccount for the Request\ 

I have encountered an case where my client is sending POs from Acumatica to another company which is also using Acumatica. Because both companies are using the default Email Tags [ ] they are having issues communicating with each other as their emails are routing incorrectly. With the expansion of Acumatica clients I have a feeling that this is going to become a more common occurrence. Is there any plan in place to handle this type of issue? Aside from changing my clients Email Tags, which many of their other vendors are now used to, what can we do to resolve this communications issue?

I am trying to create a report where i am not able to get the Alternative ID a dropdown table. Alternative ID comes from INItemXRef table and for my report relevance, Soline table.Can’t seem to bring any of the table in the Alternative ID dropdown parameter by using any of the below  =Report.GetFieldSchema('INItemXRef.SubitemID,AlternateID')=Report.GetFieldSchema('INItemXRef.AlternateID')=Report.GetFieldSchema(‘Soline,AlternateID') in the View Name: field. Infact any thing put in View Name omits the Altenate ID parameter itself as seen in the picture.  Any Idea what could be done?

So, i want to create a request but why the name of employee can not be found only the customers.I create a request class with name employee, but still it can cot link to request. How to solve about this, cause i want to create a request demo by show the request is employee. Thank you

One of the import scenarios that we run has been producing a “divide by 0” error for some, but not all, of the processed lines. I’m not a 100% sure, but I believe the formula is the thing causing the issue. However, I don’t see any division equations in the formula. Could there be something else causing this issue? The equation: “=IIf( [POReceiptLine.PONbr]=Null, Concat(CStr(Left( [POReceiptLine.VendorID_Segment1],7 )),'-',CStr([POReceiptLine.ReceiptNbr]),'-',CStr([POReceiptLine.LotSerialNbr])), Concat(CStr(Left( [POReceiptLine.VendorID_Segment1],7 )),'-',CStr([POReceiptLine.PONbr]),'-',CStr([POReceiptLine.LotSerialNbr])) )” The Import Scenario.   

Hi, is there a known issue with GIs that are linked to Pivot Tables - v 2024R1/2024R2. I have a number of GIs that have Pivot Tables. When I try to unpublish the GI I get this. All the information on web points to going to Pivot Tables and deleting it, but it still returns the same error.  

Hello!When trying to create an Adjustment for Physical Inventory for an item that has been Transferred to a Project (Track by Project Quantity), the system throws the error “Insufficient Qty. On Hand”.The only resolution we can find is to transfer the qty. back to Project X, or delete the item from the PI Adjustment and manually create an Issue doc. instead.Am I missing something?

Hello,  We are trying to set up our Amazon Connector in Acumatica. The Product Link, Availability, and Sales Order work just fine. However, when the Shipment was confirmed in Acumatica, no records show up to sync when clicking Prepare Data. Does anyone know any special setup or tricks to get this shipment to show up to sync. It’s not that the sync fails… there isn’t anything to sync in the first place when there should be. Lastly, does anyone who uses this connector know how long it takes for the payment to sync over from Amazon seller central? Thanks in advance!

I am working on an SO Order generic inquiry that lists the Requested On field date as just Month Name (e.g. if date is 10/20/2025 the results should read October).  Here’s my GI edit and the resulting issue.  

We’re running into issues trying to short ship in Acumatica when items turn out to be missing after the shipment and pick list are already created.Here’s our Current process:If we discover the shortage during picking:Change Sales Order Preferences > Warehouse Management → Short Shipment Confirmation to “Allow with warning.” Pick what’s available and click Confirm Line Quantity. Confirm the Pick List and export Picking Details for reference. Delete the Pick List and Shipment. Adjust out the missing goods, update the Sales Order, and re-create the Shipment.So even though Acumatica lets us pick short, it won’t let us ship short — when we try to confirm the shipment, we get this error:“One or more lines have unassigned Location and/or Lot/Serial Number”It seems Acumatica still requires every line to have a valid location and/or lot/serial assignment, even when we intentionally didn’t pick the full quantity. Since we can’t modify the shipment quantities directly, we end up deleting the s

I have dac: using PX.Data;using System;using PX.Data.BQL.Fluent;using PX.Objects.GL;using static PX.Objects.AP.APTran;namespace ASAmazonIntegration.Ext{    [PXCacheName(Messages.SPAmazonTransactionMapping)]    public class SPAmazonTransactionMapping : PXBqlTable, IBqlTable    {        #region BindingID        [PXDBInt(IsKey = true)]        [PXDBDefault(typeof(SPAmazonStore.bindingID))]        [PXParent(typeof(SelectFrom<SPAmazonStore>.            Where<SPAmazonStore.bindingID.                IsEqual<SPAmazonTransactionMapping.bindingID.FromCurrent>>))]        public virtual int? BindingID { get; set; }        public abstract class bindingID : PX.Data.BQL.BqlInt.Field<bindingID> { }        #endregion        #region TranType        public abstract class tranType : PX.Data.BQL.BqlString.Field<tranType> { }        [PXDBString(15, IsUnicode = true, IsKey = true)]        [PXUIField(DisplayName = Messages.TranType)]        [PXDefault(PersistingCheck = PXPersistin

Has anyone been able to utilize Amazon Shipping and buying their labels using the native Acumatica connector and keeping the process within Acumatica?