Financials

Hi All,Have you encountered this issue with  the Type in Payments and Application using the mobile app where it defaults to Balance WO? Every time you select a different Type, it automaticall goes back to Balance WO type. I'm not sure if this a bug with the Mobile app but even using the  Balance WO type doesn't work. Selecting a Reference Nbr. doesn't do anything. Thank you.

We are using Velixo to create a report showing current percent complete and forecasting the percent complete per month till the end of the project.  The problem I have is when pulling the Budget Forecast into the spreadsheet I need the RevisionID of last update.  I have pulled that field into the GI but it wont show up.  It doesnt even show up, but its on the results grid.  Any idea how I could get this number to show?  

I'm trying to log into Vendor Classes form and come up with above error massage? Is it a access problem? Else could you please help me to sort this out. Thank you very much in advance

in segmented keys I would like the system to pickup the BAccountID and fill this in as the 1st part of the subaccount being used So for example I have set subaccount up as such in the CS202000 screenAnd I would like the system to look at the customer or (vendor if applicable) and fill the 1st segment of the subaccount with the  BAccount code So if I was entering a AR Invoice I would like the first segment of the subaccount to pickup the current BAccountID and autofill with thatthe only way i can think of doing this is using custom workflows but wanted to check that I’m not missing something

Within the AR Invoice process screen (Print Invoices and Memos), there is an option to MARK AS DO NOT EMAIL. We automate  this function for $0 invoices through an automation schedule. However this same functionality does not exist in the Sales Order Invoice Process screen (Process Invoices and Memos).Until this functionality is added, any ideas on how to automate this? My first instinct would be an import /export scenario to check the DON’T EMAIL box inside the Sales Order Invoice Screen.Ideas?

Hello, we are not using the time and expenses module but I would like to upload a journal file for CC expenses. Ideally I would like to book the liability by employee so we can see who has balances when reconciling. It does not appear the system will let you add a Customer/Vendor on the GL journal. Without having access to time and expenses is there a way to achieve this?

I have a project that is not creating an invoice even though there are hours to bill.  It also is not showing up on the summary Unbilled Time and Miscellaneous report. Any ideas how to correct?

I have a question on fixed fee projects and the movement of WIP after billing has occurred.  I have a  project I set up as Fixed Fee and we generate an invoice every month for the fixed amount.  Why does the WIP account have hours that have already been billed? 

Hello Everyone,  Just curious as to who can VOID a Bill, which role...The VOID function is there but I can not seem to figure out who can use that function...please refer to screenshot...Thank you…  Kind regards,Melq 

Working on cleaning out historical transaction that had receipts but never billed since we were running congruent systems and the bills were handled in our previous ERP. As such I have a very high number of both PO and Landed Costs receipts that I need to bill in order to get the balances off the accrual accounts.  Is there a way to mass bill Landed Cost receipts so I can then start clearing from AP?

Hello,     I’ve met a case, to make it easier to understand, below are the simple example:Item A has 2 UOMs, which is  1 Case = 50 lb, lb is the base uom and case is the sales and purchase uom.We purchased ItemA  at $50 per case, however , at that time someone forgot to put the conversion rate on item, so the IN Receipt records the item was receipted at $50 per lb. Which is wrong, should be $1 per lb. We paid vendor at $1 per lb (cost on bill) and sold to customer at $2 per lb, which are both correct.     However, as the internal profit analysis, this item shows highly negative profit, It shows every case we sold ($100), we are loosing (100-50*50) $2400, which is not true.      I already did IN Adjustment to correct the average cost of the item, from $50 to $1 per lb. The afterwards sales would get correct profit.      However, we have already sold a lot of the items on a lot of invoices, and these invoices have been closed.      We do not care too much on the profit analysis on single

I have a situation where our company has 4 different Cash Accounts of 2 different backs for 2 branches.  GL account AAAA, we have 2 cash accounts AA and aa also GL account BBBB, we have 2 cash accounts BB and bb both have the same Account Class. When I imported the Trial Balance Cash Accounts AA and aa showed the right amount, but Cash account BB an bb shows the beginning balance as 0. Does anyone know how I can make account BB and bb show the beginning balance?

HI SirNot sure who can advise me the problem below?For inventory code 14720 , the history inventory figure is not tally with general ledger inventory code 14720Please refer to below screenshoort 

Hello,      When I study the table, I see a lot of columns start with Fin or Tran.I konw Fin means the Finanical Period,   How about Tran?I know YTD is year to date, PTD is period to Date.But what are tranPTD and TranYTD?For me, it looks like the same with FinPTD and FinYTD

Our client wants to look at a PnL and compare it to the number of employees that were working in that department for the month.  Is there a good way to use a statistical ledger or GI to get that number?I was thinking of a GI and then I got stuck.

We upgraded from 2019r1 to 2020r2.  We had a notification set to go out when we paid our vendors with ACH and not it seems to have disappeared.  Does anyone else send a notification to ACH payees?  Whats the best way to do it?

documentation says you should be able to delete a general ledger transaction that is in a balanced status. I do not see that option. Does anyone know if this can be done and what settings and/or permissions are needed. thanks in advance.

Hello everybody,My question is: is there a field as “matching code” in vendor subledger register (for matched invoices and payments) like it is in general ledgers ?if there isn’t, is there a way to create a field and personalize the payment matching process in order to feed this field?  And after all post this field on the vendor subledger visualization screen so that we can do filter or sort on it?thank you! 

I am pretty new to Acumatica and wondering if it offers AP invoice approval workflow.  A couple of systems I used before had the capability to store invoices and once workflow is kicked off, approval e-mail will be sent with invoice attachment to the first approver, then second approver, so on.  It just saved so much time for everyone and we were able to track the unapproved invoices whereabouts.  Does Acumatica have the solution available?  If not, does anyone know good applications that are compatible with Acumatica?

Hi Not sure if anyone can assist for below problem that i encountered.I did set auto trigger SOA customer statement . If i am not wrong ,  we the done the “ prepare statement” , it suppose to auto trigger the SOA customer statement to recipient that we set . However , seem like it is not working. Below is the screenshot that i set in the “ customer”Not sure if i missed any step in the automation process? 

Hi SirWe noticed that the post period and date is not tally ,Not sure what is the problem? is it bug? Please refer to the screen below.For Date 12 Mar 2021 , period should be 12-2020However, system is under period 01-2021 where this is for April date  

Hi Can i check with you all about the account code for “Goods In Transit” According the inventory preference as below , there is a accounting setting for “ Goods in Transit”My question : Is accumatica system can allow more than one of  “good in transit” account code? Exmaple: we got 2 category of inventory - 1st is inventory of product a, 2nd inventory of product b If we need to create 2 account code of “ goods in transit “ for inventory product a and inventory product b , is it possible?  

Helloi just add a parameter in my report to select the account range it works fine but i want my filter to suggest the list of the account i writing like this one but its not working this is what the filter looks like  i tried to add the branch id like the standard filter but its not working 

Helloi tried to add a status filter in a standard report to recover the values i need but the report recover a specific statusso i tried to remove all the filters , created new screen and i still get the same error its like the report still waiting for the filter value the execute you see if i created the report from scratch i don’t have any problem so is their any where else i need to check for this to work Ps: i removed the filters , Parameters and variables  thank you 

Our current credit card processor (authorize.net) requires an authorization to be above the dollar amount of the actual capture.  We have to authorize before we ship and are using the Acumatica Fedex and UPS carrier plugin to obtain our Freight Charges. What is the best way to get our Sales Order an estimated dollar amount above the actual order total, but only have the actual freight (from the plugin) on the Invoice.  We currently have found no solution that doesn’t require manually editing the Invoice.  What are other companies workflow like?  What is the Acumatica recommended workflow? Thanks!