General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,478 Topics
- 4,904 Replies
Hi, When entering a direct sale through invoice I need to take the sales account from the posting class or from the warehouse (other than a stock item)I've tried changing ‘use sales account from the field’ of posting class but it has not worked for me. Is there any possible way to get this done?Regards Amanda
I am trying to create an export for customer locations. on the export scenario, I have Source Object as Location Summary, Field / Action Name of Customer, target field / Value of =Every. customer mapped to customer id. Location ID mapped to location. I do not get all customer/locations on my export. The number of lines that exports is the number of customers only, I am missing hundreds of other customers which has multiple locations. Please advise
Join UBIX on Thursday, April 7th at 11 AM PT / 2 PM ET How advanced analytics can: Empower business users and owners Improve financial and operational forecasting Improve demand forecasts by 10-40% Improve input commodity price forecasts by 10-20% Become part of your strategic roadmap Register Today
Auto Balancing entries were not generated when paying branch 1 bill using branch 2's identity and cash account
Hello, We are still using 2020 R2 Build 20.209.0027. Is there a known issue of this version or some setting issue. I paid branch 1’s bill using branch 2’s identity. They are setting in different companies with different ledger. I remember a pairo f entring GL transactions should be automatically generated like below. However, I did not see this in production envrionment. How is that. Thanks.
If an AP invoice is accidentally booked to the Fixed Asset clearing account, and then either reclassed to an expense instead of the FA clearing account or reversed with an adjustment, the original AP invoice still shows in convert purchases to assets.Is the best way to remove the transaction to mark it as reconciled and process? It seems to remove the transaction from the list, but I’m not sure if there are any other issues that may cause I’m not seeing yet. Or is there another way to remove that transaction from the list so users don’t accidentally convert it to a FA?
Hello Everyone, Totally noob to the fixed asset module in Acumatica...ok, here it goes...trying to upload the list of FA in our LIVE environment so doing some testing...and I can not seem to put in the correct accum depr amount for a fixed asset...am I missing a step of do i need to know some basic accounting stuff?E.g. FA item#1 cost 1M and I want to put in that the accum depr amount is 100K so far...how do I do that? Thanks! Kind regards,mrivera67
I just created a new unit 32C and want to include the unit in the consolidated report. When I run the consolidated report, 32C will not be included in the report. Am I missing some critical steps to set this up correctly? When I run the department 32C report standalone by clicking the tree, it will show a correct report. But it is just not included in the consolidation report…. Thank you for your help in advance!
Hi All, I have select wrong fixed asset in convert purchase to asset. How can I reverse it? I try to create FA Transaction with transaction type purchase + with negative amount, and it FA Accrual is on debit and asset is on credit (batch nbr FA000155), the asset balance is deducted but it showing error on fixed asset reconciliation tab “The current cost of the 00000026 fixed asset and its unreconciled amount must have the same sign.” and in the convert purchase to asset is not showing the journal of batch nbr FA000155).fa adjustment purchase + with negative amounterror info reconciliationgl journal from fa adjustment convert purchase to asset not showing the FA000155 journal Regards,Sergius Ketaren
Can someone let me know what the logic of the conversion of units of measure is. I have read the help area about 10 times and I must have a mental block as it seems to be the reverse of what I would expect for converting from one unit to another. i.e. I would think converting a box of 10 bottles to a base of 1 bottle would require the instructions to divide by 10 but the operand is multiply. I am feeling quite stupid about this so please be gentle..
I am receiving an error when trying to enter an AP Bill.The Purchase Order has one line item, for a quantity of 10 pieces. All 10 pieces have been received and a receipt for the 10 has been created and released.Now when I get the invoice a few days later from the vendor, I go to the Purchase Order # mentioned on the invoice, however, when I click the “Enter AP Bill” from the actions drop down, I receive the following error:
Looking for info on how I can create a printed form for AP bills. Ultimately, we would like forms for all bill types but looking for immediate need for a Debit Adjustment printed for so we can send to a Vendor for a Debit Request (Credit Note to the Vendor). Has anyone had any success in creating these? I am a bit surprised these are not out of the box. Thanks all!
We are trying to reverse a payment application on an AP Bill through Checks and Payments on the Application History tab. We get an error of “SO Error: the document is out of balance”. Any idea why? The “Reverse Application” works fine on the AR side, but it is not working on our AP side.Thanks!
After upgrading to 2021R1, the Bank Deposit screen has become unusable. We have a not-so-large ARRegister table (few million rows). It takes about 8-10 minutes after clicking “Add Payment”. Looking through the built SQL query, Acumatica is using a STRAIGHT_JOIN on the ARRegister and the ARPayment. After capturing the query and using an INNER JOIN the results are immediate. I understand the difference between the two and using STRAIGHT_JOIN is rarely used. Has anyone ran into this issue with a fairly large db?FYI - I did un-publish customizations and I also created a ticket and reproduced the issue with support. Any other ways to create bank deposits other than import scenarios since that will just make the problem worst.
Are there any repercussions of creating a Fixed Asset without an AP Bill (bypassing the Convert to FA step)? Create Fixed Asset Debit FA and Credit FA Clearing Then Create Cash Entry to record the transaction Debit FA Clearing and Credit Cash This would bypass the AP Bill process completely and I want to be sure there won’t be later problems.
Our services clients have sub contractors who provide invoices but the payment of the invoices has to be made to an umbrella services company and only one payment to cover all sub-contractors associated to the umbrella company.A parent child association would work well here as it does in AR.
There is an old video on the topic of Customer Refunds where the user goes through about five or six steps to issue a refund to a customer. And it works great! However, there were too many steps and Acumatica appears to have simplified the process in subsequent releases.So now, in my 2021 R2 demo database, when the credit memo is on the screen, there is an option on the ...More menu to REFUND the amount to the customer. I’ve done that and I see a JE that shows AR was debited and Cash was credited but I don’t see where a check was actually issued to the customer. I can’t find a pending payment in payables but the JE looks like is was processed as a check.The whole point of this exercise is to issue a refund check to the customer and I’m just not seeing it. What am I missing here?
Dear All,I was wondering if any of you encountered this issue. We hosted 1 instance for multiple tenants. When we run depreciation in Tenant A as well as Tenant B of the same instance, Acumatica will prompt an error “Another depreciation process is running. Wait for completion.” Is this a core issue in Acumatica?
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.