General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 561 Topics
- 1,708 Replies
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.
Where an invoice has attached files, is there a way in which we can add these attachments to the invoice form in report designer? I see from previous discussions that the use of a sub report might work, but where does one find the schema for the attached files and how does the linking work?
Hi all,One of our employees purchased a fixed asset using his personal account. Then he needs to claim expense and record this asset into our book. Here in the expense claim form we only see “expense account”, but we’d like to record this amount into “fixed asset” instead of an expense account. So how do we do that? Is it ok if we just key in an account for fixed asset here? Thanks!
I can only see how to set Wiki article as the homescreen, but I was wanting to create an I-Frame in a dashboard to our corporate website. Below I’ve attached screenshots of the Dashboard setup and the Portal Homepage selection
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
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.
Right now we have a few allocation rules that are setup to capture cost, every hour, for certain cost codes that get time applied to them from Time Entry. For example… if cost code 00-0010 (cost type Labor) gets entered on time entry for 4 hours - accumulate $400 of cost. The issue is 00-0010 (cost code) E (cost type) is the cost code that automatically gets created for $400. Is there a way we can dictate what cost code those allocation rules accumulate cost towards? Ex: 00-0010 - Cost Code Labor (L) - Cost Type gets selected during time entry, that $400 goes towards 00-2000 Equipment.Seems silly they wouldn’t allow us to dictate where those costs get tracked?
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?
I would like to add an step in the AP Bills approval when the difference in price between the vendor’s invoice and the PO receipt is greater than 10%. I can only find in the AP Bills approval map an option for PO PPV Amount is greater/less/ than a particular amount but not nothing that I can use for %. Any ideas on how to handle this?
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?
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.
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!
Long-time Sage 100/Aatrix user attempting to file my first Acumatica-based 941. Acumatica downloads the data, but on Verifying Data I receive the following error: The EIN in the AUF does not match the specified EIN for the user. I have verified with Aatrix our EIN is correct (logged in and verified on the Aatrix website and verified with an Aatrix tech).Acumatica is passing either the wrong EIN or possibly a masked EIN (e.g., dash after the second digit as is common) or possibly a blank. I have searched high and low and found no instances of errors or blanks in Acumatica setup.Anyone encountered this error and have a fix?
Acumatica has a built in function to “recalculate” various balances such as vendor and inventory. We have been live for eighteen months and have never run these “recalculate” functions. Recently, we noticed an error in our inventory and our VAR suggested we run the “recalcuate inventory” function. We ran the fuction and it fixed our error. My questions is should we run all of these “recalculate” functions regularly such as monthly or quarterly? Is there any harm in running these recalculate funtions more often?
We have been live for eighteen months. We have never run the “Recalculate Customer Balances”. What is the procedure to run the recalculate customer balances? Does this need to be done for each month? Should we start with the oldest month run to current month?
Is there anyway of changing the account type of a GL Account from the database. I understand its not possible from Acumatica’s Chart of Account screen so I think a script is the most possible options but I am not sure which tables store the account type.
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?
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???
In the AP world, there could be a number of reasons to capture retainage on a vendor bill. Reasons could be things like contractual agreements, IRS requirements, or even garnishments in some cases.Currently, Acumatica only has 1 amount and 1 account to capture retainage per bill, which can be limiting when one needs to capture more than 1 reason for a vendor. Breaking out what the amount is made up of can be very hard after the fact, and is not supported natively at all.It would be great to be able to enter a number of lines of retainage detail, which is summed up in the bill. Each line could have its own GL account, in case customers want to manage contractual retainage separately from IRS (tax) retainage for example. These lines would then post to the GL individually.Strictly speaking IRS (tax) retainage should be paid to the IRS, and not to the vendor, depending on the customer’s AP process. Not sure what the best way would be to implement that in the ERP when required.
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.