Financials

Hi Anyonei would like know more about the landed cost in accumatica. As i know once we entered the landed cost . it will become part of value of inventory instead of freight cost expenses. Not sure if my understanding is correct?As we would like to know the freight cost of each import shipment or outbound shipment, Not sure if acumatica got this function to let us take in the freight cost?Hope to hear from you soon.Thank you

Hi may i check with you all whether finance- payable can create the debit note or credit note for those debit and credit adjustment in PAYABLE?We understand that  is OK to issue credit/debit note in RECEIVEBLE but not able in PAYABLE Who can advise on this?Thank you 

Hi Now i currently the chart color all are blue .May i know how to change to other color that we preffered like green , orange , purple and etc .Understand we need to go in the chart setting to type in the common. Not sure who can share with me the step of how to change the color or any video link can send to you? Thank you very much

Hi:There was a focus group on selecting/checking off bills in a vendor payment. The check off proposed feature was very interesting. However I could not find that feature in 2019R2 and 2020R1. Was that ever implemented? This was documented in the video: https://www.youtube.com/watch?v=Z6yTlgJ8dmsThe same feature was discussed for AR. Selecting/checking off invoices for a customer payment.Is it documented somewhere what happened to those proposed features? Thanks for your helpToon SIx

The new AP OCR ML feature is great if you are only using AP bill processing.  Many clients have purchasing/receiving and it would be great to incorporate an option to select if the AP bill is related to a PO so the receipt information can be pulled into the bill.

Is there an easy way to keep track of value that you owe a vendor if they are a customer too? The end result would be to see how much they have bought from you so you aren’t over paying there AP Bill.

Hi, I have not been able to locate a manual or how-to for submitting expenses using the app. Does this exist?Thanks!

I would like create a monthly P&L that uses the Actuals ledger for Start Period through End Period and then uses Budget ledger for “End Period +1” through Period 12.Currently I update the data source in the appropriate column each month within the column set.  I would like to find a way to dynamically select the correct ledger based on End Period.Something like the following for the column representing the Period 7 . . .=IIf(Left(@EndPeriod,2)>=7, ‘Actuals Ledger’, ‘Budget Ledger”) 

Hello,    We are calculating commissions based on profits of each AR document.For example, if the total prices of 1 invoice is 1000, and the total cost of all the items on invoice is 800, then the commission would be calculated based on 200.    However, we encountered a case:We did oversell for 1 item, such as item A. and Item A has 0 qty and 0 average cost in system. Supposing, we sold 10 cases item A at price $100, since item A has 0 average cost and 0 ARtran cost, the profit for Item A is calculated to $1000. which is not right in the real world.  The next day, we did receipt on item A with unit cost $80.  So the total profit of item A on that invoice should be only $200.       Is there a way for us to adjust that profit? If we can not do it on that single invoice, can we do a combination of several docs to adjust?

Hello,      Our company normally just give customer credit memo and will not refund money. So we used “customer refund” function only 1 time in 2019R2, and it is ok. It went well, no error happened.       However, after we had upgraded to 2020R2 and we had to create a new customer refund. it says “Sequence contains no matching element”. Just right after we have chosen the type as “customer refund” or “void refund”.      Can someone helped us out?  

When we processed a credit card with our old system and it was declined for any reason, a box popped up and said "DECLINED". With Acumatica a declined credit card has a status of closed and in the deposit batch looks just like the successful transactions. It even posts to the invoice. T