Financials

The current Calculate Commissions process ONLY computes commissions for salespersons.  No financial transactions are generated from the Calculate Commissions process. I’m suggesting an enhanced process that would debit Sales Commission Expense into an expense account associated with the salesperson and a balancing credit to a Sales Commission Payable Liability account.  There are other Ideas in the Acumatica Community that request posting commissions into an Accounts Payable vendor and I support those ideas as well.  Credit A/P - Debit Commission Expense. Currently the reporting for Sales Commissions is inadequate.  The report of commissions by salesperson does not list the customer, invoices, or amounts that comprise those totals.  The Commission Details inquiry does not list the Salesperson responsible for the sale.  It is a challenge to get a GI that provides all the information a controller would need to make financial entries into

Hello thereWe are an importer of goods and often use sea shipments from the Far East, which means we are invoiced in full by the supplier when the goods are handed over to the agent at the port (say month 1) and then the goods can take up to 9 weeks to arrive and then they are booked in (say month 3).With previous software I have had two date fields, one the posting date which is when the entry arrives in the accounts and two the document date which is the date of the suppiers invoice. This way the invoice would be entered as the same date as the receipt of goods but the aging could be arranged by document date. All very helpful. Acumatica has only one date field avaiable for a purchase invoice and I am not sure what to do for the best. I know we could probably use Goods in Transit booking which is technically the correct way but we prefer not to as we are such a small company and would prefer one entry instead of two. (booking goods in and then transferring them once they ar

Hello,I am aware that Acumatica has a dedicated account for keeping track of the YTD Net Income balance and with every income or expense transaction, this account is updated. Furthermore, as documented in Acumatica’s Help material (see below), Acumatica automatically updates the Retained Earnings account for the next financial years that are defined. The system updates this account for every transaction posted to an income or expense account. When the system updates the balance of the YTD Net Income account, it also updates the beginning balance of the Retained Earnings account in the next financial years for which the financial periods are defined. For a new financial year, the system resets the balance of YTD Net Income to zero for a new financial year. However, for auditing purposes, when a user looks at the Account Summary and Trial Balances for the retained earnings account, the Ending Balance of the last period of one

Hi,In the invoices form (SO3030PL) always system picks the sales account which is mentioned in the stock Item if a stock item is available in the invoice. Even though we change to pick the ledger account from posting class or warehouse by posting class, it always pick the account from the stock item.Is it possible to change this to pick the sales account from warehouse or posting class ? Thanks

Hello Everyone, As I am a newbie to the Fixed Asset module...i did a big BUBU...I uploaded a list of fixed assets but later was told that that is not the final list, so how can I erase the first uploaded list? or should I just override the existing list, is this possible? Thank you! Kind regards,mrivera67

Is it possible to add a new Actuals Ledger and configure the system such that postings are directed to the new Ledger only?We want to retain the original Actuals for archive purposes but essentially start with a clean book in the new Ledger.

I am looking to expand my profit and loss statement to include details for each of the expense accounts. I currently have my expenses grouped together and I am not sure how to show them all separately. For example, the salaries I have 10 g/l accounts for and everything is grouped together as salaries…. Does anyone have experience in customizing the P/L? Thank you! I appreciate any feedback!

Im having an issue enabling the AP document recognition service. It is an active license. But when I go to enable the license, I get an error that says: the feature cannot be enabled because the current license doesn't include the support of cloud services -  Any suggestions??Thanks!

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! 

Primary contact has been introduced for customer in 21R1. After we moved to 21R1, it seems billing/shipping contact is still loading from default Contact (defContactID in DAC) if uncheck override on Customer screen, but no where to change default contact anymore

Invoice form with extra margin on the right side. It appears to be set as landscape instead of portrait. How do I fix this? I do not have report designer. 

Hi,I need to calculate VAT amount not on the full balance of the document. Related to AR Invoice, once the invoice created advance will be deducted from the invoice. I need to calculate VAT on the balance amount after applying the prepayment to the invoice. Example.The Progress Bill (AR Invoice) - 1000 $Prepayment deducted              -200$Balance Receivable                  -800$ In the system it does calculate VAT on 1000$. I need to calculate VAT on 800$. How is this possible in the system . Thank you,Dulanjana 

Hi. I have three variance columns that show the variance between MaterialCost and ActualCost.I want to sum these three values in a new calculated field. How do I do this? Thank you,

Does Acumatica allow for singular invoices per Shipment? When I attempt to process shipments, the step of creating invoices based upon a shipment, consolidates all shipments that are confirmed for a customer (different shipment numbers and different order numbers) into one single invoice. How do I avoid this? Below you can see where the system is creating one large invoice for customer TEST90, although it covers 4 different shipments and 4 different orders. I would need the system to create one invoice per shipment.  

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 o

I’m working on ARM report for Balance Sheet by Branch, but outcome is not coming, please advise.

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.

What should we do for a Quick Check that was written for a donation on 12/27/21. The check was lost in the mail and never cashed so not cleared. We need to reissue a payment but the prior year is closed.

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? 

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.

Is there a solution in Acumatica for tracking payments to foreign vendors for US Sourced Income? Or anything that helps with 1042 reporting?

hi, i have the following error, between the balance and amount, it differs by one decimal place. i don't know how to do the acumatic rounding.

Hi everyone, I want to add a 8% surcharge to the invoice. I tried to apply a -8% discount. It’s working but the problem is this surcharge will not apply to every customer. I want to know anyway to apply a surcharge by percentage ? like non-stock item or others.  

Hello,I have added a dialog to Bills and Adjustments Screen to be able to route the documents to an assignee. See below snip: I have made the “Assignee” Required. As you can see the DAC is set to force the user to enter the assignee. Here is the DAC:#region Ownerpublic abstract class owner : PX.Data.BQL.BqlInt.Field<owner> { }[Owner(PersistingCheck = PXPersistingCheck.Null, DisplayName = "Assignee", Required = true

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.