Solved

Hi All, I am modifying the GL Register Detailed Report (GL621000.rpx). I am trying to add 2 optional parameters (Module and Batch Number in Journal Transactions form) but the batch number selector parameter does not get populated. Hope you can help.Module ParameterBatch Number ParameterFilter ConditionsErrorThank you.

Hi ,How can we reset all passwords at once.  Is it possible to reset all user passwords to a one passwords  at once? Thank you,Dulanjana

I am looking for a report that would show ALL ITEMS issued to a POP. Does one exist, or will it need to be created?

We recently found a variance between the LOT numbers  that our material transactions were set to consume vs the LOT number our issue transaction were consuming. The quantity of each product deducted was the same, but the LOT it was using was different between the two transactions.We escalated this issue to Acumatica and they came back and told us that we needed to switch our base UOM to the smallest unit of measure that we use. Currently our base unit is in LBS and we have a UOM conversion into grams and into kilograms.Moving all of our inventory from being stocked in LBS to being stocked in grams is going to be a major change to our processes and take a lot of time to fix a problem that was working fine for us for over 6 months. Does anyone have any ideas in how to fix this issue with changing the UOM’s?

Hello!We are trying to work with the PO505000 Massprocessing but we stumbled upon a problem without a clear solution. If the Order with the Articles marked for Purchase (SOLine.PoCreate) is in the Status Open, the screen PO505000 displays everything right. As soon as we switch to a custom defined Status (In Production) that we implemented with workflow changes, some data seems to disappear from the screen.Please take a look at the following Screenshot for Reference.Line 1 is in Status OpenLine 2 is in our Custom Status As you can see, line 2 is missing several details like the Customer or the Order Nbr.Yet it is still possible to click on the order nbr and it will redirect to the correct Order.Is this a bug? Or do we have to implement something specific?Greetings

Requirement: We have an Import Scenario to import project transactions. The Sub Account value needs to be assigned from the default cost sub account set for each project. As part of the import source file, we have the project ID in the source file. Then for the that Project ID, I want the system to populate the sub-account from the default Cost Sub Account set on the project in Acumatica. Is this doable?

Good day, I am trying to depreciate a fixed asset per calendar days per period. For example, if an asset has an original acquisition cost of $365 (useful life 1 year, straight-line), the depreciation schedule should look as follows:Jan: $31, Feb: $28, Mar: $31, …… , Dec: $31.I have created depreciation methods using the full day averaging convention but this feature seems to prorate the depreciation when placed in service during a period, for example if an asset is acquired half way through the period - only 50% of the depreciation will be posted to that period. Example of Depreciation Method setup: Example of Calculating Depreciation for Fixed Asset:May you assist?Kind regards,Nicolas

I want to get count of all visible records on grid. If I will filter it for ex. by Vendor record count will change and I want that count not from BQL select;

We are using the REST API to create a Sales Order in Acumatica. For some customers we receive the below error message. Not sure why the API is complaining about “inter branch” as we target a single tenant and try to create a sales order for an existing customer under that tenant. (Not sure if branch means something else than “tenant” in this context) I read the other post on the forum and tried to find the feature for enabling inter branch but that feature was not listed. Can someone please help with this?   Exception: An error occurred during processing of the field Allocated value False Inter-Branch Transactions feature is disabled.PX.Data.PXOuterException: An error occurred during processing of the field Allocated value False Inter-Branch Transactions feature is disabled

Dear ALL,Please help me to know which DAC takes the data of the accounts for all periods of the year (Period 1 to Period 12).This DAC will have Fin.BeginingBalance, Fin.PTD Debit, , Fin.PTD Credit, Fin.YtdBalance,.. almost like DAC GLHistory. But the DAC GLHistory is missing periods where there are no transactions.Many thanks !NNT  

Just found that my Default Contact ID are one less than the correct Contact ID. I can work around it in formula, but makes me nervous being out of sync. System working correctly, so is that just the way it is on Vendors which I’m working on now?

My need: I have setup a scenario to test posting of transactions.  Once they are posted, it cannot be undone.  So, in order to test multiple times, I have been using a snapshot.  However, restoring a snapshot is pretty tedious and time consuming.  I have SQL installed locally.  Doing a backup via SQL takes mere seconds.  Restoring a db via SQL takes seconds.In the past, I tried restoring a sql db and it corrupted my instance of Acumatica so badly, I had to delete everything and install from scratch.  I think it might have been because I was logged into the instance when I did the restore, but I don’t know what happened.Before I kill my environment, I want to know if any of you use SQL backup/restore to perform repetitive testing.  This is what I think *should* work.Prepare my transactions for posting log out do a FULL sql backup login  post and look at the results. logout restore the db start over at step 4.Any thoughts on this?

Hello folks. I’m trying to open a report template to make a couple of minor cosmetic changes. I’ve done it several times before without any problems.But when I tried to do it today, the “Open report from server” dialog box wouldn’t accept my login credentials.I have two accounts in the system, both have Administrator and Report Designer permissions. One is an AD-connected account (the one I use all the time for everything) and the other is a native account (that I rarely ever use).Although Acumatica itself doesn’t prompt me for credentials when I use the Active Directory log-in option, the Report Designer app does. As expected, the Report Designer’s “Open report from server” dialog box pre-populated the Login field with my user name and left the password field empty, expecting me to enter the password. But when I enter my password (the one associated with my AD account), the dialog box returns the error: “Error during login : Invalid credentials”.Any idea why the “Open report from serv

Dear Concern,request you to please suggest the process for inventory out from warehouse and in after job workInventory Out for job work and in against job work: for example we wish to out inventory like  component, Semi finish goods and Raw material from warehouse  to vendor place for job work activities and after job work same will be return back as Semi finish goods or finish goods . how to track inventory out and in process thru acumatica ERP.  

Hi MFG community. I just ran into issue with 2022 R1 build 22.102.0054. My client has configurator. When you create  a production order and add the preconfigured key to the reference page, the order saves correctly.If on the other hand, your create the production order, click save, then add the preconfigured key to the references tab, Acumatica copies in the default Bill of materials associated with the configured item. It does not copy the preconfigured key build.Is anyone else seeing this behavior? Chuck

Hi everyone,Hoping someone can help us.We posted a customer payment to 20 June 2022 in 09-2022 period but should have been 20 July 2022 and 10-2022 period. We have re-done the payment to 20 July 2022 in period 10-2022 however, when we voided the initial incorrect payment (posted in period 09-2022), we accidentally used the wrong period (10-2022). Now the bank reconciliation is out by the same amount.There doesn’t seem to be an option to reverse a void payment unfortunately. Much appreciated,Daniel 

Hi guys Here I want to change the colour of fields in green in the grid when status is Active .@Naveen Boga, @stephenward03, @Marco Villasenor  Thanks,shahidavali

I have setup Row Level Security to GL Account Access and allocated the restriction group to a userThe User should not be able to transact or view the account included in the restriction groupThe result is that the account in the  restriction group is not visible to the user when he view GI/Pivotand the user cannot select the account when capture transactions.I am therefore happy with the resultThe problem however is that the user are able to view the account in the batch file on theJournal Transactions screen GL301000I can restrict the user to not be able to view the detail of the Journal Transaction batch with Access Rights to a role.To implement the Access Rights  by Role is not the ideal solution.Please confirm if I understand the functionality of the Row Level Security to GL Account Access correctly.Should the restriction to the account also apply to the account in that the user will not be able to view transactions captured against the account. 

Hello, Can we changed or is there a way to change the ship via code when the shipment is already released?

Dear All,I want to import AR & AP opening balance with details: Customer ID/ Vendor ID, Account, Sub Account, VAT Invoice, Date, Due Date, Debit, Credit, and Amount.Is there any import template in Acumatica that fix to this requirement?Thanks in advance!Yên Chi

I have added the Order and Shipment Number fields to the Details grid in a customization but would like them to navigate to their respective screens when clicked.  This seems like a really simple thing but I haven’t been able to work out how or where this is defined. This is already present in SO303000 and I’ve been comparing to see what the difference is but am not sure where I should be looking. Can anyone give me some pointers as to how to go about this? Thanks, Phil

I would like to add a dashboard widget that aggregates data from a multiselect attribute. When I configure, the widget is displaying separate data sets for each instance of the varying multiselect values.Scenario: business account 1 has an attribute that currently has value 1 and value 2 selected. Business account 2 has an attribute that has value 2 and value 3 selected.I would like the widget to show 1 for value 1, 2 for value 2 and 1 for value 3. It currently is displaying 1 for ‘value 1 and value 2’ and 1 for ‘value 2 and value 3.’ Is there a certain way the widget needs to be configured to get this to display correctly or is this kind of data crunching not possible for multi select attributes? Thanks!

I have a scenario where we created 2 separate approval workgroups (reviewer and approver) for AP Invoices and Memos. Once I created this and tested the workflow, I noticed that the document gets automatically approved if the user belongs to reviewer and approver.Ideally, the process should be, after reviewer approve it flows to approver. I am not sure if my configurations are wrong.Anyone having similar issue?

Hi All,Need help to figure out why the Automation Schedule are not working, we are not in lock out mode but still we are getting error as “Automation Schedule scenario has not been performed due to the database lockout”. Please help us.I think this is happening from yesterday after we published new customization package. Below are the steps we followed when doing package publish first put in lockout mode, then took snapshot then deleted the snapshot, then removed the lockout modethen again, when i was about to publish the package, i put in lockout mode again and published the package then removed from lockout mode

I am trying to figure out how to have multiple purchase receipts againt a single PO. For example, if a vendor shipped the PO in staggered shipments, and we want to have multiple receipts against that PO.Can someone post on how this is done? I see that the Purchase Receipt gets linked back to the PO in the “PO History” tab. But I can’t see how to add an additional Purchase Receipt once a single receipt has been entered...