Solved

Doing some editing work on stock Dunning Letter Form, but can’t seem to figure out how to manipulate the ARDunningLetter.Deadline field that is showing up on my Dunning Letter. Looks like it is adding 3 Days to ARDunningLetter.DunningLetterDate, but not sure where that additional 3 day setting would be coming from? 

Hi TeamLooking for an Import scenario to update the Sync field on the ‘BOPIS Store to Sync’ grid.Thank you.Screenshot for reference  

Hello, I have added Three UDF’s and UDf’s Addition values am assigning in Default Price of Stock Item Screen Please Help me with the SolutionThanks,Version-22R1

Trying to modify the Sales Order GI so it calculates partial price (ignoring or subtracting one of the line items on the Sales Orders). Is this possible? Example:SO100038 - Total Order Price of $10,000Item A $2000 Item B $5000 Item C $3000 In my GI, I want to display an adjusted price column that is calculated by taking total Order Price - Item C Price resulting in an adjusted price of $7,000 per this example. I can perform joins to bring in the SOLine detail but not sure how I would be able to subtract the correct line item?  Any thoughts?  

After our upgrade to A2022 R1,  users are cannot create a Timecard for employees that are not setup as users.  We have the delegate assigned.   Error:Error: An error occurred during processing of the field Employee value 000001562 EP Error: The employee record is not associated with a user.IF this is the requirement, then this seems will cause major business process changes to enter time for employees associated to projects that are not users. 

Hi all,I’ve been running into some issues while trying to create a purchase receipt for a purchase order through the REST API.I’m making a PUT request to /PurchaseReceipt in Postman with this body:{ "VendorID": { "value": "DER" }, "LocationID": { "value": "MAIN" }, "Details": [ { "InventoryID": { "value": "10068777051226" }, "Warehouse": { "value": "NORR" }, "Location": { "value": "J01A" }, "LotSerialNbr": { "value": "1016" }, "ExpirationDate": { "value": "2025-05-01T00:00:00+00:00" }, "POOrderType": { "value": "Normal" }, "POOrderNbr": { "value": "PO000271" }, "POOrderLineNbr": { "value": 1 } } ]}But I end up with a 422 and the following error messa

Hi Team, What is the best way you all have come up with to set up leasing in Acumatica? 

When ordering major components on a project, I will “mark for PO” on the sales order.  After the product is received and sales order invoiced the PO link tab is cleared so you can’t go back into an old sales order to establish what PO the product was ordered in on.  When dealing with warranty claims, all of my suppliers require me to supply the PO number that the product was ordered on for traceablility.  Why is this field wiped out when going back to check a historical Sales order?

We have a customer going through upgrade testing for 2023R1 and they are receiving the error below when trying to confirm a shipment: This is what the configuration on the carrier looks like (and testing the connection was successful): Thanks for any assistance!

Hi Team,Does anyone have have import scenario template to import “Bills and Adjustment” transaction to Project Transaction screen. Please help me on this. Regards,Ramya Krishna

Just getting used to the what seems incredibly formal statement process (for a small company anyway). I ran the statements for a period and forgot to enter one receipt of money from the customer, how do I re-run the statement to include for this extra money received on the last day of the month. It all feels very locked in and unwieldly to me as I am used to just re-running a statement as many times as I like. Best Regards Malinda

My company previously had Acumatica PCP license, and we had to change to PCS because acumatica stopped selling the perpetual license. Now, our acumatica country agent is insisting that we move to AWS because PCS cannot be hosted on local server. I found multiple online sources saying that both PCS and PCP licenses can be deployed anywhere, on-premises or in a private data center, depending on your preference. But I still wanted to confirm it Can we install acumatica PCS on our local server?

Is there a way to restrict information mobile users can see?  For example, (with project/job costing) can a project manager only be presented with his/her specific jobs, cost codes, etc. and not the entire project/cost code, account groups?  In particular, asking this in regard to Advanced Expense Management mobile users who would select the appropriate project, etc., after OCR has run?Of course, this would apply to other mobile users who need to interact with manufacturing, distribution, etc.

I own a manufacturing company. I uses vehicles on (own, rental, contract) basis. I delivery my goods to different logistics area through vehicles. my question is can I able to track my vehicle and also diesel usage ?

Hi Experts,I am currently working on integrating with Acumatica and I have encountered a situation where I need to retrieve the count of records while executing an API from Postman.I have a few questions regarding this: Is there a solution to obtain the count of records in Acumatica through the API? What is the purpose of the "$expand" key? Is there an alternative way to import all inner nodes without explicitly specifying them using the "$expand" parameter? How can I determine the "Data Type" of a field when retrieving the schema of an object within the Acumatica system from Postman? I would greatly appreciate your assistance.  

How can we combine all the sales order report (so641010) within a specific date range. I want to merge so641010 report based on a date range on order date. If five order are placed on a particular date I want all 5 report for individual sales order (so641010) to be combined in a single one. Any ideas how it can be achieved ?Thanks

I am trying to Build and compile a customization in Visual Studio 2022 and it is throwing warning messages that it cannot find any of the PX DLL files that are in the referenced folder.  Other DLL’s I am referencing are found in that folder, just none of the PX DLL files.Does anyone have a hint, suggestion or idea why only the PX DLL’s are not being referenced when OTHER DLL’s I am using are being found?Here is a screen shot of the folder and the VS 2022 warnings.  

Hi everyone.I login as admin. I go to Employee Time Card EP305000 screen and it’s show error. How to set role Employee for admin user? Thank everyone.

Can someone help to explain why cash return document is placed automatically to credit hold when credit term is Prepayment (terms requires 100% prepayment) and how to change this behaviour? Credit verification rule for this customer is Disabled. This doesn't happen on non-prepayement credit term though. Workaround is changing credit term but not ideal.  

I need to restrict the creator of requisition from creating the purchase order.i.e The Create orders button should be disabled for the creator of requisition.Kindly assist on thisAny kind of responses is always highly appreciated.

Hello All, I have a client who needed a Pivot Table as a side panel in one of the screens. I have done the work and created the Pivot Table using Screen SM208010 and all work just fine but I do not see a node in Customization Packages to include the Pivot Table in a package. I thought if we include the underlying GI, the platform is smart enough to include the associated Pivot Tables but it didn’t happen. I added this PT to a Dashboard and included the dashboard in the package but it didn’t help either. Has someone come across this in the past and are you aware of any way to include it? I know I can export the PT and import it on the client site but I would like to keep the package neat and clean and include the PT in it. The version I am using is 22.211.0034@smarenich @Dmitrii Naumov @Yuriy Zaletskyy @BenjaminCrisman

I created a UDF in ARRegister called UsrInvParent (datatype INT), in the ARRegister table.What I want to do is save the ParentBAccountID of the customer BAccount on the invoice to this new UsrInvParent UDF upon the “Release” of the invoice.So, using customization what is the best way to code this in Acumatica? (if someone could provide an example, I would greatly appreciate that also.)(The reason for the new UDF is that our customers quite often change parent accounts due to acquisitions and we need to capture the parent account at the time of invoice for historical reporting.)I hope I am being clear as to what I am wanting to do. Thank you so much! NOTE :I am trying to do in Acumatica with an Invoice Release what I can do in SQL with the following command.UPDATE ARSET AR.UsrInvParent = Cust.ParentBAccountIDFROM [dbo].[ARRegister] ARINNER JOIN[dbo].[BAccount] CustON AR.CustomerID = Cust.BAccountIDWHERE AR.[CompanyID] = 2AND AR.[CustomerID] = 26603

Hello,While making changes to the layout of a sales order screen using the Customization Project Editor I’ve managed to break something. I’m not sure what change caused the problem but it is now in a state where I cannot get the screen to load into the Customization Project Editor and so I cannot make any changes in order to fix. I get the following error: I’ve had similar issues in the past but usually linked to a problem with a missing view in the VS project and easily fixed, but I cannot seem to fix this and it’s not linked to a problem in VS. I’m sure others will have had similar experiences too. I’m thinking about just deleting the form and starting again but I have done quite a lot of work on the form and it would be a shame to lose it. This specific error is about px:control but my question is more general, how do others go about resolving problems like this, when Acumatica cannot display the form because of an problem with the html?ThanksSteve

i have a problem with my tabs the default values isnt working with the tabs also the save isnt saving the views for the tabs it only saves the master values onlythis is my screen  and this is my tab dac [PXCacheName("InspectionMalfunctionCheck")]    [PXPrimaryGraph(typeof(InspectionFormEntry))]    public class InspectionMalfunctionCheck : IBqlTable    {        #region malfunctionCheckID        public abstract class malfunctionID : PX.Data.IBqlField        {        }        protected int? _MalfunctionID;        [PXDBIdentity(IsKey = true)]        [PXUIField(Enabled = false)]        public virtual int? MalfunctionID        {            get            {                return this._MalfunctionID;            }            set            {                this._MalfunctionID = value;            }        }        #endregion        #region InspectionNbr        [PXDBString(20, InputMask = "")]        [PXUIField(DisplayName = "Inspection Nbr")]        [PXDBDefault(typeof(InspectionFormInq.inspecti

Hi Acumatica,Seeking your assistance to figure out the reason behind this error,Upon generating a report into excel file, The generated file has 0 bytesand when opening the file the excel give as this king of error, May we know the cause of this error?Thanks!