Financials

Hi SirWe have encountered a problem about the inventory , we make mistake do receipt in a part # where that should be use existing 5 parts to do kit assembly into one part # . Currently , our system have extra 5k in inventory history valuation but in financial inventory account is correct . We cannot do adjustment transaction as it concern about double entry where it will affected financial account figure.May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure?  Hope to hear from you soon.Thank you

Hi allFirst time here so please bear with meWhen choosing a Customer in Payments and Applications on a specific date ( July 8th ono.) it goes blank. But when in Profile and choosing Actions- Payments and Applications the process is allowed.

Hi Everyone ~After years of using Quickbooks Online I have recently taken a new job using Acumatica. It’s been a learning curve, so many moving parts in Acumatica. Here’s my question:  The company I work for receives inventory items that are paid by credit card and there is no PO. How do I enter the inventory and the bill that goes with the items.  Thanks for your help. 

Hello Acumatica! I have a question (a dumb one :p) ; can we import a transaction with Batch Module = AP ?  Thnx :) 

I need to create a Parent - Child relationship between APTran and ARTran tables. The artran.OrigInvoiceLineNbr field has no value (value is NULL) on the existing data. Can I populate this field with the APtran.LineNbr value for reference in the ArTran table?

We are trying to change the description field in the timecard.  We have found that the “Summary Day for:”  is very confusing.  We would like to make the Description field be filled with a single ‘ or a , .  This makes the Summary day for: go away.  Has any one defaulted the description or know how to. My next project is to make overhead tasks not choose Billable when the employee uses them

On the Revalue AP Accounts form, I specify the settings to perform the revaluation of open AP documents. The Revalued Balance > 0.  When I release the transaction and review the Journal Transaction for the revalue AP.  I notice that the generated batch has a 0 Debit and Credit AmountNotice that on the Revalue AP Accounts screen the Revaluation Total value is not 0How do I resolve this? 

On the Budget Form the Stat Ledger is defaulting in the LEDGER field.  When I run the Budget Import Scenario the first branch gets imported to the budget ledger but the following branches go to the statistical ledger.  I have hard coded the ledger on the import scenario and I have tried mapping the field.I think the issue with the default ledger being incorrect is causing the incorrect import results.Has anyone else experience this?ThanksColeen

Acumatica Overview WebinarThursday, July 1, 202110:00 AM PDTRegister hereTake an in-depth look at how Acumatica can help small and medium sized companies solve many challenges of remote work and achieve growth.  Register now 

Is there a way to calculate a proporational discount if you partially pay a Vendor early on an AP Bill?Bill #  on 6/01/21  2% Net 30  on a Bill amount of $50,000Client pays half on 6/29/2021 $25,000 to capture partial discountFull Discount is 50,000*.02 = $1,000Partial Discount is 25,000*.02 = 500

Hi EveryoneNot sure who can advise for below question related with corporate credit card - expenses claim.As the credit card transaction involved with different currency , example: SGD , HKD and USD.Understand that when we create expenses claim under corporate credit card , only one currency that we using  (the currency depend on what currency we set in employee profile)  .If like my scenarios , there are 3 different currency, how should i create the entry under one expense claim?Hope to hear from you soon .

Hi Anyone know what is the “turn off autocomplete” in user profile?  

Hi Not sure if anyone know that what problem to caused below error message when i run a new created generic inquiry?  

Hi May i know if we can copy/duplicate existing generic inquiry to another new one ? From there, we will do some modification become another new generic inquiry.Thank you

Hi EveryoneNot sure if you know why i cannot click the “shared configuration” when i want to create a new pivot table?   

Hi,When I used to click on the Payments and Applications under Transactions for Receivables, it would give me a list of all my payments and applications (a transaction list). Now it just takes me to the individual payments and applications, and not the actual transaction list. Did something happen to that list? Or is it a settings configuration that I need to fix? All my other options under Transaction still seem to work fine, but this option changed recently for Payments and Applications.  Thank you.

Hello, Can you help me with following issue?How do I make the tax that I enter in Sales Prices (AR202000) for a given Price type, Price Code and Inventory ID appear and calculate when creating a Sales Order? I have created a special customer and a special Customer Price Class for him. Then I have set in Sales Prices for this Customer Price Class the prices for the given stock items and taxes. When creating a Sales Order, I would like the price and tax to be transferred from the Sales Prices after entering the Customer and Inventory ID. Currently, when I select the inventory ID in Sales Orders (SO301000), the tax category set in the Stock Items (IN202500) pops up. Is it possible to overwrite it ?  

Hi!Does anybody knows if it’s possible to restrict visibility in the Aging Report to specific users that manage a group of customers? For example, the group A of salespersons manage 5 customers only and they only need to view the aging for their specific Customers.I tried first to use Restriction Groups for Customers entities but when the same user runs the Aginig report, the customers that not belong to their restriction group, are displayed anyway.ThankS!!

Hi, How do you maintain your petty cash float in Acumatica. What are the steps taken to get the necessary funds in to petty cash to maintain the petty cash float. Would really appreciate your feedback.

Hello All, apologies if this is a silly question.  We are new to Acumatica and getting more experience by the day.In our sandbox environment when trying to print AP checks we are receiving the following error:Field not found: ‘PX.Objects.AP.APPrintChecks.APPaymentList’.On the Checks and Payments screen it shows status of “Pending Payment’. Any feedback is appreciated.  Thank you in advance

Hi,I was about to depreciate an asset but the system warns stating that “FA error: The fixed asset contains unreleased transactions. Release them to continue splitting the assets”.When I checked the unreleased FA transactions and was about to release the batch, there is still an error stating “FA Error: Calculated depreciation of the Fixed Asset tries to post into the period 12-2020. It can be posted only to current period 09-2020.”What I did was open the FA period from 09-2020 and added the Financial Supervisor role in my access just in case that was the cause of the error but I still encounter the said errors. Please help. Thank you.

I am trying to upload a TB. My base currency is LKR. However I also have two cash accounts on USD and GBP. In the upload, I specify the correct currency amounts and load the TB. I am able to release it as well. However the GL batch that gets created does not balance. Its based currency is LKR, but the two entries for the denominated accounts, it shows the foreign currency values, not the relevant LKR (Base) value. Is this a bug or am I missing something here?

Hi Team,I have issue with the Base currency in CurrencyInfo table. MultiCurrency enabled. (Acumatica Cloud ERP 2021 R1Build 21.103.0054)First, I have two tenants :tenant with fresh create and create company with Base currency CAD. I create generic inquiry to fetch PX.Objects.CM.Extension.CurrencyInfo, I find the two Base currency records in the table. other tenant, I create fresh, but import snap shot from other tenants. after that I use same generic inquiry looking for CurrencyInfo table. the two base currency record not exists.It cause the error when in FSAppointment add detail item with inventory, the error is: Object reference not set to an instance of an object.   at PX.Objects.FS.ServiceOrderBase`2.X_CuryUnitPrice_FieldDefaulting[DAC,CuryUnitPrice](PXCache cache, PXFieldDefaultingEventArgs e, Nullable`1 qty, Nullable`1 docDate, FSServiceOrder fsServiceOrderRow, FSAppointment fsAppointmentRow, CurrencyInfo currencyInfo) Looking for help.Thanks

Hi ALLNot sure if anyone is using Manufacturing Module in acumatica ?Understand AVL is very basic for every manufacturing company.We would like to find out if there is BOM- AVL this function in Manufacturing module? Hope to hear from you all soon   

General Business Edition Overview Tuesday, June 15, 2021  10:00 AM Pacific Daylight Time  45 minutesAcumatica is a company on a mission! We are a leading innovator in cloud ERP with customers located around the world. Acumatica ERP delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model, enabling a complete, real time view of your business anytime, anywhere.In this webinar we review the building blocks of Acumatica’s General Business Edition and discuss how these blocks lay the foundation for a complete business automation system. We briefly explore the interaction of the financial modules, reporting tools, integration points, mobile framework, and platform tools, followed by a product demo highlighting Acumatica Business Edition.Register Here