Solved

Hello linkies,I have been trying to setup my google workspace account in Acumatica. Did tried to implement the same on System Email Accounts (SM204002) form but not able to setup. Kindly let me know how can I setup the same.   Thank you in advance.

Hello,      I don’t know it is my code issues or system framework issue.  Somehow, I encountered a case that the system can ignore the error on the screen and proceed to save and release document.    My environment is Build 21.208.0032. So I don’t know this issue still exists in current version.My need is to forbid SO invoice being saved/released if any line contains 0 qty.I am using the below code mainly protected void ARTran_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { ARTran aRTran = (ARTran)e.Row; if (aRTran != null) { using (new PXConnectionScope()) { InventoryItem item = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>> .Select(Base, aRTran.InventoryID); if (item != null) {

HI. I am looking for a report that shows the same information as the standard Inventory Valuation report that shows inventory as at a certain date. For example, I want to print the report showing what the inventory was as at Dec 31,2022. I’m actually surprised that Accumatica doesn’t have this as a standard report. Thanks

What tables need to be added to the employee listing (Screen ID EP2030PL) so the current Position Title can be displayed as well (is this possible)?  What is the relation/link for the new table(s) that need to be added in order to get this information to be displayed on the listing?  The Position Title is located on the Employment History Tab in the employee record.  Thanks!

Hello all,I have been trying to import some test AR Invoice data into the system, but getting the follow error:  The Import Scenario: Have checked out the Customer Class details and the Tax Zone and Category details too. Everything has been setup as per the requirements.Kindly let me know how to resolve the error. 

Is there an Authorization.net Credit Card integration with Acumatica ? 

How do you pay your credit card bill and link credit card purchases made and listed under other vendors?

Hi all, I am looking for a way to add the customer price class to the customer list view. I am trying to do this so I can sort the customers based on the price class and also to quickly see what customers have what price classes. I am trying to add fields to the generic inquiry, however I cannot seem to get it to work. Here is how I currently have the GI set up (I have tried all different join types)And here is the result I am gettingThose are all the same customer. As you can see, it is just repeating the price classes for each customer.I wouldn't mind using a report that would show this, however I cannot seem to find one. I do need to be able to export it to Excel.Any help is appreciated!  

Is there anybody out there that knows if this Problem field can be made NOT required:  

i Have encounter in oaouth2 configuration

Hi all, Anyone knows which access rights to control the Audit History under the TOOLS? I know there is a role named Field-Level Audit for it. But I want to know the access rights.   

My client manufactures stock items with different container sizes. They have stock items listed as shown below:WG36-BulkWG36-264GAWG36-317GAThere are times they need to do a repack from Bulk to 264GA and need to allocate labor and overhead costs. If we use the BOM for the stock items, it includes the component parts needed to produce the item. In this case, we will not need the standard components as we will issue WG36-Bulk as the component. Is there an easier way than deleting all the components and adding this one item with the labor and overhead added? Somone suggested an Inventory Kit Assembly but I really want to tie this to a production order from a sales order. Looking forward to the feedback,Thanks, Jim

I’m trying to run a basic import scenario that looks at specific opportunities and updates the owner. I know I’ve had issues before with updating an owner field on a business account, but not an opportunity. Any input? Sometimes it’s the simplest thing but I can’t figure out what would cause this...

Good day Team, I have a customatization that allows me to set the Bill Description from the new APPrintCheckDetailWithAdjdDoc.DocDesc, and is working as expetec, the issue, is that when there is no data the results is a zero, i have tried to use the iif statment when the Variable $DocDesc00 with valueExpr =IIF($LineNbr = 0, [APPrintCheckDetailWithAdjdDoc.DocDesc], $DocDesc00), will provide the correct value, but when the line is empty, the value is 0, if I do a IIF statement the report errors out, i have use this statement on the VisibleExpr field, but not working. Any ideas how to solved this?

In our receiving department we print out receiving labels for ingredients used in production. We normally receive Cases, Pallets, Bags….etc. and we generate an inventory bar coed label to apply to the container. On the Purchase Receipt I have 1 line item on the PO for 4.44 kg. The product is delivered in 5 separate containers 4 - 1 kg and 1 - .44 kg. I select the Line Detail in the Purchase Receipt and add my 5 containers with the lot code and quantity of each. The current bar code Inventory Label is printing from the PO Receipt Line quantity, (ex. 4.44 kg of product) How do I set this up to print a label for each line in the Line Details screen in Report Designer? See image. 

I a working on a Dashboard and one of the items the user want to see is a comparison of items sold, in a date range. The user wants to see the results in a doughnut chart. There are three items that will figure into this chart, the quantity sold of two of the items needs to be added together and displayed as one of the elements in the doughnut chart.As an example lets same the three items are Light Blue widget, Dark Blue widget, and Red Widget.We want to combine the quantity sold of the Light Blue and Dark Blue together and show that as one element of the doughnut chart, and the Red Widget total sold would be the second element of the doughnut chart.My question is, how do I total the two Blue widgets together in the Generic Inquiry  

How do we apply a payment, using payments and applications, for something that is not invoiced or does not require an invoice. For example, we may get a government tax refund and need to apply the check we receive. How do do so using payments and applications?

All of my menu items for CRM, parables, and Finance just vanished and I don’t know how. I have the 2021 r2. I checked if they were disabled and who has access and they all seem to be perfectly fine.Can someone help me recover these? 

​Hi all,I have this Sales Invoice print preview in Acumatica.when exporting it to excel while in ‘Auto’ excel model in report designer, it looks like this. These boxed amounts should have been in the lower right corner cos there should be a long gap between.I want to set a default format when exporting Sales Invoice to excel that will place the details exactly where their position in Acumatica preview is. I know that I can set the excel mode to ‘Manual’ to specify the column, row, height and width. But when putting excel height and width, I’m getting error. What is the correct way I can get the desired result?Thank you!

I’m currently modifying this report. Regarding to this report there is a custom table called APPromaItemList in my instance which contains the sales order details along with the proforma invoice details. Bellow screenshot depicts the modifying invoice report.Modifying Invoice Report000010 is the corresponding sales order number for the above invoice report number 000004. Please check the below screenshot.By this sales order number 000010 I'm generating a sub report of this APProformaItemList table to obtain the ProForma Invoice number. But when generating this the same Proforma Invoice Number is printing 4 times as shown in the above screenshot. It is not what I expected. I need only to print it once. So to overcome this issue ,I grouped by using the Reference Number in the APProforma as shown in the below screenshot.Screenshot of group byBut it was not success. So, to overcome this issue please give me some guidance. Thank you.     

I am trying to setup Device hub on our server, but am getting a permissions error with theconnection to ERP...[Error] There was an error opening the connection: StatusCode: 403, ReasonPhrase: 'Forbidden', Version: 1.1, Content: System.Net.Http.StreamContent, Headers: So this results in Acumatica (MYOB Advanced in Australia) not seeing the printers that are setup in DeviceHub, but if I add the printers manually in the ERP then the DeviceHub recognizes them as setup… but still nothing is found in Acumatica. 

Hello, I am currently putting together a GI that will provide inventory on hand values on a specific date. With this, I had added the InTran table to acquire the InTran.TranDate values for the Parameters tab. With the addition of the InTran table, I am now getting a large number of duplicate values from the GI. I assume the reason is join related, but I am having trouble getting these duplicates removed. Any assistance would be appreciated! Results Joins 

Hello, does anyone have an inquiry that lists bills and the payments applied to the bills? I am having trouble with my inquiry. The joins seem find but not all results are populating.   

Hi Team,Below is the screen shot of my question. I clicked “Load Documents” to show all the open invoices for my transaction period, customer and location. 1) it shows 13,646.73 Applied to Documents after unselecting all invoices. Should it be $0.00 if I unselected all invoices? Why does it show $13K invoices selected? 2) It does not show all open invoices. It only shows 19 invoices when there are 59 open invoices. The next arrow is greyed out. How can I show all open invoices for my criteria?   

A client of mine requires restricting access to projects for their project managers. They do have around 15 Project managers. Their access needs to be restricted for projects, Purchase orders and Purchase receipts.I’m just struggling to think of the best way to handle this. I thought of restriction groups however not sure how to do that for 15 different people who require access to a single project or two, purchase orders raised for that project and can do purchase receipts for the project.In the instance, a procurement manager raised a bulk purchase order for different projects at the line level these managers need to be able to pick up the relevant entry for their projects.Any ideas ?