Financials

If we have a Purchase Receipt for which we will never create an AP Bill. What can I do so the ENTER AP Bill button is not shown?  

Error: Inserting  'Payment' record raised at least one error. Please review the errors. 'Empresas del Grupo' of 'AP Subaccount' does not exist in the system. 

Hi, I have 2 relevants question related to timetracking: is there any way to prevent time tracking two to three weeks back? What if the timesheet has been released,  and then we wanted to add additional hours to that week? is it possible?Thanks!

I’m trying to increase font size on checks in Report Designer.  I’ve gone to style and increased the size and then saved to server, but the font size is the same when I print.  Any ideas??

Hi,Scenario - Customer invoice amount is 580 and prepayment is 530 need to allocate cash discount of 30 (Cash discount Balance 35) and keep the balance payable as 20. System gives error “Cash discount can be applied only on final payment.”I have tested the same scenario in testing environment, and it allows to process the transaction.can anyone help to correct this error. Thank youDesh

It is quite common to have refunds associated with expense claims, particularly when they are credit card expenses. However, Expense Claim entry will not accept a negative value.What is the best way of dealing with refunds ?

Hi Team,Recently , I have tried posting Intercompany purchase process. I have created PO and triggered the SO then shipment also completed. When I checked the “Inventory summary” inquiry I couldn’t find the movement of inventory from one company to another company.Actually, Purchasing company will receive the inventory and the selling company inventory will be reduced by the quantity which is in the sales order.Please let me know the issue here.Thanks in Advance. 

Hi guys,It seems that when link a cash account to an account in the chart of accounts, it has to be “one to one”. When I tried to link more than one cash accounts to one account in the chart of accounts, the systems showed an error. So is it impossible to do that? Thanks. 

Hi all,when you design a report, you need to define the data source in the column set / row set. I could only see dimensions listed below. Is there any possibility to have “project” here? We’d like to have financial reports by project. I know there are several reports under project, but is there any one of them that shows financial results of multiple projects for comparison? Thanks a lot! 

Please do add Bank Giro account to financial modul.For Indonesian, bank giro account still commonly used.

Hi, I am trying to pull the customer statement with detail as sometimes there is a discrepancy and you want to indicate what has been paid or received and what is still open as well.  Kind regards

Hi, I am trying to Release an invoice but I get an error  that says GL Error Actual Ledger “ must be defined in base currency USD only. This is happening in our live environment but not in the sandbox (which was refreshed yesterday). This leads me to believe that a setting was changed somewhere inadvertently by a user.  Any help would be appreciated.TIA

We are a US company and need to charge GST tax to our Canadian customers. We also have to charge PST tax in addition to the GST tax to our BC customers. I understand how to setup a tax zone to calculate both the GST & PST for specific customers, but how can I get these 2 taxes to print separately on the BC customer’s invoice?I appreciate any help or direction you can provide.

Hi guys,We need to do translation of financial statements and I learned from the course F340 that when you try to define an average rate, you enter it manually in the “currency rates” form (CM301000). Can Acumatica automatically calculate average weighted rate?Thanks!

Hi all,In the sales demo test environment, there is a report of “Profit and Loss by Product”, of which the column set has been confirued to differentiate each column by “start sub”. It only defines the first 3 letters here.And if we take a look at the subaccounts, the logic here is to define products by the first 3 letters and define departments by the last 3 letters.That makes me wonder if we can design a report called “Profit and Loss by Department”, and differentiate each column by “end sub”, for example in the column of Finance department, the data source would be like this:But when I tried to generate a report, en error occurred. So do I misunderstand the logic of “end sub” here? And how should I design a report of “Profit and Loss by Department”? Thanks a lot. 

Is there a way to format the date in report designer to show the month name in a different language? Our client has invoices and sales in German and I need to format the month name accordingly.

Hello everyone, with the rising trend on data privacy, how can I disable the ‘export to excel’ button on the customer generic list for most users? Thank you. Kind regards,mrivera67

I have a customer requesting a report of everything they have rented from us, with prices included. Is there a report out there that has this information on one report?

Hi all,We’re a relatively small equipment hire company based in the UK who has recently implemented Acumatica.We’re really keen to learn from experience, and wondered whether anyone has some really good credit control functions, dashboards, GIs, Business events etc. within Acumatica that they could demo/share knowledge on?We’d love to explore automation etc., but not sure where to start and our consultants and regional representative suggested asking the experts on this forum!Thank you!

Created and successfully prepared customers in an import scenario.  However, when “Import” was activated, random customers were not loaded.  Can not find a common problem as to why it brought some in and some not.  It did not give an error, just did not bring them in.Reran in test company with  The ones in yellow are missing.Excel dataThe Customers loaded: 

Using the out of the box Import Scenario for Customers.  The customer is displayed but when Import is selected, get the error:Here is the Import Scenario: The excel data file:Thanks. 

Contacted my VAR and they recommended we do NOT implement bank feeds at this time. VAR indicated it is not working well with PLAID. Is anyone having great success with Bank Feeds using PLAID? 

Hi I would like to Populate the customer Billing Email automatically when we run the report for one customer for sending an Email. Response from Acumatica :The report will need to be customized in order to meet this requirement. Even if the customer is indicated in the report parameter, there is no link between this parameter and the mailing settings of the report. Looking for some best approach to meet this requirement.

Hi Team, Can we create a Fixed asset directly from Purchase order. I know we can do with “convert purchase items to Fixed assets” but I do need to know how it works when we directly purchase from Purchase order. And what will be the possible transactions that will be displayed in the “convert purchase items to fixed assets”.

Acumatica help lists 3 files types for uploading. OFX (Open Financial Exchange) QBO (QuickBooks Online) QFX (Quicken File eXchange)When choosing a “Statement Import Service”, I only see an OFX option.  Maybe it handles all 3 file types above, but I’m getting errors with QBO and QFX files so I doubt it.How do I get or add the other Statement Import Services / PX.Objects?