Hello, I’ve created what I thought was a rather simple GI, yet it keeps timing out saying the request entity is too large. It should be pulling customers, which is only about 9,000 records, and it can’t load it. Can someone take a look at this GI and see if something could be improved? Thank you!
Hi Team,I need to get the Vendor registered or configured Tax Id's (Tax class) to a foreach loop for a particular vendor record (BAccountID = X). Can someone please help me out to give me the BQL query for this?ThanksBhagya
Hi, In my Acumatica 21.211.0033 I need to configure endpoint in such way that I will have an ability to generate Checks and Payments item with type Prepayment that will have ‘Documents to Apply’ table and ‘Orders’ tableI have already found and added ‘Documents to Apply’ tableBut I can’t find ‘Order’ table for checkes and payments. What’s it’s name ? Can it be added for using in creating new ‘Checks and Payment’ item with type ‘Prepayemnt’ ?I need something like this
I am trying to divide the results from Column B by a value in a Row. I have tried various combinations of the following. Can someone please suggest? If you are wondering, I am using the @BaseRowCode for another column. Thanks! B/@RowCode = 0280=B/ Value(@RowCode ,0280) =B/ Value(@RowCode ,'0280’) =B/ Value(@RowCode ,'B') = '0280'
In our application we are creating Purchase Order Receipts and they had been working fine, but we had not used this function for 6 months or so and are using it again. We are getting this errorGuzzleHttp\Exception\ClientException: Client error: `PUT https://prestigesalonproducts.acumatica.com/entity/ORDIO/20.200.001/PurchaseReceipt` resulted in a `422 Unprocessable Entity` response: {"id":"15468762-cac9-ee11-65424-12a215648465216","rowNumber":1,"note":null,"error":"'POAccrualAcctID' cannot be empty.; Here is our codereturn [ 'note' => $receipt->comment, 'VendorID' => ['value' => $po->vendor_id], 'PostPeriod' => ['value' => now()->format('mY')], 'Details' => collect($receipt->products)->map(function ($product, $key) use ($po) { return [ 'InventoryID' => ['value' => $product->inventory_id], 'ReceiptQty' => ['value' => $product->qty],
We have transfer orders that are being consumed by another production order. Each line is marked complete, but the transfer orders are not being moved into Completed status.Can we simply cancel the Transfer Order after it’s done?
I am getting the following error message.Error: Inserting 'Sales Order Line' record raised at least one error. Please review the errors. 'Project Task' cannot be empty. Require Ship/Receipt is OFF in the Non-Stock settings.This just started. We have been on the system for about 4 years without this issue. Nothing has changed that we are aware. Can anyone help? It seems to only happen with requisitions that are associated with a project and project task. We have always just entered this information into the PO once created.
Hello,we have the salesforce sync setup on our Live(cloud) and a Sandbox(self hosted) and suddenly this morning both sites are giving us an error on the real time sync. None of the entities will “Start” on the Salesforce Sync page, and I see this error in trace:“Failed to connect Salesforce Bayeux client”These are connected to different salesforce sites, so I don't think it’s on the Salesforce end.could something have broken on the Acumatica server side?
Hi We want to restrict sales orders for users based on the items attached on the sales order. Up to now we are only able to restrict selecting items on the sales order but since users can view all the sales orders is able to view the other sales orders which attached the stock item. Here our users will be selling for same customers but different products. Amanda
Materials Consumption GI was working fine for us then all of a sudden the ‘Actual Consumed QTY’ field stopped working properly (calculations are off). If we pull up the Production Order GI the QTY for labels consumption is accurate on a specific order (2 and 544). Which should = 546 Actual Consumed QTY for labels. However on our Materials Consumption GI for that same production order, only the most recent 2 Actual Consumed QTY is displayed. The Materials Consumption GI is set up as AMProdMatl.QtyRemaining We also tested reversing the 544 qty, and the total adjust to -542. Our question is why isn’t the 544 being calculated properly in this GI?
Get Started HERE and be sure toIntroduce Yourself
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.