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'
Hello - Is it possible to grant users the ability to create and save Journal Transactions, but not allow them to take it off of hold or release them? I am able to restrict the ability to create new transactions via the access rights by screen, but I have not been able to figure out how to allow the creation of them without release. Thanks!
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
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
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.