Financials

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! 

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

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. 

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

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.

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? 

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

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 !

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? 

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!

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?

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

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?

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?

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! 

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)

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

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

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

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.  

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?

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