Solved

we are have a requirement to read the data from external API and add to grid, this should repeat in every 5 seconds and stop when we clicked stop.Can someone please guide me the correct way to do this.So, we created two buttons START and STOP and also a method to read from API and insert to grid.Issue we are facing is - on start, say we are inserting 2 records, when we clicked on stop button, the records in the grid the getting duplicated, i mean, total 4 records.Please have a look at below code. public PXAction<DAC> startRead;        [PXUIField(DisplayName = "Start Scan", MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select)]        [PXButton(CommitChanges = true)]        public virtual IEnumerable StartRead(PXAdapter adapter)         {            System.Threading.Thread.Sleep(5000);            //cntLoop is unbound field with propery [PXUnboundDefault(true, PersistingCheck = PXPersistingCheck.Nothing)]            if (this.Document.Current.CntLoop == true)

Hello, @vkumar , @Naveen B  I have an American date format in an excel file that needs to be uploaded into MYOB Adv.  The format is like so ‘20231231’ (i.e. YYYMMDD).  How can I convert this to an AUD format in the Import Scenario?Regards,Laura

Hi everyone,We need to use different languages in Acumatica. The website is working well. I only have problem with mobile app. I checked out the mobile code as below. Does anyone have any ideas to add localization for mobile app?  

I have customer who regularly gets orders from the government with quantities between 50,000 - 150,000.These are usually scheduled over a period of months.They would like to be able to create a manufacturing order for the total monthly quantity and then release smaller (unique) batches to the shop floor and be able to track those batches through clock in/out entries by shop floor personnel.If they created individual manufacturing orders for each of the batches, there would be in excess of 100 manufacturing orders for each monthly delivery and the maintenance would be prohibitive.Thoughts?Thanks for your help!Donna

Hi Everyone, I am learning Acumatica. Please help me on below issue. Whenever ,I open Stock Item Form. I am Getting the below issue.I’m unable to stop the debugging.  

Hi, I’m relatively new to Acumatica but far from new to ERP systems and implementations.I have created an item number. That Item can exist at three warehouses. Those warehouses have replenishment relationships defined with each other. I have set safety stock, order multiples, etc. at each location. I have set an inventory level at the main picking warehouse that is significantly below the safety stock. At this point, I would expect replenishment activity to be suggested to transfer stock from the next warehouse in the chain. This does not happen.I then increased the demand at the picking warehouse by adding a sales order, in case there was some requirement for a SO to trigger the replenishment. This also did not work.Hopefully, I am missing something really straightforward.Warehouses are PICK, BOX and OFF-SITE. What I want is for transfer orders to be suggested to bring stock in from BOX to PICK when there is SO demand or when safety stocks fall below the defined parameters. Likewise,

Hello everyone,I am dealing with a peculiar issue with closing the fixed assets financial periods. To give some background, I was reconciling some new assets and I needed to open some old periods for the reconcile+ transactions to be in the right period. When I tried to close the periods again the system gave me an error stating that I had a bunch of unreleased fixed asset transactions. The assets in question are all fully depreciated assets that were brought in at the go-live with the “update gl” checkbox de-selected. Now I am stuck with this module being open all the way back to 10-2020. Has anyone come across this issue before? There are no transactions to release on Release FA Transactions FA503000.   Thanks

In the mobile app for 1 client the SO page is displayed differently than my others. The SO nbr itself isn’t displayed, so when my client has to find a SO by it’s Nbr he has to do a universal search. He said it wasn’t like this a week ago. I noticed there was an update to the iOS app about a week ago. Has anyone else seen anything like this? I’ve tried to find differences in customs with other clients, and can’t. This client is on the latest version of Acumatica. Also a suggestion, a separate category for mobile apps? 

I’m creating a production Order through the processing screen where it doesn’t have a SyncTimeTag table used. when i create any transaction manually from the screen its saves a record with the note id in  SyncTimeTag table. So, while creating a production order an error throws like Cannot insert the value NULL into column 'NoteID', table 'DB.dbo.SyncTimeTag'; column does not allow nulls. INSERT fails.The statement has been terminated.

Hi, I am new to Acumatica, I want to show or hide some section based on the check box value which is available in another form. How to achieve this functionality. Could you please assist on this.

Good dayI am import my invoice type “cash returns” and on the template I am getting the following error message“object not set to an instance of an object”There are no customizations done on the invoice screen SO303000 

Hi,Could you please provide a quick guidance on importing opening balances for Cash Accounts without affecting the bank reconciliation. Thanks,Dulanjana  

Does anyone know of a way to Export and then Import Document Templates? I looked to see if I could add them to a customization, but dont see a way. Seems like an issue if you have users in UAT creating these documents, and not a way to get them moved to production. 

Hello Everyone,I have an instance with Build 20.212.0038 and have configured Authorize.Net as processing center and payment method and using to map with BigCommerce Authorize.Net payment method.But as soon as I am selecting Processing Center ID the Release Payments checkbox getting disabled and then the synced payment records are not getting released automatically.Can someone please suggest on how we can configure the settings to Release, synced payments automatically.  

Not able to save MRP preference form  

Hi @Naveen B , All, me again :-).  I have created an import scenario to create Sales Orders from information in a file.  The issue I am having is when the there are duplicate items for the same SO in the file.  The duplicate inventory lists in the Sales Order fine however adding the Batch and Batch Expiry is where I cant get it to work.Any help appreciated. Both import scenario and file attached.Regards,Laura

We have a few items that the Vendor is requesting that we order in multiples of 10. We thought of doing a Pop-Up Note for the item so it would appear when placing on a PO, but then it appears on the Sales Order screen also.  This is confusing to the order entry users. Any other suggestion on how to accomplish ordering the correct amount on the PO?

I have a customer who costs EVERYTHING used to manufacture an item (i.e. pallets, bags, box labels, etc.). But a quantity of 1 is used per manufacturing order, not per piece during an operation.Is there a way to add those items to the BOM without having to have it be a fraction of the item per item produced?Please help :)

Hi there,we would like to use backflushing in multilebel boms. Automated reporting back of work and material works fine for one-level-BOMs. However, if we use multilevel BOMS (e.g. a BOM with a subassembly) then we always need to report work back for all operations. This can be very annoying since we sometimes have 10 operations in one BOM and also several operations in subassemblies. We also marked the subassembly BOMS as phantoms. And we also marked backflushing everywhere. However, it does not work automatically. Is there any possibility to automate this? Thank you very much.Best Wishes  maracuja 

say if i want to review run a report to show production ticket A and B from the period of Nov  2021 labor hours details. it seems like the native report do not have a field of production ticket number..the exact field for filtering.. do we have to customize the report?thank youZoey

What is the process required to enable the report attached below in order to run the report, we cannot run this report using the report parameters as well. The screen ID of the form is RQ302000.Requisitions Form 

Hi,I did one Customization related to Vendor Screen in 21R1(Build 21.113.0011)After publishing Package in Sandbox/Server Instance. Package got published Successfully.After opening an instance I am getting error like below{"Message":"An error has occurred."}Can you please help on this errorThanks.  

How to get the default value for the Transaction Period and Financial Period based on a date field entered and branch selector Hello,I have a customization form that I need to fill “Transaction Period” and company’s “Financial Period” by defult from a date field and the selected branch but I can not make it work. I reviewed a couple Acumatica’s owen screens and I’m doing exctly the same (at least I think so) but these two fields are not filled by default. Any help appreciated. Here is my little Graph, partial DAC and Partial ASPX. namespace MyCustom}    // Graph    public class PMCashflowProjectionEntry : PXGraph<PMCashflowProjectionEntry, PMCashflowProjection>    {         [PXViewName("Projects Cashflow Projections")]        public PXSelect<PMCashflowProjection> CashflowProjections;         public PXSelect<PMCashflowProjectionSchedule, Where<PMCashflowProjectionSchedule.projectID, Equal<Current<PMCashflowProjection.projectID>>>> CashflowProjectionSc

An ap quick check was produced for an employee as they were found as a vendor when the check was entered.  Which was kind of cool that you did not need to make up an employee and an employee vendor to reimburse out of payroll.However, if you go in and try to void that quick check you get an errorEmployeeID 101087 cannot be found in the system.note 101087 is part of the error as the employee id and not an error codehas anyone run into this issue. I have researched and cannot seem to find any issues beyond simple instructions to void a check

There is a “Weight Item” checkbox in the Stock Items screen in Acumatica 2021R2. What does this checkbox do?