Underinvoiced sales orders show yellow
Un-invoiced show red
correctly invoiced show green
OVER-INVOICED show green too
This lack of difference between correctly invoiced and over-invoiced make it difficult to pick the error of over-invoicing. Its an error that can affect a lot of things. I am suggesting a different color code for over-invoiced sales orders.
It is not clear at all what you are talking about. Please show screenshots. Also explain which Manager edition and Version that you are using
Check how red is for uninvoiced sales order, yelplow is underinvoiced, green is for over invoiced as well as correctly invoiced
Check how red is for uninvoiced sales order, yelplow is underinvoiced, green is for over invoiced as well as correctly invoiced
[/quote]
Thank you for the clarification. However the yellow label does not say âunder-invoicedâ but it says âpartially invoicedâ.
Please note that Manager if following normal procedure can not over-invoice and can not detect it. Maybe some manipulation through bulk-actions, or direct journal entries would make it possible to tamper with the figures but these would not balance and thus show up in the Suspense account that must be cleared because these signal errors and you would just simply correct these.
More important is to realize that invoice is considered âover-invoicedâ when the price listed for goods or services is artificially inflated, often with the intention of fraudulent activity like money laundering or to deceive the buyer about the true cost.
Thats not correct. Once i copy sakes order to an invoice and later adjust sales order and forget to update sales invoice it can result in over invoicing. The color remains green. If i increase sales order value and forget to update invoice it becomes under invoiced or partially invoiced. My issue is all scenarios or uninvoiced, under invoiced or over invoiced or correctly invoiced should all have different color codes. Its not even a complex issue to bring up issues of money laundering.
Yes, so you will be carrying out a practice that as I mentioned is doubtful. Why would anyone change the sales order after invoicing?
Lets bw practical, why would anyone fail to change the order after invoicing when the client adjust the order? Youvare addressi wrong issues, the issue is a oht color, can we have a different color when an invoice is over invoiced as we already have a different color when an invoice is under invoiced? Thats the point. Issue of saying why someone would change sales order after invoicing depends on nature of business. There arw billions of businesses world over and operations differ. We change ours and its not even any fraud. Even our clients know the sales value might change.
I am practical and consistent with accounting practices. For most businesses, Sales Invoices are used to record sales transactions and requests for payments, and these should only be issued after Sales Orders, which act as contracts for the sales. As mentioned earlier, if Manager is used as intendedâwhich adheres to this simple principleâthen instances of what could be labeled as âover-invoicingâ would never occur.
I am saying in our business it occurs. Manager actually allows it to occur. So ny question is can we flag those with a different color code. It definitely occurs no doubt or arguing about that. I am not criticising the software an just asking for the addition and am not asking for any explanation about anything because i am experiencing it.
The addition does not make sense and would encourage Manager to be used wrongly. You did not explain your workflow, but I strongly encourage you to look into it and improve to prevent over-invoicing. As mentioned before the Sales Order determines the contract including the amounts, the Sales Invoice follows and asks the Customer for the payments of the Sales Order (the contract!).
What you dont know is the current state is more dangerous as it is very difficult to quickly indenitfy over invoiced transactions as they are green just like correctly invoiced. Appears like nanager does not ring a bell when clients are over invoiced, it only rings when not invoiced or partiality invoiced. Thatâs the point you are missing and you have really missed it. You arw actually promoting over invoicing or over billing.
That is incorrect. See my posts. I explained that if over-invoicing happens then you better adjust your work-flow as it should never happen. If you have someone tinkering with the Sales Order after issuing the Sales Invoice or issuing a Sales Invoice that does not reflect the Sales Order (which is a contract!) then the management of your business should take action and thereby negating the need for any such colour addition. Anyway letâs see how many other users have this âneedâ and suffer from bad work flows.
Mistakes happen my guy. If that woukd never happen why would manager flag under invoiced and does not flag over invoiced. I cane here to specifically ask if manager could also flag over invoiced and not be lectured by you. Dont lecture me on running my business, this is exactly the help i want to run my business. If you cant help exactly on what i am asking then say so⌠your argument does make sense at all.
It used to show the Over Invoiced status but this has now been changed. The reason for this change is that sometimes invoices do not match the exact ordered quantity. This may happen because at the last moment, a customer may ask additional quantity, or the available container/truck loading capacity may allow for more quantities (such as FTL/FCL where exact quantity are sometimes not known). There could be many other reasons that may cause the invoice quantity to differ from the original order.
If something like this is implemented this will solve the issue you are facing
Thank you so much.
Then one should not issue an invoice if the order is still under negotiation. Fact remains that the order represents a contractual agreement and the invoice is simply confirming that and asks for it to be paid.
Thats your own fact, the system should be customized to help us have an easy life. I am a reviewer. I just need to check colors that tell me something is wrong. When i want to check uninvoiced orders i just check red colors , partialy invoiced i check yellow, over invoiced i have to compare figures because they are all green. That takes a lot of time. Remember the system is not used by one person. And if what you are saying makes sense then the system should just disallow invoice above associated sales order but currently it allows that. Please stop forcing people things they dont want we also have brains, i am a chartered accountant myself and i am asking for what i want not what you want. If what i have asked for cant be done just say so not to tell me that i dont need it, who are you to tell me that i dont need what i want ? A simple even excel formula can highlight such a condition.
If what you arw saying make sense why does manager even allow an invoice above sales order value?
I disagree with you on this, @eko. Certainly, a sales order may be used to represent the results of a contractual agreement. But, since they are not financial transactions, sales orders in accounting systems can also be used legitimately to represent other things, including:
Thus, Manager must be adaptable to such completely allowable circumstances and their resulting workflows.
@archybee, while I believe it appropriate that you use Manager as suits your needs, you are expecting too much. And you accuse @eko of behavior that is not his. @eko is a forum moderator, not the developer. Neither @eko nor the program is promoting over-billing. The program simply allows it, something necessary in many ordinary situations.
You want Manager to be customized to your exact, personal preferences. Thatâs impossible for a general purpose accounting application. You would not have this complaint if the developer had decided to present only the two columns of numbers representing sales order and sales invoice totals. You would be examining those numbers, possibly by copying them to a spreadsheet and adding your own comparison test. My guess is that your desire for different color codes would not even have occurred to you.
But the developer decided to add the convenience of color coding. You personally want more color codes, but where would that stop? Other users might want, for example, designation of invoice amounts within 5% of ordered amount, or more than $10 above, etc., etc., etc. The developer made a design choice to build in some coarse visual indicators. If those are not to your liking, you can still copy data to a spreadsheet and design visual analysis tools to your heartâs content. That is why the developer incorporated the copy feature. He recognized long ago the program could not incorporate everyoneâs analysis preferences and made the conscious (and well-publicized) decision not to turn the program into a charting and display behemoth, but to include only simple reports and indicators, along with the ability to capture data for more sophisticated analyses and displays.
