Solved

Hi-I'm trying to add a PUT request to my payment screen (AR302000). However, when I test it using Postman, I encounter the following error, and I'm a bit stuck on where to find the issue and fix it. Here's the error message and the JSON data. If anyone could assist me in identifying what's wrong, I'd greatly appreciate it.Thanks a bunch!Error: JSON:{    "Type": {        "value": "PMT"    },    "ReferenceNbr": {        "value": "PAY0001"    },    "Status": {        "value": "Balanced"    },    "ApplicationDate": {        "value": "2023-12-28T00:00:00+00:00"    },    "PaymentRef": {        "value": "nugsl - INTEGRATED_ATM - 2023-12-28"    },    "CustomerID": {        "value": "C0001660"    },    "PaymentMethod": {        "value": "ATM"    },    "CashAccount": {        "value": "INTATMDSWC"    },    "Description": {        "value": "API Test."    },    "PaymentAmount": {        "value": 1400    },    "BranchID": {        "value": "01-DSWC"    },    "DocumentsToApply": [        {         

Good afternoon consultant,I would like to know if you can help me with the following query:In Property Management, in the Units option, one of the units was deleted by mistake and when trying to create it again, Acumatica gives the following error "Error: An error occurred during processing of the field Unit / Space: Error: The record has been deleted ."My question is: how can I locate within Acumatica if this Unit has any associated transaction that prevents its creation or what is causing this error?Thank you very much in advance for your response.

Is there a process that would disassemble a configured - serialized item?My first thought was that I have to reference the production order the item was produced on, but I have not been able to get the results I need with what I’ve tried.

Hello. I am importing some stock items to the Acumatica sandbox, and I get the error code "Item." I double-checked everything, and nothing looks wrong with the mapping and import. Below is a screenshot of mapping and import: Could you please tell me what is wrong here?ImportMapping  

I am trying to insert a vendor record using the REST API. I am met with the following error message.    "error": "Inserting  'Vendor' record raised at least one error. Please review the errors.; DiscTakenAcctID: 'Cash Discount Account' cannot be empty.; DiscTakenSubID: 'Cash Discount Sub.' cannot be empty.; TaxUseVendorCurPrecision: The Use Currency Precision flag was set because the tax report precision is equal to the currency precision", The JSON I am sending looks like this.{         "note": {             "value": "Abhijit - Testing"         },         "Cash Discount Account":{"value":"5922"},         "Cash Discount Sub":{"value":null},         "AccountRef": {},         "APAccount": {             "value": "2000"         },         "APSubaccount": {             "value": "000"         },         "CashAccount": {},         "CurrencyID": {             "value": "USD"         },         "CurrencyRateType": {},         "EnableCurrencyOverride": {             "value": false         },    

Hello all,Is it possible to create a new parent folder so that we can create extra wikis for internal ops?  

Hi,Looking for your insights into the the following questions around inventory valuation methods.Average Cost Calculation:  Is the average cost recalculation triggered only on a purchase? If a purchase is back dated after a sale has already been posted does the system recalculate the cost on that sale to reflect the true average cost? FIFO Cost Calculation If a purchase is back dated after a sale has already been posted does the system recalculate the cost on that sale to reflect the proper FIFO cost? Inventory Adjustments:  Under FIFO do all inventory adjustments need to be matched to a prior purchase?  Negative Inventory: Average Cost:  If inventory sold into a negative position and purchase back dated will system adjust costs to accurate average cost or just use the last cost for sales made? FIFO:  If inventory sold into a negative position and purchase back dated will system adjust costs to accurate FIFO cost or just use the last cost for the sales made? Thanks,Hari

Desired End State:Be able to track our prospecting efforts and cross reference them to other source campaigns. These efforts are to allow us visibility into where an opportunity comes from, and whether that contact in that opportunity hashad a touch point during any other source campaign.Current Idea:We currently utilize source campaigns to reflect the following:               -Marketing efforts               -Industry Events               -Trade ShowsThe idea is to create a source campaign, “Prospecting 2024” for the purposes of this conversation, that we can track when we do those types of activities.Ex. We walk into a new client’s office to drop off our info, and we meet a contact who provides us some information that turns into an opportunity. We then track that by selecting the source campaign of “Prospecting 2024” under that opportunity.Then, we can download the different campaign lists and cross reference them by contact name to see if they had multiple touch points.Ex. Did they

Hello Everyone, can anyone found any difference between 2022R2 and 2023R2 Customization. if so can you provide the details...

I’m attempting to add a new Vendor via the REST API. I receive the error:DiscTakenAcctID: 'Cash Discount Account' cannot be emptyThis is a required field located under the GL Accounts tab. However, the field does not appear when getting the list of Vendors via the REST API. How should the JSON be structured to include this field when adding a new Vendor via the REST API?

After we upgrade the acumatica form 2022 to 2023 r1 we encounter this problem, A lot of order from Bigcommerce are not flowing in Acumatica because of the error “The system failed to commit the Taxes row.”  

I have been using stock item attributes for years. They always show up in the InventoryItem DAC for me to select in a generic inquiry on on a report.However, I’ve just run into a situation where they aren’t in the InventoryItem DAC and I can’t figure out why they are not showing up for this specific customer.I have set up this attribute: And added it to this Item Class: The attribute shows up on the Stock Item and allows me to enter a value: However, when I try to add it as a column on the Stock Items list, the attribute is not a selection in the InventoryItem DAC. It’s also not available to select in any report that uses the InventoryItem DAC. I thought maybe something had changed in the 23R2 release (that’s what this customer is using), but we have other customers on 23R2 and the attributes are behaving as expected in the InventoryItem DAC.Below is the generic inquiry that I’m trying to add the attribute as a column, but it’s not available as a selection:  What am I missing?

We’ve found that for companies that have the “Allow AP Bill before Receipt” option enabled for their vendors, the Purchase Accrual GL account and the Purchase Accrual Summary report in the Purchases module don’t match. This is because the Purchase Accrual Summary report is based upon PO Receipts. Companies that allow AP Bill before receipt cannot then easily reconcile their Purchase Accrual account. We can create a different GI or report for this, but before we do, I thought I’d ask -- has anyone else run across this and if so, how did you resolve?

We want to start using the Parent-Child Account feature in Acumatica.  Can someone tell is if we use Acumatica Parent-Child accounts, will multiple Big Commerce accounts be created (we hope multiple Big Commerce accounts are created)?

Client has a 5 page Terms & Conditions for the want to have sent with their PO.  It has word-level formatting which would be time consuming to replicate in report designer.  I tried adding a PDF version of the T&C’s to the email template but it doesn’t carry over when I send a PO out of the system using that template.Outside of writing the report does anyone have an easier method of attaching a document to a template that isn’t a report?  

I have the following attribute: We then use one of these values in Project Quotes: Now I would like to display a calculation of this Attribute value and the Total Sales value in the Project Quote PL GI. I tried to apply the below calculation:​​​​​​​But it doesnt display the results:​​​​​​​What is the mistake in the calculation that I am making? Please guide me through it.​​​​​​​Thanks in advance.

I’m ultimately trying to add each of our 70,000 items to each of a couple hundred fictious locations for purposes of a semi annual full count of our retail store. I know that we can add items one by one (article), but of course that would take ages. So, I’m trying to create an import scenario to accomplish the same thing. Here’s what I have so far:  When Importing the excel doc, I get an error that says “the scan action cannot be found”. Does anyone know what this means? Is it not going to let it be updated by import?   

It appears the quote screen within opportunities is not the same as it lives within the CRM. When we quote a customer we also quote freight.  How do we do this within opportunities/quotes?

Hi. I created a business event to send a notification of a sales quote created based on the amount. The issue I am facing now is that the business event send out notification on quotes that were sent out on past dates (if a person makes changes to the sales quotes created on previous dates). I need the notification to only send out sales quotes created today only. Please can you help me out.

Hi,Is there a way to check which user create a journal in the system and when it was created? Thank you. Regards, Raymond

Hi group ! ,I am almos a new Acumatica End user( and not a VAR). I asked this question without having a clear answer(var).We did our GoLive on Acumatica 7 months ago now and it is going well. We haven't asked users too much to archive all PDF documents in the forms, at least for the beginning.For the moment, we are attaching the PDFs of the important AP bills, let say ± 10% of them, but not all without exception. I would like us to do phase 2, which would be to archive all AP bills in PDF without exception. However I am always concerned about space usage.What will happen when we bounce the max space? When it will arive, Should we export/delete somes files? If I need to export/delete files, Is the choice of file to delete will be easy & convenient? (Eg: sorting by date, document type)? Or the solution is to take a bigger package with acumatica, and so on when we will bounce again...I'm wondering if there are many of you who upload PDF invoices to all AP invoices or if we are the on

Hi All, I have a very simple Business Event that I can’t get to trigger. Condition is for an appointment that changes to status of Completed. I made a copy of the Appointments primary list to use in the BE. Screenshot below. To test I open an Appointment, start it, then complete it so status is Completed. No history shows. Spent a while trying different things… Not sure if I’m missing something obvious?  

A client with SOX compliance requirements, but a small accounting group, needs to make sure that a JE created by one person is posted by someone else.  This is for their internal controls and outside Auditors.  An approval flow would be ideal rather than security roles. 

Hi Everyone,I am unable to binding the data in grid, I don’t know what’s going on . Data view (Graph)   [PXFilterable]   public SelectFrom<FSEquipment>.          InnerJoin<FSSODet>.On<FSSODet.SMequipmentID.IsEqual<FSEquipment.SMequipmentID>>.          InnerJoin<FSServiceOrder>.On<FSServiceOrder.refNbr.IsEqual<FSSODet.refNbr>>.          Where<FSSODet.refNbr.IsEqual<PYServiceEquipHistory.refNbr.FromCurrent>.          And<FSSODet.SMequipmentID.IsEqual<PYServiceEquipHistory.equipmentID.FromCurrent>>>.          OrderBy<FSServiceOrder.orderDate.Desc>.View ServiceEquipmentView;  Where condition not working here..! Data available in the database When we select the both fields data adding into the grid but it’s not working.Please help me on this issue.ThanksNageswararao.

In ARM report, if the data source for a row has no activity, the row shows blank. I need it to show ‘0’ I tried the IsNull formula. This works if I have no accounts in the data source, but if I have accounts selected with no activity in the period, it still shows blank. So it’s looking at the data source rather than the result/activity. Anyone know how this might be accomplished?Thank you