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?
Hello All,We are using Production Orders to complete a good. Note when the Production Order is set up, we have selected the Project WHS, Location to place the finished good in. (Note this project WHS is for government materials that have already been invoiced to the customer) On the reference tab we also will add the project # and task to tie the project to the production order. The materials added are coming from a main warehouse while some of the other materials bought to that project are coming out of that same project WHS, location where the finished good will be placed. When using the material wizard, the materials being released from the main warehouse there are no issues, the materials released from the project WHS location are being removed from the warehouse, however the materials are not appearing as a credit on the project? Using the wizard there is no option to add the project? Is there a different way we should be going about this? Trying to accomplish:taking the invoic
Suddenly, we are unable to add lines to the Weekly Crew Time entry screen on all projects.
When printing the invoice for the Customer, I would like the POD image file attached to the ARInvoice document to display on the report. The way it currently works in ReportDesigner is using a PictureBox, with the Source set as Database. The value is [ARInvoice.NoteFiles]. This works fine some of the time, but if there are multiple attachments on the Invoice document it will pull the one first added. Is there any way to change this so it gets the image from the latest added attachment? I would like to avoid a subreport as this is generated extremely frequently and I’m worried that generating twice the reports to achieve this will take an unnecessary toll on performance.
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.