Financials

Is it at all possible to upload the beginning balances for a GL account with subledgers? Please help! or is there a work around? Thanking you in advance!mrivera67

Hello everybody,My question is:We pay our employees the professional fees reimbursement by bank transfer (SEPA).  And we made it through another software, so we have to book the reimbursement laterly in acumatica, for example on the bank statement, it would appear 3000€ outcoming that we have to affect to 10 employees accounts (512100 Bank account to Sxxxxx employee subledger accounts).  It seems that this schema is not available under acumatica, I don’t find how to dispatch a payment and distribute it to 10 different accounts.  (as prepayment, sometime the fees bill comes later) For the received payments, check remitment for exemple, I can use the check remit account to aggregate 10 checks and got a unique incoming amount for the bank reconciliation, but I don’t know weather there is a way to do the same with the outcoming payments ? Hope you understand my issue. Thank you in advance for your help.

Hello,I am wondering if there is any way to restrict the credit verification rule for the credit holds to be only positive? Seems that when there is a credits with the firm, the hold option is activated.

Our approval maps have always been employee supervisors and when we upgraded to the new version somehow its changed.  We are not able to approve time cards because there are lines that are not approved.  The only approver is the supervisor but Acumatica wont let us do that now.  Any suggestions, yes I did put in a case.  No response for 5 days to the case.

Acumatica Users – Best Practices for Accounting and ERP Closing ProceduresCalling all Controllers, Accounting Managers, Accounting Staff and others interested in defining and developing your Accounting Closing Procedures for Acumatica.  The Acumatica User Group (AUG) will be conducting a presentation on this topic on November 12, 2020.  The board of directors of the AUG would like to use this post to start community collaboration for members to share their thoughts. Click here for the session description and registration form.We hope to pull topics from this thread to use for the upcoming session and to collaborate as a community in the upcoming meeting.   Members may also wish to start other conversations based on procedures for specific operational areas modules, i.e., Project Accounting, or Manufacturing.Please start sharing your thoughts and questions to collaborate with AUG members.  Thank you for your participation.

Helloi tried to add a filter  in GL63CG00 but its not appearing   but its not appearing thank you 

I would like to create a report where the user would supply the ending period as a parameter and a hidden parameter would automatically be calculated as the thirteenth period prior to the period supplied by the user.The report will always retrieve data from the current period plus the prior twelve periods.I have tried using the FormatPeriod function with an offset but I get a response stating the FormatPeriod function is undefined.I also want to populate 13 variables for each of the periods selected to use in calculations and placing data on the report.What is the proper syntax for using the FormatPeriod function in Report Designer?

Hi I tried to upload the bank statement (excel file) for do the bank recociliation. However system pop up below screenshot  not sure if i didnt update/do the setting in somewhere. 

hello i tried to get some result from sub report but i think some parameters didn't go throw i duplicated the same parameters in the sub report itself   and i didn’t get any results thank you 

i tried to replicate the relation between LegalGeneralLedgerGLTran , account and batch like GL63CG01 in GL63CG00 but i get this error Conversion failed when converting date and/or time from character string.

hellotoday i’m trying something new i have a boolean filter but in the Filters i need a condition like :if the boolean is true (field is not null) and id the boolean is false the (field is null)

I am looking to set the default period to post on transaction screens (journal entries, AP Bills, A/R invoice etc) to be the last open period for the corresponding module.  Currently when a user enters a bill, the default period to post will be based on the date of the transaction.  An example might be that the oldest open period is period 1 and a user keys an invoice with a date of 2/1.  The default would be the period to post defaulting to period 2.  The goal is to have the period to post automatically default to period 1 since it is the oldest open period.  Any idea on how to do this without a customization?

hello againi filter my report with BAccount.AcctCDbut i the main report data is from LegalGeneralLedgerParameters which contains only  ReferenceIDits the same as  BAccount.BAccountID so my question is can i filter with one field and i get in return another one thank you for your cooperation

Hello Everyone! Could someone please show me how to import/upload beginning balances of several cash accounts in Acumatica 2020r1? Thank you in advance!  Kind regards,Mrivera67 

Running 2020 R2 Build 20.206.001I was wanting to change the default location on all of my vendors and thought that I would try an import scenario to make the change. I cannot delete the old location until I make another location the default location. Using Inspect Element on the Set as Default button on the Locations tab produced the error:An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.Also happens in a local install of Build 20.208.0031.

HiI have created a dashboard in finance , however i dont know how to put it as main page , which mean when i log in , it will show the dashboard that i created as currently is show the “controller” that created by aucumatica as below 

Hello everyone,I’ve updated the instance to version 20.208.0031 and the Customer Name has been changed to Vendor Name.   Does anyone have the same problem with me? 

helloi want to add parameter range with the field ReferenceID from gltran in GL63CG01 report from LegalGeneralLedgerGLTran and it didn't work so i tried to add the GLTRAN and it same thing so i decided to get the field from the BAccountID but i did't know to link it with gltran or account to the parameters to have an account range filter.

Hello Guys  Can you help me with finding a way to link “Account” and “Batch”; I tried using GLTran but I have the same line repeated multiple times select * from account INNER join GLTran on Account.AccountID=GLTran.AccountIDINNER join Batch on GLTran.BatchNbr=batch.BatchNbrorder by AccountCD I’m missing something ? 

We processed two check against two AP bills.  The checks show on the check register but not on the payment register.  The two AP bills remain Open as the status.  How do we connect the bill to the check after the check printed without having to void and issue a new check? 

Is there a way to set the accrual account based on PO type? i.e. We want the accrual account to be 2210 on a normal PO, but we want the accrual account to be 1250 on a drop ship PO.The accrual account is defined on the item level - so it seems that we would need a Drop Ship SKU as well as a normal SKU to do this out of the box -  which doesn't take the manual entry element out of the equation due to needing to pick the correct SKU. 

Does anyone have a reference for hierarchy of GL/SUB accounts being defaulted?  We have struggled to fully understand how Acumatica defaults the GL/SUB accounts when inventory items are added to a sales order. Does anyone have a document they can reference or point me to a help topic on the portal or Acumatica that would cover this topic?

how can i find the values in DB for the the Beg Balance and Ending balance fields in Account by period screen . 

Hi Anyone know that where can pull out the data for taxable amount details for AP Bill? Please refer to below screenshotI would like to pull out the report with taxable amount for AP bill where have involved for Taxable amount 

We are paying expense claims outside Acumatica, but would like to use the list of claims paid which we can easily obtain to automate the expense claim status changing from Approved to Released.