General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,095 Topics
- 3,658 Replies
How to configure the VAT tax settings so that we can generate a tax report with whole sales amount and cash discount displayed separately?
Hi guys,Consider this case below.If the credit terms for customers is “3% discount in 10 days, net in 30 days”, and we made a sale to a customer of $100, with a VAT rate of 10%. The customer paid within 10 days, and I’m trying to generate a tax report looks like this:Total sales: $100Cash discount: $3 (-$3 is also ok)Total taxable amount: $97Total tax amount: $9.7But according to what I have tested on Acumatica, it seems like the above couldn’t be achieved. I tried to use the cash discount feature, and the outcome looks like this:Total sales: $100Total taxable amount: $100Total tax amount: $10The total tax amount here isn’t even correct (should be $9.7).I also thought of recording the cash discount in a separate line in the invoice, but we wouldn’t know whether the customer takes the cash discount or not while recording the invoice. And once the invoice is released, I assume there’s no other way to add a line for cash discount.So any better ideas on this case? Thanks in advance.
Payable Incoming Documents - Currency Issue Bills
Good day,We just started using the Payables Incoming Document feature. It works fine in my US tenant however, when I tried to demo it in the UK/EUR instance for other currency (GBP/EUR) I get the below message. The vendor profile is correct in the currency types.Any ideas or solution on fixing this issue. It the currency rate is defined however, could this be a date issue on the currency effective date? Thank you@Evan G
Australian Diminishing Value Depreciation method
Hi, We are trying to use Australian Diminishing Value in Fixed Assets, however system forces us to use ‘useful Life Year’.This method is only capturing the place-in-service date, the cost and the percentage per year.So it does not make sense to have years against each asset, as it’ll change the method. Can someone assist and let me know how you imported your assets using this method? Thanks,Foujan
Purchase Order > Purchase Receipt > AP Bill
Hi Everyone, How to create a bill directly from PO not PO receipt?ExamplePO created - material + freight(non stock)PO receipt - only material When I create a bill, I can add the PO receipt details, so freight cost will not be added on the bill. If I manually add it in the bill, will there be a problem on the PO side? My boss doesn’t wanna add the freight cost in the PO receipt, since freight is not a material.
Recently Acumatica stopped defaulting the Branch on the AP Bill Screen
This is a local install. Default of Branch on the AP Bill Screen just stopped working. Have to go to the financial tab and select branch to get period to default. Any ideas how we can get back the branch default on the ap bill screen? Where is that set?
Just getting used to the what seems incredibly formal statement process (for a small company anyway). I ran the statements for a period and forgot to enter one receipt of money from the customer, how do I re-run the statement to include for this extra money received on the last day of the month. It all feels very locked in and unwieldly to me as I am used to just re-running a statement as many times as I like. Best Regards Malinda
Credit Hold on Cash Return document
Can someone help to explain why cash return document is placed automatically to credit hold when credit term is Prepayment (terms requires 100% prepayment) and how to change this behaviour? Credit verification rule for this customer is Disabled. This doesn't happen on non-prepayement credit term though. Workaround is changing credit term but not ideal.
Excel Cannot Open the File " File Format or File Extension is not valid"
Hi Acumatica,Seeking your assistance to figure out the reason behind this error,Upon generating a report into excel file, The generated file has 0 bytesand when opening the file the excel give as this king of error, May we know the cause of this error?Thanks!
Balance sheet line contains data from another ledger
I am trying to understand how the Balance Sheet works on Acumatica so I can reproduce it in my integration project. From my understanding, Balance Sheets are generated based on a Ledger. However, it appears that the Inventories account in the Balance Sheet below contains data that has been posted to a different Ledger.This Balance Sheet was generated using the T100 demo data, using the ACTUALSOFT Ledger. Inventories amount of 440,480. In addition, I am not sure why this Balance Sheet does not balance. The Journal Transaction that I am confused about is shown below.As you can see, this journal was posted to the ACTUALCOMP Ledger, and not the ACTUALSOFT Ledger which I used to generate my Balance Sheet. However, it is still present in my Balance Sheet. You can see the calculation for the Inventories account below to see that it includes that transaction.419,000 + 21,480 = 440,480 -- the amount shown in the Balance Sheet Why is this transaction, that has been posted to a different ledger,
Unposted GL Transactions
Does anyone know why journal transactions from the AR Module wouldn’t automatically post to the GL if it’s set up to do so? We have noticed that 3,666 transactions from a one week period in December have not posted to the GL. I’m relatively new to the position and at a loss as to why this would have happened. Any help is greatly appreciated!
HiAm trying to configure automation schedule to prepare and email statements to my client, the statement cycle set up for all the customers in the client system is end of financial period but he wants the system to prepare and email statements by end of month(EOM), is it possible configure the same as per his demands? Regards
An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.
I’m trying to delete a void payment that is in a balanced status but I receive the below error.An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details. How can I delete the voided payment?
Bank Reconciliation by using other currencies.
Hi All,I need to do a bank reconciliation for EURO currency. But my base currency is USD. Could you please let me know that should I convert my EURO figures to USD before import my bank statement to the system or system automatically converts it. Thank you
Recurring entry for monthly loan payments where principal and interest distributions determined from amortization schedule
Situation - a business has a long term loan, a mortgage loan, where the monthly payment is fixed and the split between principal and interest varies each month based on the mortgage amortization schedule. The monthly loan payments to the lender are set up to be made via PAD direct from the company bank account.I can create the first monthly mortgage payment as a journal transaction and then create a recurring transaction from the journal transaction. Generate recurring transactions will create the monthly payment journal transactions, but only the 1st payment will be correct. The finance user will need to edit the 2nd and future journal transactions and correct the principal and interest distribution amounts manually, according to the amounts from the amortization schedule.Is there a better way to configure this?I suppose the Balanced 1st journal transaction could be exported to Excel and the future monthly payment transactions be added into the Excel sheet with the correct split betw
Already have an account? Login
Social LoginLogin with your Acumatica account
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.