Skip to main content

Financials

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

  • 2,410 Topics
  • 7,965 Replies
2410 Topics
D
Jr Varsity III
dsenevirathne54Jr Varsity III
asked in Financials
Change Debit Account of Bills when in Open Status

Hi,In my customer’s instance, the debit account in the details tab of the AP bill is allowed to change when the AP bill is in the Open Status. What is the option to stop this ? Thank you,Dulanjana

372
D
Jr Varsity III
M
Freshman I
mfreemanFreshman I
asked in Financials
Cross entity Import or Export

I have an import scenario for Trial Balance and an export scenario to process/release all the entries.  My question is, has anyone ever made an export or import scenario that works across entitles?  When you process/release a trial balance entry it takes to you a journal entry which breaks the import/export scenario.  I am looking for a way to automate the whole process. 

501
dang.huynh
Jr Varsity III
N
Freshman I
nperez94nawFreshman I
asked in Financials
resetting cash account beginning balances

Is there a way to reset the cash account beginning balance when there are existing transactions already in the system for that cash account?If so, could it be reset without posting to the GL?Thank you

5494
N
Freshman I
xkylewrightx
Semi-Pro I
xkylewrightxSemi-Pro I
asked in Financials
Note on Invoice vs Payment application

I was wondering if anyone can help me look behind the scenes and figure out if the Notes on the payment application is tied to any other record?We would like for it to be tied directly to the invoice itself, so notes on the invoice appear on the line item in the payment record. However, the note field on the payment does not appear to be tied to the invoice, the line item on the invoice, the journal transaction, or anything else that I can see. Any thoughts or help on this would be much appreciated!! Notes in question are highlighted in redSee notes active here that do not pass through to the payment 

1051
Julia Golomidova
Captain II
S
Jr Varsity III
suemackeown13Jr Varsity III
asked in Financials
Previous dunning letter details for current dunning letter

On the report designer for dunning letters, I need to reference the previous dunning letter dates when the dunning letter level of the dunning letter is > 1.The dunning letter table does not have the information for previous dunning letters. is there a table that can be used where there is a list of dunning letters for the customer? I tried the ARDunningletterList table, but this gave an error - table does not exist.

360
S
Jr Varsity III
R
Captain II
ray20Captain II
asked in Financials
Where is the AR line TaxAmt be kept in DB/DAC?

Hello,     I am writing a report to customers and would like to show the AR line amt and line taxamt.however,  The ARTran.TaxAmt is empty, and also the ARTax.TaxAmt is empty.   We do have TaxAmt on TaxTran, but is is not single line, it is the whole AR document.  Can somebody tell me where I can get the line TaxAmt directly?  Or I have to calculate it by myself? 

3828
M
Varsity I
D
Freshman I
dvertes
asked in Financials
Mass Processing of Balanced Invoices

Hi everyone,We want to release over 175 invoices via mass processing rather than individually. However, we only one invoice is displayed in Release AR documents. Really hoping someone can show us how do we fix this? Thanks,Daniel

2491
Julia Golomidova
Captain II
M
Freshman I
mbowen16Freshman I
asked in Financials
Attaching additional documents to customer statements

Is it possible to attach an additional document when emailing customer statements ? For example, to send out a promotional flyer pdf with a particular statement run ? Thanks !

893
Ahmed
Varsity II
S
Freshman I
sysuser113Freshman I
asked in Financials
How to Apply Bills of different vendor to Bill Payment record using "Document to Apply".

Hello Team,I have been working on AP side Bill Payment Processing. There is a scenario in which the Bills are created with different Vendor Name and get released and now while making the Payments I need to apply the same Bills using “Document to Apply” for a different Vendor. eg. I have Bill Payment with the Vendor Name “XYZ” and Bill has been created with the Vendor name “ABC”. How to apply Bills of different Vendor Name to the Payment ?. Does Parent child relationship will work here? 

2001
Julia Golomidova
Captain II
D
Freshman I
Deidre177Freshman I
asked in Financials
Rates and Billing for Service Company that bills same customer to diff entities depending on work performed

Curious is there are any other companies who has customers that sometimes bill direct to customer and sometimes bill a specific billing account (depending on who is calling in the service request). and also wondering how you have it set up to pull tax zone from customer that service happened at, but pull rates and tax exemption status from billing account? ex. we service “Gas Station A”, when station A calls us, we collect payment (using labor rates and markups set on A as well as submit tax to A’s location taxing authority) BUT if Fuel Supplier B calls us, we bill Fuel Supplier B for the services performed at station A. (using labor rates set on B, but if B is tax exempt, we need to not charge tax on the invoice, but also need to know its an exempt sale from A’s tax zone. 

400
D
Freshman I
M
Jr Varsity II
Mondeddula Madhu Venkat ReddyJr Varsity II
asked in Financials
we are getting this error how can we resolve it error: Account-Subaccount mask pair overlaps with another Account-Subaccount mask pair: 69500 - 000OPS

 

762
Chris Hackett
Community Manager
A
Freshman I
ataiFreshman I
asked in Financials
Fixed asset list does not show any of our FA input. What would be the possible errors?

Hi, I was trying to run the FA list at the FA module to see what we have in hand, but nothing shows for 2022. And we have been booking FA in ACU. What could we have done incorrectly here?Thanks ahead for all your help!

641
Laura02
Captain II
J
Freshman I
jechangFreshman I
asked in Financials
Customer Refund for prepayment , unable to key in finance charges

On the payments and applications screen, type is customer refund and apply to documents of type prepayment, I’m unable to add finance charges. May I know what’s the logic behind where finance charges option is disabled for customer refund? And also, how can I process the finance charges?

803
Kandy Beatty
Captain II
K
Freshman I
Kfarren29Freshman I
asked in Financials
Acumatica New Tenant vs. New Company

Does anyone have any experience with separating a branch of your company into a separate company or separate tenant in Acumatica?  We have entered into a membership agreement with another entity and need our Foundation (currently a branch of our company in Acumatica) to be completely separate with its own set of customizable financial statements.  Just wondering if we should make our foundation a new company under the same tenant or create a completely new tenant in Acumatica???

2031
Laura02
Captain II
D
Freshman I
dcarman90Freshman I
asked in Financials
UK VAT

Hi - does anyone have any recommendations for a UK based Acumatica consultant who can help on UK VAT set up?

2146
andythomas65
Freshman II
martinxfe
Jr Varsity II
martinxfeJr Varsity II
asked in Financials
How do I auto-route multiple GL accounts to a single 1099 box?

I work for a mid size logistics brokerage. A large portion of our business involves outsourcing freight from owner/operators. We use a handful of GL accounts to keep certain charges due to these haulers separate. However, most of these are all 1099 NEC expenses.  How do I set up 1099 defaults so that a bill generated for any of these GL accounts auto-populate the same 1099 box without updating each vendor or each bill individually?

883
martinxfe
Jr Varsity II
J
Freshman I
jeremyhodge0Freshman I
asked in Financials
Bank Reconciliation

Is anyone using the bank reconciliation feature in Acuamtica?  We are having an issue getting the debit detail.  The credits are itemized in the batch payment export but the debit is one lump sum.  The bank is unable to provide us a detailed debit report for us to use to reconcile. How can we export the debit transactions?

1070
J
Freshman I
jenjen98
Freshman I
jenjen98Freshman I
asked in Financials
P&L - Actual vs Budget - need to eliminate % calculation in column set

We would like to see Gross Profit percentages (COGS/Revenue) for the three divisions of our company. I have been able to set this up in the row set, but in our period and YTD variance columns I do not want see the percentages. Is this possible? I am fairly new to configuring reports so I apologize if this is a simple answer! 

3513
bryanb39
Pro II
cdiaz
Jr Varsity I
cdiazJr Varsity I
asked in Financials
How to return all batches where a given account is involved.

Hi everyone, I want to create a GI to look at where our cash is going. My first attempt was to start with CATran and join GLTran, then to join GLTran on itself with just the BatchNbr. I thought this would return all rows for all batches that involve the cash account.Has anyone done something like this before? So far, it appears I may need an SQL nested view… would love it if there was another way. I don’t think I have access to make new DACs with SQLGeneric Inquiry – Use subqueries for a field – Acumatica Generic Inquiries & Pivot Tables – Acumatica User Group Forums (augforums.com)

1244
bryanb39
Pro II
R
Captain II
ray20Captain II
asked in Financials
What is the best way to let AP staff mark AP bills can do online payment for AP admin?

Hello,         Previously, our AP staff pay vendor 1 by 1 by printing checks.Now, the boss(The AP admin) would like to transfer the money (actually pay vendor) on his own in bank online system. But the AP staff should also take the resposiblity to verify the bill qty, price and total.         So the workflow should be like below:1, AP stafff verify bill total and mark them as “verified/paid/closed” and complete the bills payment in Acumatica system.2, AP admin get a list to operate in bank online system. The AP admin actually need to operate nothing in Acumatica system.-----The AP admin prefer less work, but I doubt he might have to do something to mark he really post in bank system in case he actually forget.             I studied, the ACH payment can generate a batch payment list. But, the actually payment in banking may not be ACH. (Like vendor did not accept ACH). The bank can take the things afterwards.      So the key is just to prepare a list, I can write a specific inquiry. But

943
R
Jr Varsity II
S
Freshman I
sbhattaraiFreshman I
asked in Financials
Advance on Purchase orders

We issued a P.O for $10.000.00 to purchase Raw materials.  P.O has lead time of 45 days. 30 days for production and 15 days transit time. We have to pay advance 50% to the Vender with P.O.We pay next 25% when the order is ready to ship. (Within 30 days)We release remaining 25% before accepting shipment in our dock. How can I record these transactions inside accumatica liked with a P.O and adjust with accruals when the products are received?  Thank you,SB

704
Kandy Beatty
Captain II
M
Freshman II
Malinda278Freshman II
asked in Financials
Non-stock items general question

Can someone please tell me the value of the non-stock item feature. I am new to Acumatica and have seen on our system many non-stock items being set up for equipment such as desks and tables, actually broken down into their features, which are being purchased to set up as part of the set up of a new business. I imagine these are on-off purchases and I am struggling to see the point in creating any part numbers at all...why not just use the nominal (general ledger) code and the description. I kind of get it for labour and purchases you may be making frequently but otherwise I am not sure what the value is?Thanks in advance

6257
M
Freshman II
kristianharianja
Semi-Pro I
kristianharianjaSemi-Pro I
asked in Financials
Process Bank Transaction/Matching prepayment against SO

How do we process bank transaction/matching of customer prepayment against sales order?Eg: We enter SO awaiting for payment, customer paid through the bank, and we want to match the payment to SO it relates to.  

801
dang.huynh
Jr Varsity III
ChrisWeidner
Varsity I
ChrisWeidnerVarsity I
asked in Financials
Incoming Documents - Post Period Issue

When using the incoming documents screen & recognizing documents. We are not able to modify the Post Period until the document is created. Our Financial Supervisor (Access role), is the one who handles incoming documents so it is somewhat problematic to change on the Document level (increased risk of error). Ideally we could modify the post period on the Incoming Documents level instead of the document being automatically created in a closed period. Any Ideas on how to bypass this?

830
ChrisWeidner
Varsity I
M
Freshman I
mcl0001Freshman I
asked in Financials
How to expire Sales Prices in Bulk?

Hello,I am trying to expire Sales Price worksheets created for customer classes and can’t seem to work out a solution to complete this in bulk / mass. I  tried to create a GI then use the Mass update function, however no fields are brought across from the AR202000 screen. I also wondered about an import scenario, however haven’t had any luck in creating one of these that updates the field. Unfortunately, it is not as simple as creating a new sales price worksheet as we plan to move away from using this in our tenant. Any tips on the above would be greatly appreciated. Thanks,Matt

1750
M
Freshman I

Badge winners

Show all badges
Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved