General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,462 Topics
- 4,857 Replies
Historical Inventory Valuation : How to adjust out the inventory without do the adjustment transacation
Hi SirWe have encountered a problem about the inventory , we make mistake do receipt in a part # where that should be use existing 5 parts to do kit assembly into one part # . Currently , our system have extra 5k in inventory history valuation but in financial inventory account is correct . We cannot do adjustment transaction as it concern about double entry where it will affected financial account figure.May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure? Hope to hear from you soon.Thank you
Hello, One of our clients has imported and then posted several hundred bank transactions (they imported twice). As far as I know, the best way to void them out would be to create an import that reverses the transactions. If anyone knows a better way, please let me know. I have created the integration but keep getting an error that it cannot save or release the transaction. I have followed the steps exactly in Acumatica and I can manually perform them, but the integration seems to be having an issue. All I am trying to do is import a list of the transactions that need voided and tell the system to reverse them. Maybe because it is creating a new transaction by reversing?Any thoughts or ideas would be help. Thank you!
Hi Everyone ~After years of using Quickbooks Online I have recently taken a new job using Acumatica. It’s been a learning curve, so many moving parts in Acumatica. Here’s my question: The company I work for receives inventory items that are paid by credit card and there is no PO. How do I enter the inventory and the bill that goes with the items. Thanks for your help.
I need to create a Parent - Child relationship between APTran and ARTran tables. The artran.OrigInvoiceLineNbr field has no value (value is NULL) on the existing data. Can I populate this field with the APtran.LineNbr value for reference in the ArTran table?
We are trying to change the description field in the timecard. We have found that the “Summary Day for:” is very confusing. We would like to make the Description field be filled with a single ‘ or a , . This makes the Summary day for: go away. Has any one defaulted the description or know how to. My next project is to make overhead tasks not choose Billable when the employee uses them
On the Revalue AP Accounts form, I specify the settings to perform the revaluation of open AP documents. The Revalued Balance > 0. When I release the transaction and review the Journal Transaction for the revalue AP. I notice that the generated batch has a 0 Debit and Credit AmountNotice that on the Revalue AP Accounts screen the Revaluation Total value is not 0How do I resolve this?
On the Budget Form the Stat Ledger is defaulting in the LEDGER field. When I run the Budget Import Scenario the first branch gets imported to the budget ledger but the following branches go to the statistical ledger. I have hard coded the ledger on the import scenario and I have tried mapping the field.I think the issue with the default ledger being incorrect is causing the incorrect import results.Has anyone else experience this?ThanksColeen
Is there a way to calculate a proporational discount if you partially pay a Vendor early on an AP Bill?Bill # on 6/01/21 2% Net 30 on a Bill amount of $50,000Client pays half on 6/29/2021 $25,000 to capture partial discountFull Discount is 50,000*.02 = $1,000Partial Discount is 25,000*.02 = 500
Hi EveryoneNot sure who can advise for below question related with corporate credit card - expenses claim.As the credit card transaction involved with different currency , example: SGD , HKD and USD.Understand that when we create expenses claim under corporate credit card , only one currency that we using (the currency depend on what currency we set in employee profile) .If like my scenarios , there are 3 different currency, how should i create the entry under one expense claim?Hope to hear from you soon .
Hi,When I used to click on the Payments and Applications under Transactions for Receivables, it would give me a list of all my payments and applications (a transaction list). Now it just takes me to the individual payments and applications, and not the actual transaction list. Did something happen to that list? Or is it a settings configuration that I need to fix? All my other options under Transaction still seem to work fine, but this option changed recently for Payments and Applications. Thank you.
Hello, Can you help me with following issue?How do I make the tax that I enter in Sales Prices (AR202000) for a given Price type, Price Code and Inventory ID appear and calculate when creating a Sales Order? I have created a special customer and a special Customer Price Class for him. Then I have set in Sales Prices for this Customer Price Class the prices for the given stock items and taxes. When creating a Sales Order, I would like the price and tax to be transferred from the Sales Prices after entering the Customer and Inventory ID. Currently, when I select the inventory ID in Sales Orders (SO301000), the tax category set in the Stock Items (IN202500) pops up. Is it possible to overwrite it ?
Hi!Does anybody knows if it’s possible to restrict visibility in the Aging Report to specific users that manage a group of customers? For example, the group A of salespersons manage 5 customers only and they only need to view the aging for their specific Customers.I tried first to use Restriction Groups for Customers entities but when the same user runs the Aginig report, the customers that not belong to their restriction group, are displayed anyway.ThankS!!
When trying to print AP Checks we receive: Field not found: 'PX.Objects.AP.APPrintChecks.APPaymentList'.
Hello All, apologies if this is a silly question. We are new to Acumatica and getting more experience by the day.In our sandbox environment when trying to print AP checks we are receiving the following error:Field not found: ‘PX.Objects.AP.APPrintChecks.APPaymentList’.On the Checks and Payments screen it shows status of “Pending Payment’. Any feedback is appreciated. Thank you in advance
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.