DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Creating Retail Calculation


#1

Hello for the managers of this software …

I have one request regarding the entry of articles into the warehouse?

It is obligatory for us to calculate the prices of goods based on the invoice of the supplier.
It serves as a material proof of the way in which the prices of articles in the warehouse are determined and kept by the state authorities. Which means that on the basis of this calculation we are doing the entry of goods into the warehouse. At the same calculation it must be seen:
Supplier’s invoice number;
The date of issue of the invoice;
Supplier;
Like all purchased items from suppliers, for which we are pricing the pricing as attached (picture).
Without these calculations we can do input items in the warehouse, nor the same legally sell.
We are talking about Europe, namely about Balkan.



#2

I imagine this is most unlikely to be a feature of the software any time soon. The main purpose of the software is to provide a double-entry accounting service


#3

This almost has everything in the invoice, you just need to add some elements, as an optional one (example box discount).

Each item should have these calculations individually, and finally in total.
In retail this would not be called “Input Account”, but “Calculation price”.


#4

These two fields should be calculated reciprocally, if you enter%, then the absolute amount of the margin is calculated, and if you enter the absolute amount, then the% margin should be calculated.


#5

Manager already does most of this. The Average cost is calculated from all prior purchases, whether by payment voucher or purchase invoice. The drill-down history on the inventory item will show you the transactions involved.

The Purchase price field in the inventory item description is only an optional convenience. You can leave it blank, and Average cost will still be calculated correctly. If you buy the same item from different suppliers at different prices, you probably should leave it blank. If you buy the item at the same price all the time, filling in this field means less manual typing when entering purchase orders or purchase invoices.

The Sales price field is also optional, a time saver. Manager allows you to sell an item at any price you like.

It is not realistic to calculate your sales price based on a single purchase invoice. What if you have inventory on hand from several purchases, all with different prices? I doubt that your local law requires you to price each individual unit of an inventory item based on its specific purchase price. And Manager would not support that, because it does not distinguish among quantities of an inventory item. But if you are required to adjust sales prices based on cost, you can do that by checking the current average cost before entering a price.


#6

Yes, I agree with you but all this has to be seen on the Invoice or Calculation Price.
Like it is presented in the following picture.
These elements should be printed on paper.


#7

If we have one hundred Invoice Accounts, no matter how many items per account are, for each individual account we need to make a Cost Calculation. What is the purchase price per item and the selling price per item must be known on this Calculation Price.


#8


#9

For this reason I would have to buy an additional driver for the Calculation Price.


#10

So you seem to be saying that you must provide a trace back to the original purchase invoice for every individual item sold, not just a calculation of average cost of an item and average margin. Is that correct?

If so, can you provide a link to official documentation (in English) describing this requirement? I have never heard of such a requirement anywhere in the world. Manager provides no such capability, nor does any other accounting package I know about. There are other users in your country, but no one has ever asked for such a feature.