There is a default Physical Inventory reason code in Inventory Preferences. I have approximately 20 different Physical Inventory Types generated by Item Class. When you select “GENERATE PI” in “Prepare Physical Count” it always pulls the default reason code from Inventory Preferences. I need a different reason code for each of the Item Class Inventory Types. Does anyone know if there is a way to set this up so you don’t have to change the default reason code every time before selecting “GENERATE PI” (in “Prepare Physical Count”) ?
I am importing Change Request data from another system into Acumatica.This particular data was given a status of “Void” in the other system.I noticed that Acumatica supports a status of “Rejected”. I am looking for an interactive way to assign the “Rejected” status to a selection of Change Request records(hopefully without having to create a Change Order).Thank you for reading this.-Ken Severud
From my brief research and testing it would not appear that Acumatica allows for a workflow where Landed Costs can be entered and paid for prior to the purchase receipt. Has anyone figured out a way to accomplish this cleanly? Like many companies, we are importing items from overseas and paying some significant landed costs in the form of freight and duties. We want to capture these costs and apply them to our item costs, but often we need to pay bills before items are received. Neither the freight companies or the brokers are interested in waiting for us to receive the inventory before they get paid and I imagine this is a very common scenario - is this a simple oversight in the Acumatica functionality? or have I missed something obvious? Appreciate any insight others have in this area
General contractor here. I was told by a trainer that we needed to select the “Require Single Project per Document” spec in AP Preferences. I don’t remember the reason, but when we enter bills, it makes our lives much more difficult to enter AP bills one project at a time. Is there any reason deselecting this option would be a negative thing? Thanks,Hannah
We want to keep track of the vehicles we own and use in servicing our clients. We want to be able to also track any costs to repair or maintain each respective vehicle over time. When creating a vehicle, we can enter purchase information but I do not see anywhere whereby we can track expenses incurred over time for the vehicle. Should we be using some other module to do this? Should we be creating individual internal projects for each vehicle to track costs against them? Any thoughts? Thanks, Joe
I work for a mid size logistics brokerage. A large portion of our business involves outsourcing freight from owner/operators. We use a handful of GL accounts to keep certain charges due to these haulers separate. However, most of these are all 1099 NEC expenses. How do I set up 1099 defaults so that a bill generated for any of these GL accounts auto-populate the same 1099 box without updating each vendor or each bill individually?
Good day, see the attached SO import. I have used it before and it worked to have one order with multiple lines items. Now the scenario is importing one order per one line item. The original file contents have changed; I did use the same columns remapping them.Any suggestions; I have orders with multiple lines.Thank you
Hi,I have already imported the basic fixed asset information. We are doing a FA implementation and the system is in migration mode. However, I am trying to do a second import only to update the Last Depr Period and Accum. Depr (see below) and my import is failing. The second screenshot is my import scenario. I have also attached a copy of my data provider. What fields am I missing in my import scenario or Data Provider. Thank you,Frances
The report exists on my end. I can see it under Data views. See screenshot. However, Emily and other users can’t view it anymore. She used it this morning. I looked at the security. I review the GI but nothing pops out on what the issue could be. I tried moving it to a different module and the moved it back. Any ideas?
Hello Everyone,I am working on a SO Import and ideally I would like to have the least amount of lines possible on the sales order. For instance, let’s say my data provider has 8 lines for a cheeseburger, is it possible to combine those 8 lines into one?For instance combine the asparagus and cheeseburger lines into one:
Hello, Our vendor is requiring us send files which are exported from Acumatica to them by SFTP in daily basis. Yes, this can be done manually, I can export the file to my local computer and then I use a SFTP client to send the file. However, I am wondering can this be done in an automation way? Thanks in advance.
Enter landed cost or AP Bill prior to the PO Receipt but does not pay the amount at the moment creating the liability
Hi,One of our customers practices the following scenario.They buy an insurance policy prior to the Receipt of goods and create a bill to make the liability for the insurance company. But does not pay that amount until the goods are received. When the goods are received this amount needs to be allocated to the inventory appropriately. In Acumatica we couldn’t find a way to create a landed cost/bill prior to the purchase Receipt and attach the Bill to landed cost lately. Since the customer is not paying the amount, we cannot assist them to use the prepayment request method, pay the amount and create a prepayment and apply the landed cost once the goods are received.Is there a way to handle this kind of scenario? Please assist me on this regard.Amanda
Our base currency is ZAR which is around 20:1 to the USD.When our approval values go through, I need them to translate into our base currency.In the following example, a PO for the following USD values:Will have the following ZAR values:This is how I have setup the approvals:The above example should have gone to the >150,000 approver, but went to the <150,000 approver. Which field should I rather use that would use the base currency instead of the PO currency? I have tried Line Total and I think Order Total.
Hi guys, a question on multicurrency accounting.I transfered 1000 USD from the USD bank account to SGD bank account, I received 1350 SGD and there’s a gain of 1.16 SGD here (base currency is SGD). But in the journal transaction, the realized gain/loss from currency shows 0. Then I checked P&L, it actually shows the right amount of 1.16 gain in the statement. Anyone knows why’s it like that? Could there possibly be anything wrong with the journal transaction? Thanks!
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.