Learn
Learn
Support
Support
Product
Community
Partners
MAP
- Marketing Automation Platform

Community
Discussion Forums
Financials

Financials

General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management

2,148 Topics
7,179 Replies

When you subscribe we will email you when there is a new topic in this category

2148 Topics

Most replies

Most views

Newest first

ldanczigerJr Varsity III

asked in Financials

Purchaase Receipt for stock item in No Purchase status

Hi,Im trying to create a purchase receipt for a stock item that is in the ‘no purchase’ status but system is giving me an error that you cant create receipt for item with no purchase status.Any way i can do it? we still need a receipt for it since at the time of creating the PO it was still a purchase item.

Reprint Checks in AP with the same numbers

Can any one tell me how to Reprint Checks in Acumatica? I prepared my payments and processed, but an error came up...not sure what the error said, it was only up for a sec. So I hit the process button again. So now the invoices are showing closed and I have not checks. 😔

vivian46Freshman II

Can Lien Waivers be generated automatically from AP when creating a bill related to a Project?Now only the waivers are generated automatically if a Po is created in the project and an Ap bill is generated from this PO.Vivian

2901

2 years ago

kgawryluk80Freshman II

posted in Financials

Specifying a Savings Account on an ACH (NACHA) Export

The out of the box system does not let you specify any other type of account for a Vendor on an ACH (NACHA) export from AP. Follow these steps to fix:Go to Banking → Preferences → Payment Methods Select the Payment Method ID of the profile that you want to update, mine is ACH Click the “SETTINGS FOR USE IN AP” tab Click the + to add a new line ID Description Entry Mask Validation Exp 5 Account Type (Chk=22, Sav=32) 00 ^\d{2,2}$ Save Go to Integration → Profiles → Export Scenarios Select “Export AP Payment to ACH” or which ever one you use Click the + to add (3) new lines Field Values Source Object Field/Action Name Target Field/Value vendorPaymentSettings @VendorPaymentMethodDetail.detailID ='5' vendorPaymentSettings DetailValue CCD_TransactionCode vendorPaymentSettings =IIF([CCD_TransactionCode]=null,'22',[CCD_TransactionCode]) CCD_Transact

5877

2 years ago

sarahFreshman I

asked in Financials

Payment Terms - Net 10th of following month

How can I set up a payment terms for the 10th day of the month following the invoice date? Example: Invoice Date = 03/09/2022 Due Date = 04/10/2022

6502

2 years ago

mlupro87Jr Varsity III

posted in Financials

Allow Calculate Commission process to post into Financials and provide better reporting.

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 the general ledger and get the salespersons paid.

1272

2 years ago

Malinda278Freshman II

asked in Financials

Goods shipped by sea date of invoice

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 arrive)….Doe

280

2 years ago

npace29Varsity I

asked in Financials

YTD Net Income Balance transfer to Retained Earnings Account - how is this done by Acumatica & is there a Journal record for this?

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 year would not match with the Beginning Balance of the first p

148619

2 years ago

dsenevirathne54Jr Varsity III

asked in Financials

Account Selection of Invoices under Sales Orders

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

642

2 years ago

mrivera67Freshman I

asked in Financials

How to erase the uploaded fixed assets?

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

RoyceLithgoPro II

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.

1358

2 years ago

CetyliteFreshman II

asked in Financials

Profit and Loss - Customize and Expand

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!

13532

2 years ago

KristinaFreshman I

asked in Financials

AP Document Recognition- Enable Error

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!

2301

2 years ago

cyokotaFreshman II

asked in Financials

How to include a new unit just created in the consolidated reports?

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!

884

2 years ago

woodyg84Jr Varsity III

asked in Financials

Billing /Shipping contact without override

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.

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.

331

2 years ago

dsenevirathne54Jr Varsity III

asked in Financials

Change VAT calculation Basis

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

560

2 years ago

cdiazJr Varsity I

asked in Financials

Generic Inquiry: How to reference a calculated field from another calculated field.

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,

5111

2 years ago

trenton78Freshman II

asked in Financials

Remove the Consolidation of Invoices (multiple orders)

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.

3582

2 years ago