Solved

I have been asked if there is a way to have the filters selected for the Default and Item Status set to True and Active by default as this is what the person using this screen has to do each time they open it.  I don’t believe it’s possible to alter those fields programatically or get the screen to remember what they were set to.I thought maybe having the underlying query that the grid uses changed to use values in fields defined at the top might work.  I’m not sure how to update the query used for the details for the grid though. Is this possible and are there any examples of how to go about it?Thanks for any help,Phil

We use Landed Cost.  We need to allocate freight charges over several purchase receipts.  Our suppliers will aggregate freight charges from several shipments and add the freight charge to just one invoice.  If we use landed cost and add the aggregated freight charges to the one purchase receipt, the cost of the items on that one purchase receipt are inaccurate and distorted.  Is there a way in the landed cost system to add a freight charge to a few fully received purchase receipts to better spread the aggregated freight charges? 

Is there any guidance on best practices for user profiles?  I have a number of users that are no longer with our company and we have disabled them.  I am wondering if there are any ramifications to deleting the user accounts to keep data cleaned up.  I’m thinking this is a twice a year type activity, run a report and any users that have been disabled since they are no longer employed, their user profile would be deleted.  Anyone have experience with something like this?

Where do i download the zip file to upload the Acumatica plugin into outlook?

Hi All,I am creating Physical Inventory Types and run into an issue where not all my location can be selected within the Locations Table. Our warehouse have 279 locations and seems like system is only able to take 200 locations at a time. Does anyone have a solution on how to increase the limit so I am able to include the whole warehouse in one Physical Inventory Types instead of breaking it to 2 parts?Kind regards,Calvin

We would like to see the ability to report prior period WIP reports that include open commitments and change orders by period.  Another way of saying this is period sensitive reports for POs and COs.

Does anyone know of a way to format a date in report designer as follows:10th October 2022I can get the date, month and year correct, but not the ‘th’.Is this possible? 

Dear ALL,I created Generic Inquiry using “Customer Listing” table. But when I pressed “VIEW INQUIRY” to see the result it gave error “Invalid object name 'CustomerBalanceSummary'.”I am aware that ‘CustomerBalanceSummary’ (DAC) is a Non existent DB  table in Acumatica. Can anyone let me know which DAC shall i use to show the “Balance” field of Customer Screen in GI.My Acumatica Version is : 22R1 [22.108.0024] Please follow the below screenshot for reference. Thanks a ton in Advance This is the field I want to show in my GI But ‘CustomerBalanceSummary’ is a NonExistent DAC in DB I am creating join like this This is the error I am facing 

I have created numerous service order types for all of my customers but now I would like to delete of them for each customer I have. It would take too long to delete them one by one. How do we delete Service Order Types tied to a customer in one shot? Could it be done via an import scenario? Also, how do I add more than one service order type to a customer in one shot using an import scenario? I know how to add one type to all customers but how do you add 3 or 4 types to all customers at the same time?  How do I adjust my import scenario for this? 

Dear All,Our business case is we will deliver material to the site and after finishing the installation, we will calculate the actual quantity of material to issue an invoice to the customer. The actual material quantity is less than the budget quantity.Current process:Set up a warehouse called Pending Sale and use order type TR on Sales Orders, transfer material to Pending Sale warehouse with a specific location linked to a specific project. (Each project has 1 location in Pending Sale warehouse) after finishing the installation, use order type SO on Sales Orders with actual quantity to issue an invoice.Issue: On Project PM301000, we can't track how many materials we already delivered to the site (TR or SO historical transaction).Question: do we have any function on Project that allows us to create a delivery transaction and it can be shown on Project PM301000 tooThanks in advance,Yên Chi

Is it possible to make a GI (or ideally, a dashboard tile based on that GI)  sensitive to the value in UserPreferences.DefBranchID?(I reckon that if there is no value in UserPreferences.DefBranchID, this requirement, ideally, would be ignored)I have tried to edit the filter on the dashboard gadget but the 'Value1' field doesn't allow me to pass through a dynamic field such as UserPreferences.DefBranchID - it only allows me to hard-code a certain value.Perhaps there is another way to go about this.Or perhaps this related Community Idea is as far as we can get. It would just be handy if we could retrieve the value for the User’s default branch and show them the data for that branch.  

Our client has requested to issue them multiple invoices in one sales order based on the payment method they have provided.Scenario:ABC Company ordered to XYZ Company 10 pcs of keycards, 100pcs of lockset, and 6000 pcs of Dustbox for ANSI Strike. Payment Terms as follows:For 50% downpayment - No shipment of stock items but with issuance of Invoice for downpayment If 80% of payment were collected - Sales Team will start to prepare to ship out the items that will create shipment on the system, update inventory issuance and issue new invoice for all items less the 50% downpayment For remaining 20% collectible - This will be reserved for retention - No shipment but with new invoice tagging the Sales Order reference.Is this possible in Acumatica? Any tips and advise for this kind of transaction?  

If I already Login but My token has been expired .How to refresh token get. or Any other way to get token through rest API. 

When I see the Stock Item screen my items get duplicate.  

Does anyone have tutorial videos on how to use Currency Management Module in Acumatica 2022 R1? 

Hi,I want to copy field Invoice Note in Invoices to Sales Orders and whenever this field is updated in Invoices, the field in Sales Orders should be updated with same value.What happen in my mind: create a custom field in Sales Orders, then implement Event Handler FieldUpdated of the field “Invoice Note” set value for custom field.However, I don’t if it is possible and how to set value for custom field in Sales Order in Event Handler.Any suggestions greatly appreciated.

Hey Community!!  I have customized a an out of the box GI (Appointment Details). I have added tables SO order and joined it with Service Order. And joined opportunity table (CR Relation and CR Opportunity) to SO order. This was done to get owner ID of the opportunity. What I can observe is that for certain records only, the lines are duplicating and for others it is fine. Also,  observed this was working fine few days ago but suddenly not sure why it is showing the duplicates. Here is the table joins:  These are the dupe values I am seeing only for certain records:  One thing I noticed is the Owner Field is coming for one line and is not coming for another wherever there are dupes. Attaching xml for the GI.

I’m afraid this is a bug, but I’m wondering if anyone else has encountered this problem. I have a Generic Inquiry created for Cases. There’s nothing especially unusual about this GI. The Case ID column is mapped to a navigation parameter which opens the Case screen. As my own user, the GI works fine. As several other users, the GI also works fine. As one or two particular users, the GI navigation does not work. Clicking any Case link opens the first Case in the list. Of course, the first thing you’d think of is to eliminate the variables. So using my computer with my Edge browser, I open an incognito tab and using the ‘Sign in as user’ feature, I sign into these user’s accounts. Exactly the same results. Some users it works for, some it doesn’t. How is this possible?

I was reviewing the release notes and looking to see if anyone knows if with the new feature of the side panels on the forms such as the Sales Order and Stock Items, can those be edited? I know you can edit from the generic inquires but is there a place to add/edit on the forms? Has anyone come across this yet? 

I am preety new in the acumatica customization….is there any chance for me to call external API call so that i can get the data ? after the data is being collected and presented i would like to enable user to select the data which then he can save.I was thinking to create screen, also to create custom unbound DAC-s but i am not sure how to work with the rest of the requirements, any suggestion would mean a lot.Maybe i could perform the get method using some other methods….i am currently stuck...at first i was thinking to call Acumatica POST call, but the problem is that i must first perform “login” so that i can “POST” the data, but i must use only one link from that external app….that is the reason which i wanted to create the GET call from the Acumatica itself…. 

Hi,Although we have branch security implemented, we are regularly getting employees picking projects from other branches on their expense receipts on Acumatica 2021 R2.Is there another way in our current version or is there a future version that supports this?Thank you,Dave Z 

HelloAbout the different “Tax Type” available in the “Taxes” settings in Acumatica:I would like to know if all types need to be integrated/supported for the retail-ecommerce (ex: VAT, Sales, etc) or if only the type “Sales” can be used? If the tax type “VAT” is selected for a Tax ID, is there any impact on the retail-ecommerce for the related options that can be checked (ex: Reverse VAT, Internal VAT, etc)? Do we need to integrate all of them? Is there any document for retail-ecommerce about the different tax type integration with retail-ecommerce?Thank you, 

Hi all, I set up the file synchronization to the FTP server as below. Currently the file name received on FTP server includes a date time tag, e.g. "STOCKEXPORT_2022_08_11_14_31_46.csv". Is it possible to remove the data tag and keep the file name as "STOCKEXPORT.csv" which is the file attached to the data provider. I haven’t selected anything in Export File Naming Format field and thought it would not add anything to the export file name, but it seems to still add a date tag.  Thank you.  

I am looking to join the ApproverEmployee DAC with my custom GI so I can see the required Assignee ID for the expense receipt.  I have figured out that the ApprovedEmployee DAC is hidden but I don’t have any other ideas how to gather that data and associate it with the receipt.  I have the screenshots below of the field I am looking for along with the tables & relationships for my custom GI.  

I am looking for a 401k report by payperiod for upload to the 401k provider (or Generic Inquiry).  What is the best report to start with for customization that includes deduction by payperiod and YTD total earnings and hours? ThanksSharon